Dir2Dac and github2dacpac - create dacpacs from script folders or the internet

I like writing go (golang not the batch separator) and one of the things that I like is that if you want to use something from github you literally...

SSMS 2016 – Compare Execution Plans

Microsoft are releasing regular CTP updates for SQL Server 2016. In the very recent release (CTP 2.4), there is a...

Copying data from Azure Blob Storage

In a previous blog I talked about copying on-prem data to Azure Blob Storage (Getting data into Azure Blob Storage). ...

My PASS Summit 2015

Its just a bit over a week until PASS Summit 2015 will start. If you are a Microsoft Data Platform...

Better Practices for Reading Event_file Targets

In this article, I am going to address some better practices for Reading Event_file targets attached to an XEvent Session.
Related Posts:

How to: File Target use in Extended Events December...

Better Practices for Reading Event_file Targets

I have demonstrated over the past couple of articles the basics involved with reading the

event_file target along with a more...

“That little green arrow.” or “My code used to work but now I’m getting a debug error.”

If you’ve worked with SSMS for any length of time this will look awfully familiar:
SSMS 2008R2

SSMS 2012 +

This little green...

Presentation Design – Before and After

Recently I gave a session on the SQL Server Days about the new features for business intelligence in SQL Server...

SQL server Encryption – Transact SQL Functions.

In the previous blogs we came across various encrypt functions like ENCRYPTBYKEY(),ENCRYPTBYASYMKEY(),ENCRYPTBYCERT().We also saw the corresponding decrypt functions likeDECRYPTBYKEY(),DECRYPTBYCERT(),DECRYPTBYASYMKEY(),DECRYPTBYCERT(),We shall...

Speaking at SQLSaturday #459, Madrid 2015

Glad to share that I have been picked up to speak at Spanish SQLSaturday for the second time in a...