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…
Speaking in Seattle
Microsoft SQL Server 2016 CTP 2.2 syncs MDS
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…
Upcoming speaking events – Dublin & Seattle
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…
Microsoft SQL Server 2016 Ignites Master Data Services
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…
Speaking schedule update – Master Data Services
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…
SQL Server 2014 Database permissions poster ensures swifter UAT
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…
MS SQL Server 2012 Master Data Services – list all user / group permissions using TSQL
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…
PowerPivot – “Data overflow converting to the data type for table ‘68868d91-787b-49fa-bb65-fa1cc475c3c8’ column ‘Tape_Date’.”
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…
Getting started with Master Data Services in SQL Server 2012
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…
More BI videos – Ad-hoc reports, Data Mining
Data Mining: http://youtu.be/YrnD46xMFNk Ad-hoc reports : http://youtu.be/RWjUYpwOx70