Time Slot(s)

May – 5th

10:00 AM – 10:30 AM (EDT)

(View in your time zone)

Join, Settle Down & Tech Check

10:30 AM – 10:45 AM (EDT)

(View in your time zone)

Opening Note
by DataPlatformGeeks Team

10:45 AM – 11:45 AM (EDT)

(View in your time zone)

A Slice of Time: Window Functions in SQL ServerA Slice of Time: Window Functions in SQL ServerWindow functions are a powerful technique for analyzing data in SQL Server. In this session, we will understand when to use a window function like ROW_NUMBER() or LAG(), including specific use cases. We will understand the performance implications of window functions, including performance tuning of queries with window functions, using window functions to make certain classes of queries faster, and performance implications of having multiple windows in a single query. This talk will also review some of the limitations in SQL Server's implementation of window functions and how to work around many of these.
by Kevin Feasel

11:45 AM – 12:00 PM (EDT)

Switch-over Time / Break

12:00 PM – 01:00 PM (EDT)

(View in your time zone)

Improving Analytics Performance With Columnstore IndexesImproving Analytics Performance With Columnstore IndexesAdministrators and analysts often struggle with the storage and maintenance of reporting and analytics data. Traditional rowstore tables do not scale well when data is measured in billions of rows.Columnstore indexes provide a speedy and convenient way to store OLAP data within SQL Server. Compression allows the data to be much smaller than other storage methods, allowing for faster reads. Column metadata provides the tools needed for SQL Server to be able to service queries over massive data sets quickly and efficiently.The basics of columnstore indexes allow an administrator to improve the performance of analytics, but there is much more to learn! Understanding the internals of columnstore indexes allows querying to be even more efficient.Columnstore indexes have evolved greatly since their introduction in SQL Server 2012. This presentation explores this feature in SQL Server 2017 and SQL Server 2019 and how its newest features can turbo-charge your analytics workloads! by Edward Pollack

01:00 PM – 01:15 PM (EDT)

Switch-over Time / Break

01:15 PM – 02:15 PM (EDT)

(View in your time zone)

Database DevOps with Containers Database DevOps with ContainersUnlike CI/CD pipelines for applications, we can't just delete the database and pop up a new one with each new version. Let's start with the production database, and get SQL Server content to developers in containers, and then flow schema and lookup data back into production with migration tools. You can bring the reliability and automation of CI/CD pipelines to Database DevOps with containers.
by Rob Richardson

02:15 PM – 02:30 PM (EDT)

Lunch Break

02:30 PM – 03:30 PM (EDT)

(View in your time zone)

How to use the Cloud for Data (and actually save money)How to use the Cloud for Data (and actually save money)I’ve seen too many companies move to the cloud “because we’ve heard that’s the way to go these days” and completely miss the expected results because it was a mere business decision without the necessary technical research.In this session we’ll explore the move to the cloud from a data professional perspective, helping you evaluate if moving to the cloud is the right thing for your business, and if so how to do it in order to avoid having performance issues and more expenses than before.We’ll then review the role of the Database Administrator to understand how it can evolve to bring even more (tangible) value to the business.At the end of this session you’ll be able to evaluate if and how to make the move in a way that will actually benefit the business, the developers and, of course, you!
by Emanuele Meazzo

03:30 PM – 03:45 PM (EDT)

Switch-over Time / Break

03:45 PM – 04:45 PM (EDT)

(View in your time zone)

SQL Server Health Check – How We Do It. SQL Server Health Check - How We Do It.We all want healthy SQL Servers. For that, a regular health checkup needs to be performed. But where to start? Where is the health data? How to see it, collect it, analyze it, and most importantly, interpret it? Join this session and learn the techniques we use at SQLMaestros. You were waiting to do this. Right? Now is the time!
by Amit Bansal

04:45 PM – 05:00 PM (EDT)

(View in your time zone)

Closing Note
by DataPlatformGeeks Team

Time Slot(s)

May – 6th

10:00 AM – 10:30 AM (CEST)

(View in your time zone)

Join, Settle Down & Tech Check

