How do I test if a linked server works using T-SQL?
I get that linked servers are almost as despised as the dreaded cursor or (lord save us) NOLOCK, but they ... Continue reading
2020-10-29 (first published: 2020-10-27)
827 reads
I get that linked servers are almost as despised as the dreaded cursor or (lord save us) NOLOCK, but they ... Continue reading
2020-10-29 (first published: 2020-10-27)
827 reads
I was recently asked to add on to my permissions stored procedures (sp_SrvPermissions, sp_DBPermissions and sp_AzSQLDBPermissions) and create one for ... Continue reading
2020-10-22 (first published: 2020-10-15)
256 reads
I was recently watching the first session of the Azure SQL Bootcamp by Anna Hoffman (twitter) and Bob Ward (blog|twitter) ... Continue reading
2020-10-22
171 reads
Rob Volk (blog|twitter) is our host for TSQL Tuesday this month and wants us to Explain a database subject like ... Continue reading
2020-10-20 (first published: 2020-10-13)
457 reads
It took me a little bit longer to get here than I expected but I finally made it. 800 posts. ... Continue reading
2020-10-20
2 reads
Quick post today. Recently I was helping a co-worker write a trigger. Basically there is a table of servers that’s ... Continue reading
2020-09-11 (first published: 2020-09-03)
460 reads
Triggers. Still blech. In June I asked you to play with DML triggers. Well, one more time. First of all ... Continue reading
2020-09-01
87 reads
TL;DR; Yes Frequently in our industry we talk about gatekeepers as bad things. We talk about breaking down barriers and ... Continue reading
2020-08-27
176 reads
Well, I’m running a bit late. Both for this month and the fact I completely missed last month. It was ... Continue reading
2020-08-13
82 reads
I almost died. I’m sure a lot of you already know this but just to be clear, I should have. ... Continue reading
2020-08-11
16 reads
By James Serra
The new data governance features in Microsoft Purview are now being made generally available...
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added...
By Steve Jones
I saw a post internally that asked this question: Anyone have a handy powershell...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item Bad Stored Procedures
Comments posted to this topic are about the item Disable All the Indexes
How do I disable all the indexes on the dbo.Logger table?
See possible answers