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.
A technical overview of Azure SQL Data Warehouse Gen 2. SQL Data Warehouse is a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data.
This talk will address how to add the unit testing framework tSQLt to the database deployment pipeline. The purpose is to reduce the cost of validate every change in the database with a fully automated pipeline.
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.
A walk-through on what is possible analyzing your data with the "R" language.
We will review this new feature of ADFv2, do deep dive to understand the mentioned techniques, compare them to SSIS and/or T-SQL and learn how modelled data flow runs Scala behind the scenes.
See how to analyze images in your Data Lake with Azure Data Lake Analytics, U-SQL and custom models
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.
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.
Look inside Query Store to see what it does and how it works
Biml is not just for generating SSIS packages! Come and see how you can use Biml to save time and speed up other Data Warehouse development tasks like T-SQL development, test data creation, and dimension population.
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.
Azure offers a wide range of services that can be combined into a BI solution in the cloud.
This session looks at creating a SQL test lab on your workstation. We start by selecting a hypervisor, look at building a virtual machine and then creating a domain controller, a Windows failover cluster and a couple of SQL Servers.
Paginated reports (SSRS), are available in both on-premises and cloud-based solutions. Join this session to experience the journey of SSRS and how to create and deploy reports across all the different products available in the Microsoft Ecosystem.
Based on real life scenarios, an audience interactive session.
Learning DAX can be tricky, especially if you have a background in SQL.
The dbatools module now has over 400 commands you can work with. How do you know where to start and which ones you can use in your day-to-day work?
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).
In this hour long session we will attempt to include lots of advice and guidance on how to develop code that will easily get approved by your DBA prior to release to production.
Using Azure DevOps and Azure RM templates to created isolated environments for testing PaaS solutions.
Step back through the ages and explore how database teams have approached creating environments for dev and test. Learn how, in the new age of provisioning, databases are delivered safer, faster, and more efficiently
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.
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.
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?
An end-to-end solution covering many Azure features
In this session you'll learn how Hyperscale removes limits for cloud based VLDBs.  We'll demonstrate how to create, migrate, and do point in time restore of very large databases in Azure.
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.
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
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.
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.
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
With SQL 2017 we entered a brave new world with cross-platform SQL Server, and with the new Azure Data Studio, we now have the tools to go with it. In this demo-packed session, learn about the newest tool for SQL Server for Windows, MacOS, and Linux, and how you can use it and extend it for your own needs. Be one of the first to see the new Notebooks feature for SQL Server, which brings the power of Jupyter notebooks to your SQL Server workflow.
The new SQL Server tool designed to help manage your estate
This session aims to introduce database professionals to the language of HiveQL.
We are now giving you the opportunity to securely execute Java code in SQL Server using the new 3rd party extensibility framework. Come to this session to learn how you can execute Java code in SQL Server on both Windows and Linux. This sessions will also cover the 3rd party extensibility architecture we are launching soon, which will enable the SQL Server community to build their own language extensions!
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2017 / 2019 has introduced many new features.
In this session we will learn which processes are required to build a real-time analytical model along with batch-based workloads, which are the foundation of a Lambda architecture.
Learn how to understand and read execution plans.
Everyone that has been involved in Software Development can notice how huge the impact of a bug can be, and Databases are not the exception. In this session, you will learn how to test your SQL Server projects using Visual Studio and SQLUnitTesting.
In this session, you'll learn about the various prebuilt AI/ML models that are available for your consumption through Microsoft's Cognitive Services. Additionally, you'll see examples of how these prebuilt services can be leveraged with SQL Server 2019.
A chance for speakers new and seasoned to take the stage for 5 minutes and effuse about something/anything in SQL Server they love.
In this session, you will learn about the architectural details of Managed Instance, the available features, and the best ways to configure it and migrate your databases to Managed Instance.
In this session, we will discuss the strategies and thought process one should adopt for modeling and partition data effectively in Azure Cosmos DB. We will also briefly cover related topics such implementing optimistic concurrency control, transactions with stored procedures, batch operations, and tuning queries + indexing
SQL Data Warehouse is a cloud-based Enterprise Data Warehouse (EDW) that leverages Massively Parallel Processing (MPP) to quickly run complex queries across petabytes of data. Azure Databricks is a fast, easy and collaborative Apache Spark-based analytics service that can be used for big data analytics and artificial intelligence (AI) solutions. This session will cover the architecture patterns for using the two in synergy.
SQL Server 2008/R2 is soon reaching end of support. We'll take a look at the migration life cycle and show you how easy it is to migrate SQL Server instances to Azure with near-zero downtime by using the Azure Database Migration Service and related tools. We'll also give you a deep dive how to perform scale migrations using our CLI components
Upgrades should be approached with the same rigor and processes as a full software or hardware project – a solid methodology is required for success. Microsoft provides you with all the tools you need to achieve a seamless, reliable upgrade experience. In this session we demonstrate some of the free tools that Microsoft provides in order to ensure your SQL Server upgrade is a success.
Join this session to learn how managing performance is even more critical with Azure SQL DB. Learn what key performance indicators are most applicable, what auto-tuning really means and get some tools to help you identify and fix issues.
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.  ?
This session covers situations where the SQL Server query optimizer does not rely on index order and provides tips and tricks to solve those.
<<12>>