SQL Server 2014 - In-Memory OLTP End-to-End - Preparing for Migration
Explore SQL Server 2014's In-Memory OLTP feature, its performance benefits, and learn how to plan and execute a successful migration using a sample workload demonstration.
Perfect Fits for Azure SQL Database Migrations
Explore Azure SQL Database migrations, including challenges, limits, and best practices for new projects, instrumentation, web apps, parallel processing, and data warehousing.
Winning with Column Store in SQL Server 2016 - A Customer Story
Explore SQL Server 2016's Column Store feature through a real customer migration case, covering challenges, best practices, and performance improvements in data warehousing.
Modernize Data Platform
Explore key considerations and implementation approaches for migrating on-premise databases to Azure, setting up a modern data platform, and utilizing Azure Database Migration Service.
Modernizing SQL Server
Explore free Microsoft tools for successful SQL Server upgrades, covering compatibility, migration, assessment, and optimization strategies for modernizing your database infrastructure.
End of Support for SQL Server 2008R2 - 20 Years of PASS
Detailed guide on migrating SQL Server 2008/R2 to Azure, covering migration lifecycle, tools, and strategies for near-zero downtime transitions as end-of-support approaches.
SQL Managed Instance - A Fully Managed SQL Server in the Cloud
Explore Azure SQL Managed Instance's features, benefits, and migration best practices. Learn about architecture, pricing, and disaster recovery for efficient cloud-based SQL Server workloads.
Embracing Database DevOps through CI/CD
Learn to implement Database DevOps using SQL Server containers, Flyway, Kubernetes, and Azure DevOps. Explore strategies for efficient database migrations and build your first CI/CD pipeline for database deployment.
Migrating Hundreds of SQL Server Instances to Azure at Scale
Learn strategies for migrating large numbers of SQL Server instances to Azure efficiently, including services, components, and automation techniques for minimal downtime and maximum scalability.
Core Data Migrations - Can We Do Better?
Explore Core Data migration strategies, from lightweight to custom, and discover a NoSQL alternative that eliminates data model requirements for easier schema changes.
Vitess Intro - How to Migrate a MySQL Database to Vitess
Explore Vitess for MySQL database scaling: architecture overview, feature highlights, and live migration demo. Learn to retrofit scaling into existing systems seamlessly.
Codename VIFL - How to Migrate MySQL Database Clusters to Vitess
Learn how Slack migrated petabytes of data to Vitess with zero downtime using a transparent, application-agnostic framework. Discover strategies for seamless large-scale database migrations.
Migrating Shopify's Core Rails Monolith to Trilogy
Explore Shopify's migration from Mysql2 to Trilogy, covering MySQL protocols, Active Record adapters, and open source contributions. Learn about implementation challenges and the impact on Shopify's monolith.
Build Software Like a Bag of Marbles, Not a Castle of LEGO
Explore modular software design for easy feature addition/removal. Learn to structure WebAPI, Entity Framework, and database migrations for flexible, loosely-coupled systems.
Migrating to Microservice Databases - From Relational Monolith to Distributed Data
Explore strategies for migrating from monolithic databases to microservices architecture, covering consistency, CQRS, event sourcing, and integration techniques for zero-downtime transitions and data management.
Driving the Future of PostgreSQL Adoption
Explore strategies for accelerating PostgreSQL adoption and shaping its future in the database landscape.
Go Concurrency Powering Gigabyte-Scale Real-World Data Pipeline
Explore Go concurrency techniques for building high-performance data pipelines, focusing on MongoDB to RDBMS migration and optimizing worker pools for gigabyte-scale data processing.
Bringing MongoDB Workloads Back to Open Source
Explore how to migrate MongoDB workloads to open-source alternatives, enhancing data control and reducing vendor lock-in.
Major Migrations Made Easy
Discover strategies for simplifying major software migrations, enhancing efficiency and reducing risks in large-scale development projects.
SQL Server 2022 Migrations with dbatools
Migrate databases to SQL Server 2022 using dbatools, streamlining the process with PowerShell automation for efficient and seamless upgrades.
Crossing The Streams - Adding PostgreSQL to Your SQL Server Skillset
Expand your database management skills by learning how to incorporate PostgreSQL alongside SQL Server, addressing the growing need for multi-platform expertise.