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 |