» Database Journal Home

» Database Articles

» Database Tutorials

MS SQL

Oracle

DB2

MS Access

MySQL

» RESOURCES

SQL Scripts & Samples

Tips

» Database Forum

» Slideshows

Free Newsletters:

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Advertiser Disclosure

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

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

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:

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

Advertiser Disclosure: Some of the products that appear on this site are from companies from which QuinStreet receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. QuinStreet does not include all companies or all types of products available in the marketplace.