|
|
-
|
|
Here are the seven Demo’s that I had posted over the past few weeks, listing them here:
Detecting invalid values in Price domain or unrealistic values in Height domain
How to standardize data using DQS
How to clean records using third-party reference...
|
|
-
|
|
[UPDATE 29 Dec 2012: One more whitepaper that's on the same subject and should be read after the tutorial: Cleanse and Match Master Data by Using EIM ]
Here’s the resource: Tutorial: Enterprise Information Management using SSIS, MDS, and DQS Together...
|
|
-
|
|
Introduction: In this blog-post, we’ll see what you can do when the Excel data mining add-in disappears. Steps: 1. What … Continue reading »...
|
|
-
|
|
I hear you ask: “why are you writing about columnar databases?”. To answer that, I have spent some time researching about PowerPivot and Tabular Model these days which is powered by what Microsoft calls xVelocity (previously called Vertipaq) en...
|
|
-
|
|
I passed couple of SQL Server 2012 business intelligence beta exams! The exams are:
71-463: Implementing a Data Warehouse with Microsoft SQL Server 2012
71-466: Implementing Data Models and Reports with Microsoft SQL Server 2012
Filed under: beyondrelati...
|
|
-
|
|
Visualizing stuff is powerful – if you have visualized something then you can remember it for a longer period of time. So in this post, we will visualize what the Merge Transformation in SQL Server Integration services (SSIS) Does:
Note:
1) Do not...
|
|
-
|
|
Following the announcements at “Meet Windows Azure” event, we now have three options to run SQL Server on CLOUD; They are:
1. SQL Azure which is now called Windows Azure SQL Database
2. SQL Server on Windows Azure VM Roles
3. SQL Server on Amaz...
|
|
-
|
|
1. SQL Azure reporting is generally available and backed by SLA
2. You can now run SQL Server on VM roles
3. Azure was rebranded a while back but quick reminder: SQL Azure was renamed to Windows Azure SQL Database and so in the “new” portal ...
|
|
-
|
|
Recently at SQLRally, Rushabh Mehta sir pointed me to a great BigData resource. It was a great read and thought it could help you too. So, If you want to get started on the world of BigData, then there’s a resource that could be of help:
Oreilly̵...
|
|
-
|
|
Up until April 2012, the only way to run SQL server on cloud was “SQL Azure”. But recently AWS announced SQL Server on Cloud. Good news? Probably. it’s always good to have more than one option. So for those who are new to world of AWS, he...
|
|