My Fall Speaking Schedule
SQLSaturday #84 : Kalamazoo, MI : September 17th I will be giving two sessions at SQLSaturday #84 in Kalamazoo, Michigan. One is on "What's New in SQL Server Denali" and the other, "T-SQL :...
SQLSaturday #84 : Kalamazoo, MI : September 17th I will be giving two sessions at SQLSaturday #84 in Kalamazoo, Michigan. One is on "What's New in SQL Server Denali" and the other, "T-SQL :...
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...
This question came up on twitter, and I thought a quick blog post would be better than a series of 140-character snippets. Management Studio does not do the best job at highlighting missing indexes....
Last night Microsoft released a new cumulative update package (CU #9) for SQL Server 2008 R2. The build # is 10.50.1804 and it contains 26 fixes – some of which, like the new CU...
Last night Microsoft has released Cumulative Update #2 for SQL Server 2008 R2 Service Pack 1. The build # is 10.50.2772 and it contains 14 fixes, a few of which are wrong-results bugs or...
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...
As its name implies, the FORMAT() function was added to Denali in CTP3 to make formatting easier. For the purists, all formatting should be done at the presentation layer. For the rest of us,...
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...
If you have access to both a CTP3 instance and a CTP1 instance, and the CTP3 instance can see the CTP1 instance, you can run all of these queries simply by creating a linked...
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...
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...