Split Function in SQL Server 2016

Posted by on Mar 4, 2016 in SQL Server 2016 | One Comment

It was about 4 years ago that I’ve wrote a custom function to split a delimited string in T-SQL. I’ve wrote that because there was no split function for SQL Server at that time. Fortunately SQL Server 2016 comes with new excitements, and built-in split function is one of them. The new String_Split function is ...

Read More

Change Set and Approval Workflow in MDS 2016

Posted by on Dec 8, 2015 in MDS | 3 Comments

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

SSIS Catalog Changes in 2016

Posted by on Dec 4, 2015 in SSIS, SSIS Catalog | One Comment

SQL Server 2016 brings some new features for Integration Services such as AlwaysOn, and Custom Advanced Logging. You’ve probably read about these features in other blog posts, If you haven’t I encourage you to read some of them, like this. These changes also comes with some changes in SSIS Catalog, in this post I’m going ...

Read More

SSIS 2016; What’s New in CTP 2.3

Posted by on Sep 6, 2015 in SQL Server 2016, SSIS | 4 Comments

SQL Server 2016 is under a heavy improvement plan, The latest CTP version (Community Test Preview) of it is 2.3 which released as preview three days ago. CTP 2.3 has some new features across all components of SQL Server, such as SSRS, SSAS, SSIS, MDS and etc. Previously I wrote about some new changes in ...

Read More

MDS 2016: What’s New in CTP 2.2

Posted by on Aug 4, 2015 in MDS, SQL Server 2016 | One Comment

On Late May when CTP 2.0 of SQL Server 2016 published, I’ve wrote a blog post about What’s New in MDS 2016. Recently CTP 2.2 has been published, and I’ve seen some new features again added to MDS. In this post I’ll explain new features of MDS 2016 CTP 2.2 which are; Entity Sync SCD ...

Read More

What’s New in MDS of SQL Server 2016

Posted by on May 28, 2015 in MDS, SQL Server 2016 | 6 Comments

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. ...

Read More