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 [...]
Archive for May, 2009
Disk Partition Alignment Best Practices for SQL Server
Posted in SQL, tagged Alignment, Disk, Partition on May 12, 2009 | Leave a Comment »
Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series)
Posted in Integration Services, tagged Design, Performance, Tuning on May 12, 2009 | Leave a Comment »
For all of those whom are interested in SSIS performance, we have posted a new SQL video series about how to design and tune your SSIS packages for performance. Measuring and Understanding the Performance of Your SSIS Packages in the Enterprise (SQL Server Video) Link | Watch this video Author: Denny Lee, Microsoft Corporation This [...]
Disk Partition Alignment Best Practices for SQL Server
Posted in SQL on May 11, 2009 | 83 Comments »
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 [...]
Designing and Tuning for Performance your SSIS packages in the Enterprise (SQL Video Series)
Posted in Integration Services on May 11, 2009 | 97 Comments »
For all of those whom are interested in SSIS performance, we have posted a new SQL video series about how to design and tune your SSIS packages for performance. Measuring and Understanding the Performance of Your SSIS Packages in the Enterprise (SQL Server Video) Link | Watch this video Author: Denny Lee, Microsoft Corporation This [...]
Webcast on SQL Auditing
Posted in Privacy, tagged Audit on May 6, 2009 | Leave a Comment »
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 [...]
Webcast on SQL Auditing
Posted in SQL on May 6, 2009 | 85 Comments »
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 [...]

