2005-12-13
2,191 reads
Kathi Kellenberger
- Interests: Walking, running, grandchildren!
2005-11-30
2,286 reads
Get MAXimum functionality
SQL 2005 provides a the new max specifier to be used with varbinary, varchar and nvarchar data types. You can...
2005-11-12
1,283 reads
SQL Diagnostic Manager Review
SQL Diagnostic Manager from Idera is a great tool for troubleshooting issues with your SQL Server databases. Kathi Kellenberher puts this tool through it's paces and gives you some insight into how it fits in a busy SQL Server environment.
2005-11-08
16,142 reads
On vacation!
It was busy at work after returning from PASS which means my work day continued for 2 or 3 hours after I got...
2005-10-16
1,283 reads
Something About Nothing: NULL
You wouldn’t think that “nothing” would cause so many problems. But seriously, understanding how to correctly use NULLs is a...
2005-10-16
1,384 reads
Using the sa account -- Just say "NO!"
Aunt Kathi knows many of you do things you know are wrong, like rolling through stop signs, littering, and using the sa...
2005-10-04
1,301 reads
Thoughts about the future
So far my posts have been non-technical musings about my life outside of work. I guess it is time to...
2005-10-03
1,241 reads
Back home after PASS
The past week at PASS was more informative and fun than I could ever have imagined. By getting involved in the...
2005-10-01
1,284 reads
Thinking about PASS
With PASS just a little over a week away, I realized that I had better fine-tune my presentation and practice...
2005-09-18
1,301 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
Best way to log Data Flow errors in SSIS 2005?
Hi everyone, I’m working with some old SSIS 2005 packages, and I’m trying to...
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...
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