Comparing Files from Different Folders Using SQL Server and XML
Sometimes there is a need to process files in a folder, but first you need to determine which files need to be processed compared to older files that have already been processed. There are several ways that this can be done, but in this tip I show you a way this can be done using SQL Server and XML.
Peer-to-Peer Replication in SQL Server 2008 – Add a node and resolve conflict
Add a third node to a two-node Peer-to-Peer replication topology and learn how to resolve an update-update conflict.
What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005?
Question: What mechanism allows SQL Server 2008 to commit transactions on the mirror faster than SQL Server 2005? This question was asked on a technical discussion group. My reply follows.
Imaginative Auditing with Rollback (Undo) and RollForward (Redo) Part II
Continuing with his series on using auditing information to roll transactions forward or back, David McKinney shows us how to generate audit triggers using XML.
June Triangle SQL Server User Group
The June meeting of the Triangle SQL Server User group features MVP Andy Leonard. If you are in the Raleigh area, check this out.
Staring you in the Face
Tools expand, some might say bloat, at an alarming rate and it's often the case that, in amongst all the clutter, the most valuable features somehow elude us.
Giving Your Best
It's easy to get into a rut at work, and easy to just attempt to get some minimum amount of work done each day. Steve Jones is inspired today to think about doing more.
Giving Your Best
It's easy to get into a rut at work, and easy to just attempt to get some minimum amount of work done each day. Steve Jones is inspired today to think about doing more.
Giving Your Best
It's easy to get into a rut at work, and easy to just attempt to get some minimum amount of work done each day. Steve Jones is inspired today to think about doing more.
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