Understanding the Benefits of Intelligent Query Processing

Understanding the Benefits of Intelligent Query Processing

In this episode of Data Exposed, Kate Smith will take you through the basics of why query processing matters, what it does, and how Intelligent... Details
Storage 101 for Azure SQL and SQL Server Engineers

Storage 101 for Azure SQL and SQL Server Engineers

Learn how storage impacts the performance of your database solution. In this episode with MVP Argenis Fernandez, go over the basics of I/O, what the... Details
Granular Permissions for Azure SQL Dynamic Data Masking

Granular Permissions for Azure SQL Dynamic Data Masking

In this episode of Data Exposed with David Trigano and David Brookler, learn how you can leverage new capabilities in Dynamic Data Masking, help your... Details
Easy Ways to Refresh Tabular Models

Easy Ways to Refresh Tabular Models

In this episode with Gaston Cruz, he'll show you the options to process Azure Analysis Services models (Semantic Layer) connecting to an Azure SQL DB... Details
How to Create Operational Analytics with Window Functions in Azure SQL – Part 3

How to Create Operational Analytics with Window Functions in Azure SQL – Part 3

Running complex aggregations and analytical functions on real-time operational databases is a powerful capability in Azure SQL. In the last part of this three-part series... Details
A Tour of SQL Workshops

A Tour of SQL Workshops

Join Anna Hoffman and Buck Woody as they take a tour of the incredible learning resource the Microsoft Engineering team has put together. From labs... Details
Live Coding T-SQL in the First Responder Kit

Live Coding T-SQL in the First Responder Kit

The one and only Brent Ozar where he writes & tests T-SQL scripts in Microsoft SQL Server on a livestream. Github repo: http://FirstResponderKit.org   Details
How to Create Elastic Jobs in Azure SQL Database Using PowerShell

How to Create Elastic Jobs in Azure SQL Database Using PowerShell

In this episode of Data Exposed, Kate Smith walks us through the process of how to create Elastic Jobs for Azure SQL using PowerShell. Details
Using SQL Server Data in ML.NET Model Builder

Using SQL Server Data in ML.NET Model Builder

Jon Wood shows us how to use the new SQL Data Loader in ML.NET Model Builder to load in training data. He also creates an... Details
How to Automate Disaster Recovery in SQL Server On-Prem

How to Automate Disaster Recovery in SQL Server On-Prem

Are you prepared if a tornado filled with sharks destroys your primary data center? Sure, you may have backed up your databases, but what about... Details