My Fall Speaking Schedule

SQL Saturday #84 : Kalamazoo, MI : September 17th I will be giving two sessions at SQL Saturday #84 in Kalamazoo, Michigan. One is on "What's New in SQL Server Denali" and the other, "T-SQL : Bad Habits to Kick," is basically a summary of my "Bad Habits to Kick" […]

A CTP for SQL Server 2008 Service Pack 3 is available

Yesterday Microsoft made available Community Technology Preview (CTP) of Service Pack 3 for SQL Server 2008. This allows you to test the service pack in your test or QA environments before deploying the eventual final release, and also to provide feedback to Microsoft about potential issues with the service pack. […]

T-SQL Tuesday #21 : Crap Code

Yes, Adam is right: we've all written crap code (the topic of this month's T-SQL Tuesday Wednesday. Usually we have an excuse: tight deadline, short shelf life of the code, or didn't know any better. I'm sure if I perused my career codebase I'd find tons and tons of examples […]

Connect Digest : 2011-08-08

This week I reported a few bugs – one with sp_helptext, one with Activity Monitor in Management Studio, and one in the new sys.dm_server_services DMV. #683234 : sp_helptext treats non-system objects as system objects For this one there is at least one weird case where running sp_helptext against on object […]

sys.sp_hexadecimal : A Quasi-System Object?

In KB #918992 and KB #246133, which describe how to transfer logins between instances, Microsoft recommends creating a user procedure in master called sp_hexadecimal (with no schema prefix, tsk tsk). Since I know there have been a lot of people who have created this procedure in SQL Server 2008 R2 […]

SQL Sentry Plan Explorer : New release and an SSMS add-in

Today we released a new build of SQL Sentry Plan Explorer. The build # is 6.2.34 and you can download it from the usual location. Plan Explorer Changes The updates in this release include the following: A new "Check for Updates" feature accessible via the Help menu: Other new additions […]