Management Studio Tips & Tricks, version 1.0
Today I presented "Management Studio Tips & Tricks" at SQLSaturday #34 in Waltham, MA. I had an audience of close to 100 (my biggest talk yet!), and unless they were stroking my ego, I...
Today I presented "Management Studio Tips & Tricks" at SQLSaturday #34 in Waltham, MA. I had an audience of close to 100 (my biggest talk yet!), and unless they were stroking my ego, I...
The behavior of column matching in subqueries is a little peculiar, to say the least. If you've been bitten by this behavior once, you're unlikely to have been bitten a second time, but for...
Michelle Ufford (@SQLFool) has just announced some shiny new updates to her popular index maintenance scripts. Read about them and contact her if you're interested in beta testing: http://sqlfool.com/2010/01/index-defrag-script-updates-beta-testers-needed/
Decrypting an encrypted stored procedure is not difficult – but is it ethical?
Just a quick reminder that I will be presenting a Management Studio Tips & Tricks talk at SQLSaturday #34, this Saturday, January 30th at the Microsoft offices in Waltham, Massachusetts. I go on at...
Give us easier to read execution plans Michelle Ufford (@SQLFool) recently asked for help pinpointing the most expensive node(s) in a complicated execution plan. Mladen Prajdic (@MladenPrajdic) has a useful workaround; he coded up...
It used to be very difficult to obtain hotfixes for SQL Server (sometimes even to learn about their existence), and they were often unsupported. They have made extremely great strides in this area, and...
I was tagged by Tim Mitchell (twitter) in a recent meme launched by Paul Randal (twitter), entitled, "What three events brought you here?" Well, I've lied told stories about this in the past. If...
Late last night, the SQL Server Release Services team announced new cumulative updates for both SQL Server 2008 RTM and SQL Server 2008 SP1. There are too many fixes to mention, but I once...
I tried to deploy nested stored procedures that both had a cursor with the same name. SQL Server didn't like it.
Control over procedure cache We are still waiting for more control over procedure cache. Adam Machanic wrote up this blog post highlighting a Connect item which he opened in 2007. It is currently closed...
About two months ago, I began planning a cluster migration for one of our primary SQL Server 2005 clusters to newer hardware, and a simultaneous upgrade to SQL Server 2008 SP1. The old system...
I am putting together a presentation on SSMS Tips & Tricks, which I will debut at SQLSaturday #34. I already have a pretty full slide deck, but I am not the be-all and end-all...