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.
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.
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.
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 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.
Based on real life scenarios, an audience interactive session.
Learning DAX can be tricky, especially if you have a background in SQL.
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
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?
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
The new SQL Server tool designed to help manage your estate
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.
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.