At PASS Summit next week, I will be available most of the day on Monday and Tuesday to meet with anyone to discuss Database Health Monitor, or consulting work. Just send me an email or contact me via twitter @SqlEmt. I am also available to meet up during the summit, for lunch, dinner, drinks whatever works best. Related Links: Database Health …

Interested in some personal training on Database Health Monitor? Read more »

This year in October, I again have the privilege to speak at PASS Summit in Seattle. One of my favorite topics, Database Corruption was the session that was selected. Here are the details. When Database Corruption Strikes You database is running fine month after month with no problems. Suddenly someone reports that their query won’t run. They get an error …

Speaking at PASS Summit 2016 Read more »

Last week I had the great opportunity to speak at PASS Summit 2015. My presentation was on Common Table Expressions.   Here is the sample code from the presentation. AdvancedCTEs.zip   Related Links: Common Table Expression (CTE) Month at SteveStedman.com (introduction) Sample Database for Common Table Expressions Writing Your First Common Table Expression with SQL Server Video: Writing Your First CTE …

Epic Life Goal Completed: Speaking at PASS Summit – Advanced CTEs Read more »

Friday morning at 8:00am at PASS Summit 15 in Seattle, I will be presenting my Advanced Common Table Expressions and Recursive Query Technique session. Advanced Common Table Expressions Here is the abstract: You might have been introduced to Common Table Expressions (CTEs) and understand the WITH syntax, but want to know more. Learn how recursive queries work with CTEs and how …

Advanced Common Table Expressions and Recursive Query Technique Read more »

The speaker lineup for PASS SUMMIT 2015 was announced today and my Advanced Common Table Expressions session was accepted.   Here is the abstract: You might have been introduced to Common Table Expressions (CTEs) and understand the WITH syntax, but want to know more. Learn how recursive queries work with CTEs and how to display hierarchical data. Did you know …

I will be presenting at PASS Summit 2015 in October Read more »