SQL Azure Databases - Active Secondary - How to connect? - Part 2

As a continuation of "SQL Azure Databases - Active Secondary" series started earlier, this post will cover how to connect to...

Web API 2 Interview FAQs

Web API FAQs:

1.       What are the return types of Action methods in Web API?

a. Void:     If the return type is void, Web API...

Friday Reading 2017-05-26

The weather in Dublin is absolutely gorgeous at the moment so I’m not planning on spending much time inside this...

Microsoft Professional Program in Data Science – The Road So Far

I’ve currently been participating in the Microsoft Professional Program in Data Science. It’s an online curriculum of MOOCs (Massive Open...

Pester Test Inception and the Show Parameter

My fantastic friend Andre Kamman b | t  and I presented at PSConfEu last week

and whilst we were there we were...

Shipping Database Changes–T-SQL Tuesday #90

This is a good T-SQL Tuesday topic from James Anderson: shipping database changes. It’s especially poignant for me since I...

Speaking at SQL Saturday Pensacola!

I’m proud to announce that I will be speaking at SQL Saturday Pensacola on June 3rd 2017! Check out the amazing schedule!
If you don’t know what SQLSaturday is, it’s a...

Speaking at SQL Saturday Pensacola!

I’m proud to announce that I will be speaking at SQL Saturday Pensacola on June 3rd 2017! Check out the amazing...

Tuning Parallelism on SQL Server

Parallelism and MAXDOP
There’s no doubt that parallelism in SQL is a great thing. It enables large queries to share the...

Find when your SQL Server database grew

A quick post that is hopefully useful, I wanted a quick way to find the time, size of the database...