Explicit and implicit datatype conversions
Did you know that 1/2=0? If you didn’t you could be in for some interesting surprises. 1/2 returns 0 because ... Continue reading
2022-08-25
39 reads
Did you know that 1/2=0? If you didn’t you could be in for some interesting surprises. 1/2 returns 0 because ... Continue reading
2022-08-25
39 reads
DBCC CLONEDATABASE is one of those features that I don’t use often but it’s really cool when I need it. ... Continue reading
2022-08-24 (first published: 2022-08-11)
534 reads
I was recently asked to review SQL Server Query Tuning and Optimization by Benjamin Nevarez (blog|twitter), and as soon as ... Continue reading
2022-08-16
116 reads
You’ll hear a lot of people complain about replication. Including me. That said, replication is an amazing tool. There really ... Continue reading
2022-08-15 (first published: 2022-08-02)
256 reads
🎶🎵 Memories, not being alone in the moonlight 🎵🎶 Kevin Kline (blog|twitter) is our host for this month’s episode of ... Continue reading
2022-08-09
17 reads
In case you didn’t know I was given notice about a month and a half ago. Since I’ve talked about ... Continue reading
2022-08-04
23 reads
I use impersonation a lot. It’s a really easy way to check if someone has the permissions they are supposed ... Continue reading
2022-08-03 (first published: 2022-07-26)
766 reads
I recently passed the second anniversary of the start of my stay in the hospital. A lot has happened since ... Continue reading
2022-07-28
31 reads
It’s T-SQL Tuesday again! Deborah Melkin (blog|twitter) is our host this month and she’d like to hear our opinion. A ... Continue reading
2022-07-27 (first published: 2022-07-12)
381 reads
A while back (6 years ago 😲) I talked about how you can change the behavior of SSMS so that ... Continue reading
2022-07-21
121 reads
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...
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
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
Hi, below i show various results trying to reach our ftp site (a globalscape...
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