This editorial was originally published on Feb 19, 2006. We are reprinting pieces this week as Steve is traveling in the UK.

Raw Materials - Green Enterprise

by Larry Gonick

SQLServerCentral.com

Comic Strip

How to Profit from saving the world, or not

Second Normal Form

by Tom Thomson

SQLServerCentral.com

Normalization

In this article Tom Thomson takes a look at what second normal form means, how it is violated, and how you can fix it. This is part of our normalization series.

Identifying PII Data to Lock Down in SQL Server - Part 1

by Additional Articles

MSSQLTips.com

Security

We're pretty confident that we have locked down and encrypted our financial data, but a lot of our customer's PII (Personally Identifiable Information) data is still held in unencrypted form. This data is able to be selected directly by read only business users on many of our downstream reporting, datawarehouse and standby servers. The rise of identity theft makes protecting this data imperative. DBAs are the custodians of this information and must protect it like we protect our own personal information. Recent publicity over the theft of Sony PSN data underscores both the economic and ethical importance of protecting personal data.

Here's a Reason to Document

by Steve Jones

SQLServerCentral.com

Editorial

This editorial was originally published on Feb 17, 2006. Steve is traveling in the UK this week and we are re-printing some old pieces. This one talks about a search engine for code.

Questions About SQL Server Distribution Statistics

by Additional Articles

SimpleTalk

T-SQL

Fabiano Amorim was asked a couple of questions about SQL Server Distribution Statistics. Having given an answer based on his current knowledge, he then decided to find out for himself whether what he'd said was right, and started an epic journey of exploration into Distribution Statistics and the way that the Query Optimiser uses them.

Bad Eyes

by Steve Jones

SQLServerCentral.com

Editorial

This editorial was originally published on Jan 9, 2006. Steve is traveling to the UK this week and we are reprinting a few older editorials. This editorial talks about the health of your eyes, a topic of concern for those of us that work with computers regularly.