January 16, 2004
Muthusamy Anantha Kumar aka The MAK
mak@mssqlengineering.com
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
Scripting data out of a table in SQL Server 2008
- December 16, 2009
Query Active Directory Data from SQL Server using T-SQL
- December 2, 2009
SQL Server Virtual Database from Idera
- October 21, 2009
Open DBDiff for SQL Server 2008
- October 7, 2009
Page compression in SQL Server 2008
- June 17, 2009
Row compression in SQL Server 2008
- June 3, 2009
Formatted date in SQL Server 2008
- May 20, 2009
Audit your Windows domain DBA group using PowerShell - September 20, 2008
Terminate User processes in SQL Server - September 3, 2008
Enhancement in variable declaration – SQL Server 2008 - June 24, 2008
Compound Assignment Operators in SQL Server 2008 - June 4, 2008
Table-valued parameters – SQL Server 2008 - May 21, 2008
Row Value Constructor in SQL Server 2008 - May 6, 2008
UPSERT Functionality in SQL Server 2008 - April 16, 2008
New datetime datatypes in SQL Server 2008 - January 2, 2008
BACKUP compression in SQL Server 2008 - December 19, 2007
SQL Server 2005 Articles:
Top Queries in SQL Server 2005 - April 2, 2008
Find space Usage by Table , Schema in SQL Server 2005 and 2008 - March 18, 2008
UNIQUE Column with multiple NULL values - November 21, 2007
Upload multiple XML files to an XML data type column - May 16, 2007
Query XML data from a table with XML data type - May 2, 2007
Error handling in SQL Server 2005 - January 5, 2007
SYNONYM in SQL Server 2005 - October 4, 2006
Upload multiple files to VarBinary column in SQL Server 2005 - September 22, 2006
SQL Server 2005 – DML Usage on an untyped XML column - September 6, 2006
Database Mail in SQL Server 2005 - August 16, 2006
INTERSECT Operator in SQL Server 2005 - May 17, 2006
Except Operator in SQL Server 2005 - May 3, 2006
OUTPUT clause in SQL Server 2005 - April 19, 2006
SQL Server 2005's EXECUTE AS statement - April 5, 2006
SQL Server 2005 TableDiff Utility - March 29, 2006
COPY_ONLY Backups in SQL Server 2005 - March 15, 2006
System Tables and Catalog Views - March 1, 2006
OPENROWSET function in SQL Server 2005 - February 16, 2006
SQL Server 2005 - Data Definition Language Triggers - February 1, 2006
Row_Number() function in SQL Server 2005 – Part II - January 18, 2006
Row_Number() function in SQL Server 2005 - January 4, 2006
"TOP" Clause in SQL Server 2005 - September 7, 2005
SQL Server 2005 – Automating Creation of Database Snapshots - August 3, 2005
Cross-Tab reports in SQL Server 2005 - July 19, 2005
SQL Server 7/2000 Articles:
Backup your SQL Server Analytical Database – Part II - December 20, 2005
Backup your SQL Server Analytical Database – Part I - December 7, 2005
Monitor CPU Usage of All Running Processes – Part II - November 16, 2005
Monitor CPU Usage of All Running Processes – Part I - November 2, 2005
Compress SQL Server backups using WinZip – Part II - October 26, 2005
Compress SQL Server backups using WinZip – Part I - October 19, 2005
Automatic Email Alerts for Low SQL Server Disk Space - September 20, 2005
Executing the result set - August 16, 2005
Data Portion and Used threshold - July 6, 2005
Import Security event logs using Log parser and SQL Server - June 29, 2005
Enumerate SQL Server Names from "SQL Server Enterprise Manager" - June 1, 2005
Monitor SQL Server CPU Loads - May 17, 2005
SQL Server: Customized Calendar Tables - May 4, 2005
Generate Script for objects and dependent objects - April 29, 2005
Monitor the CPU Usage of your SQL Servers - April 28, 2005
SQL Server: How to Check the Status of a File Before Processing - April 18, 2005
Formatted emails from SQL Server - April 7, 2005
All about the 'Case' - March 15, 2005
Checking the status of weekly rebooted SQL Servers - March 2, 2005
Replicating Identity columns in SQL Server - Customizing replication - February 16, 2005
Rebuilding SQL Server Cluster Nodes - February 2, 2005
Connect to Lotus Domino using SQL Server Linked Server - January 25, 2005
Find TCP/IP Sockets Net-Libraries port number used by SQL Server 2000 - January 20, 2005
Setting up a reboot cycle for Active/Passive Cluster SQL Server - January 13, 2005
Transaction Log Backups Based on Log Usage Threshold - January 5, 2005
Upload multiple files to SQL Server Image column - December 14, 2004
Checking Latency on SQL Server 2000 - December 1, 2004
Compare Query Results - Part II - November 16, 2004
SQL Server: Compare Query Results - Part I - November 3, 2004
"sysperfinfo" in SQL Server - October 28, 2004
Monitor Blocking in SQL Server 2000 - Part II - October 26, 2004
Monitor Blocking in SQL Server 2000 - Part 1 - October 20, 2004
Restore multiple DTS packages - October 6, 2004
Scanning the network for SQL Server for a range of IP addresses - September 29, 2004
Scalar Sub-Queries in SQL Server - September 22, 2004
Automating "Save DTS package" - September 15, 2004
Automating "Generate SQL Script" - September 1, 2004
Scanning the network for SQL Server - August 24, 2004
Restoring a SQL Database - August 18, 2004
Finding inactive machines using Active Directory - August 4, 2004
Bits in SQL Server - July 14, 2004
Auto-Number and Cumulative sum in SQL Server Query results - July 7, 2004
Inventorying hardware and OS information on all SQL Servers - June 16, 2004
Production Releases on to Multiple Databases - Part 2 - June 2, 2004
Production releases on to multiple databases - Part I - May 19, 2004
Checking SQL Server's Heart Beat - May 5, 2004
Monitor Database Growth on Multiple SQL Servers - April 14, 2004
OpenRowSource and OpenRowSet in SQL Server 2000 - April 7, 2004
Import Multiple Files to SQL Server Using DTS - March 24, 2004
Import multiple Files to SQL Server using T-SQL - March 16, 2004
"File Watcher" for SQL Server - March 3, 2004
Storing scanned web-pages and files to SQL Server - February 25, 2004
DTS Servers and Schedulers for MS SQL - February 23, 2004
Monitor Event Viewer on Multiple SQL Servers - February 11, 2004
SQL Server and Collation - January 28, 2004
Monitor Disk Space on Multiple SQL Servers - January 14, 2004
Control your SQL Server 7.0 and 2000 via E-Mail - December 31, 2003
Updating SQL Server Connection Properties from the DTS Package INI File - September 5, 2003
Compressed Backup of SQL Server 6.5, 7.0 and 2000 on Windows 2000 - August 20, 2003
Enhanced SQL Server Security Auditing - August 1, 2003
How to Create ODBC DSN on multiple SQL server machines - July 24, 2003
Export a Table to a Date Stamped File Name in SQL Server - June 20, 2003
Backup Table Data in SQL Server 7.0 and 2000 - May 16, 2003
A Server by Any Other Name - April 24, 2003
Backup--Transfer--FTP! - April 22, 2003
Synchronizing Production Data with a Test Database on SQL Server - April 3, 2003
Import Files with Date-stamped Filenames or Paths - March 10, 2003
Linking SQL Server to Heterogeneous Systems - Feb. 28, 2003
SMTP Email Setup for SQL Server Cluster Server - February 18, 2003
Scripts:
Check if column is NULL or empty - May 11, 2007
UNIX POSIX Time - October 6, 2006
Find what database and object a column belongs to - August 10, 2006
Generate UserNames - August 4, 2006
Find the Zodiac - August 2, 2006
Find ssnetlib.dll version in SQL Server 2000 - July 10, 2006
Reboot Machines - May 12, 2005
NZ function in SQL Server - April 20, 2005
Get the MDF Size of a given database - February 1, 2005
First day of previous month - January 6, 2005
Check File Size - December 6, 2004
Beginning date of any week in a year - August 9, 2004
Padding - July 23, 2004
Say, as in Roman Calendar - July 21, 2004
Spell the numbers - July 1, 2004
Find all numbers in a string - May 21, 2004
Find string in procedure, view, functions, defaults etc. - April 30, 2004
Generate GRANT EXEC script for existing users in the database - April 30, 2004
Last day of previous month - April 20, 2004
PreviousQuarter - April 19, 2004
Displays range of dates - Calendar - April 11, 2004
Delete Old Files - April 10, 2004
Comma Separated or Slash Separated Row Values in a Column - August 4, 2003
VB Scripts
Delete Older Files - July 1, 2005
Display FQDN of a machine - June 22, 2005
Display CPU Information - May 3, 2005
Send a simple email using CDOSys - April 25, 2005
NZ function in SQL Server - April 20, 2005
Enumerate members of a domain group - April 20, 2005
Test SQL Connectivity - April 4, 2005
List Processes - March 30, 2005
Check Windows Process - November 17, 2004
Search for a string in today, yesterday or the day before's files - July 1, 2004
Delete Old Folders - June 17, 2004
Add databasejournal.com to your favorites
Add databasejournal.com to your browser search box
|
|
Receive news via our XML/RSS
feed
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. 
IE 7
Firefox 2.0