Muthusamy Anantha Kumar

In SQL Server 7.0, Microsoft introduced sp_attach_db and sp_attach_single_file_db system procedures. It was very convenient for SQL Server database administrators to perform the following tasks: Attach .MDF and .LDF files directly to the server using sp_attach_db system stored procedure. Attach only .MDF files using sp_attach_single_file_db system stored procedure. Detach the databases from one server using […]

In Part 1 of this article series, was a step by step illustration of how to setup database mirroring. Part 2 discussed how data is mirrored from the principal server to the mirrored server and how to monitor them. This installment examines how to create database mirroring between the principal server and mirrored server using […]

In Part 1 of this series we saw a step by step illustration of how to setup Database mirroring. This article examines how data is mirrored from the Principal server to the mirrored server. Let’s create a table "Test" on the Principal database DB1 using the transact SQL below. USE [DB1] GO /****** Object: Table […]

What is Database Mirroring? Database mirroring is the feature in SQL Server 2005 and SQL Server 2008 that provides a high availability solution for Databases. This feature can be enabled and used only on a database with Full recovery models. The database can be mirrored from one SQL Server instance to another SQL Server instance. […]

Until SQL Server 7.0 was released, the page size in SQL Server was 2K; now the page size is 8K. Microsoft introduced page compression in SQL Server 2008. This new feature is available in the Enterprise edition and developer edition. The page compression feature of SQL Server can compress the entire page. Page compression is […]

Microsoft SQL Server 2008 introduced row compression. This new feature is available in the Enterprise edition only. The row compression feature of SQL Server can compress columns of data to use only the minimum amount of space required. Row Compression can be enabled when creating a table or index or when altering an index or […]

We all know that different countries require different kinds of date formats. Different applications require different date formats. SQL Server database administrators and developers use the function convert() in conjunction with other date functions such as datepart(), datename(), etc. to manipulate the format of the output. This article illustrates how to create one common function […]

LoadWithPartialName(“Microsoft.AnalysisServices”) >$NULL $server = New-Object Microsoft.AnalysisServices.Server $server.connect(“PowerServer3\SQL2008”)

LoadWithPartialName(“Microsoft.AnalysisServices”) >$NULL $server = New-Object Microsoft.AnalysisServices.Server $server.connect(“PowerServer3\SQL2008”) Now let’s list all of the databases available on the Analysis server “PowerServer\SQL2008” as shown below. [Refer Figure 1.1] $database=$server.databases $database|select-object name Result Name —- Advent2 Adventure Works 2008 DW Adventure Works 2008 -3 AAA Adventure Works Test Adventure Works 2008 -2 MyCube xyz Marketing Finance1 Finance2 Finance3 […]

Now let’s list all of the databases available on the Analysis server “PowerServer\SQL2008” as shown below. [Refer Figure 1.1] $database=$server.databases $database|select-object name Result Name —- Advent2 Adventure Works 2008 DWsss Adventure Works 2008 -3 Adventure Works 2008 -2 AAA Adventure Works Test Adventure Works 2008 DW MyCube xyz Marketing Finance1 Finance2 Finance3 Marketing1 Figure 1.1 […]

(“Microsoft.AnalysisServices”) >$NULL $server = New-Object Microsoft.AnalysisServices.Server $server.connect(“PowerServer3\SQL2008”) Let’s list all of the databases available on the “PowerServer\SQL2008” Analysis server as shown below. [Refer Figure 1.1] $database=$server.databases $database|select-object name Result Name —- Advent2 Adventure Works 2008 DWsss Adventure Works 2008 -3 Adventure Works 2008 -2 AAA Adventure Works Test Adventure Works 2008 DW MyCube xyz Marketing […]