Level 200 

Let us review the latest and the greatest investment that Microsoft has made into the Azure SQL Managed Instance, the product that serve as the best target for the existing SQL Server migration into Azure PaaS. We shall discuss the latest announcements and who knows, maybe there might be something exclusive.

Do you face performance problems with queries generating multiple query plans? Identifying the optimal plan for these queries becomes difficult if you only depend on the plan cache. You need a history of the query plans over time to identify performance degradation, and this is where Query Store can help! If you are not familiar with Query Store and its benefits, this session is right for you! You will learn about Query Store fundamentals, monitoring performance using Query Store, how to manually force and unforce plans, automatic plan correction, things to remember while using Query Store, and the new query hint feature added recently to Azure SQL Database and available for preview. The demos will show you how to readily test and implement Query Store and take advantage of this amazing feature SQL Server has to offer!

Big Data Clusters are a highly anticipated feature of SQL Server 2019, but what exactly are they? Attend this session to learn the basics of this hot new technology that adds HDFS and Spark to SQL Server. Topics covered will include SQL Server Big Data Cluster components and architecture, deployments, and demonstrations of queries that combine relational and non-relational datasets. Attendees will leave with an understanding of how Big Data Clusters differ from a standard SQL Server deployment, the advantages and capabilities they offer, and which scenarios benefit most from their utilization.

Power BI is a great sandbox environment for report design. However, knowing how to leverage visuals and features in a way that adds additional value can be challenging. New visualizations and features can be created a number of ways including: layering visuals, customizing visual formatting, and/or utilizing DAX measures. The session will include a series of visualization and reporting techniques that you’ll be able to leverage in your company’s reports to take them to the next level.

Automating the configuration of SQL Server instances and being able to check the configuration for standard configuration is an important role for any DBA when you have lots of instances. But how can we automate the configuration easily? How can we check to make sure the proper configuration is in place and hasn’t changed? In this session, we will look at how to configure your SQL Server Instances using PowerShell and the dbatools module.

Data Saturday #5 Redmond is a free one-day event for professionals who use the Microsoft data platform. This community event offer content across data management, cloud and hybrid architecture, analytics, business intelligence, AI, and more.

There are many ways to represent data. Most of us stuck with Relational Database Data Models and we don’t feel comfortable when data gets represented in different ways. Graph Processing Tables is yet another way to represent data, it can change the way you look at the data. Relational Databases don’t adapt well to changes. Adding a new domain or relation to your data model should not be that difficult. You want to create flexible data models that evolve with your business process.

In this 95% demo session, I will show you some getting started tips and a few sophisticated queries using KQL.

I will do a live demo, generating an alert using KQL. At the end of this session, beginners will have a solid knowledge about KQL that they can build upon by themselves; others will also learn many advanced operators, including machine learning ones. Come and learn about the future of monitoring and investigations of Azure services.

Microsoft Docs are open source on Github! Join the SQL-Docs content team for a discussion on modern Microsoft documentation (regardless of technology). Learn about the content publishing engines behind Docs, and the best ways to add your content and fixes to Docs that are read by the entire customer community. There are hundreds of thousands of GitHub issues and PR’s submitted to Docs every month, how can you be an effective part of that process and get your face on the top of an article?