Savepoints: The Other Other White Meat

29 September 2010 by Bob Pusateri in SQL Server , SQLServerPedia Syndication with zero comments

Most T-SQL guides and tutorials I’ve seen concentrate on the following transaction commands: BEGIN, COMMIT, and ROLLBACK, which I’ll henceforth refer to as the “big three”. While they’re certainly very important, there’s also a fourth command, SAVE, which is typically treated like a distant cousin who’s only seen at family reunions every few years. [...]

Leave a comment

SQL Saturday #50 Wrap-up

21 September 2010 by Bob Pusateri in Speaking , SQL Server , SQLServerPedia Syndication with 5 comments

I had the immense pleasure of speaking at SQL Saturday #50 in Iowa City this past weekend. To say it was an awesome time would be quite the understatement. Special thanks to Michelle Ufford (blog | twitter), Ed Leighton-Dick (twitter) and Jeff Belina (twitter) for all you did to make this event possible. [...]

5 comments

Potty Chairs and Duplicate Indexes

14 September 2010 by Bob Pusateri in SQL Server , SQLServerPedia Syndication , TSQL Tuesday with 3 comments

This post is my contribution to T-SQL Tuesday #10, which is being hosted by Michael J. Swart (blog | twitter)

Each year my Boy Scout troop has a rummage sale as a fundraiser.  All the scouts and their families gather up their old clothes, books, toys, electronics, and any other treasures they no longer need and [...]

3 comments

A Look at the SQL Server Browser Service

1 September 2010 by Bob Pusateri in SQL Server , SQLServerPedia Syndication with 2 comments

Let’s say you’re starting off in a new environment (new job, department, client, whatever) and after being shown your workspace and meeting with your supervisor, you sit down to start figuring out their databases.  You send an email requesting the name of the development database, and the reply you get is as follows:

DevDB1\Blah, 1436  (It’s [...]

2 comments