Introduction AWS Appflow is a new data integration service which as the tagline states, securely integrates apps and automates data flows at any scale, without code. It offers a variety of features such as: Point and click user interface Native…
Yesterday I attended the Great Data Minds debate on the pros and cons of different data architectures. The panel: Hans Hultgren: CEO, Genesee Academy – defending DataVault Scot Reagin: CEO, Sensible Data Integrations – defending Traditional Tyler Allbritton: Managing Director,…
At the beginning of this year I became an Associate Faculty with the School of Computing at the National College of Ireland. The College augments it’s full time staff roster with experts from industry in a part time lecturing capacity.…
Graph databases are made up of nodes, edges (relationships between nodes), and properties. Patterns are identified by searching or “traversing” the graph, and use cases include recommendation engines, social networks, and fraud detection. Microsoft have made Graph Database functionality available…
Microsoft SQL Server Master Data Services 2016 (MDS) provides comprehensive permissions configuration functionality, from the functional permissions level right down to column and row level. However there are a few gotchas that if you are aware of up front, will…
Tues 6th Dec-2016 – SQL User Group – Christmas Lightning Talks Extravaganza – SQL Server and Data Lineage Tues 6th Sept-2016 – Dublin SQL Server User Group, Sandyford, Dublin – What’s new in SQL Server 2016 – MDS Sat 18th June 2016…
The 2015 SQL Server Ireland User Group Lightning Talks extravaganza took place at Microsoft in Sandyford last Tuesday evening. 10 local speakers lined up to test their speaking skills and share their MS SQL Server knowledge while keeping one eye…
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…