The Self Join – Inner Join and Outer Join - An Example(blog.sqlauthority.com)

submitted by pinaldave(9662) 1 year, 10 months ago

Self Join has always been an note-worthy case. It is interesting to ask questions on self join in a room full of developers. I often ask – if there are three kind of joins, i.e.- Inner Join, Outer Join and Cross Join; what type of join is Self Join? The usual answer is that it is an Inner Join. In fact, it can be classified under any type of join. Read more for example. read more...

add a comment |category: Database |Views: 442

tags: SQLAuthority pinaldave SQLServer Database SQL another

Streaming World Cup Tweets in Silverlight With a Few Lines of Code(gregdoesit.com)

submitted by jcaverns(317) 1 year, 10 months ago

The World Cup is on and there have been quite a few good Twitter mashups made for this event, the most popular being TweetBeat. In this post I'm showing how to build a simple service similar to TweetBeat using a publicly available real-time streaming service, Kwwika. read more...

add a comment |category: Silverlight |Views: 110

tags: Silverlight another

Say Goodbye to NAnt and MSBuild With IronRuby(www.codethinked.com)

submitted by justin_etheredge(8539) 2 years, 1 month ago

Tired of writing tons of XML in order to create automated .NET builds? Well, look no further... IronRuby, Rake, and Albacore are here to rescue you! read more...

add a comment |category: Other |Views: 651

tags: IronRuby NAnt MSBuild another

Moles: Mocking the Un-Mockable(www.dimecasts.net)

submitted by dwhittaker(13.1k) 2 years, 1 month ago

Taking at how to use Pex/Moles for .Net. Unit testing is great, but most free isolation frameworks require that your mocks implement an interface. But what do you do when the class you are trying to mock is static or sealed with no interface. If you can’t modify the class then your unit testing efforts are usually stuck. Moles, the new free isolation framework from Microsoft, supports mocking almost any CLR based class (including sealed and static classes) read more...

add a comment |category: Unit Testing |Views: 433

tags: Testing another

Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DA(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 2 months ago

SQL SERVER – Difference Between ROLLBACK IMMEDIATE and WITH NO_WAIT during ALTER DATABASE March 17, 2010 by pinaldave | Edit Today, we are going to discuss about something very simple, but quite commonly confused two options of ALTER DATABASE. The first one is ALTER DATABASE …ROLLBACK IMMEDIATE and the second one is WITH NO_WAIT. read more...

add a comment |category: Database |Views: 118

tags: SQLAuthority pinaldave SQLServer Database SQL another

Force Index Scan on Table – Use No Index to Retrieve the Data – Query(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 2 months ago

Recently I received the following two questions from readers and both the questions have very similar answers. Question 1: I have a unique requirement where I do not want to use any index of the table; how can I achieve this? Question 2: Currently my table uses clustered index and does seek operation; how can I convert seek to scan? read more...

add a comment |category: Database |Views: 122

tags: SQLAuthority pinaldave SQLServer Database SQL another

A Visual Look At The LINQ SelectMany Operator(www.codethinked.com)

submitted by justin_etheredge(8539) 2 years, 2 months ago

An inside look at how SelectMany works, along with visuals to help you more easily understand it. read more...

add a comment |category: C# |Views: 468

tags: C# another

Poll: IoC containers for .NET(www.sturmnet.org)

submitted by olivers(95) 2 years, 2 months ago

Trying to find out which IoC containers people use on .NET, or even if they use any. Put your vote in and kick it! read more...

2 comments |category: Patterns |Views: 761

tags: Patterns another

Rollback TRUNCATE Command in Transaction(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 2 months ago

Interesting Conversation on the subject. Take your side and learn along! read more...

2 comments |category: Database |Views: 241

tags: SQLAuthority pinaldave SQLServer Database SQL another

MEF will not get easier, it’s cool as ICE(blog.maartenballiauw.be)

submitted by maartenba(5845) 2 years, 2 months ago

Over the past few weeks, several people asked me to show them how to use MEF (Managed Extensibility Framework), some of them seemed to have some difficulties with the concept of MEF. I tried explaining that it will not get easier than it is currently, hence the title of this blog post. MEF is based on 3 keywords: export, import, compose. Since these 3 words all start with a letter that can be combined to a word, and MEF is cool, here’s a hint on how to remember it: MEF is cool as ICE! read more...

1 comment |category: Architecture |Views: 375

tags: MEF Architecture another

Disable All or Selective Controls on a Page using jQuery (www.devcurry.com)

submitted by mopen(3596) 2 years, 2 months ago

Disabling controls on a Page using jQuery is a cakewalk, thanks to the wonderful Selector API. Here’s an example. read more...

add a comment |category: jQuery |Views: 295

tags: jQuery another

Data and Page Compressions – Data Storage and IO Improvement(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 2 months ago

The performance of SQL Server is primarily decided by the disk I/O efficiency. Improving I/O definitely improves the performance. SQL Server 2008 introduced Data and Backup compression features to improve the disk I/O. Here, I will explain Data compression. A detail analysis of the performance along with working script. read more...

2 comments |category: Database |Views: 184

tags: SQLAuthority pinaldave SQLServer Database SQL another

DiffPlex - a .NET Diff Generator(diffplex.codeplex.com)

submitted by jemts(591) 2 years, 2 months ago

DiffPlex is a combination of a .NET Diffing Library with both a Silverlight and HTML diff viewer. It is released open source on CodePlex under the MS-PL license. read more...

1 comment |category: Open Source |Views: 516

tags: OpenSource another

Creating a Weather Gadget for Windows 7(www.dotnetcurry.com)

submitted by mopen(3596) 2 years, 3 months ago

In this article we will see how you can develop a Weather gadget for Windows 7 which uses Yahoo Weather API for fetching Weather data. The application will also have some of the latest exciting features of Windows 7 like Thumbnail Toolbar and Progress bar. read more...

add a comment |category: Windows Forms |Views: 577

tags: winforms another

Reason of Compute Scalar before Stream Aggregate(blog.sqlauthority.com)

submitted by pinaldave(9662) 2 years, 3 months ago

Running the following query will give you Stream Aggregate Operator in Execution Plan. To turn on Execution Plan, press CTRL + M. I would like to know your feedback about Stream Aggregate Operation. read more...

add a comment |category: Database |Views: 162

tags: SQLAuthority pinaldave SQLServer Database SQL another

.NET 4.0 and System.Collections.Concurrent.ConcurrentStack(www.codethinked.com)

submitted by pitadev_aj(300) 2 years, 3 months ago

The ConcurrentStack is an excellent new tool in our parallel programming toolset which allows us to get the LIFO behavior we want, all without having to worry about locking. read more...

add a comment |category: CLR |Views: 270

tags: CLR another