LocalDB DSC Script

Hello!
So, there are many different product SKUs of SQL Server available, and generally when developing it’s probably best to use...

SSRS Report Deployment Made Easy – 700 times Faster

Back in October 2016, Microsoft started a new GitHub repository – ReportingServicesTools – an open source PowerShell module to manage SQL Server...

Update SSMS With PS1

With how many updates are coming out I threw together a script to parse the latest version from the webpage,...

Don’t Forget the Keys

I was recently given the nod to upgrade my monitoring server from SQL Server 2012 (SP 3) to SQL Server...

My Most Embarrassing SQL Moment

T-SQL Tuesday #92: Lessons Learned the Hard Way

This post is a response to this month's T-SQL Tuesday prompt. T-SQL Tuesday was created by Adam Machanic and is a way for...

One day of „In-Memory Technologies in SQL Server – From 0 to Operational Analytics Master“ at Data Platform Summit 2017 in Bangalore/India and further conferences this summer

Ein Tag “In-Memory Technologien im SQL-Server – von 0 zum Operational Analytics Master” beim Data Platform Summit 2017 in Bangalore/Indien und auf weiteren Konferenzen diesen Sommer

(EN) It is no...

One day of „In-Memory Technologies in SQL Server – From 0 to Operational Analytics Master“ at Data Platform Summit 2017 in Bangalore/India and further conferences this summer

Ein Tag “In-Memory Technologien im SQL-Server – von 0 zum Operational Analytics Master” beim Data Platform Summit 2017 in Bangalore/Indien und...

Power BI Custom Visuals Class (Module 57 – Infographic Designer)

In this module you will learn how to use the Infographic Designer Custom Visual.  The Infographic Designer give you the...

Save and save often

It’s the second Tuesday of the month, and as I’m sure you remember that means it’s time for T-SQL Tuesday!...

Streaming ETL: SQL Change Data Capture (CDC) to Azure Event Hub

[read this post on Mr. Fox SQL blog] I had a recent requirement to capture and stream real-time data changes on several SQL database tables from an on-prem SQL Server to Azure for...