Advertisements

Archive

Posts Tagged ‘Denali’

Introduction and Installation of Data Quality Services for Denali

May 24, 2012 2 comments

Data Quality Services (DQS)  enables you to discover, build, and manage knowledge about your data. You can then use that knowledge to perform data cleansing, matching, and profiling

DQS is not installed automatically with Microsoft SQL Server Denali CTP3.  You must perform additional following steps to complete your Data Quality Server installation, configure it, and then use it. Read more…

Advertisements

Powershell – Powershell Script to backup all user DBs in SQL Server

Powershell is Microsoft’s task automation framework.

The following is a simple powershell script to take full backup of all users database of MS SQL Server, this script is tested on MS SQL Server 2008R2 and MS SQL Server 2012(Denali). Read more…

Table Attributes Dependencies in Store Procedures with SQL Server 2012

May 21, 2012 2 comments

Couple of days back I got an opportunity to migrate the existing Sybase ASE database (Adaptive Server Enterprise/15.0.2) to my favorite MS SQL Server 2012, to find out the feasibility of migration activity in near future.

Our team consists of Project Manager, Database architect and few of the senior guys we all concluded to just migrate the database objects from Sybase to SQL Server 2012, and along with the migration we need to find out dead objects in the existing database which is being carried so far. Here the dead objects means such tables, columns and views which are no more in use. Read more…

VertiPaq Engine Renamed as xVelocity in SQL Server 2012(Denali).

VertiPaq engine is currently only available to PowerPivot for Excel in SQL Server 2008 R2. After the amazing success of PowerPivot for Excel in the previous release of SQL Server 2008 R2 this engine moved to the server side with the same InMemory BI and compression and it’s called the VertiPaq Engine or the Analysis Services Tabular Mode. Data retrieval and calculations happen at a much faster rate as its entire database is in-memory.Vertipaq enables Excel to process hundreds of millions of rows with sub-second response times on desktop hardware. Read more…

%d bloggers like this: