Muthusamy Anantha Kumar

WHERE ID = OBJECT_ID(N’[DBO].[USP_BAKZIP2]’) SET QUOTED_IDENTIFIER OFF GO USE MASTER GO IF EXISTS (SELECT * FROM DBO.SYSOBJECTS WHERE ID = OBJECT_ID(N’[DBO].[USP_UNZIP]’) AND OBJECTPROPERTY(ID, N’ISPROCEDURE’) = 1) DROP PROCEDURE [DBO].[USP_UNZIP] GO CREATE PROCEDURE USP_UNZIP @ZIPFILE VARCHAR(2000), @BAKPATH VARCHAR(1000) AS –CREATED BY : MAK –CREATED DATE : OCT 12, 2005 –OBJECTIVE: UNZIP THE GIVE ZIPPED FILE TO […]

SQL Server Database Administrators often run out of space due to huge backup files that have been retained on the disk. This article illustrates how to take full and transaction log backups and compress the backup files using the reasonably priced WinZip. Step 1 Install the WinZip software on the SQL Server machine. [Refer Fig […]

Usually SQL Server database administrators use the feature “Auto Growth” in the database configuration, in order allows automatic file growth when the database tries to expand. Though it is a good feature, sometimes SQL Server runs out of hard disk space. This article illustrates how to set up email notification when SQL Server is running […]

We all know the “TOP” clause returns the first n number of rows or percentage of rows thereby limiting the number of resulting rows displayed when we are selecting rows in a table. SQL Server 2005 is packed with new features and enhancements. One of the enhancements in SQL 2005 that we are going to […]

SQL Server Database administrators often generate SQL Statements and execute the generated SQL statement in order to simplify certain tasks. It has always been a twin operation. This article illustrates how to use un-documented stored procedures to execute the generated SQL Statements directly. Example 1 The following example generates a SQL statement to find the […]

SQL Server 2005 is packed with many new features. One of the new features that I would like to discuss in this article is Database Snapshots, which are read only static views of a database. SQL Server 2005 allows you to create multiple snapshots on a database. In this article, I would like to demonstrate […]

Microsoft introduces new operators PIVOT and UNPIVOT in SQL Server 2005. Traditionally we create queries using the CASE statement and aggregate function in order to produce cross-tab reports. This article illustrates the usage of the new operators, PIVOT and UNPIVOT. Let us assume that we have a table as described below. [Refer Fig 1.0] Create […]

When Database Administrators manage multiple databases on multiple servers, it is difficult to keep track of and monitor the used percentage of data portion on every database. Though SQL Server has the capability of auto growth whenever the data portion reaches 100%, it is always advisable to increase the database size manually when it comes […]

In order to satisfy the demands of General-Controls review by public auditors and regulatory agencies, companies should monitor the security events of every production system they have. This article illustrates how to use Microsoft Logparser 2.2, Job Scheduler and SQL Server database to monitor the event logs, and extract Monthly, Weekly Low security event reports […]

Occasionally, SQL Server database administrators are requested to provide a list of development SQL Servers, production SQL Servers and so on. Many articles, such as "Monitor Disk Space on Multiple SQL Servers" and "Inventorying hardware and OS information on all SQL Servers" require a list of servers in a text file. Usually Database administrators do […]

This article illustrates how to monitor the CPU load on SQL Server and Windows machines using Windows Management Instrumentation and VBScript to collect data in the Round Robin database and then produce graphs using the Round Robin Tool. Usually SNMP is used to monitor and analyze CPU loads. This article illustrates how to obtain CPU […]

SQL Server job schedule configuration is limited to a one-time occurrence: daily, monthly and weekly. [Refer Fig 1.0] There are many occasions when you need to run a job on certain dates in a year. Many Finance and pharmaceuticals companies have End of Month processing, End of Week processing, etc. where batch jobs need to […]