Data Engineering – Learn from the experts
-
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,…
-
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…
-
August 2010 UG Scheduled
After a big wonderful event conducted last month we are back on our normal UG sessions. Please go-ahead and register for the event, hope to see all the faces again.
-
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…
Got any recommendations?