Microsoft will retire SCOM SQL monitoring packs in 2027, pushing customers toward Azure Monitor and cloud billing.

An installable assembly for SQL Server that adds Deflate (the algorithm used by GZip) Compression functions for nvarchar values. Download the latest release from the Download page. Please note that ...

Aggregate functions help turn large datasets into simple summaries used across many fields. GROUP BY and HAVING allow structured grouping and filtering of data for clearer reports. Functions like ...

Choosing between Microsoft Dataverse and Microsoft SQL Server resulted in us having to decide between two good options. Microsoft Digital stories Editor’s note: This story was created with the help of ...

Who are these scripts for? You need to troubleshoot performance problems with SQL Server, and you need to do it now. You don't have time to track down a bunch of DMVs, figure out Extended Events, ...

A new SQL Server 2025 feature lets organizations run vector-based semantic searches on their own data, connecting to local or cloud-hosted AI models without relying on massive general-purpose LLMs. I ...

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

If you don’t have a backup of your MS SQL database, then follow the below ways to recover deleted data. Transaction log files record each change made to the ...

Despite its steep licensing costs, SQL Server continues to prove its worth over open-source alternatives in some key areas. SQL Server is an expensive part of your IT stack -- SQL Server Enterprise ...