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 ...

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 ...

I'm on a project that inherited some old generalized metadata search code and it can get terribly bogged down speed-wise. It's a bit annoying wait a couple minutes for a search to run: an example ...

As SQL development increasingly becomes part of full-stack workflows, developers are looking for ways to simplify their tooling without compromising capability. While SQL Server Management Studio ...

SQL Server Management Studio (SSMS) is the tool of choice for most developers when managing SQL Server and the relational data stored in it. Microsoft recently outlined plans for SSMS 22, currently in ...

Analyze database contents using basic, intermediate and advanced SQL statement syntax and usage. Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database ...

Microsoft today released SQL Server 2022, the latest version of its database software, which originally launched more than 33 years ago. Microsoft describes this release as the “most Azure-enabled ...