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…
Upcoming speaking events
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…
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…
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…
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…
RAID 5 vs. RAID 10
The following is a brief description of 2 of the main types of disk configuration you will deal with; RAID 5 and RAID 10. A notable differences is performance. In both cases disks are striped which at a high level means…
The server response was: 5.7.1 Unable to relay
SQL Server Database Mail has been configured correctly, but while trying to send a test email, an error is logged in the DatabaseMail log: The server response was: 5.7.1 Unable to relay After checking the mail log (Management studio –>…