Muthusamy Anantha Kumar

In many organizations, the Active Directory administrator creates a dedicated domain group for Database administrators. All of the domain logins of the Database Administrator logins are added to that dedicated domain group. These dedicated domain groups are usually added as local administrator on the SQL Server host as well as being granted access to SQL […]

-computername $hostname -errorvariable errorvar if (-not $errorvar) { foreach ($drive in $drives) { if ($drive.drivetype -eq “3” ) { $message= “DeviceID=”+$drive.Deviceid+” Size=”+ Conclusion This is the fourth part of the article series “Check your SQL Server using Windows PowerShell”. The article illustrated how to access the hard disk and network card adapter information using Windows […]

Conclusion This is the third part of the article series “Check your SQL Server using Windows PowerShell”. The article illustrated how to access the operating system and hardware information using Windows PowerShell and WMI-Object. In the next installment, we will add some additional checking, so that we don’t have to do all of the checking […]

Conclusion This is the second part of the article series “Check your SQL Server using Windows PowerShell”. The article illustrated how to access the Windows Service on a remote machine using Windows PowerShell and WMI-Object. In the next installment, we will add some additional checking, so that we don’t have to do all the checking […]

Enhanced variable declaration, one of the many enhancements that Microsoft added to SQL Server 2008 allows you to declare and initialize a value at the same time, similar to other languages. For some reason, this enhancement was never made to the actual variable declaration. In previous versions, we could declare a parameter in a stored […]

As a Microsoft SQL Server Database Administrator, when we are paged or emailed with red alerts, we tend to run some scripts, commands, or procedures to see if the status of the server looks ok. This article series is going to illustrate different methods and procedures to check the current status of the Operating system, […]

We have seen and used compound assignment operators in procedural languages like C++ and C# etc. Now this Compound Assignment Operator feature and enhancement is introduced in SQL Server 2008. What is compound assignment operator? Compound assignment operator means an operator combined with another operator. The compound assignment operators that are supported in SQL Server […]

In previous versions of SQL Server, it has not been possible to pass a table variable, as a parameter, to a stored procedure. Microsoft introduces table-valued parameters, along with other features, in SQL Server 2008. Table-valued parameters have two major benefits: a.  It does not acquire locks for the initial data b.  It does not […]

We all know how to use Data Manipulation Language to Insert, Delete and Update data on a SQL Server table. Sometimes we need to insert too much data using insert statements. There are traditional and cumbersome methods to insert huge amounts of data. Now, SQL Server 2008 provides a new method to insert data to […]

The UPSERT command inserts rows that don’t exist and updates the rows that do exist. The Word UPSERT is a fusion of the words UPDATE and INSERT. UPSERT was officially introduced in the SQL:2003 standard. IF FOUND THEN UPDATE ELSE INSERT; In SQL Server 2008, Microsoft introduces the UPSERT functionality through the MERGE command. Until […]

SQL Server Database Administrators usually like to know which queries use the most CPU time and which queries use the most I/O. To get that information, SQL Server Database Administrators have run profiler pro-actively in SQL Server 7.0 and SQL Server 2000. In SQL Server 2005 we could query this information using the dynamic management […]

Often SQL Server Database administrators struggle with hard disk space and constantly strive to clean up tables and schemas, writing many queries to find which table and schema uses the most hard disk space. This article illustrates how to query system catalogs to find the space usage, which helps database administrators identify the schemas and […]