What If You Need to Index a Lot of Duplicate Data?
Let’s get a little nerdy and look at database internals.
Triggers
Triggers. Who doesn’t like a good, lively debate about triggers? With the extreme cold that we’ve experienced this past week in the northeastern U.S., I feel like a little heated debate wouldn’t be a bad way to forget about the cold. But alas, I’m not here to talk about database triggers. Sorry, we’ll have to […]
Configuring Maintenance Plans in SQL Server
See a walkthrough of setting up a maintenance plan in SQL Server.
Moving On After a Technology Fail
After his watch broke, Steve had to get a new tool and isn't sure it was a good move.
Upgrade and Migrate SSIS Catalog and SSISDB to a New Server
There will come as time when you need to upgrade the host operating system and SQL Server to a newer version. If you are using SQL Server Integration Services (SSIS), one of the things you may need to do is to move the SSIS catalog (SSISDB database) to the new server. We will cover the steps in this tutorial to migrate the SSISDB from one server to another.
How to Resolve SQL Server Database Stuck in Recovery Pending State
Learn how to recover a database from a missing or corrupt transaction log file.
Is Ransomware Fading?
There is a report that less ransomware ransom is being paid. Perhaps that's a good sign for all of us.
Index Rebuilds Make Even Less Sense with ADR & RCSI
Accelerated Database Recovery (ADR) is a database-level feature that makes transaction rollbacks nearly instantaneous. Here’s how it works.
The Change Failure Rate
The number of times that you have a failure when deploying changes is a good metric to watch.
Blogs
New article – migrating from a named instance
By Brian Kelley
Do you have a case where you have a named instance you'd like to...
Cleaning Up My Blog's SEO and AEO with Claude in GitHub Copilot
I’ve been running this blog on Hugo for a long time, and like most...
Using the SIGN() Function: #SQLNewBlogger
By Steve Jones
I was trolling the docs and noticed the SIGN() function. I have never written...
Forums
Admin Rights for Everyone
Comments posted to this topic are about the item Admin Rights for Everyone
Kerberos Authentication for Aurora PostgreSQL: Mapping AD Groups to Database Roles
Comments posted to this topic are about the item Kerberos Authentication for Aurora PostgreSQL:...
RegEx Functions I
Comments posted to this topic are about the item RegEx Functions I
Question of the Day
RegEx Functions I
Which of these RegEx functions need compatibility level 170 in SQL Server 2025?
See possible answers