Category: Presentations

  • Presentation Materials: 15 Aspects of SQL Server Indexes that You Might Not Know

    2013-04-12 - Presentations

    Abstract You probably know that indexes make you queries faster. But do you know why? Knowing how the different index types work under the covers will help you make the right decisions when (re-)designing you indexing strategy. After attending this [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…]

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

  • Presentation Materials – Index Internals

    2012-01-22 - Presentations

    Abstract In this session we will examine one of SQL Servers’ most fundamental yet most important functions – how does SQL Server store data on disk and how does it find it again when executing a query. Using a combination [more…]

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