Management Studio Tips & Tricks, version 1.0

Today I presented "Management Studio Tips & Tricks" at SQL Saturday #34 in Waltham, MA.  I had an audience of close to 100 (my biggest talk yet!), and unless they were stroking my ego, I achieved my primary goal for the session: to make sure that every single person in […]

Decrypting : A question of morals, ethics, or both?

In essence, encryption of code within the engine is more like obfuscation than anything else.  Unlike passwords and other sensitive data, the engine has to be able to read the code, so there has to be a way to reverse the so-called "encryption."  While the engine inherently has the ability […]

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 9:30 AM.  There are plenty of other great speakers, lunch will be provided, and best of […]

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 a quick query to parse the showplan XML and order results by cost descending.  The Connect […]

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 in general, I find the new procedure much more convenient : just go to the KB […]

"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 you've read my previous posts about my career (in particular, this one), you'll know that I'm […]

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 again notice the trend that the "newer" branch (SP1) has more fixes than the RTM branch.  […]

When you don't follow your own "bad habits" advice…

Today I came across a self-created problem that could have been avoided if I had only followed my own advice.  It wasn't directly and explicitly mentioned in this context, but the concept is the same.  Let's start with the source of the problem: one stored procedure that called another.  The […]

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 as "won't fix" but it's been shown time and time again that in some cases we […]

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 runs Windows Server 2003 R2 Enterprise, 32-bit, with 4 dual-core CPUs and 16GB of RAM.  The […]