Sessions & Content

Search
Content Type
Conference
Tags
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.
A dive into the architecture that is Azure SQL DW Gen2 Philip Beaumont
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.
The video is not available to view online.
Adding unit tests to the database deployment pipeline Eduardo Piairo
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.
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 Data Factory v2 with Data Flows capabilities Kamil Nowinski
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.
Azure Data Lake : SELECT * FROM DataLake WHERE People=Happy Jean-Pierre Riehl
See how to analyze images in your Data Lake with Azure Data Lake Analytics, U-SQL and custom models
The video is not available to view online.
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
Biml Tips and Tricks: Not just for SSIS packages! Cathrine Wilhelmsen
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.
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.
Build your next BI solution in Azure Alexander Klein
Azure offers a wide range of services that can be combined into a BI solution in the cloud.
Create a SQL Test Lab on Your Workstation David Fowler
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.
The video is not available to view online.
Create Pixel Perfect Reports: The Story of Paginated Reports Patrick LeBlanc
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.
The video is not available to view online.
Database Adventure Kevin Chant
Based on real life scenarios, an audience interactive session.
The video is not available to view online.
DAX for the SQL developer Alexander Arvidsson
Learning DAX can be tricky, especially if you have a background in SQL.
The video is not available to view online.
dbatools-PowerShell and SQL Server Working Together Sander Stad
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?
The video is not available to view online.
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).
Developing SQL Server code to keep your DBA happy Annette Allen
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.
The video is not available to view online.
<<12345>>