SQL Server Code,Tips and Tricks, Performance Tuning

Ken Henderson passed away this last Sunday . My condolences go out to his family, friends, and coworkers. I owe so much to Ken, if it wasn...

Francois Ajenstat on his blog writes that "Microsoft is excited to deliver a feature complete CTP during the Heroes Happen Here launch...

This question is asked every now and then so I decided to do a little blog post. How can you quickly without writing a bunch of OR statement...

Since I have nothing useful to post today I decided to post some links to some of my friends The first one is from someone in Belgium, his n...

This download is the January 2008 release of SQL Server 2005 Best Practices Analyzer. Get it here: http://www.microsoft.com/downloads/detail...

The last two days have been the worst of my life; it feels like he combination of a really bad hangover, the flu and a massive toothache. It...

It has been a while since my last teaser but here we go What do you think the following returns? SELECT CONVERT ( datetime , '1/1/1...

SQL Server 2005 introduced a new type of function to create a uniqueidentifier; the NEWSEQUENTIALID(). This new function has been created fo...

FAA: Boeing's New 787 May Be Vulnerable to Hacker Attack Boeing's new 787 Dreamliner passenger jet may have a serious security vulne...

Remember the How Is Your Sensitive Data Encrypted In The Database? post I wrote a while back? A colleague just informed me that he got a le...

Someone had code like this on the tek-tips forum DECLARE @v varchar (24) SELECT @v = '06029202400250029' SELECT RIGHT (@v,4) - SU...

Here is the list of the ten most popular posts for 2007 in terms of pageviews according to Google Analytics 1 The Sysinternals Troubleshooti...

Here is the list of the ten most popular posts in terms of pageviews since I started collecting this info with google Analytics. I haven...

Take a look at this post: Rails Is A Ghetto This is probably one of the longest rants I have ever seen, interesting but be warned NSFW

Go to DotNetRocks, download show number 300, fast forward to 57:45 and start listening. It is the funniest geek story I have ever heard. You...

These are the best posts according to me, it might have been the content or it might have been the comments. Either way here are the 21 + 1 ...

Red Gate have released Red Gate SQL Data Generator 1.0 Beta From the site: This tool is aimed at generating test data for SQL Server databas...

This is the final part of this series. You can find the first two parts here Part 1 The Phone Interview Part 2 The face to face interview. A...

This is priceless Alien VS Predator picture In case you wonder which one the predator is, here is a hint one of them preys on children :-)