dcsimg
Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
SQL Scripts & Samples
Tips
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  

By submitting your information, you agree that databasejournal.com may send you databasejournal offers via email, phone and text message, as well as email offers about other products and services that databasejournal believes may be of interest to you. databasejournal will process your information in accordance with the Quinstreet Privacy Policy.
News Via RSS Feed
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Posted Jan 16, 2004

Muthusamy Anantha Kumar aka The MAK

By DatabaseJournal.com Staff

mak@mssqlengineering.com

Muthusamy Anantha Kumar, a.k.a. MAK, is a Microsoft Certified IT Professional - Database Administrator ( (MCITP: Database Administrator). He has more than 10 years of experience in Information Technology including database Administration, System Analysis, Design, Development and Support of MS SQL Server 2005/2000/7.0/6.5/6.0/4.X for production/development/testing.

He is experienced in MS SQL Server Engineering, installation, configuration, performance tuning, client/server connectivity, query optimization, back-up/recovery. He has handled VLDBs and been involved in SDLC of various data warehouse projects. Currently, MAK is Senior Database Engineer responsible for Engineering and standardizing Microsoft SQL Servers in one of the big finance companies on Wall Street.

Previously, he was a Senior Database Administrator/Data Architect, responsible for development, test, DR and production servers for many finance, .com and B2B companies. He plays an active role in forums as a SQL Expert and moderator.

MAK has written a Wrox book titled “Microsoft SQL Server 2008 Administration with Windows PowerShell” with Yan Pan, who is also a columnist for DatabaseJournal.com.

Article Series

Auditing in SQL Server 2008
SQL Server 2008 : Accessing Audit Details
Configuring Granular Settings for a Database Level Audit
Database Level Auditing with Microsoft SQL Server 2008
Creating a Server Level Audit the Easy Way
Auditing made easy by Microsoft SQL Server 2008

Working with .MDF and .LDF files in SQL Server 2008
Attaching .MDF files and .LDF files of a database with FileGroups
Rebuilding the log when attaching multiple .MDF files
How to handle multiple .MDF files and .LDF files in SQL Server 2008
Attaching a database in Microsoft SQL Server 2008

Database Mirroring in SQL Server 2008
Database Mirroring Using T-SQL
How data is mirrored
Database Mirroring in SQL Server 2008

Microsoft Windows PowerShell and SQL Server 2008 AMO
Script a cube using Windows PowerShell and AMO
Script dimensions using Windows PowerShell and AMO
Detach and attach Analysis Service Database using Windows PowerShell and SQL Server 2008 AMO
Processing an Analysis Service Cube using Windows PowerShell and SQL Server 2008 AMO
Process Dimensions in an Analysis Service database
Restore Analysis Services database using Windows PowerShell and SQL Server 2008 AMO
How to Restore an SSAS database using Windows PowerShell and SQL Server 2008 AMO
Backing up Analysis Service database using Windows PowerShell and SQL Server 2008 AMO

Check your SQL Server using Windows PowerShell
Using Windows PowerShell and AMO to create an SSAS Database
Get SSAS Database Properties with PowerShell and AMO
Discover Analysis Service's Properties using Windows PowerShell and AMO
Microsoft Windows PowerShell and SQL Server 2008 AMO
Using Windows PowerShell to get SQL Server connection information
Check your SQL Server using Windows PowerShell - Part 7
Check your SQL Server using Windows PowerShell - Part 6
Check your SQL Server using Windows PowerShell - Part 5
Check your SQL Server using Windows PowerShell - Part 4
Check your SQL Server using Windows PowerShell - Part 3
Check your SQL Server using Windows PowerShell - Part 2
Check your SQL Server using Windows PowerShell - Part 1

Microsoft SQL Server 2008 - Change Data Capture
Microsoft SQL Server 2008 - Change Data Capture - Part 4
Microsoft SQL Server 2008 - Change Data Capture - Part 3
Microsoft SQL Server 2008 - Change Data Capture - Part 2
Microsoft SQL Server 2008 - Change Data Capture - Part I

Data Encryption in SQL Server 2005
SQL Server 2005 - Hacking password Encryption
SQL Server 2005 Encryption types

Microsoft Windows PowerShell and SQL Server 2005 SMO
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 11
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 10
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 9
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 8
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 7
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 6
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 5
Microsoft Windows Power Shell and SQL Server 2005 SMO - Part 4
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 3
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part II
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part I

Case Functions in SQL Server
CASE Function in SQL Server 2005 - part IV
CASE Function in SQL Server 2005 - part III
CASE function in SQL Server 2005 - part II
CASE function in SQL Server 2005 - part I

SQL Server 2005 Command Line Tool �SQLCMD�
SQL Server 2005 Command Line Tool "SQLCMD" - Part III
SQL Server 2005 Command Line Tool "SQLCMD" - Part II
SQL Server 2005 Command Line Tool "SQLCMD" - Part I

Data partitioning in SQL Server 2005
Data partitioning in SQL Server 2005 - Part V
Data partitioning in SQL Server 2005 - Part IV
Data partitioning in SQL Server 2005 - Part III
Data Partitioning in SQL Server 2005 - Part II
Data partitioning in SQL Server 2005 - Part I

SQL Server 2005 - Unattended installation
SQL Server 2005 - Unattended installation - Part V
SQL Server 2005 - Unattended installation - Part IV
SQL Server 2005 - Unattended installation - Part III
SQL Server 2005 - Unattended installation - Part II
SQL Server 2005 - Unattended installation - Part I

SQL Server 2008 Articles
Scripting data out of a table in SQL Server 2008
Query Active Directory Data from SQL Server using T-SQL
SQL Server Virtual Database from Idera
Open DBDiff for SQL Server 2008
Page compression in SQL Server 2008
Row compression in SQL Server 2008
Formatted date in SQL Server 2008
Audit your Windows domain DBA group using PowerShell
Terminate User processes in SQL Server
Enhancement in variable declaration - SQL Server 2008
Compound Assignment Operators in SQL Server 2008
Table-valued parameters - SQL Server 2008
Row Value Constructor in SQL Server 2008
UPSERT Functionality in SQL Server 2008
New datetime datatypes in SQL Server 2008
BACKUP compression in SQL Server 2008

SQL Server 2005 Articles:
Top Queries in SQL Server 2005
Find space Usage by Table , Schema in SQL Server 2005 and 2008
UNIQUE Column with multiple NULL values
Upload multiple XML files to an XML data type column
Query XML data from a table with XML data type
Error handling in SQL Server 2005
SYNONYM in SQL Server 2005
Upload multiple files to VarBinary column in SQL Server 2005
SQL Server 2005 - DML Usage on an untyped XML column
Database Mail in SQL Server 2005
INTERSECT Operator in SQL Server 2005
Except Operator in SQL Server 2005
OUTPUT clause in SQL Server 2005
SQL Server 2005's EXECUTE AS statement
SQL Server 2005 TableDiff Utility
COPY_ONLY Backups in SQL Server 2005
System Tables and Catalog Views
OPENROWSET function in SQL Server 2005
SQL Server 2005 - Data Definition Language Triggers
Row_Number() function in SQL Server 2005 - Part II
Row_Number() function in SQL Server 2005
"TOP" Clause in SQL Server 2005
SQL Server 2005 - Automating Creation of Database Snapshots
Cross-Tab reports in SQL Server 2005

SQL Server 7/2000 Articles:
Backup your SQL Server Analytical Database - Part II
Backup your SQL Server Analytical Database - Part I
Monitor CPU Usage of All Running Processes - Part II
Monitor CPU Usage of All Running Processes - Part I
Compress SQL Server backups using WinZip - Part II
Compress SQL Server backups using WinZip - Part I
Automatic Email Alerts for Low SQL Server Disk Space
Executing the result set
Data Portion and Used threshold
Import Security event logs using Log parser and SQL Server
Enumerate SQL Server Names from "SQL Server Enterprise Manager"
Monitor SQL Server CPU Loads
SQL Server: Customized Calendar Tables
Generate Script for objects and dependent objects
Monitor the CPU Usage of Your SQL Servers
SQL Server: How to Check the Status of a File Before Processing
Formatted emails from SQL Server
All about the 'Case'
Checking the status of weekly rebooted SQL Servers
Replicating Identity columns in SQL Server - Customizing replication
Rebuilding SQL Server Cluster Nodes
Connect to Lotus Domino using SQL Server Linked Server
Find TCP/IP Sockets Net-Libraries port number used by SQL Server 2000
Setting up a reboot cycle for Active/Passive Cluster SQL Server
Transaction Log Backups Based on Log Usage Threshold
Upload multiple files to SQL Server Image column
Checking Latency on SQL Server 2000
Compare Query Results - Part II
SQL Server: Compare Query Results - Part I
"sysperfinfo" in SQL Server
Monitor Blocking in SQL Server 2000 - Part II
Monitor Blocking in SQL Server 2000 - Part 1
Restore multiple DTS packages
Scanning the network for SQL Server for a range of IP addresses
Scalar Sub-Queries in SQL Server
Automating "Save DTS package"
Automating "Generate SQL Script"
Scanning the network for SQL Server
Restoring a SQL Database
Finding inactive machines using Active Directory
Bits in SQL Server
Auto-Number and Cumulative sum in SQL Server Query results
Inventorying hardware and OS information on all SQL Servers
Production Releases on to Multiple Databases - Part 2
Production releases on to multiple databases - Part I
Checking SQL Server's Heart Beat
Monitor Database Growth on Multiple SQL Servers
OpenRowSource and OpenRowSet in SQL Server 2000
Import Multiple Files to SQL Server Using DTS
Import multiple Files to SQL Server using T-SQL
"File Watcher" for SQL Server
Storing scanned web-pages and files to SQL Server
DTS Servers and Schedulers for MS SQL
Monitor Event Viewer on Multiple SQL Servers
SQL Server and Collation
Monitor Disk Space on Multiple SQL Servers
Control your SQL Server 7.0 and 2000 via E-Mail
Updating SQL Server Connection Properties from the DTS Package INI File
Compressed Backup of SQL Server 6.5, 7.0 and 2000 on Windows 2000
Enhanced SQL Server Security Auditing
How to Create ODBC DSN on multiple SQL server machines
Export a Table to a Date Stamped File Name in SQL Server
Backup Table Data in SQL Server 7.0 and 2000
A Server by Any Other Name
Backup--Transfer--FTP!
Synchronizing Production Data with a Test Database on SQL Server
Import Files with Date-stamped Filenames or Paths
Linking SQL Server to Heterogeneous Systems
SMTP Email Setup for SQL Server Cluster Server

Scripts:
UNIX POSIX Time
Find what database and object a column belongs to
Generate UserNames
Find the Zodiac
Find ssnetlib.dll version in SQL Server 2000
Reboot Machines
NZ function in SQL Server
Get the MDF Size of a given database
First day of previous month
Check File Size
Beginning date of any week in a year
Padding
Say, as in Roman Calendar
Spell the numbers
Find all numbers in a string
Find string in procedure, view, functions, defaults etc.
Generate GRANT EXEC script for existing users in the database
Last day of previous month
PreviousQuarter
Displays range of dates - Calendar
Delete Old Files
Comma Separated or Slash Separated Row Values in a Column

VB Scripts
Delete Older Files
Display FQDN of a machine
Display CPU Information
Send a simple email using CDOSys
NZ function in SQL Server
Enumerate members of a domain group
Test SQL Connectivity
List Processes
Check Windows Process
Search for a string in today, yesterday or the day before's files
Delete Old Folders

Current Articles

FileTable in SQL Server 2012
User Defined Server Role on SQL Server 2012
SQL Server 2012 Command Line Utilities
Microsoft SQL Server 2012 - (SQLPS)
Analysis Services PowerShell Provider (SQLAS) in SQL Server 2012
New Date,Logical Functions in SQL Server 2012
Top 10 Index T-SQL Statements That SQL Server DBAs Should Know
TOP 10 SQL Server Requests That Should Be Automated
Top 10 Transact-SQL Statements a SQL Server DBA Should Know
Data Archiving, Purging and Retrieval Methods for Enterprises
SQL Server 2008 : Accessing Audit Details
Configuring Granular Settings for a Database Level Audit
Database Level Auditing with Microsoft SQL Server 2008
Creating a Server Level Audit the Easy Way
Auditing made easy by Microsoft SQL Server 2008
Scripting data out of a table in SQL Server 2008
Query Active Directory Data from SQL Server using T-SQL
SQL Server Virtual Database from Idera
Open DBDiff for SQL Server 2008
Attaching .MDF files and .LDF files of a database with FileGroups
Rebuilding the log when attaching multiple .MDF files
How to handle multiple .MDF files and .LDF files in SQL Server 2008
Attaching a database in Microsoft SQL Server 2008
Database Mirroring Using T-SQL
How data is mirrored
Database Mirroring in SQL Server 2008
Page compression in SQL Server 2008
Row compression in SQL Server 2008
Formatted date in SQL Server 2008
Script a cube using Windows PowerShell and AMO
Script dimensions using Windows PowerShell and AMO
Detach and attach Analysis Service Database using Windows PowerShell and SQL Server 2008 AMO
Processing an Analysis Service Cube using Windows PowerShell and SQL Server 2008 AMO
Process Dimensions in an Analysis Service database
Restore Analysis Services database using Windows PowerShell and SQL Server 2008 AMO
How to Restore an SSAS database using Windows PowerShell and SQL Server 2008 AMO
Backing up Analysis Service database using Windows PowerShell and SQL Server 2008 AMO
Using Windows PowerShell and AMO to create an SSAS Database
Get SSAS Database Properties with PowerShell and AMO
Discover Analysis Service's Properties using Windows PowerShell and AMO
Microsoft Windows PowerShell and SQL Server 2008 AMO
Using Windows PowerShell to get SQL Server connection information
Check your SQL Server using Windows PowerShell - Part 7
Check your SQL Server using Windows PowerShell - Part 6
Check your SQL Server using Windows PowerShell - Part 5
Terminate User processes in SQL Server
Audit your Windows domain DBA group using PowerShell
Check your SQL Server using Windows PowerShell - Part 4
Check your SQL Server using Windows PowerShell - Part 3
Check your SQL Server using Windows PowerShell - Part 2
Enhancement in variable declaration - SQL Server 2008
Check your SQL Server using Windows PowerShell - Part 1
Compound Assignment Operators in SQL Server 2008
Table-valued parameters - SQL Server 2008
Row Value Constructor in SQL Server 2008
UPSERT Functionality in SQL Server 2008
Top Queries in SQL Server 2005
Find space Usage by Table , Schema in SQL Server 2005 and 2008
Microsoft SQL Server 2008 - Change Data Capture - Part 4
Microsoft SQL Server 2008 - Change Data Capture - Part 3
Microsoft SQL Server 2008 - Change Data Capture - Part 2
Microsoft SQL Server 2008 - Change Data Capture - Part I
New datetime datatypes in SQL Server 2008
SQL Server 2005 - Hacking password Encryption
BACKUP compression in SQL Server 2008
SQL Server 2005 Encryption types
UNIQUE Column with multiple NULL values
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 11
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 10
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 9
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 8
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 7
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 6
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 5
Microsoft Windows Power Shell and SQL Server 2005 SMO - Part 4
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part 3
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part II
Microsoft Windows PowerShell and SQL Server 2005 SMO - Part I
Upload multiple XML files to an XML data type column
Query XML data from a table with XML data type
CASE Function in SQL Server 2005 - part IV
CASE Function in SQL Server 2005 - part III
CASE function in SQL Server 2005 - part II
CASE function in SQL Server 2005 - part I
SQL Server 2005 Command Line Tool "SQLCMD" - Part III
SQL Server 2005 Command Line Tool "SQLCMD" - Part II
SQLServer: Dynamic Cross-Tab
SQL Server 2005 Command Line Tool "SQLCMD" - Part I
Error handling in SQL Server 2005
Data partitioning in SQL Server 2005 - Part V
Data partitioning in SQL Server 2005 - Part IV
Data partitioning in SQL Server 2005 - Part III
Data Partitioning in SQL Server 2005 - Part II
Data partitioning in SQL Server 2005 - Part I
SYNONYM in SQL Server 2005
Upload multiple files to VarBinary column in SQL Server 2005
SQL Server 2005 - DML Usage on an untyped XML column
Database Mail in SQL Server 2005
SQL Server 2005 - Unattended installation - Part V
SQL Server 2005 - Unattended installation - Part IV
SQL Server 2005 - Unattended installation - Part III
SQL Server 2005 - Unattended installation - Part II
SQL Server 2005 - Unattended installation - Part I
INTERSECT Operator in SQL Server 2005
Except Operator in SQL Server 2005
OUTPUT clause in SQL Server 2005
SQL Server 2005's EXECUTE AS statement
SQL Server 2005 TableDiff Utility
COPY_ONLY Backups in SQL Server 2005
System Tables and Catalog Views
OPENROWSET function in SQL Server 2005
SQL Server 2005 - Data Definition Language Triggers
Row_Number() function in SQL Server 2005 - Part II
Row_Number() function in SQL Server 2005
Backup your SQL Server Analytical Database - Part II
Backup your SQL Server Analytical Database - Part I
Monitor CPU Usage of All Running Processes - Part II
Monitor CPU Usage of All Running Processes - Part I
Compress SQL Server backups using WinZip - Part II
Compress SQL Server backups using WinZip - Part I
Automatic Email Alerts for Low SQL Server Disk Space
"TOP" Clause in SQL Server 2005
Executing the result set
SQL Server 2005 - Automating Creation of Database Snapshots
Cross-Tab reports in SQL Server 2005
Data Portion and Used threshold
Import Security event logs using Log parser and SQL Server
Enumerate SQL Server Names from "SQL Server Enterprise Manager"
Monitor SQL Server CPU Loads
SQL Server: Customized Calendar Tables
Generate Script for objects and dependent objects
Monitor the CPU Usage of Your SQL Servers
SQL Server: How to Check the Status of a File Before Processing
Formatted emails from SQL Server
All about the 'Case'
Checking the status of weekly rebooted SQL Servers
Replicating Identity columns in SQL Server - Customizing replication
Rebuilding SQL Server Cluster Nodes
Connect to Lotus Domino using SQL Server Linked Server
Find TCP/IP Sockets Net-Libraries port number used by SQL Server 2000
Setting up a reboot cycle for Active/Passive Cluster SQL Server
Transaction Log Backups Based on Log Usage Threshold
Upload multiple files to SQL Server Image column
Checking Latency on SQL Server 2000
Compare Query Results - Part II
SQL Server: Compare Query Results - Part I
"sysperfinfo" in SQL Server
Monitor Blocking in SQL Server 2000 - Part II
Monitor Blocking in SQL Server 2000 - Part 1
Restore multiple DTS packages
Scanning the network for SQL Server for a range of IP addresses
Scalar Sub-Queries in SQL Server
Automating "Save DTS package"
Automating "Generate SQL Script"
Scanning the network for SQL Server
Restoring a SQL Database
Finding inactive machines using Active Directory
Bits in SQL Server
Auto-Number and Cumulative sum in SQL Server Query results
Inventorying hardware and OS information on all SQL Servers
Production Releases on to Multiple Databases - Part 2
Production releases on to multiple databases - Part I
Checking SQL Server's Heart Beat
Monitor Database Growth on Multiple SQL Servers
OpenRowSource and OpenRowSet in SQL Server 2000
Import Multiple Files to SQL Server Using DTS
Import multiple Files to SQL Server using T-SQL
"File Watcher" for SQL Server
Storing scanned web-pages and files to SQL Server
DTS Servers and Schedulers for MS SQL
Monitor Event Viewer on Multiple SQL Servers
SQL Server and Collation



Comment and Contribute

 


(Maximum characters: 1200). You have characters left.