Migration to a new data platform can be a complex and time-consuming process. To ensure a successful migration, it's important to have a well-defined plan and a checklist in place. In this blog, I will outline my own Snowflake migration checklist created based on my experience helping customers migrating their workloads to Snowflake, a cloud-based … Continue reading The ultimate Snowflake migration checklist
Tag: Migration
Online Data Migration from SQL Server to Cloud Spanner using Striim
This post will focus on the implementation of a continuous migration from SQL Server to Cloud Spanner using Striim. The explanation will include steps for configuring and initial load and a continuous data replication using Change Data Capture. this is enablement post and doesn't talk about a full scale database migration and its challenges. This … Continue reading Online Data Migration from SQL Server to Cloud Spanner using Striim
T-SQL to script out logins and permissions of all databases
T-SQL to script out logins and passwords for the SQL server instance. Can be useful for taking backups for your logins and DB permissions and can also be useful for migrating logins and permissions. Note: In SSMS, check the “Maximum number of characters displayed in each column” settings before executing the below script. It is defaulted … Continue reading T-SQL to script out logins and permissions of all databases
The 'Cloud' Workbook 