Data Engineering – Learn from the experts

  • Running Adhoc queries against multiple servers using SSMS 2008

    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…

  • Script to find SQL Job activity details

    Ive 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. Ive tried sp_help_jobactivity for SQL2K5 SQL2k8,…

  • September 2009 Month Meeting Scheduled

    We are back again for this months UG session. We have a slight change in timing for this week UG due to non-availability of conference room at our usual timings. Venue: Microsoft Training centre, Radhakrishnan Salai Landmark: Opposite to President hotel Timings: 9:30AM to 12:30PM Date: September 19th 2009

  • Ten Minutes to configure Reporting Services 2008

    In my previous webcast we have seen how to install reporting services 2008. Here is my next webcast on configuring reporting services 2008.

  • August Month Meeting Presentation Materials

    The Chennai SQL Server UG for the month of August was held on 22nd of this month, refer this link for the details. It was a great learning experience and a good space for SQL networking. There were two sessions.

Got any recommendations?