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.| SQLBlog.org
I dug a little into one of the new RegEx functions in SQL Server 2025: REGEXP_SPLIT_TO_TABLE.| SQLBlog.org
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.| SQLBlog.org
In this article, I detail some of the things we do to manage backups and retention policies for hundreds of production databases.| SQLBlog.org
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.| SQLBlog.org
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...| SQLBlog.org
I recently had a great conversation with Louis Davidson as part of his "Coffee chat with..." series on Simple Talk.| SQLBlog.org
I talk about some of the challenges and qualitative factors that influence how you add, remove, and change indexes.| SQLBlog.org
I consolidate many bits of Docker advice that had previously been scattered across several different posts.| SQLBlog.org
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.| SQLBlog.org
I show an inline table-valued function to extract values from an integer encoded with days of the week.| SQLBlog.org
In this post, I talk about why it's so important to regularly test that your backups can be restored.| SQLBlog.org
In the last part of the series, I show how I coordinate multiple parallel jobs... and what comes after them.| SQLBlog.org
In part 3 of this series, I dig into some detail about how I further parallelized the work and reduced overall runtime.| SQLBlog.org
In part 2, I show how I take advantage of snake draft order with a couple of real use cases.| SQLBlog.org
In this four-part series, I borrow a concept from fantasy football to solve an optimization problem in a long-running weekly job in SQL Server.| SQLBlog.org
I talk about a technique that can avoid expensive sorting to paginate by large string values.| SQLBlog.org
In this post I talk about how to avoid losing valuable debugging information in the abyss and noise of SQL Server Agent's history.| SQLBlog.org
I put together a few pointers about upgrading SQL Server, including /SkipRules, and avoiding the web installer.| SQLBlog.org
For this month's T-SQL Tuesday, Brent Ozar asks about the last ticket we closed. I came close...| SQLBlog.org
I talk about several things you can do to clean up after yourself and be a good RDP citizen.| SQLBlog.org
If you're planning to roll forward your existing configuration file to SQL Server 2022, read this first.| SQLBlog.org
Azure SQL Database got an update: A new locking model that might finally displace NOLOCK.| SQLBlog.org
2023 was an interesting year for SQLblog.org - I talk about top posts and some changes I made here over the year.| SQLBlog.org
I show how to use metadata to avoid costly reads when retrieving counts, even for a subset of the table.| SQLBlog.org