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.
Find Text in Stored Procedure, Function, View, or Trigger
How can I accurately find which SQL Server Stored Procedures, Views or Functions are using a specific text string, which can be a table name or any string that is part of the code?
Blogs
Beyond Pipelines: How Fabric Reinvents Data Movement for the Modern Enterprise
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
A Broken Copilot Query
By Steve Jones
I was testing the new SSMS (v22 Preview 3) with Copilot and ran into...
SQL Server Alerts
By Kevin3NF
Don’t Let Trouble Sneak Up on You Most SQL Servers run quietly. Until...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Building a RESTful API with FastAPI and PostgreSQL
Comments posted to this topic are about the item Building a RESTful API with...
The Journey to PostgreSQL (or anything)
Comments posted to this topic are about the item The Journey to PostgreSQL (or...
Question of the Day
A Common Split
What happens when I run this code:
DECLARE @s VARCHAR(1000) = 'apple, pear, peach' SELECT * FROM STRING_SPLIT(@s, ', ')See possible answers