In a few previous articles, I have talked a lot about Managed Service Accounts (MSA) and Service Principal Names (SPN) and given examples of managing the separately. As a...
2022-11-11 (first published: 2022-11-01)
359 reads
I’ve seen a few people start Azure Data Factory (ADF) projects assuming that we would have one source control repo per environment, meaning that you would attach a Git...
2022-11-09 (first published: 2022-10-31)
323 reads
Background
T-SQL Tuesday - the brainchild of Adam Machanic and coordinated by Steve Jones (blog|Twitter) is a monthly blog party on the second Tuesday of each month. And I will...
2022-10-31
41 reads
In just a couple of weeks, the PASS Summit will return to Seattle, Washington. This one will be extra special, since it’s going to be the first in-person Summit...
2022-10-31
45 reads
The Community edition of Flyway has some nice basic features, and it works well for many people. However, it requires you to do a lot of the heavy lifting...
2022-10-31
180 reads
It’s time to look back at the 155th blog party. I was the host this month, asking about Dynamic SQL. I got quite a few responses, which I’ve gone...
2022-11-01 (first published: 2022-10-31)
19 reads
Hello Dear Reader! This past week was an extremely fun time over at the Tales From The Field show! Fall is here, the leaves change and fall in Florida...
2022-10-31
23 reads
I may have occasionally talked about the importance of Query Store, but today I want to emphasize just how much Microsoft is weaponizing query store. Of course, I don’t...
2022-10-31
23 reads
Today’s coping tip is to find a new perspective on a problem you face. I don’t face many big problems, but I do face lots of small ones on...
2022-10-31
19 reads
My responsibilities revolve around providing the business with the data they need to make informed business decisions. One of those processes requires us to shift data from a Snowflake...
2022-11-11 (first published: 2022-10-30)
193 reads
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Comments posted to this topic are about the item Checking the Error Log II
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers