Validating Replication (All or Just One Article)
You may sometimes have reports or other processes that are dependent on transactional replication being current. If that is the case, you will probably need a mechanism to check...
2019-08-09
34 reads
Pam Mooney
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
90 reads
2019-07-22
24 reads
One Way to Find Broken Code on Your Server
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
57 reads
Why I Take Pictures at Conferences
Why do I take pictures of screens at conferences? Let me count them up for you! Read on...
2019-07-05
119 reads
Gone Fishing…
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
27 reads
What is Service Broker, and Why Would We Use It?
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,322 reads
Drop It Like It’s Hot (Part 2 of the Rename/Drop Objects Process)
Dread the drop no more! Part 2 of the rename/drop process.
2019-05-06 (first published: 2019-04-22)
464 reads
Find Occurrences of a String Anywhere on an Instance
Oh, the dreaded string search (on an entire instance). What to do?
2019-04-11
241 reads
Automatically Drop a Login/User (and Solve the Schema Owner Problem)
Ever tried to drop a user/login, only to find that they owned a schema? Here's how I do it...
2019-04-08
194 reads
Blogs
T-SQL Tuesday #203: Risk and Reward
By Steve Jones
This is timely, as I’m currently on a boat in the Adriatic taking a...
dataMinds Connect 2026 – Slides & Scripts
You can find the slides and SQL scripts for my session “Spice up your...
How to Clear the SSMS Cache (SSMS 21 and Later)
By SQLPals
How to Clear the SSMS Cache (SSMS 21 and Later) Updated...
Forums
Risk Vs Reward, The never ending ROI discussion.
Comments posted to this topic are about the item Risk Vs Reward, The never...
Hyperscale Replicas IV
Comments posted to this topic are about the item Hyperscale Replicas IV
The SQL Server Date Magic: When CAST and CONVERT Keep Your Index Seek
Comments posted to this topic are about the item The SQL Server Date Magic:...
Question of the Day
Hyperscale Replicas IV
In Azure SQL Database Hyperscale Edition, how many geo-replicas can be created?
See possible answers