Muthusamy Anantha Kumar aka The MAK

Friday Jan 16th 2004 by DatabaseJournal.com Staff
Share:

All articles by Muthusamy Anantha Kumar aka The MAK

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

Working with .MDF and .LDF files in SQL Server 2008

Database Mirroring in SQL Server 2008

Microsoft Windows PowerShell and SQL Server 2008 AMO

Check your SQL Server using Windows PowerShell

Microsoft SQL Server 2008 - Change Data Capture

Data Encryption in SQL Server 2005

Microsoft Windows PowerShell and SQL Server 2005 SMO

Case Functions in SQL Server

SQL Server 2005 Command Line Tool �SQLCMD�

Data partitioning in SQL Server 2005

SQL Server 2005 - Unattended installation

SQL Server 2008 Articles

SQL Server 2005 Articles:

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:

VB Scripts

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

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved