Muthusamy Anantha Kumar

In a large IT department, it can be difficult to locate where new SQL Server installations were made and how many of those SQL Servers were patched, etc. This article explains how to scan the entire network to find which boxes have SQL Server instances running and how to identify what version they are. Pre-requisite […]

When we create a backup maintenance plan with one Full backup and transaction log backups for every 15 minutes, it is sometimes necessary to restore the FULL backup and all the corresponding transactional backups sequentially. This may happen if the production box goes down or if you want to have the same database restored to […]

In a large organization, it can be difficult to find active and inactive machines as well as machines that are not used anymore. This article provides a basic guideline to query the Active Directory and ping all the machines on the network, in order to find all active and inactive machines on the network. Step […]

The objective of this article is to analyze and understand how SQL Server uses Binary digits for categorizing and how to query such categorized binary numbers to produce detailed results. What is Bit? Bit is the short form for binary digit. What is Binary? Binary is a base 2 numbering system. A binary notation consists […]

SQL Server developers and database architects often find they have a need to sequence query results or generate a cumulative sum for a group of rows in a table. SQL Server does not have a Pseudo row-id similar to other RDBMS. In this article, I am going to guide the developers and database architects to […]

Whenever database administrators begin new jobs or to administer and manage new SQL servers, the first step is to take inventory of the server. This includes information like Operating system, Service packs, physical memory, virtual memory etc. In this article, I explain how to collect such information using VB Script and WMI. Pre-requisite Microsoft Windows […]

In the previous article, we discussed how to implement SQL production changes to multiple databases on the same server. In part two we will discuss implementing SQL changes to multiple databases on more than one server. The following steps explain how to apply similar changes to multiple databases on more than one server. Pre-requisites You […]

In certain environments, there will be multiple databases with the same structure. When Database Administrators make the same kind of changes or production releases on those databases it is tedious to open different windows in Query analyzer. In addition, it is tedious to open different query analyzers and apply changes. This article guides the database […]

It is imperative to have monitoring tools to monitor the services running in a windows operating system based server. However, small shops do not have that kind of budget to get tools for monitoring. Data Base Administrators should be notified as soon as one of the SQL Server services is stopped, restarted or not responding. […]

It is very important for SQL Server Database Administrators to monitor the database growth on all of the SQL Server boxes. By monitoring such growth, the database administrator can take pro-active actions such as increasing the volumes, moving the .mdf, .ndf and .ldf to different locations and estimating the growth of the database so that […]

SQL Server Data Base Administrators are often exposed to situations in running ad-hoc queries using external data sources such as MS-Access database or Excel sheets or CSV files or text files. For such frequent requests, Database Administrators usually use “linked servers” covered in my previous article, Linking SQL Server to Heterogeneous Systems. However, for in-frequent […]

In the typical IT environment, it is often necessary to import flat files to SQL Server tables. Sometimes it is necessary to import many files at the same time from same or different folders. In my previous article, I mentioned how to import such files using BULK Insert and BCP utility. In this article, I […]