December 2008 - Posts

SQL Server 2005 SP3 - Shipped
18 December 08 07:10 AM | Steve Carroll | 0 Comments   

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 Read More...

Filed under: Announcement, SQL Server 2005, Patches, SP3

SQL Server 2008 Upgrade Information
10 December 08 09:06 AM | Steve Carroll | 0 Comments   

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 Read More...

Filed under: SQL Server 2008, SQL Server 2005, Best Practices

Security Guidance for SQL Server
05 December 08 08:48 AM | Steve Carroll | 0 Comments   

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 Read More...

Filed under: SQL Server 2005, Security

Security Features in SQL Server 2008
04 December 08 11:30 AM | Steve Carroll | 0 Comments   

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 Read More...

Filed under: SQL Server 2008, Security