Blog

• A Join A Day – The Cross Join

  

  2012-12-04 - A Join A Day, Fundamentals, Series, T-SQL Statements

  In this 4th post of the ‘A Join A Day’ series we are going to take a detailed look at the cross join statement. The cross join is probably the simplest of all join commands, but it still has its surprises. Read on, to find out more.

  [more…]

• T-SQL Tuesday #37 – Invite to Join me in a Month of Joins

  

  2012-12-03 - A Join A Day, General, Series, T-SQL Tuesday

  It is T-SQL Tuesday time again. For T-SQL Tuesday #37 I would like to ask you to join me in a month of joins.

  [more…]

• A Join A Day – The Inner Join

  

  2012-12-02 - A Join A Day, Fundamentals, Series, T-SQL Statements

  This post looks at the inner join T-SQL command. After reading you will be able to use it and explain how it handles data and how to identify it in an execution plan.

  [more…]

• A Join A Day – Introduction

  

  2012-12-01 - A Join A Day, Fundamentals, General, Series

  In December 2012 I am going to publish one post per day about SQL Server Joins. With topics ranging from fundamentals to internals there should be something interesting in there for everyone.

  [more…]

• Presentation Materials: 5 Key Points for Effective T-SQL Unit Testing

  

  2012-11-30 - Presentations

  The 5 Key Points for Effective T-SQL Unit Testing presentation covers topics like framework selection, test-case selection, separation of concerns and some T-SQL unit testing specific topics. [more…]

• Temp Tables – Scoping & Eclipsing

  

  2012-10-16 - General, TempDb

  How long does a temp table live? Who can see and access it? What other types of temporary objects exist? What is a temp table Eclipse? This article will take an in-depth look at temporary objects and answer questions like the ones above.

  [more…]

• Renaming a Windows Machine hosting SQL Server

  

  2012-08-26 - General

  Renaming a Windows server hosting a SQL Server installation is fairly straight forward. Most of the changes necessary for SQL Server to continue to work happen automatically the next time SQL Server restarts. However there is one notable exception…

  [more…]

• SQL In The City – Agile Database Development Training

  

  2012-08-16 - Public Class

  Announcing the Agile Database Development Training tour, following the SQL In The City training events. [more…]

• Presentation Materials – Columnstore Index Internals

  

  2012-08-08 - Presentations

  In this session we are going to take a deep dive into the columnstore index feature introduced in SQL Server 2012. We will compare columnstore with b-tree indexes and see why a columnstore index is not really an index at all.

  After attending you will be able to identify queries that will benefit from columnar storage. You will be able to explain how the data in a columnstore index is stored on disk and which access mechanisms are available to SQL Server. You will be able to see whether a query is running in row mode or is utilizing the new batch mode and explain the difference between the two.

  In this talk we will also cover the gaps that were left in the current implementation, scheduled to be filled in a future version of SQL Server.

  [more…]

• Blob and Row Overflow Storage Internals – Row-Overflow Data

  

  2012-07-31 - General, SQL Server Internals

  Row-Overflow data storage is a mechanism that was introduce in SQL Server 2005. It allows for more flexibility when designing tables as it makes it possible to store more than 8060 byte in a single row. This article shows how this mechanism is working under the covers.

  [more…]