Monthly Archives: July 2011

A short list of database environment

Posted on July 30, 2011 by

These are the list of Database Management System (DBMS) in today;s data platform. Just for information and Learn more about it. File System Network DBMS Relational DBMS Object Relational DBMS Text DBMS Content DBMS XML DBMS Open Source DBMS In-Memory … Continue reading →

Posted in Uncategorized | Tagged , , , | 2 Comments

Install Data Quality Service (DQS) – Denali CTP 3

Posted on July 23, 2011 by

Installing DQS is very simply if we have the prerequisite  ready. Following are the steps involved in installing DQS. Requirement: Install SQL Server Denali CTP 3 with DQS features. Step 1: Execute the <Drive>\Program files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Binn\DQSInstaller.exe Step 2: Enter 10 characters … Continue reading →

Posted in SQL Denali | Tagged , , , | Leave a comment

Database performance and Scalability enhancements – Denali CTP 3

Posted on July 23, 2011 by

As we all know that the SQL Server Denali came up with lot of changes start form the installation, GUI, features to huge data warehouse performance capability. But, there is a special area where database professionals focus much. It is … Continue reading →

Posted in SQL Denali | Tagged , , , , , | Leave a comment

Create SSIS Catalog and Deploy Packages SSIS Denali CTP 3 – Part 4

Posted on July 21, 2011 by

Integration services node is a new feature in SQL Server Denali. It helps us to create SSISDB catalog database to deploy SSIS package and manage them in SQL Server Denali  instance. There are lot of new features available in Integration … Continue reading →

Posted in SQL Denali, SSIS | Tagged , , , , , , , | 1 Comment

SSIS Denali CTP 3 – Part 3

Posted on July 20, 2011 by

In this part 3 of SSIS denali ctp3, I am going to show you the 3 new features in SSIS. Those features are. 1 Offline connection manager 2. Project Connection manager 3. Resolve References Offline connection manager SQL Server “Denali”, … Continue reading →

Posted in SQL Denali, SSIS | Tagged , , , , | 1 Comment