Finding a decent sample API for testing can really slow things down when you’re trying to build something. You know, waiting ...

Zero-days in .NET and SQL Server, and a handful of critical RCE bugs, form the nucleus of Microsoft's March Patch Tuesday update.

Today is Microsoft's March 2026 Patch Tuesday with security updates for 79 flaws, including 2 publicly disclosed zero-day ...

This is going to sound strange, but one of the things I like about tuning Power BI DirectQuery semantic models is that their generally-slower performance and the fact you can see the SQL queries that ...

Columnstore indexes give great performance to queries that scan large sets of rows (millions of rows typically), and also provides huge savings in storage space. Typical compression rates can be 90%.

With the official release of Microsoft's latest database offering, let's see what was improved and what still needs some work. Today, at Ignite, Microsoft announced the general availability of SQL ...

Community driven content discussing all aspects of software development from DevOps to design patterns. The Google Cloud Data Practitioner Associate certification validates your ability to manage, ...

when used with an old SQL server version (or, in my case, a database with a compatibility level lower than 140). This happens because the STRING_AGG SQL function, which is used in the implementation ...

We’re excited to announce a new migration capability in Azure Arc to simplify and accelerate SQL Server migration. This new capability, now generally available, is powered by Azure Database Migration ...

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.