Use PowerShell to script existing Availability Group creation scripts!

Scripts that write scripts! One of my favorites!
So last night I was up working on an issue with an Availability...

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...

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...

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...

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...

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...

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...

SQL Developer Edition is now free!!!

Announced on 3/31/2016 SQL Server Developer Edition is now free and available as a download to all who have signed...

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...