SQL Saturday 114 in Vancouver BC

Notes from my presentation at SQL Saturday 114 in Vancouver BC on March 17, 2012.

Unleashing Common Table Expressions in SQL Server

Have you ever wanted to create a recursive query, but didn’t see how to do it. With the Common Table Expressions class you will learn everything needed to start using CTE‘s for recursive queries, as a temporary views, and to use the result set multiple times in the same query. Learn how simplify query syntax using CTE‘s. One of the most overlooked features of SQL Server is the CTE which no only simplifies the query, but gives you the ability to do things that would otherwise be impossible (or at least very challenging) with SQL Server. This presentation is targeted for database programmers and administrators who are familiar with TRANSACT SQL, Subqueries, and advanced join techniques.

Session Level: Intermediate

Presentation:  Powerpoint and SQL examples…    SteveStedman_CTE_Vancouver.zip

Using SSRS reports to analyze SQL Server health

Assessing the health of your SQL Server with Several SQL Server Report Server reports designed for DBA’s and database developers to diagnose, and locate common pitfalls of SQL Server. This includes reports for Duplicate Indexes, Index Fragmentation, Big Indexes, Backup Status – backup log, Big One Time Use Queries, Queries Needing Parameters and more.

Session Level: Intermediate

Presentation:  Powerpoint and SQL examples…    ServerHealth_SteveStedman.zip

More info the Server Health project.

13 Responses to SQL Saturday 114 in Vancouver BC

  1. Pingback: » A Great Day at SQL Saturday 108 in Redmond. Steve Stedman

  2. Pingback: » CTE Hierarchy compared to the alternative Steve Stedman

  3. Pingback: » SQL Server Health Report Updated – Top IO added Steve Stedman

  4. Pingback: » SSRS – Using a subreport for navigation Steve Stedman

  5. Pingback: » How big is your procedure cache? Steve Stedman

  6. Pingback: » 4 Sessions Submitted to Seattle Code Camp Steve Stedman

  7. Pingback: » SQL Server Health Reports – Updated Steve Stedman

  8. Pingback: » A great day at SQL Saturday in Vancouver BC Steve Stedman

  9. Gordon Kao says:

    A very useful session. Thanks Steve!

  10. Pingback: » TSQL 2012 – OFFSET and FETCH Steve Stedman

  11. Pingback: » Sessions for Code Camp in 2 weeks Steve Stedman

  12. Pingback: » Code Camp in Redmond Today— Steve Stedman

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Powered by sweet Captcha