RegEx in SQL Server for replacing text

In this post, I’m presenting usage of two functions that use Regex. My previous post was about searching text in...

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

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