I got a question from one of our UG member. He asked whether we can use SQL Server 2005 performance dashboard with SQL Server 2008. When we tried at the session we failed to implement it in SQL2K8. I was just thinking this today and planned to try this. I found out the reason why we failed to implement and what has changed in the query.
Monthly Archives: September 2009
Utilizing SQL 2005 Performance Dashboard in SQL Server 2008
Posted by Vidhya Sagar
on September 26, 2009
2 comments
Presenter – Chennai SQL Server User Group September Meeting
Posted by Vidhya Sagar
on September 25, 2009
1 comment
This month Chennai SQL Server User group (CSSUG) meeting was held on 19th September at Microsoft Campus, Chennai. It was a good experience meeting everyone and we had a nice time. I and Deepak Rangarajan are the presenters for CSSUG, we had the below sessions. We would like to thank each and every one of you for attending this meeting and making it a fun filled technical event. Read more »
Running Adhoc queries against multiple servers using SSMS 2008
Posted by Vidhya Sagar
on September 23, 2009
1 comment
Getting information from multi servers for a query is a big process for DBAs and we don’t have a direct option available till SQL 2008 Client tools. We need to write our own manual batch file to execute the query against all the server to fetch the information. In SQL Server 2008 management studio MS team has introduced this in SQL Server management studio 2008.
Script to find SQL Job activity details
Posted by Vidhya Sagar
on September 17, 2009
15 comments
I’ve written a script to find the job activity details, this script will give the output similar to job activity monitor in SQL2K5 or SQL2K8. In my working place we had a request to collect the job details from all the servers which includes all version of SQL Server. I’ve tried sp_help_jobactivity for SQL2K5 \ SQL2k8, however it doesn’t provide the columns needed. So I’ve written a script to get customized output, this script will also work with SQL2K. The script will fetch the following details Read more »
10 Minutes to configure Reporting Services 2008
Posted by Vidhya Sagar
on September 9, 2009
8 comments
In my previous webcast we have seen how to install reporting services 2008. Here is my next webcast on configuring reporting services 2008.