Apress April Fools 40% Discount Promo & Healthy SQL

April 1, 2015 – I am delighted to take part in the April
Fool’s Promotion by Publisher Apress, who are
featuring some of...

Exam Prep 70-463: Logging in SSIS 2012

This post is part of a series on this blog that will help me, and hopefully you, pass exam 70-463: Implementing...

How to import Extended Events session file target and parse deadlock-graph / Import von Extended Events Ereignisdateien und Parsen von Deadlock-Graphen

Microservices and Databases

I ran across a post on microservices recently and was intrigued. I always like the idea of loosely coupled, independent...

Parsing XML Child Nodes and Converting to DateTime with PowerShell

As part of my organiser role for SQLSaturday Exeter (Training Day Information here and Saturday Information here) I needed to...

PASS Board Update: March 2015

Hello all,
It’s been a while since my last update. Sorry. I’ve just been traveling and presenting and working on books...

Creating a large data warehouse in Azure

Microsoft Azure provides you two options when hosting your SQL Server-based data warehouse: Microsoft Azure SQL Database and SQL Server...

Intro to SQL Server Automation with PowerShell

March 26th, 2015, a date which will live in infamy!
Well, at least for me it will. March 26th, 2015...

Latches, Spinlocks & Lock-Free Data Structures Recording

A few weeks ago I have spoken at the SQLRally Nordic conference in Copenhagen about Latches, Spinlocks, and Lock-Free Data...

Outlier Detection with SQL Server, part 4: Peirce’s Criterion

By Steve Bolton
…………In the last couple of installments of this amateur series of self-tutorials on outlier identification with SQL Server,...