2018-01-29
60 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
Why Haven’t You Upgraded SQL Server?
Kathi Kellenberger wonders what's keeping your business from upgrading.
2017-12-25
56 reads
Using LAST_VALUE
When I began using LAST_VALUE, the results were not what I expected at all. Read on to learn the secret!
2016-06-03 (first published: 2015-04-14)
26,403 reads
2015-04-27
1,836 reads
2015-04-15
1,936 reads
2015-04-03
1,887 reads
Many speaking engagements!
I have several speaking events coming up, and I would love to see you there!
First of all, I'll be...
2012-07-11
1,041 reads
Running a script on multiple servers
One of my favorite features of SQL Server Management Studio (SSMS) is the ability to run a script on multiple...
2012-03-02
2,573 reads
SQL Saturday #87 Report
I drove the over 250 miles from my home in Edwardsville, IL, to attend the SQL Server 87 in Louisville,...
2011-11-02
1,315 reads
PASS Summit, more people and lots of newbies!
Once again I am back at home recovering from another PASS Summit. This year the attendance has exceeded all expectations...
2011-10-16
1,390 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
Advanced Excel Mastery for Finance, Accounting & Payroll – 2025 Edition
Unlock the full potential of spreadsheets with our “Advanced Excel Mastery” course tailored for...
2025 Form 1099 Reporting Requirements: Essential 1099 NEC Updates
Prepare your team for the upcoming compliance shift with our “2025 Form 1099 Reporting...
The case for "Understanding our business" training
Comments posted to this topic are about the item The case for "Understanding our...
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