June 2011 Version of SQL Server 2008 Diagnostic Queries

Since it is June, I thought it was time to update my SQL Server 2008 (and 2008 R2) Diagnostic Information...

Windows 8 demo

A Windows 8 demo was just released.  Looks really cool.  Check it out at Previewing ‘Windows 8’ as well as Microsoft’s...

Un-SQL Friday #004: Speaker Lessons Learned

I began writing a story about, shall we say, a less than positive speaking experience…and then I realized: This is...

NEW: Microsoft SQL Server 2008 R2 Administration Cookbook

I have had the pleasure of knowing and communicating with Mr. Satya Shyam K. Jayanty, aka Satya/aka SQLMaster|twitterfor several years...

Just Deserts

Here’s another photo from my phone, this one from SQLSaturday Tampa in the cafeteria area. An easy typo to make,...

Duplicate Identity Values?

Can you have duplicate values in a field with the identity property? Of course, and this does it.
DROP TABLE dbo.MyTable

CREATE...

PASS 2011 Pre-Conference Seminars and Spotlight Sessions Released

I have wanted to go to PASS Summit for the last several years, but have yet to get an opportunity...

Do You Ever Physically Defragment Your SQL Server MDF & LDF Files?

Every since the first file was written to a floppy disk drive using DOS, physical file fragmentation has been a...

DQ & MDM Book Available to Download

If you’re looking for a resource on the Data Quality and Master Data Management features in SQL Server 2008 R2,...

PerformancePoint wish list – change a datasource

One item on my PerformancePoint wish list is the ability to change a datasource for an Analytic Chart/Grid.  There is...