There Is a Magic Button, a Rant

OK guys. I think it’s way past time. A bunch of us have been keeping a secret from the rest...

SQL Server Express v SQL Server Developer Edition

SQL Server Express v  SQL Server Developer Edition

Over the weekend I received the following in an email from Ali Ahmad...

Connect to Microsoft Azure Subscription using Windows PowerShell – Part 1

Hello friends, in this blog we will learn how we can connect to Azure Subscription using PowerShell. As you know...

Streaming Reporting: SQL Change Data Capture (CDC) to Power BI

[read this post on Mr. Fox SQL blog] Extending on my previous post about redirecting SQL CDC changes to Azure Event Hub, I have had a few people ask for details/options...

Streaming Reporting: SQL Change Data Capture (CDC) to Power BI

[read this post on Mr. Fox SQL blog]
Extending on my previous post about redirecting SQL CDC changes to Azure Event Hub, I...

Automating tSQLt Unit Tests

This is the ninth part in the series: SQL Server and Continuous Integration. In this post I’ll add some unit tests...

Power BI Custom Visuals Class (Module 62 – Beyondsoft Calendar)

In this module you will learn how to use the Beyondsoft Calendar Custom Visual.  The Beyondsoft Calendar displays a single...

Start Your Engine’s with Startup Procedures

After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up...

Start Your Engine’s with Startup Procedures

After reviewing some recent audit results for a couple of our SQL Servers, I noted the audit checked for start up...

Need to output CSV, TSV, or other?

Ever have the need to create a CSV list in SQL Server? Not sure how? Starting in SQL Server 2017...