SQL Server 2011 (Denali) CTP3 Released!

I started this blog a few weeks ago when I heard rumors that CTP3 was coming soon, but figured that...

Subtle Errors When Using Dates-Part 2

It’s so easy to make make mistakes with dates. Here is another one I saw recently, this one used when...

SQLSaturday #80 - Wheeling, West Virginia!

Next up, on the super SQLSaturday extravaganza, is SQLSaturday #80, in Wheeling, West Virginia!  Wheeling, known as the friendly city,...

Which database is using all my CPU #2

A few weeks back we wrote about a query to tell you which database is using up most CPU time....

Teaching Transact-SQL at University of Denver, University College

Starting this week on Wednesday night, I will be teaching a special five-week condensed version of ICT 4462, Transact-SQL Programming...

Select random records using TABLESAMPLE clause

While I was reading Martin Catherall’s post about Selecting from a table with no rows returned I remembered TABLESAMPLE function...

5 Ways to Be a More Effective DBA Today

Regular readers will now that I like to talk (quite a lot) about how we can be more effective as...

2011 SQL Rally Evaluations - Reporting Services Boot Camp

I wrote this early in June, but lost it in my blog pile again and just found it…

First and foremost,...

SQL Server Myth on Clustered Index page allocation or B-Tree formation

Here is another SQL Server myth which I realised while understanding anatomy of index pages.
For a long time I...

How to move the Master database

The catch to moving the Master database is that you must also move the Resource database.  Microsoft states that the...