SQL Server articles for System Center: SCOM databases, data warehouse, reporting with SSRS, performance and maintenance tips. Keep your SQL back end healthy.
One nice gem from Steve Rachui’s blog is a trick on how to simply troubleshoot remote SQL connections.
Just create an empty txt file anywhere on the disk and give it an UDL extension and click it. You will see a tool popping up with several tabs. on t…
SQL Server 2005 Service Pack 4 has just been released a few days ago.
You can download files here:
The SQL 2005 SP4 Readme file
Download SQLServer2005SP4-KB2463332-x64-ENU.exe for X64
Download SQLServer2005SP4-KB2463332-x86-ENU.exe for X86
Downloa…
I get asked a lot for performance reporting for large groups of servers (with changing memberships). The problem that people face with this is that it usually involves an initial very big list of machines and it takes a lot of time to build this. Also if…
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…
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.
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…
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
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…
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…
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…