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
76 reads
The Non-Cluttered Index
2019-07-22
13 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
48 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
99 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
16 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,272 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)
445 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
209 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
166 reads
That Awkward Moment When….
Let's be honest - some of our best learning experiences come from our mistakes. Here's one of mine....
2019-04-05
16 reads
Blogs
Why Database AI Agents need Layers?
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
Un-Migrating From the Cloud: T-SQL Tuesday #199
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
T-SQL Tuesday #199: Back to the on-prem
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
Forums
Unable to restrict permission
I have 13 restricted views in my EDW DB. 6 of them are created...
Install SQL Scripts via GUI Wizard
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Would You Retire Rather Than ...
Comments posted to this topic are about the item Would You Retire Rather Than...
Question of the Day
Converting Money
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers