Monthly Archives: February 2018

Classifying Data with SSMS 17.5

Posted on February 20, 2018 by way0utwest

I upgraded SSMS to 17.5 recently and found an interesting addition. This version has incorporated the ability to classify data. With the GDPR coming for many of us, this is a welcome addition. This is a quick look at this … Continue reading →

Posted in Blog | Tagged , , , | 4 Comments

Virtual Data

Posted on February 20, 2018 by way0utwest

Yesterday I republished an editorial from 2014 for the holiday. The topic was production subsets of data, which has been something that many data professionals have struggled with for years. Many of us have built scripts to delete, change, obfuscate, or alter … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on Virtual Data

Use the Proper User for Azure MySQL DB

Posted on February 20, 2018 by way0utwest

I wrote about migrating the MySQL database from a third party provide to Azure MySQL DB recently. This was due to the provider raising the price substantially for me to host the site. However, after migrating the data, I ran … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

dbatools and Orphaned Users

Posted on February 16, 2018 by way0utwest

I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and incredibly useful for migrations between SQL Servers, but also for various administrative actions. I have a short series on these … Continue reading →

Posted in Blog | Tagged , , | 1 Comment