The Costs and Rewards of Speaking
Steve has had a good time sharing knowledge with others at events. He gives you a few thoughts on why you might join him at a future event.
2024-05-24
132 reads
Public Speaking
To Which Experts Should You Listen?
Many experts that speak to at events are working for vendors. Steve notes that this might mean they are making sales pitches, not not always.
2022-09-14
164 reads
Back to Basics, Reaching for the Clouds, and Leveling Up
The three themes for speakers at this year's PASS Data Community Summit are: Back to Basics, Reach for the Clouds, and Level Up. The goal here is content that covers a wide variety of areas, with many fewer restrictions from previous years. Perhaps the big thing to note for this year's event is: Free. That's […]
2021-06-02
219 reads
Looking to Role Models
Each of us can inspire and be a role model for others. Steve notes that the WIT group is doing that with an event on March 5th.
2021-02-13
110 reads
Join the New Stars of Data
There are plenty of opportunities to grow your career by sharing knowledge. Steve points out a few today.
2020-12-17
135 reads
A Virtual Trip Down Under
Steve returns from vacation and gets ready for a virtual trip to Australia.
2020-06-29
76 reads
Dummies Guide for a SQL Server Presentation
Preparing for SQL Server presentations is always a challenge. This article provides a few guidelines for the same
2016-10-27
2,387 reads
Blogs
Finding the Last Last Name in SQL: #SQLNewBlogger
By Steve Jones
I wrote a piece on the new SUBSTRING in SQL Server 2025 and got...
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...
Forums
Email change does not work
I changed my email address in Edit Profile page, but it has no effect...
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
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