Installing the FILESTREAM blob store failed with error message

“Installing the FILESTREAM blob store failed with error message: Access to the registry key ‘HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Remote Blob Storage’ is denied. Setup will continue the installation”     The reason your getting this message because of Disable User Account Control (UAC) Open your Control Panel in Windows 2008 Server and type in UAC   Change your UACContinue reading “Installing the FILESTREAM blob store failed with error message”

SQL Server Virtual Labs

Where to find SQL Server 2008 Virtual Labs? You can find SQL Server Virtual labs at : SQL Server Virtual Labs Microsoft SQL Server 2008 Virtual Labs Test drive Microsoft SQL Server 2008 in a virtual lab. See why SQL Server 2008 is at the heart of a comprehensive data programmability platform that enables youContinue reading “SQL Server Virtual Labs”

Best practices for SQL Server 2008 in a SharePoint 2010 farm

How to optimize SQL Server 2008 to get best performance for SharePoint 2010 farm? Reference: 1. Use a dedicated server for SQL Server 2008 2. Configure specific SQL Server 2008 settings before you deploy SharePoint Server 2010 – Do not enable auto-create statistics on a SQL Server that is supporting SharePoint Server – SetContinue reading “Best practices for SQL Server 2008 in a SharePoint 2010 farm”

Download SQL Server 2008 Service Pack 3

Overview  : Download SQL Server 2008 Services Pack 3 Microsoft SQL Server 2008 Service Pack 3 (SP3) is now available for download. While keeping product changes contained, we have made significant investments to ease deployment and management of Service Packs. A few key enhancements for customers in Microsoft SQL Server 2008 Service Pack 3 areContinue reading “Download SQL Server 2008 Service Pack 3”

Checking SQL Server current process

What’s currently going on on the SQL Server, who is executing which query or fetches a few thousands of rows and slowing down the server with it? With this Transact-SQL script you can list all processes with their SQL statements. Additional you get the cummulative values of IO / CPU usage and the row countContinue reading “Checking SQL Server current process”