SQL Server

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 on docs.microsoft.com (Dynamic Data Masking, Static Data Masking) but what isn’t clear to me is how to best anonymize and/or mask sensitive data before migrating to Azure. This is typically something that companies need to perform in on-premises infrastructure before moving a database outside the perimeter network. So I set to work and spent some… Read More »Anonymizing and masking sensitive data in SQL databases before migrating to Azure SQL
Photo by Dan Gold @danielcgold / Unsplash.com

Tracking, resolving, storing and presenting AKA.MS short links from social media using Serverless capabilities in Azure

I think I’ve written once or twice I’m a great fan of building Proof of Concepts and prototypes. This allows me to rapidly learn without fear or risk of failing in front of an important customer. And all customers who pay for your time are important, of course. I’ve long admired the fantastic AKA.MS short links service Microsoft has internally created for their employees. Or that’s my understanding, as I see only Microsoft FTEs posting shortened URLs such as http://aka.ms/surfacethewomen (a great campaign, by the way!) on social media and sometimes also on docs.microsoft.com. Note: I have no access, direct or indirect information about AKA.MS other than what I see publicly being used on social media. This post is based… Read More »Tracking, resolving, storing and presenting AKA.MS short links from social media using Serverless capabilities in Azure
Image by Samuel Zeller @samuelzeller / Unsplash.com

Migrating SQL Server 2008 databases to Azure SQL

“This is a quick one”, I thought. A customer asked me to have a look at their old CRM environment, that was running in a local physical server in their datacenter. The plan was to decommission the server, but rescue the CRM database. I knew I could lift-and-shift the database or databases to Azure SQL quite easily. This post walks through my experience and some of the challenges I encountered. Provisioning Azure SQL I received the source database as a traditional SQL Server backup, a .BAK file. It was compressed but still considerable big at 11,6 GB. I provisioned a new managed SQL Server in Azure. Not the Managed Instance, as I feared it would be too expensive to maintain… Read More »Migrating SQL Server 2008 databases to Azure SQL