Following on from my recent presentation at the virtual Munich Data Modeling Meetup on how to optimize the Data Vault architecture on Snowflake, along with the session recording, the SQL scripts are now available.
With the acquisition of Numeracy in March 2019, Snowflake took a step towards enhancing the Snowflake Cloud Data Platform web user experience. This is in the form of a new offering called Snowflake Snowsight.
Do come join me on the 25th May at the Microsoft Community Café to walk through the architectural principles of the Snowflake cloud data warehouse, the enhanced PowerBI Snowflake connector, and see both PowerBI and Snowflake in action.
Recently I gave an interview on Graph databases to Great Data Minds’s Mike Lampa and Kalia Garrido. Areas covered included an introduction to Graph databases, use cases, anti-patterns, the hype, and what have they got to do with Kevin Bacon?…
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…