These are the sessions submitted so far for SQLBits 2019.

SQL Server and Azure SQL Database support a multitude of data types and functions related to dates and times, and chances are you've never heard of some of them.

In this session, start with the science in an easy to understand way. Then you'll get a rundown of each of the data types and how they work. Finish with the most useful date and time system functions, using practical examples.
There's a life beyond DATETIME and GETDATE(). Start that journey here and end up in a world that embraces the latest versions of SQL Server and Azure SQL Database in just over an hour.
The lines between who manages what when it comes to Data Platform technologies is blurring, the traditional role of the DBA is evolving. Are the skills and techniques that we have used over the last decade still applicable or do we need to update our thinking and look at how we manage Data Platforms with a fresh pair of eyes?
In this talk, we will cover the Top 7 things that a DBA needs to know in order to manage a modern Data Platform solution. Covering key skills, technologies, and useful applications that mean we can ensure that data is secure and the systems perform at levels that are acceptable for our end users.
What are Azure SQL Database Managed Instances?
The range of options for storing data in Microsoft Azure keeps growing, the most notable recent addition is the Managed Instance. But what is it, and why is it there? Join John as he walks through what these options are and how you might start using them.
Managed Instances add a new option for running workloads in the cloud. Allowing near parity with a traditional on-premises SQL Server, including SQL Agent, Cross Database Queries, Service Broker, CDC, and many more. Overcoming many of the challenges of using Azure SQL Databases.
But, what is the reality, how do we make use of it, and are there any gotcha’s that we need to be aware of? This is what we will cover, going beyond the hype and looking at how we can make use of this new technology, working through a full migration, including workload analysis, selecting the appropriate migration pathway and then putting it in place.
Whether you are a Developer or DBA, managing infrastructure as code is becoming more common, but what if you need to managed Hybrid or multi-cloud deployments? Having one tool to do this can simplify management and this is where Terraform comes in.

Together we will look at what Terraform is and how we can use it to simplify managing our infrastructure needs alongside our application code. Join me as I talk through how we are able to define one VM through to building production ready infrastructure by using the open source tool Terraform.
In the age of GDPR having accurate data is vital, but how do we achieve this? Simple, we test it.
Testing data might seem like a simple task, but there are many levels of complexity including defining and understanding the rules for the tests. All the way through to how to implement these tests, are you looking at one test at a time or composite tests for the data entity?
Together we will explore the approaches that we can take for defining test strategies as well as how testing fits into a larger Master Data Management solution.
We all hate writing it, but it is essential for the stringent compliance requirements that we, as data professionals, have to support for the businesses we work for. We will look at ways that we can speed up & minimise the overhead of documentation.
We will look at the key types of documentation as well as how we can use the data model to do a lot of the work for us, as well as the features and capabilities within SQL Server that we can use. Doing the work up-front allows us to automate and simplify the creation and maintenance of system documentation.
You heard about the “R” language and it’s growing popularity for data analysis. Now you need a walk-through on what is possible analyzing your data? Then this session is for you:

You’ll get a short introduction how R came to be, and what the R ecosystem looks like today. Then we will extract sales data from different companies off a Navision ERP database on SQL Server.
Our data will be cleaned, aggregated and enriched in the RStudio environment. We’ll generate different diagrams on-the-fly to gain first insights.
Finally we’ll see how to use the Shiny framework to display our data on a map, interactively changing our criteria, and showing us where the white spots really are.
By now, all the data pro world should have heard about the R language, especially since Microsoft is committed to integrate it into their data platform products. So you installed the R base system and the IDE of your choice. But it's like buying a new car - nobody is content with the standard. You know there are packages to get you started with analysis and visualization, but which ones?

A bundle called The Tidyverse comes in handy, consisting of a philosophy of tidy data and some packages mostly (co-)authored by Hadley Wickham, one of the brightest minds in the R ecosystem. We will take a look at the most popular Tidyverse ingredients like tidyr, ggplot2, dplyr and readr, and we'll have lots of code demos on real world examples.
Microsoft introduced geospatial data types already in SQL Server 2008, some enhancements followed in version 2012. Today, geo data is used almost everywhere. Time to refresh your memories of geometry and geography!

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.
Are you prepared if a tornado filled with sharks destroys your primary data center? You may have backed up your databases, but what about logins, agent jobs, availability groups or extended events? 

Join SQL Server and PowerShell MVP Chrissy LeMaire for this session as she demos how disaster recovery can be simplified using dbatools, the SQL Server Community's PowerShell module.