| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 09:00:00 | Jens Vestergaard | Analytics and Visualization | Azure IoT, Windows 10 Core Raspberry PI (DIY) |
| 09:00:00 | Uwe Ricken | Application Database Development | Daily indexing problems and its - possible - solution |
| 09:00:00 | Andreas Bergstedt | BI Platform Architecture, Development Administration | 10 Things that you already knew about SSIS |
| 09:00:00 | Christophe Laporte | Enterprise Database Administration Deployment | SQL Server installation and configuration cookbook |
| 09:00:00 | Vedran Kesegic | Application Database Development | SQL Server Magic Show |
| 10:15:00 | Dennes Torres | Application Database Development | SQL Graph Databases: Beyond Relational |
| 10:15:00 | Magnus Ahlkvist | Application Database Development | It depends - don't mistake your Google search for my database knowledge |
| 10:15:00 | Christopher Adkin | BI Platform Architecture, Development Administration | An introduction To SQL Server 2019 Big Data Clusters |
| 10:15:00 | Mikael Wedham | Enterprise Database Administration Deployment | A Masters view on Locking and blocking |
| 10:15:00 | Dr. Subramani Paramasivam | Analytics and Visualization | Exploiting Artificial Intelligence within Power BI |
| 11:30:00 | Thomas Hütter | Application Database Development | A refresher on geospatial data in SQL Server |
| 11:30:00 | Alexander Klein | Analytics and Visualization | Azure Cognitive Services - AI for everyone |
| 11:30:00 | David Barbarin | Enterprise Database Administration Deployment | SQL Server docker containers from the development to the production |
| 11:30:00 | Miloš Radivojević | Application Database Development | Intelligent Query Processing in SQL Server 2019 |
| 12:30:00 | Pinal Dave | Application Database Development | Kick Start! SQL Server 2017 Performance Tips and Tricks |
| 13:45:00 | Oskari Heikkinen | BI Platform Architecture, Development Administration | New capabilities of Azure Data Factory v2 |
| 13:45:00 | Satya Jayanty | Cloud Application Development Deployment | Azure Cosmos DB - What you need to know to build globally distributed apps? |
| 13:45:00 | Grant Fritchey | Application Database Development | Extending DevOps To SQL Server |
| 13:45:00 | Ruth Pozuelo Martinez | BI Platform Architecture, Development Administration | Deep Dive into the M language for Power BI/ Power Query |
| 13:45:00 | Dave Ruijter | Analytics and Visualization | Power BI Cheat Sheet explained! |
| 13:45:00 | Ola Hallengren | Enterprise Database Administration Deployment | Analyzing Performance Problems Using XEvents, DMVs Query Store |
| 15:00:00 | Andrew Pruski | Enterprise Database Administration Deployment | Azure SQL Containers |
| 15:00:00 | Erland Sommarskog | Application Database Development | Working in Batches |
| 15:00:00 | Matthew Roche | BI Platform Architecture, Development Administration | Integrating Power BI and Azure Data Lake with dataflows and CDM Folders |
| 15:00:00 | Joakim Nyström | Enterprise Database Administration Deployment | Off-load data from production using Replication Change Tracking |
| 15:00:00 | Kevin Kline | Cloud Application Development Deployment | 5 Critical Considerations When Moving to the Cloud |
| 16:30:00 | Alexander Arvidsson | BI Platform Architecture, Development Administration | Arguing with myself - self-service BI from an infrastructure perspective |
| 16:30:00 | Johan Ludvig Brattås | Cloud Application Development Deployment | Don't Cross the Streams! A Closer Look at Azure Stream Analytics |
| 16:30:00 | Ted Malone | BI Platform Architecture, Development Administration | Construct Visual Data Flows by using Azure Data Factory |
| 16:30:00 | Andreas Bergstedt | Enterprise Database Administration Deployment | How to implement Row Level Security in SQL Server and Why? |
Event Date: 04-05-2019 - Session time: 09:00:00 - Track: Analytics and Visualization
This session is not for the Enterprise rather has a more DIY approach.
Event Date: 04-05-2019 - Session time: 09:00:00 - Track: Application Database Development
Event Date: 04-05-2019 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration
Delta management, Project recovery, Best and Worst practice and more.
Session is recommended for the intermediate to advanced but the beginner will also gain from this.
Event Date: 04-05-2019 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment
Then, we will talk about the famous Next Next Next Finish and the options we can choose during the setup. And, finally, we will show how to properly configure SQL Server for better performance and easier troubleshooting.
Event Date: 04-05-2019 - Session time: 09:00:00 - Track: Application Database Development
The tricks: Select count(*) from table - returns wrong count (any # you like) Deadlock - single statement, without transactions Database - without files Online index changes - on Standard edition Reading plaintext data of TDE-encrypted database - without SQL access
Event Date: 04-05-2019 - Session time: 10:15:00 - Track: Application Database Development
In this session, you will discover how Graph Databases in SQL Server works and what's new for them in SQL Server 2019
Event Date: 04-05-2019 - Session time: 10:15:00 - Track: Application Database Development
My powerpoints usually look terrible, so I will focus on T-SQL and execution plans.
Event Date: 04-05-2019 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration
Event Date: 04-05-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment
This session will show you how to detect and view blocking and lock waits, and understand the cause of it. An extensive walkthrough of the different isolation levels and their respective benefits and drawbacks. And finally a real-world quick list of suggestions on what you can do to solve some of the common issues I come across in my daily work.
Event Date: 04-05-2019 - Session time: 10:15:00 - Track: Analytics and Visualization
Event Date: 04-05-2019 - Session time: 11:30:00 - Track: Application Database Development
We'll walk through which data types are supported - from 0 to 2 dimensions, from points to polygons and some more - and see how to get spatial data into and out of SQL Server tables.
Then there are built-in functions to determine relationships between geo objects, such as intersection, inclusion or shortest distance. And of course there will be examples of practical applications of geospatial data.
Event Date: 04-05-2019 - Session time: 11:30:00 - Track: Analytics and Visualization
This is a large playground for young and old. Here you can try out to your heart's content what will be in use tomorrow. With the various building blocks such as Bot Framework, Emotion, Face, Text Analytics or Recommendations, to name but a few, impressive applications can be assembled in a short time.
Event Date: 04-05-2019 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment
Nowadays containers are part of the CI/CD pipeline and Microsoft kept up by providing a support for MSSQL databases on Docker regardless the underlying operating system and the environment context as well.
In this session, I propose you a feedback about the first steps and challenges we had to take up in the docker world for both database development and production scenarios.
Event Date: 04-05-2019 - Session time: 11:30:00 - Track: Application Database Development
The intention of these improvements is to fix poor performing queries due to wrong cardinality estimations and other sub-optimal plan decisions, and hereby enhance query performance with almost no code changes.
This session will cover briefly all these features: Batch and Row Mode Memory Grant Feedback, Batch Mode Adaptive Join and Interleaved Execution, Table Variable Deferred Compilation, and Approximate Query Processing.
The session will address questions such as do I need to tune queries anymore, does the IQP solves parameter sniffing issues and so on, and also suggest how much improvements you should expect with this promising set of feautures.
Event Date: 04-05-2019 - Session time: 12:30:00 - Track: Application Database Development
Here is a glimpse of the features we will cover in this session: • Adaptive query plans • Batch mode adaptive join • New cardinality estimates for optimal performance • Indexing Improvements • Automatic Tuning • Memory optimizations
At the end of the session, DBAs will learn 3 essential processes which can be game changers for their career. After implementing the suggestions discussed in this session, DBAs will have extra time to handle more pressing issues which they were not able to focus on earlier.
This 75 minutes will be the most productive time for any DBA or Developer.
Event Date: 04-05-2019 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration
Event Date: 04-05-2019 - Session time: 13:45:00 - Track: Cloud Application Development Deployment
Event Date: 04-05-2019 - Session time: 13:45:00 - Track: Application Database Development
Event Date: 04-05-2019 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration
Or maybe you have been tinkering with the M language for a while, but now you want to take your M language skills to the next level? If your answer is yes to either questions, come to this session were I will take a deep dive through the M language to cover things like values, syntax, tokens, row context and more so you can take your data cleaning skills to the next level.
Event Date: 04-05-2019 - Session time: 13:45:00 - Track: Analytics and Visualization
Event Date: 04-05-2019 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment
You are troubleshooting a performance problem in a business-critical database, a query is not completing, the users are complaining, and you are trying to understand what is happening. You have data from Extended Events, you are looking in the execution related DMVs, and now you are trying to find the query in Query Store. How do you put it all together?
In this session, we will look at how the tools work in different scenarios, how to correlate the data, and how you can use them in your performance troubleshooting.
Event Date: 04-05-2019 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
I'll cover the following different options for running Docker containers in Azure: Azure Container Registry Azure Container Instances Azure Container Services (AKS)
This session is aimed at SQL Server DBAs and Developers who have some experience with Docker (Docker for desktop) and want to know the different options that are available in Azure.
Each topic will be backed up with demos which will show how simple it is to get up and running with these technologies.
Event Date: 04-05-2019 - Session time: 15:00:00 - Track: Application Database Development
We will also look at batching from a different angle: problems that requires a loop for, say, a single customer, but where we can process all customers abreast for better performance.
Event Date: 04-05-2019 - Session time: 15:00:00 - Track: BI Platform Architecture, Development Administration
In this session, Power BI program manager Matthew Roche will explore integration scenarios between Power BI dataflows, Azure Data Lake Storage gen2, and additional Azure services such as Azure Data Factory. If you want to bridge the worlds of IT and self-service, and to enable easy reuse in both directions, this is a session you to not want to miss.
Event Date: 04-05-2019 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment
SQL Server comes with many tools that, when properly used, can make your life a whole lot easier; some of which are: SQLCMD scripting, the Change Tracking system, Transactional Replication and the MERGE command. In this session you will be presented to a simple toolkit that will utilize these tools to set up synchronization of your production data to an offline database in a way that is easy to configure and manage. The toolkit contains a very small number of T-SQL and SQLCMD scripts together with a “How to” instruction, AND it´s available in SQL Server Standard edition!
Event Date: 04-05-2019 - Session time: 15:00:00 - Track: Cloud Application Development Deployment
We will dive deep into the most critical considerations for moving your data and databases into the cloud, whether you use Microsoft Azure, Amazon, or another cloud provider. We will cover: • The importance of cleansing your data before a major migration • Fully documenting your data sources and metadata • Choosing from many different tools and techniques to actually move data • How to test data for fidelity • How to maintain parallel systems during transitional phases We'll also share demos and overviews of native features within SQL Server that enable you to move data, as well as show powerful tools from the SentryOne product set that can make data migrations painless!
Event Date: 04-05-2019 - Session time: 16:30:00 - Track: BI Platform Architecture, Development Administration
Event Date: 04-05-2019 - Session time: 16:30:00 - Track: Cloud Application Development Deployment
Event Date: 04-05-2019 - Session time: 16:30:00 - Track: BI Platform Architecture, Development Administration
In this session, attendees will be introduced to Azure Data Factory Mapping Dataflows, which allows users to develop comprehensive data pipelines using a graphical interface. These pipelines are executed in Azure Databricks, which provides a very efficient Spark-based execution context. Attendees will learn how to effectively build visual pipelines using common transformations, and will learn how to monitor and debug ETL and ELT pipelines by using Azure Data Factory.
Event Date: 04-05-2019 - Session time: 16:30:00 - Track: Enterprise Database Administration Deployment