Monthly Archives: August 2011

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

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

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

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