These are the sessions submitted so far for SQLBits 2018.

Microsoft has two different types of SQL Server services available in Azure. The SQL Server on an Azure VM is the IaaS (Infrastructure as a Service), which is easier to understand and migrate to.
Microsoft offers two types of PaaS (Platform as a Service) or DBaaS (Database as a Service) for SQL Server Database native to could – Single Database and Elastic Pool. Choosing the right tier for your database gets harder with the complexity in calculating the resource utilization for your Azure SQL Database.
In this session, I will walk you through the steps involved in analysing the resource utilisation and estimating the right tier to choose for your database in Azure. I will also uncover the mysterious DTU and how it is calculated.
When SQL Server 2016 was released, it offered a fantastic new feature with the Query Store. Long term, statistics based, query tuning became a reality. But what about the thousands of servers that aren't upgrading to SQL 2016 or newer? The open source project Open Query Store is designed to fulfill that need.

This session will give a short introduction to the Query Store feature in SQL 2016 and then dive into the Open Query Store (OQS) solution. Enrico and William (the co-creators of the OQS project) will explain the design of OQS and demonstrate the features. You will leave this session with an understanding of the features of Query Store and Open Query Store, and a desire to implement OQS in your systems when you return to the office.
In this talk you will learn how to use Power BI to prototype/develop a BI solution in days and then (if needed) evolve it into a fully scalable Azure BI solution.
This talk is all about showing real world tips from real world scenarios of using Power BI: the goods and the bads.

This session is targeted to whom is using or start using Power BI and want to take home some really good tips & tricks ;)
In this session we will run through all of the latest technologies and tooling we are developing at
Microsoft to democratise machine learning.

We will look at Cognitive Services with prebuilt deep convolutional neural networks and your own custom neural networks,

We will look at R tooling and how to create your own image recognition models in R.

We will cover methods for operationalizing you learning such as SQL Server 2017 and Azure Data Lake Analytics along with a few other surprises

All of this with just practical demos and no PowerPoints
In this talk we will discuss best practices around how to design and maintain an Azure SQL Data Warehouse for best throughput and query performance. We will look at distribution types, index considerations, execution plans, workload management and loading patterns. At the end of this talk you will understand the common pitfalls and be empowered to either construct a highly performant Azure SQL Data Warehouse or address performance issues in an existing deployment.
Hierarchies and graphs are the bread and butter of most business applications and you find them almost everywhere:

  • Product Categories
  • Sales Territories
  • Bill of Material
  • Calendar and Time

Even when there is a big need from a business perspective, the solutions in relational databases are mostly sort of awkward. The most flexible hierarchies are usually modeled as self-referenced tables. If you want to successfully query such self-referenced hierarchies, you will need either loops or recursive Common Table Expressions. SQL Server 2017 comes now with a different approach: Graph Database.

Join this session for a journey through best practices to transform your hierarchies into useful information. We will have fun playing around with a sample database based on G. R. R. Martin’s famous “Game of Thrones”.
Your developers need a copy of the production database, and they need it now! How do you keep up with the shift towards agile development? VMs are a good solution, but we can make environments easier to manage, smaller, and cheaper with containers. Containers let you run SQL Server in an isolated, lightweight environment but working with them can be tricky. In this session I'll explain the different types of containers available for SQL Server, why some options are better than others, and why they're worth considering. You will learn how to use Docker and Windocks containers to turn SQL Server infrastructure into a on-demand service for your developers and testers, letting them create a new instance of SQL Server with a copy of your production data in less than a minute.
Sometimes things don’t work out as planned. The same thing
happens to our SQL Server execution plans. This can lead to horrible slow
queries, or even queries failing to run at all. In this session you will see
some scenarios demonstrated where SQL Server produces a wrong plan, you will
learn how to identify them and what you can do to avoid them.