10:30 AM – 10:45 AM (CEST)

(View in your time zone)

Opening Note
by DataPlatformGeeks Team

10:45 AM – 11:45 AM (CEST)

(View in your time zone)

A deep dive into DockerA deep dive into DockerRunning SQL Server in a Docker container has many benefits (and drawbacks!) that we as SQL professionals should be aware of.In this demo heavy session we'll dive deeper into running SQL Server in Docker containers. We'll cover: -What exactly is container isolation?Container networking,Persisting data for SQL Server in Docker containers,Building custom SQL Docker images,Running SQL containers with Docker Compose,This session is for anyone who has run SQL Server in a container and wants to learn more about the platform.
by Andrew Pruski

11:45 AM – 12:00 PM (CEST)

Switch-over Time / Break

12:00 PM – 01:00 PM (CEST)

(View in your time zone)

Debugging without debugger: investigating SQL Server’s internal structuresDebugging without debugger: investigating SQL Server’s internal structuresHave you ever wanted to know exactly how SQL Server stores data for temporary structures, such as for instance the spooled data in a Table Spool or Index Spool operator? No? I don't blame you. It's a bit like wanting to know who wattered the rubber tree that produced the rubber your tires are made off before you get in the car to drive to work. You really don't need it.
But you might still WANT to know. I did. And I figured it out.
Without ever touching the debugger (I'm a simple soul, that stuff is much too complex for me!), I figured out how I could look at the exact storage structures SQL Server creates and uses to store data in Table Spool and Index Spool operators.
If you are willing to commit to a fast-paced high-level internals session that is guaranteed to teach you exactly zero actually useful information, then this is the session for you.
by Hugo Kornelis

01:00 PM – 01:15 PM (CEST)

Switch-over Time / Break

01:15 PM – 02:15 PM (CEST)

(View in your time zone)

Azure SQL Database – Where is my SQL Agent?Azure SQL Database – Where is my SQL Agent?You migrate your on premise SQL Database to cloud, taking advantage of PaaS offering of Azure SQL Database. You heard the promise of spinning up databases on demand and being able to scale up resources during high peak and scale down when not in use. You also want to make sure you are performing integrity checks, index defragmentation and statistics update when necessary. There is no SQL Agent so how do you automate your jobs? Do you have time to do this manually each time? No. There are different options available to automate these long-running, manual, error-prone, and frequently repeated tasks to increase reliability, efficiency.
In this demo intensive session I will show you different options on how to automate these tasks. Some of these solution using on-prem infrastructure or services in Azure which are conveniently encapsulate within the common Azure portal experience.
At the end of this session you will have solid understanding about how to automate SQL Server Maintenance tasks including replacing SQL Agent functionality with multiple options.
by Taiob Ali

02:15 PM – 02:30 PM (CEST)

Lunch Break

02:30 PM – 03:30 PM (CEST)

(View in your time zone)

Connect your data artifacts with Azure Synapse AnalyticsConnect your data artifacts with Azure Synapse AnalyticsIn human brains, synapses are responsible to connect information pieces together. Over time, our knowledge increases when more and more synapses are connected together. Following that analogy, Azure Synapse Analytics wants to connect (all) information silos together and provide a single point of analytics.
Join this session, if you want to hear about the building blocks of Azure Synapse Analytics, how Data Engineers and Data Scientists and even BI developer can work together in a single service and see how easy it is to start with Synapse Analytics!
by Wolfgang Strasser

03:30 PM – 03:45 PM (CEST)

Switch-over Time / Break

03:45 PM – 04:45 PM (CEST)

(View in your time zone)

Azure Synapse Analytics Serverless SQL PoolAzure Synapse Analytics Serverless SQL PoolAzure Synapse Analytics is a collection of data processing engines. In this session Armando Lacerda will demo how the Serverless SQL pool, which is part of Synapse Analytics, can be used with Power BI to implement data exploration on top of a data lake.

by Armando Lacerda

04:45 PM – 05:00 PM (CEST)

(View in your time zone)

Closing Note
by DataPlatformGeeks Team