SQL Server Code,Tips and Tricks, Performance Tuning

Microsoft issued a Katmai press release, you can read the full press release here: http://www.microsoft.com/presspass/press/2007/may07/05-09...

How do you select all the rows that contain uppercase characters only? There sre three ways to do this 1 Compare with BINARY_CHECKSUM 2 Use ...

What is new? 3+4 part name resolution through a new feature called "database references" File groups and files are now part of the...

Here is an email I received from 'Bank Of America' Dear Customer, picopaco. You are receiving this message, due to you protection, O...

The supported languages are C#, VB, JScript, IronPython, VB10 (soon), IronRuby (soon). VB10 soon???? VB9 isn't even out yet. LINQ is sup...

Microsoft SQL Server Community Samples: Service Broker On CodePlex Don't get all excited yet because nothing is available yet. I am just...

Okay so SIMP is not LAMP but it is interesting that Microsoft is doing a demo with MySQL and PHP Read more here: http://channel9.msdn.com/Sh...

The daily WTF (Worse Than Failure) has a forum with the following name: the The I-Hate-Oracle Club "Because it's time we senselessl...

Jeff Atwood is on the latest podcast from DotNetRocks, Jeff Atwood is the guy who blogs on CodingHorror . If you have never heard of CodingH...

Microsoft has a bunch of samples on their sitethat show how Lambda Expressions, LINQ, DLINQ And XLINQ work in Visual Studio Orcas Beta 1 Thi...

Reminds me of the first time I played tetris, very addictive. And no my wife doesn't appreciate the fact that I found this game URL belo...

Brian Welcker has posted a change that Microsoft is considering making in the next version of SQL Server (Katmai) for SQL Server Reporting S...

Do you use the following syntax? SELECT * FROM TABLE WHERE CoLumn IN (SELECT Column FROM TABLE) OR this? SELECT * FROM TABLE WHERE CoLumn NO...

There is a new sample database available for SQL Server 2005. The name of this database is AdventureWorksLT , this database is a stripped do...

I installed Visual Studio Orcas Beta 1 last night and now I am playing around with LINQ You know how you can do the following in SQL SELECT ...

Do you know which hotfix you have to instal to fix SQL Server 2005 Service Pack 2? If SQL Server is between 3042 and 3053, get build 3054 If...

Visual Studio Code Name “Orcas” Beta 1 Visual Studio code name "Orcas" is the next generation development tool for Windows Vista, ...

If you are a SQL developer then you know who Itzik Ben-Gan is. If for some strange reason you don’t know then listen up. Itzik is a SQL S...

I found this funny pic of the man who gave us newsgroup gems like this for example: ">> Any suggestion is greatly appreciated. EV...

This is the final word on SQL Server 2005 Service Pack 2 (at least from me, I promise) It is all explained here: http://blogs.msdn.com/psssq...