Category: SQL

SQL 2008 Best Practises Analyzer available

SQL Send feedback »
The SQL 2008 R2 Best Practises Analyzer (BPA) has been released and can be downloaded follwing this link: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591 This BPA works with both SQL 20… more »

Microsoft announces SQL Server 2008 R2 as RTM

SQL Send feedback »
  Microsoft just announced the RTM of SQL Server 2008 R2. Read more about it over here at the MS press pass. We will be able to use it in a few weeks time. more »

SQL Reporting services - Error Processing Resource

SQL Send feedback »
 While installing a SQL 2005 Reporting Services on a Windows 2003 machine today I got the following error:--------------------------------------------------------------------------------The XML page cannot be displayed Cannot view XML… more »

SQL 2008 Reporting Services Rendering PDF options on A4 paper size

Uncategorized, Windows 2008, SCOM, SQL Send feedback »
  Thanks to a question from one of my readers and some help from a Microsoft forum I updated my post on this topic based on SQL 2005 with the specifics for SQL 2008 as minor changes apply. Here is the post. Bob Cornelissen more »

SQL 2008 reporting on Windows 2008 authorization failed permissions insufficient

Windows 2008, SCOM, SQL, System Center Send feedback »
Was at a customer site a few days back and encountered a problem with SQL 2008 reporting services on windows 2008 r2. Installed the reporting services and checked http://localhost/reports and found that it did show me a page, but I seemed to miss the… more »

Failover Clustering Management Pack updated

Windows 2008, SCOM, SQL, Exchange, System Center 3 feedbacks »
  A fresh update to the Windows Failover Clustering Management Pack has been released. Some of the major updates in this release are Support for discovery and monitoring of Windows Server 2008 R2 clusters and functionality such as Cluster Shar… more »

Returning event 4000 on SQL Server 2008

SCOM, SQL Send feedback »
While looking at another problem at a customer location I found a returning 4000 event every 15 minutes with message GetSQL2008DBSpace.js : 0 on the SQL 2008 server there. At the MP Guide site I found the following: Every system with SQL Server 2008… more »

SQL CPU running at 100 percent on SCOM Reporting Server

SCOM, SQL 2 feedbacks »
Had an issue yesterday where a customer has an SQL instance on a cluster where the Operations Manager datawarehouse was hosted. Right after starting the SQL services all processors in the machine quickly rose to 100% CPU usage. It was impossible to even… more »

SQL Reporting Services Render PDF in A4 paper size instead of Letter

SCOM, SQL 17 feedbacks »
Everywhere I come to deploy SCOM a common question is to get lots of reports out of it. However after creating the reports and scheduling them for delivery it mostly stops. However as soon as somebody tries to print the reports the printers usually hang… more »
Contact. ©2010 by Bob Cornelissen. multiple blogs.
Design & icons by N.Design Studio. Skin by Tender Feelings / Evofactory.