This article describes how the Transparent Data Encryption feature in SQL Server 2008 can be used to secure your databases

Best Practices for Database Design

by J.D. Gonzalez

SQLServerCentral.com

Naming Standards

One of the few things that SQL Server does not automatically help you with is the design of your tales, views, and other database objects. Having standards and design techniques can greatly ease the maintenance of your schema as well as ease the transition to having others work with the database. New author J.D. Gonzalez brings us some of his naming techniques to keep things organized.

Startup Weekend in Ann Arbor, MI, June 20-22

by Ted-Manasa

SQLServerCentral.com

User Groups

Calling all developers! Does the idea of going from a concept to a prototype in a 54 hour marathon weekend of design and coding sound fun to you? If so, join us!

The Core

by Steve Jones

SQLServerCentral.com

Editorial

This Friday Steve Jones has a poll about core DBA skills.

Defining cascading referential integrity constraints in SQL Server

by Additional Articles

Builder.com

By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point.

Introduction to XQuery in SQL Server 2005

by Additional Articles

TechNet Blogs

This white paper provides an introduction to various features of XQuery implemented in SQL Server 2005 such as the FLWOR statement, operators in XQuery, if-then-else construct, XML constructors, built-in XQuery functions, type casting operators, and examples of how to use each of these features.