Steve Jones takes another attempt at comparing software development to another profession. Today's target: doctors.

XML Workshop XX - Generating an RSS 2.0 Feed with TSQL(SQL server 2000)

by Jacob Sebastian

SQLServerCentral.com

SQL Server MVP Jacob Sebastian continues his very successful XML series with a foray into SQL Server 2000's XML capabilities for generating custom documents.

How do I ... reject alpha characters in a SQL Server character column?

by Additional Articles

Builder.com

T-SQL

Enforcing your data's integrity is probably the single most important issue you face when designing a database. Validating user input is one way of keeping bad data from making its way into your analyses and reports.

Identity Columns

by Additional Articles

SimpleTalk

T-SQL

When Nigel Rivett takes us on a tour of the apparently innocuous subject of Identity Columns in TSQL, even the seasoned programmer is due for one or two surprises.

Software Comparison - Part 2

by Steve Jones

SQLServerCentral.com

Editorial

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

Sync All Logins on a Server in a single click using SP_MSForEachDB

by Ken

SQLServerCentral.com

Log Shipping

Reduce your recovery time and minimize the chance for error by resolving all logins in one script.

Intelligence on the Go: Mobile Delivery of BI

by Additional Articles

Intelligent Enterprise

Business Intelligence

Many BI vendors now offer modules that let you deliver just about any report to smart phones, but as a major retailer, a health care provider and a major government agency have discovered, practical, tactical wins are the key to mobile success.