
Introducing new and improved updates to SQL tools on Azure
In this post, we'll recap the updates to SQL tools over the past few months, including the recent releases of Azure Data Studio and SQL Server Management Studio (SSMS). Additionally, we'll highlight the Data-Tier Application Framework (DacFx) 160 general availability ... continue reading

Azure Monitor: Audit your Azure and non-Azure SQL Server
Hi everyone, time passed since my last post. Hope you missed me Today I am going to cover an interesting aspect on how to capture security audit events from both Azure and non-Azure SQL Server machines. Most of you probably ... continue reading
SQL Server 2019 PolyBase feature High Availability
One of the most exciting aspects of SQL Server 2019 are the enhanced capabilities around the PolyBase feature that enables access to non-SQL Server external data sources through a process referred to as virtualization. The data remains at the external ... continue reading
MEM – Managing CM Collection in the Cloud Configuration and Troubleshooting
Dear IT pros, As you knew it, starting with Microsoft Endpoint Configuration Manager - MCM version 1906 (SCCM version 1906) you could enable co-management for Endpoint Manager -MEM (Intune) devices in the Azure Public Cloud, Azure US Government Cloud. The ... continue reading

SQL Tools December release recap
The December releases of Azure Data Studio 1.25 and SQL Server Management Studio (SSMS) 18.8 are now generally available. Additionally, the mssql extension for Visual Studio Code has recently been updated to version 1.10.0. Read on to learn more about ... continue reading
HOW TO AUTHOR SCCM REPORTS LIKE A SUPERHERO
Hi there, I am Matt Balzan, and I am a Microsoft Modern Workplace Customer Engineer who specializes in SCCM, APP-V and SSRS/PowerBI reporting. Today I am going to show you how to write up SQL queries, then use them in ... continue reading
Always Encrypted Data Displayed in SSRS with a gMSA
Let's take a look at how to display Always Encrypted Data in SSRS with a gMSA (Group Managed Service Account). We are mixing some technologies and the one that throws a wrench into things is the gMSA. Here is the ... continue reading
Configuring backup storage redundancy in Azure SQL
Database backups are an essential part of any business continuity and disaster recovery strategy, because they protect your data from corruption or deletion. In Azure SQL there are two types of automated backups that customers can use for restoring their ... continue reading
Quickly Setting Up a Sandbox with Azure SQL DB/MI and AAD Synchronization
Introduction During the migration journey from SQL Server to Azure SQL Database or Managed Instance, the customers I meet often wondering how to deal with the Integrated Authentication, their applications, especially the legacy ones. The following tutorial will ... continue reading
User initiated manual failover on SQL Managed Instance
High availability is a fundamental part of SQL Managed Instance (MI) platform that works transparently for your database applications. As such, failovers from primary to secondary nodes in case of node degradation or fault detection, or during our regular monthly software ... continue reading