Continuing on with his very popular series on monitoring your servers, David Bird takes a look at how you manage checking on multiple servers.

The Software Comparison

by Steve Jones

SQLServerCentral.com

Editorial

Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.

Optimistic Locking in SQL Server using the ROWVERSION Data Type

by Additional Articles

MSSQLTips.com

Locking

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?

Software Comparison - Part 2

by Steve Jones

SQLServerCentral.com

Editorial - MP3

The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.

Table-valued parameters – SQL Server 2008

by Additional Articles

Database Journal

Table Valued Parameters (TVP)

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.