The JusDB Database Engineering Blog

A step-by-step guide to migrating an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server — covering native backup/restore via S3 with the rds_restore_database stored procedure, AWS DMS full-load + CDC for near-zero downtime, option group and IAM setup, cutover, and post-migration hardening.

The decision matrix for the three Azure SQL flavors: eight constraints (cross-DB queries, SQL Agent, CLR, linked servers, networking, licensing…) that pick Managed Instance vs Azure SQL Database vs SQL Server on Azure VM, with a cost comparison and migration paths.

Production setup of Ola Hallengren's SQL Server Maintenance Solution: the four jobs that matter, FULL/DIFF/LOG backup cadence for your RPO, DBCC CHECKDB scheduling, IndexOptimize tuning, encryption, and CommandLog-based alerting.

Read SQL Server wait stats like a senior DBA: the four DMV sources, the eight wait types that cover 95% of incidents (PAGEIOLATCH, LCK_M, CXPACKET, WRITELOG…), and the remediation for each. A 30-minute diagnostic workflow from page to plan.

Comprehensive PostgreSQL guide covering MVCC, extensions, partitioning, logical replication, and performance tuning. Learn why PostgreSQL powers modern applications.

Everything you need to know about MySQL: storage engines, replication topologies, performance tuning, and cloud deployment. From basics to advanced optimization.

Navigate the open source database landscape. Compare MySQL, PostgreSQL, MongoDB, Redis, and Cassandra with detailed feature analysis and selection criteria.

Use PostgreSQL range types (daterange, tstzrange) and exclusion constraints to prevent overlapping bookings and schedules. Includes room booking, multirange types, and GiST index examples.

Master PostgreSQL window functions: ROW_NUMBER, RANK, SUM OVER, LAG/LEAD, moving averages, and frame clauses. Real SQL examples for analytics and reporting queries.

Understand the differences between OLAP and OLTP systems — query patterns, storage engines, and when to use a hybrid approach

Use dbt to build modular SQL transformations — models, tests, documentation, and CI/CD for your data warehouse

Query remote PostgreSQL and MySQL databases from PostgreSQL with Foreign Data Wrappers. Covers postgres_fdw setup, IMPORT FOREIGN SCHEMA, and EXPLAIN pushdown verification.