Who's At Fault
Who do you blame when software fails? Hopefully you don't hire a lawyer before you do. Steve Jones talks about liability and software.
Random problems
Building random numbers can be challenging for people working in T-SQL. New author Chris Nowicki brings a solution he used to get a random number assigned to each row of a result set.
Support Your Local SQL Server User’s Group
Are user groups dying out in the age of the Internet? It seemed that way for awhile, but Brad McGehee gives some reasons why you should think about attending a meeting.
Dynamic SQL execution on remote SQL Server using EXEC AT
In this tip I am going to start my brief discussion with OPENQUERY and OPENROWSET table functions, its limitation and how the new EXEC AT command overcomes them.
Facts and Fallacies about First Normal Form
When discussing the normalisation process, it is always the First Normal Form that causes the most grief and confusion. Anith Sen takes up the challenge to explain, in simple terms, exactly what the First Normal Form really is, and why it is so important for Database Design. Along the way, he dispels some of the myths that have grown up around 1NF.
Mining for Quitters
Google is trying to figure out who might quit the company, using their own custom application. Steve Jones thinks this is a great idea and wishes more companies would do it.
Mining for Quitters
Google is trying to figure out who might quit the company, using their own custom application. Steve Jones thinks this is a great idea and wishes more companies would do it.
Mining for Quitters
Google is trying to figure out who might quit the company, using their own custom application. Steve Jones thinks this is a great idea and wishes more companies would do it.
SQL Server Encryption - Hashing Collisions
A hash is a computation that transforms one set of data into another (hopefully smaller) set of data. So a hash on your 2,000 character blog post should generate a smaller, 10-20 byte value. In doing that, obviously there are many more possible 2,000...
Best of SQLServerCentral, Volume 5
Best of SQLServerCentral vol 5 pulls together some of the best contributions to SQLServerCentral.com in 2007.
Blogs
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Self-Hosting a Photo Server the Whole Family Can Use
By Bert Wagner
Until recently, my family's 90,000+ photos have been hidden away in the depths of...
Forums
Happy Holidays, Let's Do Nerdy Stuff
Comments posted to this topic are about the item Happy Holidays, Let's Do Nerdy...
UNISTR Escape
Comments posted to this topic are about the item UNISTR Escape
Celebrating Tomorrow
Comments posted to this topic are about the item Celebrating Tomorrow
Question of the Day
UNISTR Escape
In SQL Server 2025, I run this command:
SELECT UNISTR('*3041*308A*304C\3068 and good night', '*') as "A Classic";
What is returned? (assume the database has an appropriate collation)
A: 
B: 
C: 
See possible answers