Speaking at Boston Code Camp 32!

Boston Code Camp 32 is on November 23, 2019 at Microsoft Sales and Technology Center at Burlington, MA. I am honored, humbled and super excited to deliver two sessions.  This is my first time presenting in a code camp. I am thankful to the organizers for the opportunity.

1:45 PM – 2:45 PM @Cannon

If you use Azure, you must learn Kusto Query Language?

Kusto is a service for storing and running interactive analytics over Big Data. Kusto was designed from scratch to be a “big data” repository for Azure and easy to query using Kusto Query Language (KQL). As we make progress in our migration to cloud, we are learning new ways to monitor and alert on resources and services. Microsoft has consolidated many services under the umbrella of ‘Azure Monitor’. Whether you are ‘detecting and diagnose issues across applications and dependencies’, ‘correlate infrastructure issues with Azure Monitor for VMs’, ‘drill into your SQL database monitoring data with Log Analytics’ you will be using ‘Azure Monitor’. Azure Monitor uses a version of the KQL used by Azure Data Explorer that is suitable for simple log queries but also includes advanced functionality such as aggregations, joins, and smart analytics. Going forward, the KQL must be your primary resource for querying the Azure Monitor log.

In this 95% demo session, I will show you some ‘getting started’ tips and a few sophisticated queries using KQL. At the end of this session beginners will have a solid knowledge about KQL that they can build upon by themselves, others will also learn many advance operators including machine learning ones. Come learn about the future of monitoring and investigations of Azure services.

4:15 PM – 5:15 PM @Cranmore

New features in Management Studio — Performance Troubleshooting made easier!

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 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. Both sessions are in Cannon conference room.

There is a great line up of speakers presenting some powerful sessions. This event is on wait list. If you have signed up and find you will not be able to attend, please cancel your ticket at Eventbrite to make room for another developer. If you want to join the wait list sign up here.  If you wish to volunteer at the event ask for ‘Ron Krawitz’ at the registration desk.