Midlands PASS May Meeting
The Midlands PASS Chapter will be meeting next Thursday night, May 7, at Training Concepts. We have the privilege of welcoming...
2009-04-30
1,412 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Speaking / Teaching Engagements in May
May 21
I will be teaching a half day course on SQL Server security and auditing for the Midlands Chapter of...
2009-04-30
1,521 reads
The #1 Secret to Building Your Skill Set is...
Self-Discipline
Yes, I've said it: self-discipline.
I'm reading a book called Disciplines of a Godly Man by R. Kent Hughes. Now...
2009-04-29
1,978 reads
Security Basics: Defense-in-Depth
In my security presentations, another basic I talk about is defense-in-depth. The idea here is to produce multiple layers of...
2009-04-28
4,236 reads
SQL Quiz 4: Leadership
I'm finally getting around to answering this one originated by Chris Shaw (@SQLShaw), as I was tagged by Jack Corbett...
2009-04-27
727 reads
Security Basics - The C-I-A Triad
In the course of giving my security presentations over the past year, I've learned that quite a few folks have never seen the C-I-A triad before. The C-I-A triad stands for...
2009-04-27
4,580 reads
Patterns & Practices SIG starting up in Columbia, SC
C# MVP Chris Eargle (@kodefuguru on Twitter), who is also an INETA community champion and president of the Columbia Enterprise...
2009-04-24
1,005 reads
SQL Server Security Basics: Why Would I Use SQL Server Authentication?
The standard best practice answer when it comes to connecting to SQL Server is to use Windows authentication. However, SQL...
2009-04-24
3,804 reads
Simple Maintenance Tasks for Non-Production Databases
Log File Sizes:
It's not unusual to see cases where database backups are taken from production and restored to a development or QA environment....
2009-04-23
1,340 reads
Catalog View: sys.sql_logins
When it comes to logins to SQL Server, there are basically 3 types:
SQL Server-based loginsWindows user accountsWindows security groupsThe latter...
2009-04-22
6,929 reads
Blogs
Post-quantum key exchange – Insurance policy for your packets
AWS recently added support for Post-Quantum Key Exchange for TLS in Application Load Balancer...
Plan your 2026
By Brian Kelley
If you don't have a plan, you'll accomplish it. That's not a good thing.
Another Change
By Steve Jones
Today Redgate announced that we are partnering with Bregal Sagemount, a growth-focused private equity...
Forums
Where Your Value Separates You from Others
Comments posted to this topic are about the item Where Your Value Separates You...
Fixing the Error
Comments posted to this topic are about the item Fixing the Error
T-SQL in SQL Server 2025: Encoding Functions
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Fixing the Error
On SQL Server 2025, I have a database that has this collation: SQL_Latin1_General_CP1_CI_AS. I decide I want to run this code:
SELECT UNISTR('*3041*308A*304C*3068 and good night', '*') AS 'A Classic';
I get this error:Msg 9844, Level 16, State 4, Line 24 The char/varchar input type uses an unsupported collation. Only a UTF8 collation is supported with char/varchar input type in UNISTR function.What is the easiest way to fix this error? See possible answers