Testing
We get tested in a variety of ways before we take a job, but what should be open for examination besides our technical skills? Answer this week's poll with your opinion.
2008-01-18
182 reads
Editorials
Free and Cool
Two big events this week captured Steve Jones' attention. A little MySQL and Apple commentary to break up the week.
2008-01-17
69 reads
Clearing the Bar
How do you decide who gets hired? Do you get the best candidate? Steve Jones says that most of us don't necessarily hire the best person that applies for a variety of reasons.
2008-01-15
119 reads
Digital Storage
Digital technologies have made the transfer of information easier than ever, but what about it's long term storage? That doesn't seem to be as easy as we might think.
2008-01-14
290 reads
The Weekly Editorial
Our weekly commentary on SQL Server news and notes from the week ending 1/12/08.
2008-01-14
34 reads
A Little Variety
Do we really need to corner the market for our particular business? Steve Jones talks about the need to grow your business at the expense of others.
2008-01-10
46 reads
The Backup Myth
Running backups is enough for disaster recovery, right? That's a myth that could get you into trouble. Steve Jones explains there's more that's needed.
2008-01-09
935 reads
Losing Your Job
It's not easy to lose your job, but it can be done if you aren't performing. What concerns Steve Jones is someone recently lost their job for their behavior on their own personal time.
2008-01-08
295 reads
Myths
Every profession has its share of myths about how it works. IT might have more than its share and Steve Jones comments on a few of them.
2008-01-07
690 reads
College Life
Life at college is good. It's a time in many people's lives that they'll never forget. Steve Jones asks if you'd want to go back to your adult roots.
2008-01-04
195 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