SQL Server Code,Tips and Tricks, Performance Tuning

VS2008 Training Kit: Building Windows Presentation Foundation Applications in Visual Studio 2008 and Expression Blend This session was prese...

The .NET Framework 3.5 Common Namespaces and Types Poster is downloadable as XPS or PDF format. There is also an XPS format file which print...

Group 1: Portugal, Sweden, Denmark, Hungary, Albania, Malta Group 2: Greece, Israel, Switzerland, Moldova, Latvia, Luxembourg Group 3: Czech...

Brian Kelly on his blog mentiones a whitepaper by Cesar Cerrudo : Data0: Next generation malware for stealing databases . This whitepaper d...

England and Croatia in the same group again for World Cup 2010 qualifications: Group 6: Croatia, England, Ukraine, Belarus, Kazakhstan, Ando...

Here is a small simple Thanksgiving teaser. What do you think will the result be of the select count query? USE tempdb GO CREATE TABLE Cus...

This CTP resolves a problem that when you try to open a database connection to SQL Server 2008 by using Visual Studio 2005 design tools, you...

Just reading the readme file in SQL Server 2008 November CTP. I noticed that in addition to SQL Server Notification Services the following t...

Microsoft SQL Server 2008 CTP, November 2007 is available for download from the connect site. There are several formats available. DVD image...

Yes it is true, Visual Studio 2008 RTM is available on MSDN. But be warned the site is slower than ever. Okay I downloaded it and installed ...

MSDN Subscriptions WebLog Has a post stating that Visual Studio 2008 will be available early next week. From the site: Visual Studio 2008 i...

Channel 9 will be publishing a bunch of Business Intelligence Screen Casts. This screencast is the first in a series BI Developer screencast...

I was writing a query and managed to mistype INTERSECT, I typed INTERCEPT and to my surprise the query ran, it returned 2 result set just as...

Do you store encrypted data? If you do then how is it encrypted? Do you use the built in capabilities of SQL Server 2005/2008. If you answer...

Print the @SQL variable without using PRINT DECLARE @SQL varchar (49) SELECT @SQL = 'Print This Now ' + CONVERT ( VARCHAR (30), ...

Microsoft leaning has made available a bunch of free SQL server 2008 lessons In this 3 hour online collection, IT Professionals will learn a...

You need to return NULL only if the value of your data is a certain value. How do you do this? There are three different ways. NULLIF DECLAR...

Note from my manager: "All, It looks like we have some book money left for this year that we can spend. Please select 2 books each that...

Today, during the keynote address at Microsoft TechEd Developers 2007, S. “Soma” Somasegar, corporate vice president of the Developer Divisi...

How many Java programmers does it take to round up to a power of two? Well take a look: http://forum.java.sun.com/thread.jspa?threadID=24821...