Speaking at SQLSaturday Rochester
February 18, 2020
PASS SQLSaturday is a free training event for professionals who use the Microsoft data platform. These community events offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more. SQLSaturday Rochester will be held on Feb 29, 2020, at Rochester Institute of Technology, 1 Lomb Memorial Drive, Rochester, New York, 14623, United States. I am honored, humbled, and super excited to deliver two sessions. This will be my fourth year in a row speaking at SQLSaturday Rochester.
I will be doing a lightning talk about ‘ Extended Events – How to collect the first 10 or every 4th event‘ at 11:20 AM. There will be two other lightning talks in the same session by Kimberly StJacques and Ray Kim .
Extended Events offers a rich filtering mechanism, called predicates. Have you ever thought of collecting only the 4th event, first 10 occurrences of an event, capture a wait_type when it triggers more than a certain number of times while using extended events but were not sure how to do that? In this lightning talk, I will show you exactly how to do that by applying predicate on something called ‘Predicate Source’.
My second session is about ‘New features in Management Studio — Performance Troubleshooting made easier!‘ at 1:20 PM.
SQL Server Management Studio (SSMS) is now updated each month with the latest version of the SQL Client Tools. Which enabled rapid enhancement to Execution Plan.
Do you know that you can now see how many pages are spilled to disk for a sort, as well as the memory statistics for the operator? Are you aware that you can see the top 10 waits for an execution and what trace flags were active during compilation and which ones influenced compilation? Have you ever analyzed a big plan and wish you could search for the table name, index name or column name without opening XML plan? When you see a clustered index was used do you know for sure which statistics were used by the Query Optimizer to estimate the number of rows?
In this demo intensive session, I will show you how to find and use new features introduced into SSMS and Showplan. You will walk out of this session equipped to make Query Performance Troubleshooting easier and ready to tackle those nasty, hard to solve query plans.
If these topics sound interesting to you, please join me.
There is a great line up of speakers presenting some powerful sessions. Saturday, Feb 29, 2020 Conference Schedule