Category: Articles
-
Adding Startup parameter made easy in Denali
You folks might have already know that a new version of SQL Server is on the way to market. Right now beta version of SQL Denali (aka SQL Server 2011) is released. In this version addition of startup parameter is made easy and effort less. In previous version we will be adding it in a…
-
SEQUENCE – Feature in Denali
Another long-waited feature SEQUENCE is included in the latest version of SQL server code named DENALI. Sequence is now an object in each database and is similar to IDENTITY in functionality. Sequence is an object that has start value, increment value and end value defined in them and this sequence can be added to a…
-
Add your OWN server role in DENALI
Microsoft this week unveiled its newest version of SQL server code named DENALI most probably will be known as SQL server 2011. I have had a bit of play around with the new version and found some of the new features being added to the Database engine. The first coolest thing that I looked at…
-
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
-
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,…