PSConfAsia 2016

I have just got back to the UK from Singapore following the amazing PSConfAsia conference. I must say that Matt,...

Query Store – Part 2 - Configuration Settings

Introduction to Query Store covered here.
Now for the second part on “How to Configure?”

Query Store is configured at the...

Reading a SharePoint 2007 List from SSIS 2016

It's been a while, but since I now get to play with SQL 2016 full time, I have new things to talk about!  One of major difficulties that any technology...

Reading a SharePoint 2007 List from SSIS 2016

It's been a while, but since I now get to play with SQL 2016 full time, I have new things...

Seattle SQL Pro Workshop 2016

Free workshop on SQL Server leading up to Summit 2016 that will provide attendees an alternate means to increase affordable learning opportunities during the week.
Related Posts:

Seattle SQL Pro Workshop...

Seattle SQL Pro Workshop 2016

Seattle SQL Pro Workshop 2016
You may be aware of an event that some friends and I are putting together during...

Synchronous vs Asynchronous

You’ll hear these terms thrown around in programming all the time, but what do they mean and why do we...

The dark side of Fn_dump_dblog

I want to show you what happens when you keep using the undocumented fn_dump_dblog function. (For example if you are...

Using TRY..CATCH in SQL Prompt

I learned something new recently about SQL Prompt. I was working on documenting and experimenting with snippets and found a...

Master Data Services error – Cannot read configuration file due to insufficient permissions

In preparation of my upcoming webinar on the new features of Master Data Services 2016, I installed MDS on my...