Data Warehousing Explained

Why Warehouse
Data warehousing is the act of transforming application database into a format more suited for reporting and offloading it...

Friday Reading 2017-05-12

The weather this week in Dublin has been absolutely fantastic, please hold out for the weekend. Anyway, whilst I’ve been...

How Can I Get Accepted to Speak at the PASS Summit?

There has been some discussion and concern over the changes to the speaker selection process for the PASS Summit. I’ve...

Microsoft Build event announcements

Another Microsoft event and another bunch of exciting announcements.  At the Microsoft Build event this week, the major announcements in...

Quick Graph Database

There’s a sample to work through here: https://docs.microsoft.com/en-us/sql/relational-databases/graphs/sql-graph-sample
I decided to try this in CTP2 and just see how it works....

Simple Security Report

Quite a while ago I created a couple of little security scripts to help me out with permissions research. Over...

Speaking at Charleston PASS on May 18, 2017

During the day of the 18th I’ll be at the Syntax Code and Craft Conference in Charleston, SC. That evening...

Azure Data Factory and the Case of the Missing JRE That Wasn’t

On a recent project I used Azure Data Factory (ADF) to retrieve data from an on premises SQL Server 2014...

Creating an Azure SQL Database via PowerShell

This post is about using the brilliance of PowerShell to script the creation of databases in Azure.

Background:
Apart from the obvious question...

DevOps Basics–Creating a local repo and committing files

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...