My fantasy SQL feature(s)? T-SQL Tuesday #118
It’s fantasy football time again? Oh, fantasy feature? Oh, yea, that makes a lot more sense for #tsql2sday. What’s #tsql2sday? ... Continue reading
2019-09-19 (first published: 2019-09-10)
521 reads
It’s fantasy football time again? Oh, fantasy feature? Oh, yea, that makes a lot more sense for #tsql2sday. What’s #tsql2sday? ... Continue reading
2019-09-19 (first published: 2019-09-10)
521 reads
When studying Azure one of the things you’ll be asked to learn is the Powershell commands that can control, well, ... Continue reading
2019-09-18
67 reads
If you can help it you probably shouldn’t be using triggers. But if you have to use a trigger you ... Continue reading
2019-09-09 (first published: 2019-08-26)
522 reads
TL;DR; Final query is at the bottom. Every now and again (particularly when someone is having performance problems) I’ll get ... Continue reading
2019-09-04
188 reads
Everything else aside two of the most important tasks of a database are to get data in, and get data ... Continue reading
2019-09-02
236 reads
If you started out as a developer you were probably taught how important loops are. They are one of the ... Continue reading
2019-09-02 (first published: 2019-08-22)
1,211 reads
I recently had someone tell me, and I’m paraphrasing a bit here: We know how to fix this now, so ... Continue reading
2019-08-28
157 reads
Occasionally I’ve seen date and time stored separately as integers. This had some practical applications back before we had date ... Continue reading
2019-08-27 (first published: 2019-08-15)
779 reads
tl;dr; Temporary stored procedures are excellent for testing pieces of code that are going to go into (or come from) ... Continue reading
2019-08-21 (first published: 2019-08-07)
894 reads
7 years ago today I posted my very first blog post and I’ll tell you it’s been a heck of ... Continue reading
2019-08-20
9 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...
Hi, I'm working on cleanup activity of deleting databases that aren't in use or...
Good morning campers! I'm hoping to pick your collective hive brain wrt Veeam /...
How do I disable all the indexes on the dbo.Logger table?
See possible answers