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...

SQL Server 2011 CTP3 (Denali) Released

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

SQL Server Denali CTP3: Policy Based Management

Whether you know it or not, Policy-Based Management is an integral part of the new release of SQL Server “Denali”....

SQLDIY: Index Usage Statistics

There are several different aspects of indexes that can be monitored via DMV’s. One the neatest things is just how...

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,...

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...

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...

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....

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,...

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...