You will also learn more on Adaptive Query Processing, a new
feature in SQL Server 2017. This allows your SQL Server to adjust wrong plans
while the plan is being executed. So, if running queries performantly is one of
your concerns, don’t miss out on this session!
You’ve probably already seen that R icon in the Power BI GUI.
It shows up when creating sources, transformations and reports. But the ugly
textbox you got when you clicked upon those icons didn’t encourage you to proceed?
In this session you will learn just a few basic things about R that will
greatly extend your Power BI data loading, transformation and reporting skills
in Power BI Desktop and the Power BI service.
In the current just-in-time world we want to analyze what is
happening now, not what happened yesterday. Companies start to embrace Azure
Stream Analytics, which makes it easy to analyze streams of incoming events
without going into advanced coding. But for advanced analytics we need machine
learning to learn patterns in your data. Azure Machine learning can do this for
you. But the real beauty is that both products can easily work together.

So if you want to see how within 60 minutes we can learn patterns in streams of
data and apply them on live data, be sure to attend this demo-oriented session.
If your regular SQL Server becomes too slow for running your data warehouse queries, or uploading the new data takes too long, you might benefit from the Azure Data Warehouse. Via its “divide and conquer” approach it provides significant performance improvements, yet most client applications can connect to it as if it is a regular SQL Server. To benefit from these performance improvements we need to implement our Azure Data Warehouse in the right way. In this session - through a lot of demos - you will learn how to setup your Azure Data Warehouse (ADW), review indexing in the context of ADW and see that monitoring is done slightly different from what you’re used to.
With over 30 years of personal experience, Charlie will deliver this entertaining and sometimes humorous session to inform those with leadership and management responsibilities about how they can provide the support and motivation to their teams, which is so essential for teams and organisations to succeed.
Staff engagement is a key challenge for organisations and, with a significant skills shortage, the IT industry is particularly susceptible to high staff turnover.  Staff retention is achieved through a variety of incentives, but effective leadership is fundamental to all areas of a business.
Based on personality types, Charlie discusses the current thinking on how leaders can stretch themselves into different leadership styles to provide optimal leadership for specific situations.  The modern workplace is fast moving and ever changing, so modern leaders need to have great self-awareness, emotional intelligence and an adaptable approach to leading their teams.
Query optimizer is getting smart, computers are taking DBAs jobs. In this session MVP Fabiano Amorim will talk about new “automatic” optimizations on SQL Server 2017. Adaptive query processing, auto tune and few other features added into the product. Are you taking weekend off? What about turn automatic tune to avoid bad queries to show up after an index rebuild or an ‘unexpected’ change?
SQL is a tricky programming language, if you work with SQL Server in any capacity, as a developer, DBA, or a SQL user, you need to know how to write a good T-SQL code. A poorly written query will bring even the best hardware to its knees, for a truly performing system, there is no substitute for properly written queries that takes advantage of all SQL Server has to offer. Come to this session to learn how re-write a query and see many tips on what to do to make queries execute as fast as possible.
If you are a developer+DBA, consultant+DBA, IT Manager+DBA, Intern+DBA, technical support+DBA or just a DBA, this session will be useful to you. After working for many years as developer and consultant, the SQL Server MVP Fabiano Amorim has being working with many day-by-day DBA tasks. In this session he will speak a little about the DBA job and show some very good tips about how to do it with efficiency.
Tired to look at colored and nice shape plans? Want to go further and see geek stuff? Came to this session to explore the query trees, internals and deep analysis on execution plans on SQL Server. This is a advanced session, so, expect to see lots of traceflags, undocumented and nasty execution plans.
In this session, I'll present some hidden and tricky optimizations that will help you to "speed-up" your queries. It all begins by looking at the query execution plan and from there, we'll explore the alternatives that were not initially considered by query optimizer and understand what is it doing. If you need to optimize queries in your work, don't miss this session. 
In this session the MVP Fabiano Amorim (@mcflyamorim) will show 7 different development techniques that you should avoid in case your company DBA suffer from some heart diseases. How to not write a T-SQL, triggers pitfalls, indexes, functions, parameter sniffing, SQL Injection, cache bloat and sort warnings. Come to this session to learn the most common issues when developing to SQL Server, and how to avoid them.
Back to the Future is the greatest time travel movie ever. I'll show you how temporal tables work, in both SQL Server and Azure SQL Database, without needing a DeLorean.

We cover point in time analysis, reconstructing state at any time in the past, recovering from accidental data loss, calculating trends, and my personal favourite: auditing.

