Automating Replication On Your Server
If you use replication, you have had the situation occur where you had to restore a replicated database. You’ve have doubtless been paged to restore a replicated database. You...
2019-07-31
34 reads
If you use replication, you have had the situation occur where you had to restore a replicated database. You’ve have doubtless been paged to restore a replicated database. You...
2019-07-31
34 reads
2019-07-22
9 reads
Before we approached our last major SQL Server upgrade, I was curious about what might break. Yes, I had used the DEA to check our code against deprecated or...
2019-07-19
39 reads
Why do I take pictures of screens at conferences? Let me count them up for you! Read on...
2019-07-05
94 reads
It's SQLIntersection time, and also time to meet a new member of the family. He's old enough for social media, though...
2019-06-07
13 reads
I was recently asked in a Service Broker class that I was teaching why we would use it. Good question! Read on....
2019-05-15 (first published: 2019-05-03)
1,237 reads
Dread the drop no more! Part 2 of the rename/drop process.
2019-05-06 (first published: 2019-04-22)
437 reads
Oh, the dreaded string search (on an entire instance). What to do?
2019-04-11
146 reads
Ever tried to drop a user/login, only to find that they owned a schema? Here's how I do it...
2019-04-08
127 reads
Let's be honest - some of our best learning experiences come from our mistakes. Here's one of mine....
2019-04-05
10 reads
Wondering which database to tackle first? I’ve got the lowdown on the top free...
By Brian Kelley
The Techno Security & Digital Forensics Conference (East) runs from June 3-5, 2025, this...
You can find the slides for my session Building the €100 data warehouse with...
Comments posted to this topic are about the item Changing the Paradigm of Work
Comments posted to this topic are about the item Removing a File
Comments posted to this topic are about the item SQL Cookbook: Query Solutions and...
I attempted to use ALTER DATABASE to remove a file from my filegroup in SQL Server 2022. There are 4 files in this filegroup, but I don't need them all. However, I received a message that the file was not empty. How do I empty this file so it can be removed?
See possible answers