Include Column Headers From SSMS

by Ken

SQLServerCentral.com

SQL Server 2005

Save time when copying data from SSMS to Excel by configuring the options to Include Column Headers.

Compound Assignment Operators in SQL Server 2008

by Additional Articles

Database Journal

T-SQL

MAK illustrates the use of Compound Assignment Operator that is introduced in SQL Server 2008.

Introduction to the Unified Dimensional Model (UDM)

by Additional Articles

TechNet Blogs

This paper provides an introduction to the Unified Dimensional Model (UDM), including the basic end-user model, and a brief overview of the architecture and security models.

TechEd - Day 2

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones editorializing from TechEd in Orlando on Day 2.

What do you do with a new SQL Server?

by Carolyn Richardson

SQLServerCentral.com

alerts

This article highlights some basic steps to take when you have a new install of SQL Server or take over support of existing databases.

Close these Loopholes - Reproduce Database Errors

by Additional Articles

SimpleTalk

Testing

This is the final part of Alex's ground-breaking series on unit-testing Transact-SQL code. Here, he shows how you can test the way that your application handles database-related errors such as constraint-violations or deadlocks. With a properly-constructed test-harness you can ensure that the end-user need never see the apparent gobbledegook of database system error messages, and that they are properly and robustly handled by the application.

Security Overview for Database Administrators

by Additional Articles

Microsoft MSDN

SQL Server 2008

SQL Server 2008 is secure by design, default, and deployment. Microsoft is committed to communicating information about threats, countermeasures, and security enhancements as necessary to keep your data as secure as possible. This paper covers some of the most important security features in SQL Server 2008. It tells you how, as an administrator, you can install SQL Server securely and keep it that way, even as applications and users make use of the data stored within.