The Software Comparison - Part 3
Steve Jones takes another attempt at comparing software development to another profession. Today's target: doctors.
2008-06-03
44 reads
Articles
Tips for moving from local disk storage to SANs
Move SQL Server storage to storage area networks (SANs) with network redundancy and storage multipathing tips. Learn about iSCSI databases and SQL failover.
2008-06-03
4,514 reads
SQL Overview IV - DBA's Morning Review
Continuing on with his very popular series on monitoring your servers, David Bird takes a look at how you manage checking on multiple servers.
2008-06-02
13,426 reads
Optimistic Locking in SQL Server using the ROWVERSION Data Type
Using the default SQL Server READ COMMITTED isolation level, my application sometimes falls victim to the dreaded "lost update" condition where two of my users edit the same row for update but the user who submits his/her change last overwrites changes made by the other user. Is there a good way to check for this and prevent it?
2008-06-02
3,771 reads
Software Comparison - Part 2
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
2008-06-02
41 reads
Table-valued parameters – SQL Server 2008
In previous versions of SQL Server, it has not been possible to pass a table variable, as a parameter, to a stored procedure. Microsoft introduces table-valued parameters, along with other features, in SQL Server 2008. This article illustrates the function and usage of table-valued parameters.
2008-06-02
2,812 reads
The Software Comparison - Part 2
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
2008-06-02
39 reads
The Software Comparison - Part 2
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
2008-06-02
40 reads
Database Weekly - June 2, 2008
A look back at the news from the week including Windows 7 and taking an unwired vacation.
2008-06-01
45 reads
Database Weekly - June 2, 2008
A look back at the news from the week including Windows 7 and taking an unwired vacation.
2008-06-01
31 reads
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