Past Meetup

Two New Powerful Tools to Add to Your DBA Toolbox - Query Store and Python

This Meetup is past

83 people went

Location image of event venue

Details

Agenda:

• 17:30-18:00 - Gathering, Networking, Hugs and Kisses

• 18:00-18:15 - Opening, Announcements, and More...

• 18:15-19:15 - First Session (Answering the Question "What Happened?" with Query Store)

• 19:15-19:30 - Break (More Networking)

• 19:30-20:30 - Second Session (Python Revolution in the SQL Server World)

Sessions:

1. Answering the Question "What Happened?" with Query Store – Erin Stellato (60 Minutes, Remote Session)

One of the most highly anticipated new features in the SQL Server 2016 release is Query Store. It's been referred to as the "flight recorder" for SQL Server, because it tracks query information, namely plans and runtime statistics. If you've ever had to drop everything to troubleshoot a sudden drop in performance, then you've probably already realized the value of this feature.

In this session we'll walk through Query Store with a series of demos designed to help you understand how you can immediately start to use it once you’ve upgraded to SQL Server 2016. We'll review the different options for Query Store, look at examples of what gets collected, dig through the included reports, see how you can force SQL Server to use a specific plan for a query, and find out what happens when it can’t use the specified plan.

Get ready to make troubleshooting easier with this feature that’s included in all editions of SQL Server 2016!

Use the following link if you can't attend the meetup, and you would like to join online: https://attendee.gotowebinar.com/register/1510597422007215619

2. Snakes and Ladders – Python for Mere SQL Server Administrators – Maria Zakourdaev (60 Minutes)

Python is one of the most popular languages these days, and we are very excited to have the ability to use Python inside SQL Server stored procedures starting with SQL Server 2017.
If you are a DBA, you need to get to know this wonderful feature. Forget about Machine Learning stuff. It can solve a DBA's everyday challenges when dealing with text files, bulk loads, and even simplify ETL flows when you need to get data from database systems other than SQL Server. Moreover, you can offload the big data querying to a NoSQL database, and use Python to get the results into SQL server. Have you ever dreamed about receiving emails from SQL Server stored procedure? Yes, Python can do that!

Use the following link if you can't attend the meetup, and you would like to join online: https://attendee.gotowebinar.com/register/4878548873841889281