The last week in October saw the 2015 Professional Association of SQL Server World Summit take place in Seattle. Running over 3 days it covered a plethora of subjects from technical to professional development. Luckily I had landed a summit speaking…
In March this year I threw my hat in the ring to speak at the Professional Association of SQL Server Summit 2015 in Seattle. Having already decided to attend the Summit and travel from the Emerald Isle to the far…
Microsoft SQL Server 2016 CTP 2.2 introduces some interesting enhancements to Master Data Services including a plethora of optimizations such as entity attribute custom indexing, enforcing Dynamic Data Compression on IIS and entity level compression. However for the stand out update…
The next two events in the speaking calendar are in Dublin and Seattle. Dublin On Tuesday 8th September 2015 I’ll be speaking at the SQL Server Ireland User Group in Dublin on Master Data Services. There will be three other…
MS SQL Server 2016 promises some key updates for Master Data Services including sharing entities between models, publishing multiple versions of data in the same subscription view, and increased functionality in the Excel add-in. Among other things there is a plethora…
Thursday 21st May, 6pm – will be speaking at the Belfast PASS chapter at Liberty Information Technology Ltd, 24-26 Adelaide Street, BT2 8GD Belfast, United Kingdom. Title: How far can Master Data Services take your business – Deep Dive Overview: Delivering…
While working on an enterprise customer site the SQL Server security configuration required the principle of least privileges. You can of course go down the rocky road of trial and error however the SQL 2014 Database Engine Permission Poster was…
While implementing Master Data for a company in the finance industry, some limitations around the Web permissions interface became an issue. How could I get a list of all users / Active Directory Groups and their permissions per master data…
If you’re trying to open a workbook from the SharePoint 2010 PowerPivot Gallery and you get this error: Data overflow converting to the data type for table ‘xxxxxxxxxxxxx’ column ‘Tape_Date’.” This is Excel Services saying that the PowerPivot Workbook is…
Setting up MDS in a 2012 environment isn’t the most straight forward process. 2 issues I encountered while configuring on a standalone Hyper-V VM were IIS related, plus sample MDS package deployment. The following links will help to make the…