Data Engineering – Learn from the experts
-
Activity Monitor
Activity monitor has been refreshed in SQL Server 2008 Management studio. Microsoft has recoded the activity monitor written for SQL 2005 to provide more information on SQL Server processes and how these processes affect the current instance of SQL Server. The first change which I experienced is the real time graphical view of processes, CPU…
-
Systray Utility to check SQL Server Service
I have developed this utility to monitor the instances of SQL Server running in a machine (i.e only standalone and not remote machines) and to send failure mail alerts upon service status. When I tried this type of systray utility in internet I could find only utilities that are monitoring the service and not sending…
-
Script to get row count for all the tables in all the databases
Ive written this script to get details of row count in all the tables in all the database including the system database. You can modify the script to exclude system database if you dont need details for that. You can see that I havent use COUNT() function to get these values, If I run using…
-
SQL PASS Trip Announcement for User Groups
We wanted to let you know Idera and MSSQLTips are sponsoring an all expenses paid trip from the continental United States to Seattle, Washington to attend the SQL PASS Community Summit in November 2009.
-
First CSSUG Meeting Details
We are happy to announce you that we have scheduled our first chennai sql server user group meeting. Details below Date: July 25th 2009 3PM till 530PM Venue: Microsoft Office Radhakrishnan Road Chennai
Got any recommendations?