Change Set and Approval Workflow in MDS 2016

One of the interesting features of Master Data Services 2016 is Change Set and Require Approval. In prior versions of MDS when you apply a change and publish that change automatically take place in the entity and records. However in the new MDS in SQL Server 2016 you can create a Change Set of your Read more about Change Set and Approval Workflow in MDS 2016[…]

What’s New in MDS of SQL Server 2016

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
FacebooktwitterlinkedinrssyoutubeFacebooktwitterlinkedinrssyoutube

0 heading

SQL Server 2016 CTP 2 released almost a day ago, and I’ve had a chance to install it and play with Master Data Services to see what changes has been made in this product. Master Data Services is a service of SQL Server first released in SQL Server 2008R2, and enhanced in SQL Server 2012. There was no changes in MDS of SQL Server 2014. But fortunately MDS wheels are spinning now, there are some changes in 2016. Changes are not major though they  are evidence of Microsoft investing on this services nowadays.

[…]

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
FacebooktwitterlinkedinrssyoutubeFacebooktwitterlinkedinrssyoutube

Walk-through Steps: I’m New to BI, Where to Start? – Part 3 : Data Governance

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
FacebooktwitterlinkedinrssyoutubeFacebooktwitterlinkedinrssyoutube

bag-and-hands_w

Data Governance is one of the most important aspects of BI systems, that unfortunately seen less important in many organizations. All usefulness and gratefulness of BI system will only be seen if there is a good data governance in place. If you build superb dashboards and data visualizations it won’t help until the quality of data is high. your ETL scenario won’t be so much great when there are more than one source for the same data but with different versions of it.

Data Governance and Enterprise Information Management (EIM) are concepts that needs to be covered in every organization working with the data, despite the fact that they use BI system or not. So in nutshell EIM and Data Governance are not components of BI system, they are separate systems, that can be used side by side of a BI system. However because of their very close relationship with BI system (especially because BI system is based on the data and information) we would cover them here. I would like to comment here that there won’t be a good BI system without good EIM or data governance in place.

[…]

Facebooktwittergoogle_plusredditpinterestlinkedintumblrmailFacebooktwittergoogle_plusredditpinterestlinkedintumblrmail
FacebooktwitterlinkedinrssyoutubeFacebooktwitterlinkedinrssyoutube

Speaking at SQL Saturday 352 Sydney: ETL Architecture for Solving Data Warehouse Challenges

Hi, Thanks for all attendees to my session at SQL Satuday 352 Sydney, It was great to meet Grant, and Iman and also some Persian folks in this event. I was talking about my favorite subject: ETL Architecture for Solving Data Warehouse Challenges Session Description: Data Warehouses are heavily in use nowadays in most of Read more about Speaking at SQL Saturday 352 Sydney: ETL Architecture for Solving Data Warehouse Challenges[…]

Speaking at TechEd New Zealand 2014

It is my pleasure to speak in TechEd New Zealand 2014.  TechEd is happening between 9th to 12th of September, and it will be held in SkyCity, Auckland, New Zealand. the topic that I will talk about is:   ETL Architecture for Solving Data Warehouse Challenges Description: Data Warehouses are heavily in use nowadays in Read more about Speaking at TechEd New Zealand 2014[…]

SQL Satuarday 316: Christchurch: ETL Architecture for Solving Data Warehouse Challenges

I am honored that I will speak in SQL Saturday 316 Christchurch on 14th of June 2014. Presentation topic is : ETL Architecture for Solving Data Warehouse Challenges presentation Description: Data Warehouses are heavily in use nowadays in most of businesses around the world. Data Warehousing brings higher performance, faster and more insightful data analysis Read more about SQL Satuarday 316: Christchurch: ETL Architecture for Solving Data Warehouse Challenges[…]

ComCamp 2014; Presentation Files: Solution Architecture for Inferred Dimension Members with SSIS and MDS

Thanks to all attendees of my session in ComCamp 2014 in Auckland about Solution Architecture for Inferred Dimension Members with SSIS and MDS. Here is session Title, Description, and presentation file; Title: Solution Architecture for Inferred Dimension Members with SSIS and MDS Description: Data Warehouses are heavily in use nowadays in most of businesses around Read more about ComCamp 2014; Presentation Files: Solution Architecture for Inferred Dimension Members with SSIS and MDS[…]

Presentation Materials: TechDays Hong Kong 2014, ETL Architecture for Solving Data Warehouse Challenges

Thanks to all attendees of my session in TechDays 2014 Hong Kong about ETL Architecture for Solving Data Warehouse Challenges. Here is session Title, Description, and presentation file; Title: ETL Architecture for Solving Data Warehouse Challenges Description: Data Warehouses are heavily in use nowadays in most of businesses around the world. Data Warehousing brings higher Read more about Presentation Materials: TechDays Hong Kong 2014, ETL Architecture for Solving Data Warehouse Challenges[…]

Master Data Services Software Requirements

  In this blog posts I explain what is required for master data services to be configured on a windows (server or client) machine. Required features would be listed and how to install would be discussed in detail. Master Data Services (MDS) is part of SQL Server 2008 R2 or higher. so you would require Read more about Master Data Services Software Requirements[…]