Category: General

• Connections to a Database

  

  2011-09-05 - General, SQL Server Internals

  Sometimes you need to know who is currently connected to specific database. While certainly not the only reason, the need for this information arises most often after receiving an error message like this one: Msg 3702, Level 16, State 3, [more…]

• Identity Crisis

  

  2011-08-27 - General, SQL Server Internals

  I wanted to write about this one for a while now but never got around to it. Today I came across a Connect issue that reminded me of this topic again. If you have bee around SQL Server for a [more…]

• Denali CTP3 Product Guide

  

  2011-08-14 - General

  It has been mentioned in several places already (e.g. in Denali & CTP3) but I think it is interesting enough to be mentioned again: The Microsoft® SQL Server® code name ‘Denali’, Community Technology Preview 3 (CTP 3) Product Guide. It [more…]

• T-SQL Tuesday #21 – Oh crap…

  

  2011-08-10 - General, T-SQL Tuesday

  This weeks SQL Tuesday, hosted by Adam Machanic (blog, twitter) himself, is about crappy things from our past… The first thing that popped into my head when reading Adams post was a story about a hack that, while I did [more…]

• T-SQL Tuesday #20 – T-SQL Best Practices

  

  2011-07-12 - General, T-SQL Tuesday

  This post is my contribution to T-SQL Tuesday #20, hosted by Amit Banerjee (blog | twitter). This month’s topic is “T-SQL Best Practices”. Interfaces In OOP it is a common best practice to use interfaces. Interfaces provide a layer of [more…]