Manually updating Statistics

Even though SQL Server automatically updates statistics in the background for you, you may find there are times when you...

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