Sessions & Content

Search
Content Type
Conference
Tags
Install & Configure SQL Server with PowerShell DSC Jess Pomfret
Using PowerShell Desired State Configuration (DSC) we'll install and configure a SQL Server instance in under 5 mins.
Microsoft certifications for the Data & AI professional Sandra Marin
Are you looking to take your career to the next step? Microsoft Certifications help validate knowledge and ability required to perform current and future industry job-roles in a modern digital business. Our certification
SQL Notebooks in Azure Data Studio for the DBA Rob Sewell
While you might have read about notebooks being used for Data Science, this session is for DBAs. You will see how you can use SQL Notebooks to simplify your work.
T-SQL tips and tricks focusing on backdoors and workarounds Itzik Ben-Gan
This session covers all kinds of T-SQL tips and tricks, focusing on backdoors and workarounds for restrictions and missing features in SQL Server and Azure SQL Database.
8 Steps to Securing Azure Sql PaaS Jan Rokicki
One of the last technical challenges of cloud adoption is right security configuration. This session focuses on Azure Sql PaaS, covers governance, risk management and compliance and provides 8-step process for securing public cloud.
An overview of SQL Server 2019 for the busy DBA / developer Randolph West
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.
An R primer for SQL folks Thomas Hütter
A walk-through on what is possible analyzing your data with the "R" language.
Azure Managed Instances—Your Bridge to the Cloud Joey D'Antoni
Managed Instances can make your cloud migrations simpler, but have their own nuances. Learn about what you need to know to manage this new platform.
Batch Execution Mode on the Rowstore Niko Neugebauer
Learn in 75 Minutes what Batch Execution Mode is, when & how it will affect your workloads (in upcoming SQL Server 2019 & Azure SQLDB) on the traditional Rowstore Indexes.
Behind the Query Store… Kalen Delaney
Look inside Query Store to see what it does and how it works
Build hybrid data platform with Azure SQL Database and SQL Server Microsoft
This session presents how to migrate, replicate, and synchronize data between SQL Server, SQL VM, Azure SQL Database, and Azure SQL Database Managed Instance, across on-premises, Microsoft Azure, and other cloud platforms to build a real hybrid data platform. We introduce our current technology choices, deep dive in customer scenarios, and use cases, and share product roadmap.
Deeper Integration and New Transformation for SSIS in ADF Sandy Winarko
This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR).
Extending your use of Extended Events Erin Stellato
If you've been using Extended Events the same way you used to use Trace, you might be wondering if there's more to it. There is! In this session we will explore what else you can do with XE besides capture long-running queries.
Find and Fix those Troublesome Queries Allen White
SQL Server provides a wealth of tools in the box to help you spot troublesome queries. We'll explore those and examine how they can best be used.
From adaptive to intelligent: query procesing in SQL 2019 Hugo Kornelis
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?
Identify opportunities for In-Memory OLTP Margarita Naumova
The session will uncover the In-Memory OLTP architecture, the concerns about data durability and database startup and recovery as well as some important consideration on Management of in-memory objects.
Improving SQL Server Performance with Indexing Richard Douglas
Indexing presents daunting challenges for even the most seasoned professionals, it offers countless options to choose from. With a little help you’ll see how to simplify indexing in your environment & improve the overall performance of your apps
Inside SQL Server 2019 Bob Ward
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.
Inside SQL Server 2019 Polybase Bob Ward
SQL Server 2019 expands on the Polybase feature from SQL Server 2019 by providing a robust data virtualization solution to reduce the need for ETL and data movement. Come learn how new data connectors work with sources like Oracle, MongoDB, CosmosDB, Terradata, and HDFS.
Inside SQL Server Containers Bob Ward
Containers are the new virtual machines. They present a new way to deploy, manage, and run SQL Server never possible before. This session will present an internal view of how Docker containers work, how SQL Server runs in them, and how they work in environments such as Kubernetes
<<123>>