Importing Excel files into SQL Server using DuckDB and Python

Learn to use DuckDB to read data from Excel and then send it to SQL Server with Python and Pandas.

How to Work with On-Premises AI Models to Generate T-SQL Code

See how a small local model performs on some SQL tasks. This shows how Ollama can run a model on your laptop.

What is New in SQL Server 2025

Learn about the latest version of SQL Server and get help installing it on your system.

The New OS Wars

A few countries are looking to reduce their reliance on US technology. While they might leave Windows, Steve thinks they will continue to run SQL Server.

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.