Blog

• Presentation Materials: TDD – Thwarting Database Defects

  

  2011-10-17 - Presentations

  Abstract It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make [more…]

• T-SQL Tuesday #22 – Data Presentation – XML Concatenation

  

  2011-09-13 - General, T-SQL Tuesday, XML

  It is T-SQL Tuesday again, the 22nd incarnation and this time the topic is the presentation of data, hosted by Robert Pearl (Blog|Twitter). Every so often you run into the problem of having to display a list of items to [more…]

• 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…]

• Google Alerts or How to find out about T-SQL Tuesday

  

  2011-08-06 - Off Topic

  This post contains a tip for the few people out there, that – like me – have been able to prevent Twitter from taking over their lives completely. The disadvantage of being in that position is, that you do not [more…]

• Presentation Materials – Concurrency Control

  

  2011-07-26 - Presentations

  Abstract This session will explain the different transaction isolation levels that SQL Server provides. You will see examples of different locking and blocking behaviors and you will gain insight into how the transaction isolation level affects query concurrency and performance. [more…]

• tSQLt V11 now available

  

  2011-07-17 - tSQLt

  We just uploaded the new version of tSQLt. Check out the changes new features in the release notes

• 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…]