There's even a bit of In-Memory OLTP.

There are lots of demos at the end.
Do you move to the cloud because it's fashionable, or because it's a good strategy for your organization?

How do you decide between Azure SQL Database (Platform as a Service), SQL Server on a Azure VM (Infrastructure as a Service), or perhaps a hybrid solution with both?

This session also covers Stretch Database, Data Migration Assistant, and BACPAC files, as well as some hidden gems in SQL Server 2017.
"The database is slow" is one of those eye-rolling, panic-inducing statements, but by then you're already reacting.

This session takes you on a proactive journey through basic database internals, hardware and operating system setup, and how to configure SQL Server from scratch, so that you avoid hearing that dreaded statement.

Think of this as best practices from the ground up, before you get into query tuning.
A DBA in charge of a whole lot of databases and servers has to check regularly that there are no likelihood of problems. The task is well suited for automation as workload increases. But be honest. Have you tried to do that with copy and paste in a Word Document ? If yes, you know how painful and how many time you will spend doing that. But if I told you that you can do it in seconds ? 
In this session I will introduce a PowerShell-based reporting framework that aims to simply provide a Word-based report with colour-coded alerts where there are problems or best practices aren't being followed.
Machine Learning is not magic.  You can’t just throw the data through an algorithm and expect it to provide insights. You have to prepare the data and very often you have to tune the algorithm.  Some algorithms - Neural Nets, Deep Learning, Support Vector Machines and Nearest Neighbour  - are starting to dominate the field.  A great deal of attention is often focused on the maths behind these, and it IS fascinating. 
But you don’t have to understand the maths to be able to use these algorithms effectively.  What you do need
to know is how they work because that is the information that allows you to tune them effectively.  This talk will explain how they work from a non-mathematical standpoint.
AWS DMS is a fantastic service that allows you migrate your data to the heterogenous databases in the AWS Cloud. In this session we will check how to use this service, what are replication instances and why they are so important, creating and logging tasks, tips and tricks  and finalizing how to troubleshooting it without need to open a case with AWS.
Analysing highly connected data using SQL is hard! Relational databases were simply not
designed  to handle this,  but graph databases were.  Built from the ground up to understand
interconnectivity, graph databases enable a flexible performant way to analyse
relationships, and one has just landed in SQL Server 2017! SQL  Server supports two new table types NODE andEDGE and a new function MATCH, which enables deeper exploration of the
relationships in your data than ever before.

In this session, weseek to explore, what is a graph database, why you should be interested, what
query patterns does they solve and how does SQL Server compare with
competitors. We will explore each of these based on real data shredded from


If you're looking to move data in Azure, you have inevitably heard of Data
Factory. You may have also heard it is clunky, limited and requires a lot of
effort; you are correct.  

What if you had the necessary PowerShell tools to automate the tedious and
repetitive elements of a Data Factory, allowing you to kick back while it
deploys all your pipelines to Azure?  

In this session, we will look at how to automate the mundane creation and
deployment of Data Factory artefacts so that you can reduce valuable
development time and increase agility. 

We will look at a real-world example, moving a database from an
on-premise SQL Server database to Azure, without writing any code or any JSON.
Whether you're new to Azure Data Factory, or you are a seasoned pipeline
developer, this automation framework will save you time, increase quality and
maintain consistency. 

RDS SQL SERVER is a managed service for SQL Server from AWS. In this session we will have a brief introduction o RDS SQL Server and practical examples on
how to setup and some basic operations as use native backup and restore to point in time and it limitations. We also will cover some questions that will allow you understand and consider if its feasible to your business to use RDS SQL Server instead of EC2 Instance with SQL Server
The most effective T-SQL support feature comes installed with every edition of SQL Server, is enabled by default, and costs no overhead. Yet, the vast majority of database administrator underutilize or completely neglect it. That feature’s name is “comments”.

In this session, Microsoft Certified Master Jennifer McCown will demonstrate the various commenting methods that make code supportable. Attendees will learn what’s important in a header comment, use code blocking to edit code, build a comprehensive help system, and explore alternative comment methods in stored procedures, SSIS packages, SSRS reports, and beyond.