Monthly Archive: March 2010

The pros and cons of learning

The pros and cons of learning

This week I am at a training course put on by Paul Randal (blog | twitter) and Kimberly Tripp (blog | twitter) entitled "SQL Immersion."  It is essentially a 5-day deep dive into some...

More info: a "stand-alone" installer for Management Studio Express 2008

More info: a "stand-alone" installer for Management Studio Express 2008

Last February, I blogged about something I was initially very happy about: a stand-alone installer for Management Studio Express (SSMSE) 2008.  Now users could allegedly download a much smaller installer, and only install the...

Updated slide decks from SSMS presentation at SNESSUG

Updated slide decks from SSMS presentation at SNESSUG

Tonight I spoke at the SNESSUG user group meeting in Warwick, RI.  You can download the slide deck here (this is a 3.5 MB PDF with presenter notes): http://sqlblog.com/files/folders/23423/download.aspx If you attended the talk,...

Yes, you can benefit from both data and backup compression

Yes, you can benefit from both data and backup compression

Earlier today, MSSQLTips posted a backup compression tip by Thomas LaRock (blog | twitter).  In that article, Tom states: "If you are already compressing data then you will not see much benefit from backup...

The ethics of aggregating other peoples' content

The ethics of aggregating other peoples' content

Content theft Most of the recent – what I'll call – "discussions" about content aggregators have revolved around content theft.  I'm not going to flip-flop on that topic: when you use someone else's work,...

Bad habits to kick : ignoring I/O

Bad habits to kick : ignoring I/O

In my last post in this series, I talked about problems associated with creating (and using) what I call the "uber-view."  This time, in line with tomorrow's T-SQL Tuesday hosted by Mike Walsh, I...

Bad habits to kick : creating the uber-view

Bad habits to kick : creating the uber-view

In my last post in this series, I talked about using ancient copies of Books Online, and why it can be important to keep your local documentation current.  This time I wanted to touch...

SQL Saturday #33 : slide deck, recap and shout-outs

SQL Saturday #33 : slide deck, recap and shout-outs

[Sorry I have been a little absent over the past couple of weeks.  Returning from the Olympics just a little over a week ago meant some busy catch-up and a heavy lead-in to today's...