Regular Expressions in SQL Server 2025
This article examines the new regular expression functions added to T-SQL in SQL Server 2025.
2025-10-31
15,479 reads
Deepam Ghosh
Database Ledger in SQL Server 2022
Learn how ledger databases and ledger tables work in SQL Server 2022.
2025-10-20
15,505 reads
Parameter Sensitive Plan Optimization in SQL Server 2022
Learn about a new feature of SQL Server 2022 - Parameter Sensitive Plan Optimization(PSPO)
2025-09-15
1,677 reads
Database File Growth Report Script
A T-SQL script to track and monitor the growth of your SQL Server Databases.
2025-09-12 (first published: 2025-09-04)
489 reads
Contained Availability Groups in SQL Server 2022
SQL Server 2022 introduced a new feature called Contained Availability Groups. It allows the Database Administrators to effectively manage the Server Level objects, such as Logins, SQL Agent jobs, etc. in an HA environment. In today's article, we will learn about this new feature of SQL Server. The Challenge of Managing Server Objects in Availability […]
2025-08-20
8,602 reads
2025-07-18
5,848 reads
Automating SQL Server Inventory Collection with SQLInventory
Learn about a free inventory tool to help you keep track of basic information on your servers.
2025-07-04
4,837 reads
Stored Procedure Generation Script
This script produces scripts for all the stored procedures in a database.
2025-06-18 (first published: 2025-06-13)
891 reads
SQL Automate - A DBA's Time-Saving Toolkit
SQLAutomate is a lightweight PowerShell tool that simplifies SQL Server deployment by automating both installation and post-installation configuration. Whether you're setting up one instance or dozens, this guide shows how to use SQLAutomate to save time and reduce manual work.
2025-06-06
9,936 reads
Blogs
The Benefits of Teaching
By Brian Kelley
Even preparing for a class or seminar with set materials takes a lot of...
Power BI, Excel, OneLake – Dreams Do Come True!
By DataOnWheels
I can’t believe it’s finally here! A way to have Excel live in OneDrive...
The Book of Redgate: What Our Staff Says
By Steve Jones
This image is from 2010, and it goes along with my last post of...
Forums
Website Stability 2025/12/05
All week we've had issues with the site being up and down. There's been...
403 Forbidden
I created a post (or tried) in the 2022 Admin forum. https://www.sqlservercentral.com/?post_type=topic&p=4694880 But it's...
Question of the Day
Fabric Mirroring
In which versions can I mirror a database from an on-premises SQL Server to a Fabric data warehouse?
See possible answers