Moving On After a Technology Fail
After his watch broke, Steve had to get a new tool and isn't sure it was a good move.
2025-02-21
68 reads
Technology
Where's the Printer Friendly Option?
Steve reminisces about the older technology of putting words on paper, often from the web.
2024-10-04
61 reads
2024-09-27
663 reads
AI Is Great and Tech is Failing
Steve is a little disappointed in technology that didn't work well after a security incident.
2024-09-25
178 reads
2024-09-21
134 reads
It's Time to Play
Writing editorials every few weeks for a technical mailing list has been one of the more challenging responsibilities in my (nearly) two years with Redgate as an advocate working with Steve, Grant, and Louis. Each week, it’s interesting for me to see the mix of technical insights and everyday life stuff that each of us […]
2024-08-31
386 reads
Continuity Across Restarts
A cloud version of Aurora MySQL has added support for the buffer pool to survive restarts of the database engine. Steve thinks that's an interesting technology, which could be helpful.
2024-01-12
128 reads
2023-11-24
151 reads
Using Technology for Health
I've been fairly healthy and fit for most of my life. While I've always had a few extra pounds, I do try to eat better than average and I exercise regularly. That didn't stop age and some pandemic laxity from catching up with me. My annual checkup last December had my doctor (and me) slightly […]
2022-03-05
101 reads
Digitizing Construction
One of the more analog industries is embracing digital change faster and faster./
2021-08-11
281 reads
Blogs
SQL Server 2025 GAs Today
By Steve Jones
If you aren’t watching the Ignite keynotes today, then you might have missed the...
Run SQL Server 2025 and SQL Server Management Studio on macOS Tahoe
Short version You want to get this running as fast as possible. Do these...
The Roundup for T-SQL Tuesday #192
By Steve Jones
Last week I asked you to write about SQL Server 2025 and what things...
Forums
The case for "Understanding our business" training
Comments posted to this topic are about the item The case for "Understanding our...
Specifying the Collation
Comments posted to this topic are about the item Specifying the Collation
SQL Server 2025 has arrived!
Comments posted to this topic are about the item SQL Server 2025 has arrived!
Question of the Day
Specifying the Collation
I am dealing with issues on my SQL Server 2022 instance related to collation. I have an instance collation of Latin1_General_CS_AS_KS_WS, but a database collation of Latin1_General_CI_AS. I want to force a few queries to run with a specified collation by using code like this:
DECLARE @c VARCHAR(20) = 'Latin1_General_CI_AS'
SELECT p.PersonType,
p.Title,
p.LastName,
c.CustomerID,
c.AccountNumber
FROM Person.Person AS p
INNER JOIN Sales.Customer AS c
ON c.PersonID = p.BusinessEntityID
COLLATE @c
Will this solve my problem? See possible answers