The Data Guy
- Airflow PostgreSQL to BigQuery Dynamically Generate DAGs and Tasks
- Use AWS Glue DataBrew To Remove Any Sensitive And PII Information
- Migration Journey From GreenPlum To BigQuery
- Migrate Greenplum Partitions To BigQuery With Airflow/Python
- Airflow BigQueryHook And Operator To Create Range Partition
- Airflow Custom PostgreSQL To Google Cloud Storage Operator
- Migrate 5TB ElasticSearch Cluster In GCP With Disk Snapshot
- CloudSQL Shared VPC Private IP And servicenetworking.serviceAgent role
- Access CloudSQL PostgreSQL FDW From Different VPC Or Public
- RedShift COPY Command From SCT Agent - Multiple Tables
- Backup RedShift System Tables Incrementally
- Backup RedShift Objects To GitHub With Lambda
- BigQuery Data Pipeline Without Any Orchestrator Just CloudFunction And PubSub
- GCP Convert StackDriver Log Sink As Hive Partition In GCS
- AWS RDS pg_dump ERROR LOCK TABLE IN ACCESS SHARE MODE for rds_superuser
- How To Restore MySQL Users And Passwords During Migration
- Restore AWS ElasticSearch Snapshot Failed - Index settings
- Why You Should Not Compress RedShift Sort Key Column
- Find Ghost Rows/Dead Rows For All The Tables In RedShift
- Why RedShift is showing rows_pre_user_filter is zero
- RedShift Dynamic WLM With Lambda
- RedShift User Activity Log In Spectrum With Glue Grok
- RedShift Tombstone Blocks a visual explanation
- Disk Based Queries - A Hidden Monster in RedShift
- Redshift Copy Script From Sct Agent Export S3 Part1
- Automate RedShift Vacuum And Analyze with Script
- Export RedShift System Tables And Views To S3
- Analyze RedShift user activity logs With Athena
- Reconstruct RedShift STL_QUERYTEXT using AWS Athena
- 3 Things Before Migrating To CloudSQL(MySQL)
- RedShift Reconstructing SQL from STL_QUERYTEXT
- Experimenting AWS RedShift Column Level ACL
- Internals of Google Cloud Spanner
- Debezium MySQL Snapshot For CloudSQL(MySQL) From Replica
- Setup Multi Data Center Neo4j Cluster In AWS and GCP
- Setup Neo4j Causal Cluster On GCP And AWS
- Debezium MySQL Snapshot For AWS RDS Aurora From Backup Snaphot
- Debezium MySQL Snapshot From Read Replica And Resume From Master
- Debezium MySQL Snapshot From Read Replica With GTID
- RedShift Kill All Locking Sessions On A Table
- Monitor Debezium MySQL Connector With Prometheus And Grafana
- Build Production Grade Debezium Cluster With Confluent Kafka
- RedShift Unload Like A Pro - Multiple Tables And Schemas
- Redshift Stored Procedure Comma separated string in Argument
- Where GCP Internal TCP Load Balancer Fails
- MySQL Calculate How Much Disk Space You Wasted
- BackFill Failed Delivery From Kinesis To RedShift With Lambda
- AWS Glue Custom Output File Size And Fixed Number Of Files
- RedShift Unload All Tables To S3
- How GCP Browser Based SSH Works
- CloudWatch Custom Log Filter Alarm For Kinesis Load Failed Event
- Relationalize Unstructured Data In AWS Athena with GrokSerDe
- RedShift Unload to S3 With Partitions - Stored Procedure Way
- MySQL Convert Binlog Based Replication To GTID Replication Without Downtime
- MongoDB Add Node To Replica Set Without Initial Sync In GCP/AWS
- Database Mirroring is still a Mystery
- Monitor Cassandra Clusters with Percona PMM - JMX Grafana and Prometheus
- MySQL PITR The Fastest Way With DevOps
- MySQL Exact Row Count For All The Tables
- MySQL With DevOps 1 - Automate Database Archive
- Create Aurora Read Replica With AWS CLI/Lambda Python
- AWS DocumentDB - A NoSQL Equivalent For Aurora
- Automation Script For Percona Xtrabackup FULL/Incremental
- RunDeck Series 5 - Encrypt Key Files And Passwords In RunDeck
- RunDeck Series 4 - Configure RunDeck SMTP With AWS SES
- RunDeck Series 3 - Configure Nginx ProxyPass For RunDeck
- RunDeck Series 2 - Add Nodes to the Rundeck
- RunDeck Series 1 - Install And Configure RunDeck 3.0 On CentOS 7
- Archive MySQL Data In Chunks Using Stored Procedure
- Internals Of Google DataStore And Technical Overview
- MySQL GTID vs MariaDB GTID
- How To Convert MySQL Two Digit Year To Four Digit Year
- Automate AWS RedShift Snapshot And Restore
- AWS Athena Automatically Create Partition For Between Two Dates
- Automate AWS Athena Create Partition On Daily Basis
- Automatically Add EC2 Instances to Active Directory Domain
- How To Migrate PostgreSQL Users To AWS RDS PostgreSQL
- Why Windows Server 2016 In AWS Unable To Resolve Public And Local DNS
- Automatically Enable CDC In RDS SQL Server
- Don't Use AWS AMI To Backup Your EC2 Database Server
- How To Restore Corrupted System Databases
- Configure Bucardo replication on CentOS
- Postgresql Insecure directory in ENV PATH - Unable To Start
- How To Change MySQL Default Data,Binlog,Error Log Directories
- Compare Two SQL Server Databases using Tsql
- How To Install Oracle 12C on Amazon Linux In Silent Mode
- What Is AWS Aurora Database Clone
- SQL Server All In One Security Audit Script
- How To Map Linux Users To Postgres User
- SQLServer Backup with dbatools vs Olahallengren