2009 Presentations

Posted by .

The following is a list of presentations from that I delivered in 2009.  For each presentation there is a link to the event and the presentation materials, if they are still available.

If you are interested in having any of the presentations delivered for you user group or company, just reach out and we’ll see if we can work out a time that works.

  • TechFuse 2009 (March 17, 2009)
    • Upgrade to SQL Server 2008 – Before This Presentation Finishes – In this session we’ll review lessons learned and best practices when upgrading from previous versions of SQL Server to SQL Server 2008. In this session we’ll go through the changes to the installation and upgrade to SQL Server 2008. Also, how do you prepare for the upgrade? Do you install now or wait until later? Can your production database be upgraded in less time that it takes to complete this session?
  • PASSMN (April 21, 2009)
    • Drive Your Way to the DMV – Dynamic Management Views (DMVs) and Dynamic Management Functions (DMF) have been around since the release of SQL Server 2005. But for many people DMVs and DMFs are still a mystery. Step under the hood and review some of the main DMVs and DMFs in SQL Server. From sessions to caches, this session will provide a walk-through of some of the more useful DMVs and a practical look at how they can be used?
  • SSWUG Virtual Conference 2009 Spring (April 22-24, 2009)
    • Extended Events, Work Smarter Not Harder – There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.
    • Do Certifications Really Matter? – Microsoft has a number of certifications for SQL Server. They cover the DBA, developer and business intelligence skills. But, does anyone take them seriously? In this session, see the tracks for SQL Server certifications and discover what you need to know about the exams. Which track will be right for you? What steps should you take? How do you get going? And what value will they bring to your career?
    • ABCs of CTEs – Common Table Expressions (CTE) aren’t as common as their name implies. CTEs are often seen as a secret part of the dark art of recursion. This session will explore CTEs to show how they can be extremely useful in improving performance and legibility of T-SQL code. And, of course, we will look at their use in returning recursive data.
    • Become Your Own Picasso Writing Better T-SQL (V2) – While not everyone can be a Picasso, there is an art form to writing great SQL statements. In this session we’ll go over tips and tricks in writing SQL. We’ll also review some popular bad practices and provide demonstrations to better change those velvet Elvis’s to Rembrandts. As every paint brush can’t produce a masterpiece, the same goes for SQL statements. Writing good SQL code requires the right brush. After this session, you’ll have a few more paintbrushes and probably throw out a few that are no longer useful.
  • SSWUG Virtual Conference 2009 Summer (July 22-24, 2009)
    • ABCs of CTEs – Common Table Expressions (CTE) aren’t as common as their name implies. CTEs are often seen as a secret part of the dark art of recursion. This session will explore CTEs to show how they can be extremely useful in improving performance and legibility of T-SQL code. And, of course, we will look at their use in returning recursive data.
    • Extended Events, Because I Want the Answer Today – There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.
    • Drive Your Way to the DMV – Dynamic Management Views (DMVs) and Dynamic Management Functions (DMF) have been around since the release of SQL Server 2005. But for many people DMVs and DMFs are still a mystery. Step under the hood and review some of the main DMVs and DMFs in SQL Server. From sessions to caches, this session will provide a walk-through of some of the more useful DMVs and a practical look at how they can be used.
  • PASSMN SQL Summit (September 25, 2009)
    • Necessary Evils, Building Optimized CRUD Procedures – Every developer loves them and a lot of DBAs hate them. But there are many and valid reasons for creating generic SELECT, INSERT, UPDATE, and DELETE procedures. In this session, we’ll go through designing CRUD procedures that utilize new and existing SQL features to create CRUD procedures that are optimized for performance
  • PASSMN (October 20, 2009)
    • Getting To Know Your Indexes – Without proper indexing SQL Server can be hard pressed to create efficient and performant execution plans. Dynamic Management Views (DMV) and system views provide a slew of information about indexes that can be used to analyze indexes within SQL Server. In this session we’ll go under the hood of SQL Server to look at DMVs and system views to know what indexes you have, should have, and how they feel about the way applications are treating them.
  • SQL Saturday 19 (October 17, 2009)
    • Improving Daily Imports with Partitioned Tables – At some point, everyone struggles with loading data to OLTP systems. The business needs the data loaded so that users can work through the data. But the users can’t afford the downtime to get the data into the production tables. In this session we’ll review this problem and how to use partitioning to alleviate this issue.
    • Drive Your Way to the DMV - Dynamic Management Views (DMVs) and Dynamic Management Functions (DMF) have been around since the release of SQL Server 2005. But for many people DMVs and DMFs are still a mystery. Step under the hood and review some of the main DMVs and DMFs in SQL Server. From sessions to caches, this session will provide a walk-through of some of the more useful DMVs and a practical look at how they can be used?
    • Extended Events, Work Smarter Not Harder – There are many ways to performance monitor your SQL Server environment. In this session we’ll review Extended Events, which is one of the newer SQL Server monitoring platforms. Learn the ins and outs of how to get detailed information on the errors and events that occur within SQL Server and how to dig into the information. With a few T-SQL statements, issues that could take weeks to research can be investigated in minutes.
    • ABCs of CTEs – Common Table Expressions (CTE) aren’t as common as their name implies. CTEs are often seen as a secret part of the dark art of recursion. This session will explore CTEs to show how they can be extremely useful in improving performance and legibility of T-SQL code. And, of course, we will look at their use in returning recursive data.
  • SSWUG Virtual Conference 2009 Fall (October 21-23, 2009)
    • Solving Business Pains with SSIS – SQL Server Integration Services (SSIS) offers a wide range of features and functionality that can be used to solve business pains within Extract, Transform, and Load (ETL) processes. These pains can be caused by the performance of current ETL process, the maintainability of ETL processes or represent a new pain that SSIS features can resolve. This presentation will provide a demonstration of real world scenarios where features of SSIS were used to solve business pains through modification of existing SSIS packages or through the creation of new SSIS packages. The session will also discuss current best practices in SSIS package design.
    • Are You Following Your Own Best Practices – SQL Server
      Everyone has their own best practices that they try to follow. But often times we aren’t sure how well we are following our own or industry best practices. In this session we’ll go into monitoring and managing best practices throughout your environment. The session will look at how to create a solution using policy based management and other tools to report on your compliance to best practices.
    • Improving Daily Imports With Partitioned Tables – At some point, everyone struggles with loading data to OLTP systems. The business needs the data loaded so that users can work through the data. But the users can’t afford the downtime to get the data into the production tables. In this session we’ll review this problem and how to use partitioning to alleviate this issue
    • Necessary Evils, Building Optimized CRUD Procedures – Every developer loves them and a lot of DBAs hate them. But there are many and valid reasons for creating generic SELECT, INSERT, UPDATE, and DELETE procedures. In this session, we’ll go through designing CRUD procedures that utilize new and existing SQL features to create CRUD procedures that are optimized for performance
  • Twin Cities Code Camp 7 (October 24, 2009)
    • Backups! Don’t Get Caught With Your Pants Down! – Backups! Don’t Get Caught With Your Pants Down! – Did you hear about the blog site that disappeared when their system failed and they didn’t have a backup to restore from? Or how about the pet supplier that went out of business after a DELETE statement removed everything from their database and there wasn’t a backup on hand. These aren’t urban myths but rather typical stories that make the news every couple months. Is your company one database failure from collapse? In this session, we’ll go over the basis of backups. And also go over the basics and best practices in creating a backup and recovery strategy.
  • PASS Summit 2009 (November 2-5, 2009 )
    • Getting To Know Your Indexes – Without proper indexing SQL Server can be hard pressed to create efficient and performant execution plans. Dynamic Management Views (DMV) and system views provide a slew of information about indexes that can be used to analyze indexes within SQL Server. In this session we’ll go under the hood of SQL Server to look at DMVs and system views to know what indexes you have, should have, and how they feel about the way applications are treating them. (SpeakerRate | Download: Getting To Know Your Indexes )