After much waiting and grumbling from the SQL Server community, the much anticipated service pack 3 for SQL Server 2005 shipped on 12/15/08. Finally we have a single avenue to apply all of our rollup packages that is fully regression tested. I've been...

I came across a fantastic piece of information for those who are looking to upgrade their existing SQL Server 2000 or 2005 instances to SQL Server 2008. I know from past experience that it is no fun flying into this type of upgrade blind so this is a...

In my eager attempt yesterday to post my findings on SQL Server 2008 great new security features (read more here ) I neglected to provide some valuable security information I have accumulated over the last couple of years for the other editions of SQL...

As most DBA's are aware, applications sometimes store sensitive information. This may be Social Security numbers, credit card information, salary information... and data owners have a concern that prying eyes may be reviewing this sensitive data without...