In this situation, I ended up getting the error message: Failed to provision the SharePoint Central Administration Web Application My setup is a Windows Server 2008 Enteprise x64 box with SQL Server 2008 – attempting to configure my recently installed SharePoint 2007. That should have done the trick but I ended up getting the above error message anyways. After some additional research, it became apparent that my IIS 7.0 installation was incorrect. And once I fixed that, I was good to go. So thanks to Jonas Nilsson on the linked thread below for identifying that IIS was the…
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…