Jussi Roine
Home About Me Contact
Home About Me Contact

data management

Browse posts in this collection.

After deactivating my Facebook account 3 years ago, I've now deleted it

After deactivating my Facebook account 3 years ago, I've now deleted it

December 28, 2021

Readers interested in digital minimalism will find value in my journey from deactivating to finally deleting Facebook after three years. I explain how shifting to more controlled platforms like WhatsApp and Signal helped me reclaim my attention and data without losing essential connections.

An early look at the EU Data Boundary

An early look at the EU Data Boundary

December 21, 2022

If you conduct business in the EU or EFTA area, you need to understand how Microsoft’s newly announced EU Data Boundary affects your data residency and compliance. I explore what this commitment means for Azure, Dynamics 365, and other services, clarifying that it is a documented process rather than a new tool, and highlighting why your data may still leave the region despite specific configurations.

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

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

March 13, 2019

If you are planning to migrate legacy SQL Server databases to Azure, this post explores practical methods for anonymizing sensitive data within your on-premises infrastructure before moving it to the cloud. I walk through my experience setting up a local test environment with the AdventureWorks sample database and demonstrate how PowerShell can be used to effectively mask personally identifiable information while keeping costs in mind.

Are you building sustainable and long-lasting IT solutions?

Are you building sustainable and long-lasting IT solutions?

September 7, 2020

When a former colleague asked me to fix a decade-old backup script I wrote as an employee, I was reminded of the unrealistic expectations often placed on IT professionals regarding long-term maintenance. This experience highlights the importance of setting clear boundaries and understanding that true sustainability comes from proper system lifecycle management, not personal pride or unpaid warranty work.

Backing up PostgreSQL databases in Azure

Backing up PostgreSQL databases in Azure

January 19, 2022

If you need to understand the non-trivial process of securing PostgreSQL backups in Azure, this post details my journey from testing environments to critical production systems. I walk you through the necessary components like Backup and Key Vaults, along with the specific permission scripts and credential storage steps required to execute reliable backups.

← 1 2 3 4 5 →
Jussi Roine

Jussi Roine

Microsoft MVP and consultancy founder with 30+ years of experience, passionate about Microsoft security, AI governance, and sharing what I learn along the way.

Tags

azure productivity microsoft 365 homelab windows cloud computing software development security data management sharepoint networking automation microsoft teams cybersecurity certifications virtualization macos power platform ai and machine learning docker identity management power automate artificial intelligence azure openai devops c# powershell linux serverless containers
Jussi Roine

Microsoft MVP and consultancy founder with 30+ years of experience, passionate about Microsoft security, AI governance, and sharing what I learn along the way.

© 2026 Jussi Roine. All rights reserved.