2025-03-24
546 reads
SQL Server 2022
New SQL Server 2022 Functions
There were a number of T-SQL functions added in SQL Server 2022. Today Steve asks if you are using any of these in your work.
2024-11-22
486 reads
Cardinality Estimation Feedback in SQL Server 2022
Cardinality estimation (CE) is a process used by the query optimizer to estimate the number of rows returned by a query or sub-part of a query. These estimates rely on two underlying things: statistics about the data and a set of assumptions—known as the model.
2023-12-06
Accelerated Database Recovery enhancements in SQL Server 2022
We are excited to share that there are several Accelerated Database Recovery enhancements in SQL Server 2022.
2023-12-01
Batch Execution Mode on a Rowstore in SQL Server 2022
Batch execution mode is a new optimization feature in SQL Server. In this Article, we'll explore how Batch execution mode works and how you can use it to get faster query results on Rowstore data.
2023-10-30
3,700 reads
2023-05-12
503 reads
2023-05-05
158 reads
2023-04-28
325 reads
2023-04-21
313 reads
2023-04-14
337 reads
Blogs
What’s new in SQL Server 2025 CTP 2.0
Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...
Monday Monitor Tips: Beyond SQL Server
By Steve Jones
Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...
T-SQL REST API Integration in SQL Server 2025: Streamlining T-SQL Snapshot Backups
In this post, I’ll walk you through a T-SQL script that creates application-consistent snapshots...
Forums
Connect tabular model to excel via Power BI semantic model
I have a tabular cube, with myself included in one of the roles. I...
New lightweight pure‑T‑SQL unit‑testing framework (T‑TEST) — feedback welcome
Hi all, I’ve just open‑sourced T‑TEST, a tiny alternative to tSQLt that lives...
Helpful Management Studio Settings and Features
Comments posted to this topic are about the item Helpful Management Studio Settings and...
Question of the Day
The Minimal Linked Server
What is the minimal number of parameters to add a linked server with sp_addlinkedserver?
See possible answers