Last week was the MVP Summit. This year included a bunch of very technical discussions about some of the future of the Microsoft Data Platform (a big thank you goes to Slava Oks, Bob Ward, and all the team for a great job). I can’t share much since it was all under NDA. All I […]
2019-03-30
508 reads
Trunk based development is what many of us do with shared database servers.
2019-03-29
701 reads
There is a need to ensure we decide what ethics a computer system ought to have.
2020-02-10 (first published: 2019-03-27)
256 reads
Today, Steve wonders when we'll stop installing SQL Server on a host machine.
2019-03-26
1,267 reads
Steve has a few thoughts on what is worse than telling your boss about a data breach.
2019-03-25
144 reads
If you have been working with SQL Server long enough, you have probably been involved with a SQL Server 2000 to 2005 upgrade. It was painful for many shops due to the deprecation of some features like DTS and the removal of old-fashioned comma joins with the plus operator. It was worth the pain as […]
2019-03-25
1,231 reads
2019-03-22
121 reads
A new version of an existing application doesn't always provide an upgrade.
2019-03-18
106 reads
A minor disaster in Colorado reminds Steve about the need to prepare, and think about the failure points in our preparations.
2019-03-18
79 reads
2019-03-15
128 reads
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Hi So the case statement is slowing this down - but for the life...
I need to delete rows from both the temporal main and history tables. The...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers