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 and optimize the bulk loading process. Enjoy!
The final technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments technical note series on Reporting Services Performance Optimization has just been published at Reporting Services Performance Optimization. This technical note provides guidance on the reasons to use 64-bit, how to handle large workloads, Monitoring Reporting Services (which includes a link to a sample SSRS project to view the ExecutionLog2 view), and Memory Configurations. Enjoy!
An excellent blog explaining the ExecutionLog2 view within Reporting Services has been written by Robert Bruckner at: http://blogs.msdn.com/robertbruckner/archive/2009/01/05/executionlog2-view.aspx Quoted from Robert: Before you can optimize particular reports or your entire system, you need metrics and understand what they tell you. In this posting, I want to focus on how to effectively interpret and utilize the data present in the new ExecutionLog2 view in the Reporting Services 2008 catalog database.
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!!
With the release of the SQL Server 2008 Analysis Services, there is the new and improved version of the Usage-based Optimization algorithm. The best practices and recommendations to use this feature can be found out this recently published technical note Reintroducing Usage-Based Optimization in SQL Server 2008 Analysis Services. Enjoy!
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 written to help organizations and individuals understand how to use the features of the Microsoft® SQL Server® 2008 database software to address their compliance needs. This paper serves as an accompaniment to the SQL Server 2008 compliance software development kit (SDK), which provides sample code…
Check out my Technet webcast on Building SQL Server Reporting Services 2008 Large-Scale Solutions. In this webcast, you learn about successful configuration and architecture principles to maximize the scalability of your enterprise Microsoft SQL Server 2008 Reporting Services (SSRS) environment. Join us as we provide you details, based on real customer scenarios, on how to make the most of your SSRS 2008 environment. Have fun!
Check out the the third of five technical note as part of the Building and Deploying Large Scale SQL Server Reporting Services Environments Technical Note Series: Reporting Services Scale-Out Deployment Best Practices This technical note reviews the SSRS Scale-Out Architecture Report Catalog sizing The benefits of File System snapshots for SSRS 2005 Why File System snapshots may not help for SSRS 2008 Using Cache Execution Load Balancing your Network Isolate your workloads Report Data Performance Considerations Enjoy!