Categories
General

Configuring Change Data Capture

In this article Im going to configure change data capture. Im going to create a new database and a table for this purpose. Configuring CDC is very simple its just a two step process as below

  • Enable CDC for the database
  • Enable CDC for the required tables

Categories
General

Change Data Capture

What is Change Data Capture?

CDC is acronym for Change Data Capture. This is one of the new feature added from SQL Server 2008. CDC helps us to provide information about DML changes on a table and a database. It provides these information’s in relational format. In previous versions of SQL Server we use triggers, timestamp columns etc., to capture the DML changes to the table which is resource expensive techniques, so to overcome this MS added this new feature.

Categories
General Reporting Services

Download Export RDL files from Report Server

Few days back I was working with one of my colleague with reporting service. I dont have much exposure to RS however its a simple task, he asked me to download a RDL file from the report server, we are using RS2005 and couldnt find download or export button which is supposed to be in different name. In this article we are just going to see how to download or export the RDL from your reporting server.

Categories
General

Does Extension matter for Creating a database?

We have 3 types of file extensions in SQL Server. MDF, NDF and LDF each one representing Primary, Secondary and Log file respectively. Do you think these extensions are need to be given to the respective files? If your answer is yes then you are wrong. You can give any extension as you like or else you can even interchange these 3 extensions to primary, secondary and log file. Extension plays a important role for us to understand which file is what where as when you attach the db, SQL (by pointing the primary file) knows where the log file and the additional files for the db, it will attach the database without any errors. This is because SQL will check the primary file (which you have pointed) and if its in right format then it will start reading the header page to fetch additional details about other files and attach the database.

Categories
General

SQL Server 2008 R2 New Features

On April 22nd 2010 SQL Server 2008 R2 is released to production. I tried to get the list of new features added to R2 however I couldnt find all the new features in a single thread so Im writing this article to populate the list of new features added to SQL Server 2008 R2. There are many new features added to DBA and BI however I feel we have more features for BI.