Denny Lee

Disk partition alignment is a powerful tool for improving SQL Server performance. Configuring optimal disk performance is often viewed as much art as science. A best practice that is essential yet often overlooked is disk partition alignment. Windows Server 2008 attempts to align new partitions out-of-the-box, yet disk partition alignment remains a relevant technology for [...]

Read Full Post »

For a great webcast on SQL Auditing, check out Database Security: Challenges & Solutions by Ayad Shammout, the Lead Technical DBA at Caregroup Healthcare (Harvard Hospitals) at http://www.brighttalk.com/webcasts/3755/attend   Description Organizations across the globe are being inundated with regulatory requirements.  They also have a storng need to better manage their IT systems to ensure they [...]

Read Full Post »

For all of you whom wanted to know about how to load data within SQL Server, please refer to the "Ultimate" SQL Data Loading Performance Guide at: http://sqlcat.com/whitepapers/archive/2009/02/15/the-data-loading-performance-guide-2008.aspx   This document described techniques for bulk loading large data sets into SQL Server. It covers both the available techniques as well as methodologies to performance tune [...]

Read Full Post »

For any and all of you who wanted to know more about how to upgrade to SQL Server 2008, here is THE ultimate guide: SQL Server 2008 Upgrade Technical Reference Guide.   Tonnes of great information – enjoy!!  

Read Full Post »

Organizations across the globe are being inundated with regulatory requirements. They also have a strong need to better manage their IT systems to ensure they are operating efficiently and staying secure. Microsoft is often asked to provide guidance and technology to assist organizations struggling with compliance. The SQL Server 2008 Compliance Guidance white paper was [...]

Read Full Post »

As you start playing with the features of SQL Server 2008, you realized that you will want to view your table, what indexes you applied on to it, the type of index (heap, clustered, nonclustered, etc.) as well as some key features of tihe index including uniqueness, fill factor, rows, and what type of data_compression [...]

Read Full Post »

Check out the latest technical note on the the many benefits of Money data type.  Admittedly, it’s one of my dorkier papers but hopefully you can enjoy it, eh?!  Check it out at: http://sqlcat.com/technicalnotes/archive/2008/09/25/the-many-benefits-of-money-data-type.aspx    

Read Full Post »