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
507 reads
Trunk based development is what many of us do with shared database servers.
2019-03-29
700 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)
254 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,226 reads
2019-03-22
119 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
A new version of an existing application doesn't always provide an upgrade.
2019-03-18
105 reads
2019-03-15
127 reads
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
In the era of cloud-native applications, Kubernetes has become the default standard platform for...
Hi experts, I have a 3+ TB database on a 2019 sql server which...
Comments posted to this topic are about the item The North Star for the...
Comments posted to this topic are about the item Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers