Back in July I suggested that you get your resume up to date. It’s something I’d wish I’d kept up ... Continue reading
2022-11-14 (first published: 2022-11-01)
270 reads
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)
354 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)
321 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
36 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
39 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
178 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)
17 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
20 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
18 reads
I’m excited to announce the release of a new open-source project that fully automates...
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
Comments posted to this topic are about the item AI Experience Gap that we...
Comments posted to this topic are about the item Squared Values
Comments posted to this topic are about the item I Don't Want To Do...
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers