Security

Photo by @russn_fckr / Unsplash.com

Anonymizing and masking sensitive data in SQL databases before migrating to Azure SQL

Many companies I interact with have expressed an interest in migrating their legacy SQL Server databases to Azure. Typically this is due to End of Life for SQL Server 2008 (and 2008 R2) and other times it’s a desire to perform reporting and analytics on existing data in the cloud. (I wrote about migrating to Azure SQL previously here) Mostly this is all documented nicely… Read More »Anonymizing and masking sensitive data in SQL databases before migrating to Azure SQL
Photo by Rubén Bagüés @rubavi78 / Unsplash.com

One password to rule them all: Migrating to 1Password from KeePass and text files

I can’t quite remember when I started using a password manager, or which password manager it was at the time. As an IT Pro I’ve used everything from text files stored on Windows Desktop to encrypted Excel files to post-it notes to reusing the same password (“R3member1”, “R3m3mber2”..) to forgetting my password and resetting it. Repeatedly. I left Microsoft exactly 10 years ago, and we… Read More »One password to rule them all: Migrating to 1Password from KeePass and text files
Photo by @florianklauer / Unsplash.com

Building a secure remote access solution for Azure-based virtual machines using Azure AD and Windows Admin Center

I’ve had some fun times lately with Azure. It seems there really is a second wave of adoption for cloud-based infrastructure and services from organizations. This is especially true in the Nordics, where Azure is commonly accepted as a trusted option for datacenters and PaaS services. This post stemmed from the idea of figuring out what options do we have for accessing and managing virtual… Read More »Building a secure remote access solution for Azure-based virtual machines using Azure AD and Windows Admin Center