In part 1 of my SQL Server 2022 features series, you learned about the improvements to the cardinality estimator component of query optimization. In this installment, you will learn about another ...

Welcome to the first of a two-part series. In this first part, I'll talk about the physical infrastructure that Microsoft uses to ensure availability and provide a high degree of uptime for the Azure ...

In “The end of SQL and relational databases? (part 1 of 3)” I covered some background on the SQL language and relational databases, the current and future for relational databases, the rise of ...

First off, I'm a sysadmin not a SQL coder, so please forgive me not understanding anything about this - I'm trying to cut and paste and adapt code. Story: Golden Boy can't seem to remember to close ...