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...
Monthly Archive: January 2010
Sometimes it's the small things : match column names in subqueries
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...
SQLFool has updated her index maintenance scripts and needs testers!
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 : A question of morals, ethics, or both?
Decrypting an encrypted stored procedure is not difficult – but is it ethical?
Speaking at SQLSaturday #34 in Boston, 2010-01-30
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...
Connect Digest : 2010-01-22
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...
Mis-steps in the publication of Cumulative Updates
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...
"What three events brought you here?"
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...
New Cumulative Updates for SQL Server 2008 RTM & SP1
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...
When you don't follow your own "bad habits" advice…
I tried to deploy nested stored procedures that both had a cursor with the same name. SQL Server didn't like it.
Connect Digest : 2010-01-11
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...
My experiences upgrading 2005 => 2008
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...
Quick poll : what is your favorite Management Studio tip or trick?
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...