We don't mean to introduce security issues, but sometimes we do because we give in to pressure.

Execution Plans and Data Protection

by Additional Articles

SimpleTalk

Execution Plans

One of the most important tools for query tuning is ability to view execution plans. They are even portable; you can send an execution plan to get advice from someone who doesn't have access to the underlying data. Have you even considered that sensitive information might travel along with the plans? Hugo Kornelis explains how execution plans affect data protection.

The CDO

by Steve Jones

SQLServerCentral.com

Editorial

Does your company have a Chief Data Officer? Steve Jones doesn't think you need one to use data wisely.

SQL Server Closure Tables

by Additional Articles

SimpleTalk

T-SQL

SQL Server has a couple of different ways to represent hierarchies, but they do not allow storing any additional information that is important to the relationship between objects. In this article, Phil Factor explains how to use closure tables to overcome this deficiency.

SQL Server 2008 Build List

by Steve Jones

SQLServerCentral.com

SQL Server 2008

The list of builds for SQL Server 2008 updated SP4.

SQL Server 2008 R2 Build List

by Steve Jones

SQLServerCentral.com

SQL Server 2008 R2

The list of builds for SQL Server 2008 R2 up to SP3.

SQL Server From .Net: Building a DataSet with Code

by Tim Wellman

SQLServerCentral.com

ADO.NET

A basic introduction for developers about working with the DataSet object in ADO.Net to represent objects in a SQL Server database, and some of the options available.