I recently built a process to create a new filtered index on a schedule to support a UI that only cares about the last 30 days.
I dug a little into one of the new RegEx functions in SQL Server 2025: REGEXP_SPLIT_TO_TABLE.
In this follow-up, I show how we determine all possible point of time restores and identify which backup files to keep in order to meet our recovery objectives.
In this article, I detail some of the things we do to manage backups and retention policies for hundreds of production databases.
I put together a brief list of all the things that can cause "A network-related or instance-specific" error messages, and a few things that can't.
As the SQL Server 2025 public preview hit the streets, I had to test the new backup compression algorithn, ZSTD, on a decently-sized database.
Occasionally, it's fun to talk about our wish lists for SQL Server. In this post, I talk about a few that I came across recently…