Failed to provision the SharePoint Central Administration Web Application

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…

Rate this:

The Ultimate SQL Data Loading Performance Guide

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!  

Rate this:

Reporting Services Performance Optimization

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!    

Rate this:

ExecutionLog2 View – Analyzing and Optimizing Reports

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.     

Rate this:

Reintroducing Usage-Based Optimization in SQL Server 2008 Analysis Services

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!  

Rate this:

Reaching Compliance: SQL Server 2008 Compliance Guide

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…

Rate this: