|
|
-
|
|
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 »...
|
|
-
|
|
SQL Azure has been evolving at an amazing pace. Here is a list that summarizes the evolution till June 2012:
SQL Azure, June 2012 (During Meet Windows Azure event)
SQL Azure reporting is now generally available and is backed by SLA
SQL Azure now called Wi...
|
|
-
|
|
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...
|
|
-
|
|
My journal article titled “Building Ideal PowerPivot Model for Power View reports” got published in SolidQ Journal. In this article, I talk about reporting properties in PowerPivot Model that you can set which will enhance the Power View report...
|
|
-
|
|
After reading First Impression: Google’s BigData offering called BigQuery , a reader (Shadab Shah) had few questions about it and in this blog-post, I am going to address those questions:
Q1. Which Tool do I use to Query data in BigQuery?
A1: They have a B...
|
|
-
|
|
As a part of University of Washington’s (UW) cloud class’s assignment, I played with Google’s BigData offering BigQuery and I am writing this blog post to share what I think about it. please note that the views are my own and do not repre...
|
|
-
|
|
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 ...
|
|