How to Load XML Data Files using the SSIS Script Component.

One of the common source data files that every ETL Developer/Architect will have to grapple with every now and then...

Reporting Services 2016 – Back in the game: the new capabilities & features // Zurück im Spiel: die neuen Möglichkeiten und Features

(DE)
Meine letzten Veröffentlichungen und Vorträge zu Reporting Services sind schon Jahre her. Kein Wunder, denn seit dem 2008 R2-Release...

Speaking at SQL Saturday #487 in Ottawa on April 16, 2016

If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...

Speaking at SQL Saturday 487 in Ottawa on April 16, 2016

<img alt=’’ class=’alignright size-full wp-image-1238 ‘src=’/img/2016/04/img_570152b22dc45.png’>
If you are a SQL Server professional and are interested in spending a day...

SQL Server 2014 - Cardinality Estimator - Part 1

It has been a while since I blogged. Just moved to few other mediums like speaking at user group and...

SQL Server Select – Back to Basics

Of all the fundamental concepts within SQL Server, nothing is potentially more basic and fundamental than the often overlooked Select statement.
Related Posts:

Changing Default Logs Directory - Back to Basics...

SQL Server Select – Back to Basics

Prelude in SQL Minor
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to...

Failed to Initialize SQL Agent Log... not worthy

Moving system databases in SQL Server takes a bit of practice. I got that again, along with a dose of...

Hidden code in AdventureWorks

I’ve playing around with AdventureWorks and managed to found some hidden code! Truly odd stuff. I’m so shocked I couldn’t...

How to Use Data to Improve Student Outcomes with Microsoft Power BI

Almost fives months ago I joined Microsoft as a Data Platform Solutions Architect. As a DPSA for Microsoft, I am...