Recently I developed a few PowerShell commands to make it possible to enable data masking for databases.

The commands were originally written for the module PSDatabaseClone to enable users to automatically mask the data for a database image.

The reason the commands were created was that the cloning process would otherwise expose production data to other users which is not preferable.

The commands were released and picked up by Chrissy LeMaire who implemented them in dbatools and even improved them.

This month’s TSQL Tuesday is hosted by Malathi Mahadevan (w | t) and she asks us to write about one thing you want to learn that is not SQL Server.

As a database administrator in SQL Server you might think it’s easy to think we only deal with that technology. But the role of the database administrator has been changing for a while now and we need to know more about other technologies besides SQL Server.

There must be 100 articles about this subject but I always like to talk about things that happen to me or where I have an opinion.

I was reading a blog post by Ben Kubicek about allowing failure and I agree with a lot of things.

I’m a parent of two adorable kids. The oldest is 4 years old and the youngest is almost 2. The youngest one is walking around but the oldest will not stop running, climbing on stuff, and seeing how far she can go.

On Monday, October 1st, 2018 I was awarded the Cloud and Datacenter Management MVP award.

I did not know about it until a few days after because I was busy renovating my office. During the renovation, I did not regularly check my e-mail and the notification slipped through the cracks.

Two days later at 6 AM, I checked my e-mail and jumped up. I saw an email that started “Congratulation…” from the MVP Global Administrator. I got the MVP award.

The Problem

In my daily work I have to work with a lot of SSRS (SQL Server Reporting Services) reports that have either stored procedures, queries, or dynamic queries to get all the results.

Troubleshooting dynamic SSRS queries can sometimes be difficult. That is especially the case when you’re dealing with multiple hundreds of lines of code all generated dynamically.

An example of such an error is: