Monthly Archive: January 2010

Management Studio Tips & Tricks, version 1.0

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

Sometimes it's the small things : match column names in subqueries

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!

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

Speaking at SQLSaturday #34 in Boston, 2010-01-30

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

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

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?"

"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

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…

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

Connect Digest : 2010-01-11

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

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?

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 SQL Saturday #34.  I already have a pretty full slide deck, but I am not the be-all and...