Categories
Session

October event

Our next user group session is on Wednesday, 28 October 2020, at 5:00pm MDT.

The event will be ONLINE ONLY, accessible through Microsoft Teams. The link will be provided when you RSVP using Eventbrite or Meetup. You are encouraged to join about 15 minutes beforehand.

RSVP options

You can RSVP using either the Eventbrite or Meetup links below:

Agenda

5:00pm – 5:10pmWelcome and messages
5:10pm – 5:25pmLightning session (Ginger Grant)
5:25pm – 5:30pmBreak
5:30pm – 6:30pmFeature presentation (Deepthi Goguri)
6:30pm – 6:45pmQ & A with Deepthi

Fast splash into Azure Pools: A Lightning talk (Ginger Grant)

Microsoft introduced Synapse last year at Ignite as a replacement for SQL DW and has since greatly expanded the functionality of the application. Now using the different Pools, you can query flat files, create a data warehouse, and perform advanced analysis with Machine Learning and Spark. We will review the capability in each and demonstrate how they work. This brief overview will provide attendees with a good overview of what all you can do with Synapse in a condensed time frame.

About Ginger Grant

Ginger is the principal consultant at Desert Isle Group specializing in Data Analytics. As a Microsoft MVP in Data Platform and a Microsoft Certified Trainer, she is proficient in creating solutions using the entire Microsoft Data Stack, the Azure Data Stack including Power BI, Databricks, Data Factory, Data Lake Gen 2, Data Analytics, Synapse and Machine Learning with Python. Ginger also enjoys sharing technology by teaching certification courses as well as many different community tech events. In addition to blogging at desertislesql.com, Ginger has written an Azure Machine Learning book and is currently working on another book on AI. When not working, she maintains her blog and spends time on Twitter at @DesertIsleSQL.

SQL Engine: Its Working Style (Deepthi Goguri)

Many DBAs and Developers work with SQL Server but don’t fully understand how it really works behind the scenes. Join Deepthi on her dive into the internals of SQL Server to explain why knowing what goes on under the covers will help you make better decisions quickly when solving performance problems in SQL Server. This session will cover ACID properties, key components of the Cache in SQL Server, Relational Engine, Storage engine and the Transaction manager. You will learn how SQL Server manages Plan cache and Buffer pool and how SQL Server optimizer chooses the plans. We will also cover what happens under the covers during read and write operations within SQL Server. This session also has Demos showing how components of SQL Engine works for queries. Deepthi will show you how the SQL engine thinks – enabling you to think like it!

About Deepthi Goguri

Deepthi is a Database administrator with 7 years of experience. She completed her Masters in Computer Technology at Eastern Illinois University and she is a Microsoft certified solution expert (MCSE). You can find her blog at dbanuggets.com and follow her on twitter at @dbanuggets.

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.