Database & Data Engineering Blog

Maximizing Uptime: Achieving Minimal Downtime during Aurora PostgreSQL Upgrades

A practical guide to planning and executing Amazon Aurora PostgreSQL version upgrades with minimal downtime and risk. Get insights from GeoPITS's DBAs.

SQL Server 2025: Modernizing Database Administration for the AI Era

Discover how SQL Server 2025 modernizes database administration with AI-driven features built for the AI era. GeoPITS's managed DBA team explains more.

How to connect to the contained database without creating the login and user on secondary instance

Learn what contained databases are in SQL Server, their benefits for portability, and how to configure them step by step. GeoPITS's DBA team explains it.

MongoDB Aggregation Framework

Learn how the MongoDB aggregation framework and pipeline work, with examples of common stages and use cases. GeoPITS's managed DBA team explains more.

ENHANCEMENTS OF ALWAYSON AVAILABILITY GROUP IN SQL SERVER (2012-2017)

A look at the key enhancements to Always On Availability Groups across SQL Server 2012, 2014, 2016, and 2017 releases. Get insights from GeoPITS's DBAs.

MongoDB Change Streams: Real-Time Data Changes for DBA's

Learn how MongoDB change streams enable real-time data streaming and event-driven applications built on your database. Get insights from GeoPITS's DBAs.

MongoDB and CAP Theorem

Understand the CAP theorem and how it applies to MongoDB's consistency, availability, and partition tolerance tradeoffs. GeoPITS's DBA team explains it.

Queryable Encryption in MongoDB

An introduction to MongoDB's Queryable Encryption feature, how it protects sensitive data, and how to get started. Get guidance from GeoPITS's DBA team.

Important aspects of database security

Explore the key aspects of database security every organization should address, from access control to encryption and auditing. GeoPITS's DBAs explain.

How to copy multiple tables from one database to another database using import/export wizard

Learn how to copy multiple tables from one SQL Server database to another using the built-in Import and Export Wizard. Get insights from GeoPITS's DBAs.

Resources for Modern Enterprise Teams

Data Migration & CDC from MySQL to VeloDB vs ClickHouse: Data Migration & CDC Compared

DPDP Act Compliance for BFSI: Requirements, Checklist, and Audit Readiness Steps