Excellent article on SQL Server 2005 Common Table Expressions
SQL Server MVP Nigel Rivett has written an excellent article on Common Table Expressions on Red Gate Software's Simple Talk...
2006-08-02
753 reads
SQL Server MVP Nigel Rivett has written an excellent article on Common Table Expressions on Red Gate Software's Simple Talk...
2006-08-02
753 reads
I saw this post on using Fiddler to tell the difference between an NTLM and a Kerberos connection to a...
2006-08-02
4,551 reads
This is a follow-on to Does your organization need a DBA? and Andy Leonard's Database Professionals: An Enterprise Requirement.
I was...
2006-08-01
692 reads
Andy Leonard pens the following blog entry:
Database Professionals: An Enterprise Requirement
There are quite a few organizations that feel they can...
2006-07-30
1,535 reads
Encrypting File System, or EFS, first debuted in Windows 2000 and gave
users to encrypt files without a 3rd party tool....
2006-07-30
1,585 reads
There is a new post in the SQL Server Express blog which indicates the
right way to detect SQL Server 2005:...
2006-07-29
1,473 reads
There is a new site for SQL Server blogs, SQLBlog.com. "Brought to you by Peter DeBetta & Adam Machanic," it has...
2006-07-29
1,316 reads
If you're keeping up with Windows Vista and you're interested in the
security aspects of it, there's a new blog, with...
2006-07-29
1,389 reads
Perl has been a popular language for Unix administrators for years. It is flexible, easy to learn, and capable of doing some very powerful things with relatively few lines of code. In this article by Brian Kelly, he shows you how to connect to SQL Server via Perl.
2006-07-28 (first published: 2002-12-03)
42,246 reads
Haidong Ji, co-author of Professional SQL Server 2005 Integration Services, blogged on Learning Perl using the Perl Debugger. Haidong posts...
2006-07-27
1,590 reads
By Andy Warren
Somehow two years have elapsed since my last update; hopefully it won’t be that...
By Steve Jones
If someone is trying to convince you it’s not a pyramid scheme, it’s a...
By Steve Jones
I was looking back at my year and decided to see if SQL Prompt...
Hi experts, I have a 3+ TB database on a 2019 sql server which...
Comments posted to this topic are about the item The North Star for the...
Comments posted to this topic are about the item Multiple Escape Characters
In SQL Server 2025, I run this code (in a database with the appropriate collation):
SELECT UNISTR('%*3041%*308A%*304C%*3068 and good night', '%*') AS 'A Classic';
What is returned? See possible answers