JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

An update to the cardinality estimator feature in SQL Server 2022 will be one of the biggest changes to the database engine since its inception. Database engines like SQL Server are incredibly complex ...

With the latest public preview available, it’s time to decide if you want to upgrade to Microsoft’s most cloud-connected version of SQL Server so far. Three decades on, SQL Server is still a database ...

Ok, I'm trying to write a query in a stored procedure in SQL Server 2000. Because some of the parts of the query vary based on certain situations I construct a string that contains the query and then ...

I have been testing SQL Server 2008 RC0 (Release Candidate Zero) that was made available recently and I must admit I am beginning to like it. Even the new logo is growing on me. There are many new ...

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.