Muthusamy Anantha Kumar

In a 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 the same or different folders. In this article, I am going to discuss how to import all of the files from a particular folder to […]

SQL Server Database administrators often come across situations where the scheduled DTS jobs failed because the Source File didn’t arrive on time. It is a tedious process to cleanup if there are dependent jobs that have run before the first DTS job completed successfully. The intent of this article is to provide a solution for […]

Learn how to explore any Internet web page and store partial or complete information to either an HTML file or Microsoft SQL server table. This article provides a guide on how to explore any Internet web page and store partial or complete information to either an HTML file or Microsoft SQL server table. In addition, […]

DTS is a set of graphical tools and programmable objects that let you extract, transform, and consolidate data from disparate sources into single or multiple destinations that can be bundled and saved as a package and executed. In large organizations, it is a usual practice to keep, schedule and execute all of the DTS packages […]

In the typical IT department, an un-avoidable task is to monitor the Event Log on all of the servers. It is tedious to go through all the logs one by one, on a daily basis. In this article, the methods presented will help in monitoring the Event Viewer on many servers from a single place. […]

What is collation? Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width. Case sensitivity If A and a, B and b, etc. are treated […]