Analyzing Tempdb Spills and Usage Across Recursive Queries

This article examines how tempdb is affected by recursive queries, using a few different methods.

Is SQL Server Feature Complete?

Steve asks the question about whether you think SQL Server is feature complete today.

Rows estimation with OPENJSON

STRING_AGG's behavior

Creating a Hyperscale Database in Azure Using the Azure Portal

One of the most effective ways to fully utilize your data is to create an Azure Hyperscale database. The principles of Azure Hyperscale databases have been discussed in this article, including their cost-effectiveness, worldwide accessibility, automatic scaling, and reliable performance.

Optimized Plan Forcing with Query Store in SQL Server 2022

In this Article ,  We will delve into the world of Query Store and explore how to use Optimized Plan Forcing to improve performance in SQL Server 2022. We will discuss what it is, how it works, and how it can impact your system's performance.

Working with SQL Server Stored Procedures and .NET

There is more than one way to work with SQL Server stored procedures from within a .NET Application. However, when using parameters, in order to avoid exposing your code to "SQL Injection" vulnerabilities, there is a certain way based on which you should write your code.

The Growth of IQP

Steve talks about some of the Intelligent Query Processing improvements in SQL Server 2022.

The Usefulness of Database Features

The features we want and get in a database platform can make our job easier or harder. Steve has a few thoughts on how they should work.

MSSQL Server AlwaysON: Get alerted for inconsistencies in logins, jobs and databases

This script will create the necessary login and linked servers on a given availability replica. Please ensure that the script is executed on all the replicas.