Snooping
System administrators have a lot of power and temptation to use it. Steve Jones talks about the need to resist temptation and the need for oversight.
2008-08-13
143 reads
Editorials
SQL Profanities
Do you avoid certain SQL functionality because you have been told you should NEVER use it?
2008-08-12
393 reads
Bill Baker - Database Weekly (Aug 11, 2008)
This weeks Database Weekly looks at a longtime leader for the Microsoft SQL Server development team leaving the company.
2008-08-11
127 reads
The Starting Point
The Mojave Experiment is a marketing effort by Microsoft that is very interesting in looking at first impressions. Steve Jones comments.
2008-08-11
100 reads
2008-08-08
243 reads
2008-08-07
251 reads
2008-08-06
159 reads
Un-retiring
Would you leave technology and come back to it as a career? It seems that many people are afraid of doing it, but Steve Jones talks about why it shouldn't matter.
2008-08-05
154 reads
Infinite Seizure - Database Weekly (2008/8/4)
This week's Database Weekly editorial examines the US policy of potentially seizing laptops for an infinite period when you enter the country.
2008-08-04
116 reads
Pimp My Data Center
Steve Jones talks about the changing capabilities and flexibilities of data centers as technologies change.
2008-08-04
106 reads
Blogs
Tech Conferences and Expanding Your View
By Brian Kelley
Tech conferences aren't just for networking and learning how to address a problem you're...
Managing subscribers, creating newsletters
By DataOnWheels
When I created the website on WordPress, I was expecting all the features I...
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...
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