It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

This session will take a look at better Unicode support, query processing improvements for row store tables, secure enclaves, and other neat things you'll find useful as a modern database administrator or developer.

Do you want to know why customers chose Cosmos DB? Come learn about the business goals and technical challenges faced by real world customers, and learn about key Cosmos DB features so you can help your customers deliver their high-performance business-critical applications on Cosmos DB.

Hybrid data landscapes are common and the on-premises data gateway enables connecting to your on-premises data sources from online services (like Power BI, PowerApps, Microsoft Flow and Logic Apps) without the need to move your data to the cloud. Come to this session to see the latest gateway features and best practices related to setup and configuration along with troubleshooting tips and tricks, investigate bottlenecks and resolve your common gateway errors.

Various topics will be covered such as management of large, complex models, connectivity, programmability, performance, scalability, management of artifacts, source-control integration, and monitoring. Learn how to use Power BI Premium to create semantic models that are reused throughout large, enterprise organizations.

SQL Server 2019 includes new query processing features such as batch mode on rowstore, memory grant feedback, approximate query processing, and more. How do these work? Are they as good as Microsoft wants us to believe?

Come learn all the new capabilities of SQL Server 2019 directly from the Microsoft engineering team. This session will provide the strategy behind SQL Server 2019 as well as a deep dive into all the new features and how they can help you modernize your data estate with SQL Server.

Power BI Premium enables you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through Microsoft Power BI. The session will focus on performance, scalability, and application lifecycle management (ALM).

In this session, you will learn about the latest additions to the portfolio of network security features for Azure SQL Database. This session will be heavy on the “how-to” for securing the network connectivity for Managed Instance. ?

Automatic Plan Correction is a feature you can use whether you're a pro at performance tuning or just starting with SQL Server. Come to this session to learn how to spend less time fighting fires with this new feature.

Power BI Premium has many features that organisations desire yet the price makes it impractical for most. In this talk you will learn how Power BI Embedded can be used to enable many of these features at a much lower cost.

This session will focus on the new features and capabilities that help you meet compliance and security needs with SQL Server on-premises as well as in Azure SQL Database. This includes the new Static Data Masking, new authentication capabilities, new functionalities in Vulnerability Assessment and Threat Detection as well as Always Encrypted. If you want to know about the latest developments in SQL Security, this session is for you.

This session will showcase several improvements in SQL Server, focusing on the latest and upcoming query performance diagnostics and query processing enhancements that address some of the most common customer pain points. Ranging from new xEvents and Showplan improvements, to Intelligent Query Processing innovations, learn how you can leverage these features and streamline the process of troubleshooting query performance with faster insights.

About

SQLBits was started by a group of individuals that are passionate about the Microsoft Data Platform.
There is a breadth of knowledge in the data community that will benefit everyone.
We want to spread that knowledge.

We all work in the data and SQL space, some of us for many years. We have a range of skills and experiences from being given the MVP award by Microsoft, organising user groups and speaking at events around the world.