A Identity Bug

Someone asked an interesting question recently. If they had this code:
if OBJECT_ID('aa') is not null
   drop table aa
create table...

News

If you follow me on Twitter or are my friend on Facebook, you might already know the news. I am joining...

PASS Update #29

By the time you read this we’ll have completed the transfer of the SQLSaturday web sites and data to PASS...

SQLSaturday #41 - Atlanta Session Recap

Last Saturday, April 24, I presented my session, Why I Use Stored Procedures and You Should Too, at SQLSaturday #41-Atlanta, see...

When was SQL Server last restarted?

How do you tell when your SQL instance was lasted restarted?
I was reading a post by Joe Webb (Blog|Twitter) about...

A DMV a Day – Day 28

The DMV for Day 28 is sys.dm_io_pending_io_requests, which is described by BOL as:
Returns a row for each pending I/O request...

Backup Compression in SQL Server 2008 – The Complete Presentation

From the PASS 2010 Summit Survey: 29% of people want a presentation on backup compression. OK, here it is.

Turn it...

How to Tell When SQL Server Started?

As a consultant, I’m regularly asked to diagnose and solve problems when I have incomplete or conflicting information given to...

Social Networking and SQLSaturday

I think we do a pretty good job of delivering technical content, but not such a great job at getting...

SQL Server Connection Strings

The purpose of this short post is to demonstrate a simple method of generating an accurate SQL Server connection string...