Monthly Archive: August 2011

My Fall Speaking Schedule

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

A CTP for SQL Server 2008 Service Pack 3 is available

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

How to find missing indexes quickly in SQL Sentry Plan Explorer

How to find missing indexes quickly in SQL Sentry Plan Explorer

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

Cumulative Update #9 for SQL Server 2008 R2 RTM is available

Cumulative Update #9 for SQL Server 2008 R2 RTM is available

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

Cumulative Update #2 for SQL Server 2008 R2 SP1 is available

Cumulative Update #2 for SQL Server 2008 R2 SP1 is available

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

T-SQL Tuesday #21 : Crap Code

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

SQL Server v.Next (Denali) : CTP3 T-SQL Enhancements : FORMAT()

SQL Server v.Next (Denali) : CTP3 T-SQL Enhancements : FORMAT()

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

Connect Digest : 2011-08-08

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

SQL Server v.Next (Denali) : Changes to system objects in CTP3

SQL Server v.Next (Denali) : Changes to system objects in CTP3

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

sys.sp_hexadecimal : A Quasi-System 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...

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

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