A Solutions Architect explores the harsh realities of de-identifying sensitive data by creating custom scripts, including the questions and complexities that arise along the way.

Microsoft deprecates SSRS, PBIRS and SSAS management packs for SCOM, ending support in 2027. The move signals a shift from on-prem SCOM extensions toward cloud-based SQL Server monitoring. IT teams ...

Configure Repositories for Installing and Upgrading SQL Server 2022 on Linux Check and configure source repositories for SQL Server 2017, 2019, and 2022 on Linux. The source repository affects the ...

Last month, Microsoft released a few updates for SQL Server Management Studio (SSMS) 21, while also revealing its plans for the next major release, SSMS 22. This follows the release of a SQL Server ...

Microsoft has revealed some details about what's next for SQL Server Management Studio (SSMS). Customers should expect multiple SSMS releases soon. SQL Server Management Studio (SSMS) is the tool of ...

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.

As developers look to harness the power of AI in their applications, one of the most exciting advancements is the ability to enrich existing databases with semantic understanding through vector search ...

Organizations are using generative AI to stay ahead of the competition, but the real advantage lies in harnessing the power of your own data securely and at scale. One of the most exciting new ...

In this post, we will go step by step into several aspects of Change Data Capture, a feature that is available on the Azure SQL Managed Instance and Microsoft SQL Server. The focus will be on the ...