Select Page
Code example of a query hint.

Query Store hints in SQL Server 2022

Part of the SQL Server 2022 blog series.Query Store is one of the most powerful database-scoped features in SQL Server for troubleshooting performance and improving the stability of your database workloads, and we have continued to make investments in this ... continue reading
Diagram of the use of Azure Arc to enable Azure AD authentication for SQL Server 2022.

Azure Active Directory authentication for SQL Server 2022

Part of the SQL Server 2022 blog series.Azure Active Directory (Azure AD) authentication is now supported for SQL Server 2022 preview on-premises for Windows and Linux Operating Systems.Azure AD Authentication methods The new functionality extends existing authentication modes, such asSQL ... continue reading
A screenshot of the Backup via URL GUI on Azure Data Studio.

What’s new with SQL Tools

Hello community, the June release of Azure Data Studio 1.37 is here! We are also excited to announce the release of SQL Server Management Studio (SSMS) 18.12. In this Azure Data Studio release, backup and restore to URL was introduced ... continue reading
Image of object explorer for SQL Server Management Studio 19 connected to SQL Server 2022.

Recapping recent updates to client tools in SQL Server

Hello from the SQL Experiences team! As a follow-up to Microsoft Build at the end of May, we thought it was a good time to highlight recent updates for client tools, as we've had quite a few.SQL Server Management StudioFirst, ... continue reading
A preview of table designer and its accompanying features

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
:smile:

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
bake13_0-1635332214539.png

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-CMcollection.jpg

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
Upper left corner of Azure Data Studio with Projects pane open showing 2 projects, AdventureWorksLT and WideWorldImportersDW.

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
DB-BLOG.png

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