PASS Elections – Improving the Process

Since there has been a bit of a furor over the PASS election process the past 2 years I thought...

Common SQL Server Mistakes – Multi Row DML Triggers

How often have you seen someone write a DML trigger like this:
createtrigger mytrigger on Mytable forinsertas

declare @id int
select @id = id...

Microsoft Releases SQL Server 2008 SP1 Cumulative Update 10

On September 21, 2010, Microsoft released SQL Server 2008 SP1 Cumulative Update 10, which is Build 2799. I count 29...

Braindumps and Certification

I saw a post recently that said that braindumps were the best way to prepare for certifications. It was posted...

Why You Should Come to SQL Saturday #48 - Columbia, SC

SQL Saturday #48 is on October 2. We're offering free SQL Server and PowerShell training from some great names in...

Range locks do not only occur in Serializable transactions....

According to BOL, "Key-range locks protect a range of rows implicitly included in a record set being read by a...

Updates on SQLSaturday#59 in NYC

Hi, ALL:  Just want to bring you some updates and news on SQLSaturday#59 @MS HQ in NYC on Nov 20, 2010. ...

Index Black Ops Part 3 – Index Usage

Last week, I mentioned in my TSQL2sDay index summary post, that I’d be writing a few posts on the information...

What Did that Geek Just Say?

The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people...

What Did that Geek Just Say?

The National Institute of Standards and Technology, NIST, maintains a Dictionary of Algorithms and Data Structures. The dictionary is a great place to go to find out what people...