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
16,282 reads
Articles
Static Versus Dynamic Bulk Insert Imports of Multi-File Datasets
There are numerous use cases for multi-file imports of CSV files into a SQL Server table:
2025-10-31
2025-10-29
Docker Advice for SQL Server in Production
Introduction Nowadays, with the widespread adoption of microservices across major companies, using Windows Server to host SQL Server remains the gold standard. However, there are still certain scenarios—or even specific environments—where deploying SQL Server in containerized setups using the Docker engine becomes necessary. In this article, I will offer practical tips based on my hands-on […]
2025-10-27
4,308 reads
Managing Underused Indexes in SQL Server Availability Groups – Part 2
Knowing the usage from all workloads is definitely better than focusing on only the primary or a single secondary. But what if I want to make more informed decisions, incorporating row counts, size, and index columns into this output?
2025-10-27
How Implicit Transactions Hurt SQL Server Performance Without You Knowing
Learn about implicit transaction and why you might not want to enable this setting.
2025-10-24
6,416 reads
Memories of Andrew Clarke, by Simon Galbraith
Simon Galbraith, co-founder of Redgate and one of the creators of Simple Talk, remembers Andrew Clarke
2025-10-24
DIY Database Clones
This article explores the 'shadow copy' and 'disk virtualization' services built into the Windows operating system and explains a basic solution demonstrating how the technology is used to copy the data and log files for a live SQL Server database into an 'image', from which we can create multiple, lightweight copies, or clones, of the original database.
2025-10-22 (first published: 2021-04-29)
6,142 reads
Why Indexes are Important Beyond Faster Execution of Queries
Learn how indexes can help you with more than just querying data.
2025-10-22
17,113 reads
SQL EXISTS Use Cases and Examples
I’ve seen the SQL EXISTS keyword in Microsoft SQL Server T-SQL code and don’t understand it well. What does it do? How do I use it? Are there best practices around SQL IF EXISTS?
2025-10-22
Blogs
Using CAT for Testing of Data Agents
In last months one of the scenarios where you can use AI has been...
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forums
Backup to Immutable Storage
Comments posted to this topic are about the item Backup to Immutable Storage
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Question of the Day
Backup to Immutable Storage
In SQL Server 2025, a backup can be made on Azure Immutable Storage. What changes in how the backup is created?
See possible answers