Muthusamy Anantha Kumar

Change data capture is one of the many features that Microsoft is introducing in SQL Server 2008. Part 1 and Part2 of the article explored how we could enable Change Data Capture on a database and on a table. In Part 3 we discussed how to disable and enable the Change Data Capture when the […]

Microsoft has introduced Change Data Capture, a feature that tracks changes on a table, in SQL Server 2008. Part I and Part II of the article illustrated how to enable Change Data Capture on a database and on a table. This article illustrates what happens to the Change Data Capture when the table structure is […]

One of the new feature in Microsoft SQL Server 2008 is track the changes on a table. You can enable change tracking on a table using Change Data Capture feature. Greenbay, Wisconsin’,60000,1000) Insert into Mytable values (2, ‘Rainbow Colors’,’21, East st,

One of the new features in Microsoft SQL Server 2008 is the ability to track changes on a table. You can enable change tracking on a table using the Change Data Capture feature. Part one of this series illustrates how to enable Change Data Capture on a database, and on a table, and how to […]

From the beginning, Microsoft SQL Server DBAs have longed for two different datatypes, where you could store time and date separately. The long wait is over. In all of the older versions, we had only one data type that could store Datetime datatype, and it stored both the value of the date and the value […]

Script Date: 12/18/2007 18:18:36 ******/ IF EXISTS (SELECT * FROM sys.objects Step 3 Let’s assume that we forgot the password for the encrypted data style=”color: #993300; background: transparent;”“0x01000000F75D553409C74570F6DDBCADA53FD489DDD52D9277010050565ADF30F244F8CC”. We can retrieve the password and the encrypted data by using the above written procedure as shown below. use master go select getdate() as StartingTime go […]

After a long wait, SQL Server 2008 is going to be released with inbuilt compression for backups. Until the release of SQL Server 2005, compression was only available via third party backup software such as  SQL LiteSpeed, SQLZip, etc. This article demonstrates how to take Full, Differential and Transactional log backups with compression, without compression […]

Encryption is the key for data security. Sensitive data such as Social Security numbers, credit card numbers, passwords, etc. should be protected from hacking. In SQL Server 2000, you have to create your own user-defined functions to encrypt the data or use external DLLs to encrypt the data. In SQL Server 2005, these functions and […]

As you know, when you create a UNIQUE constraint on a nullable column, SQL Server allows only one NULL value, thereby maintaining the UNIQUEness. However, there are situations when we need more than one NULL value in the column but still have to maintain uniqueness, ignoring all those NULL values. In this article, I am […]

Export output to XML Part 1 and Part 2 of this series discussed Power Shell installation and simple SMO, WMI cmdlets. Part 3 covered how to script PowerShell and connect to SQL Server. Part 4 explained how to use a PowerShell script to loop through the content of a file and connect to different servers. […]

Using PowerShell Script to Generate SQL Server Scripts for Database and Tables (“Microsoft.SqlServer.Smo”) | out-null $MyScripter=new-object Execute the PowerShell script as shown below. [Refer Fig 1.1] ./ScriptSQL "HOME\SQLEXPRESS" "Admin" "Database" Fig 1.1 Parameters explained: ScriptSQL is actually the ScriptSQL.ps1 script in the folder c:\ps HOME is the hostname SQLEXPRESS is the sql server instance name […]

Using PowerShell and SMO to Generate an SQL Server Script (“Microsoft.SqlServer.Smo”) | out-null $MyScripter=new-object (“Microsoft.SqlServer.Management.Smo.Scripter”) $srv=New-Object “Microsoft.SqlServer.Management.Smo.Server” This would generate a “Create Database” script for the AdventureWorks database as shown below. [Refer Fig 1.2] CREATE DATABASE [AdventureWorks] ON PRIMARY ( NAME = N’AdventureWorks_Data’, FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL.1\ MSSQL\Data\AdventureWorks_Data.mdf’ , SIZE = 180992KB […]