There are currently three deployment options for SQL Server Database on the cloud. Well, four, if you count Azure SQL Databases in elastic pool. But Azure SQL DB in elastic pool is essentially just Azure SQL Databases grouped into an…

This article is about working effectively with multiple OCI Environments via OCI CLI and encourages the use of an environment variable file called ocidtab, however before we look into it’s working the next couple of sections would give an understanding…

As business entities move some of their services to Microsoft Azure Cloud (Azure), we see hybrid networks emerge that can span multiple physical sites and multiple cloud environments. Connecting those network segments securely can present some challenges. I’ve encountered two types…

There are at least four ways to back up a Postgres database: SQL dump, filesystem snapshots, continuous archiving, and third-party tools. For each, notes on the recovery point objective (or RPO, which is a measure of how up-to-date your application…

Over the past month, I organized #DataSessions for the Singapore SQLPASS group. Singapore SQLPASS is the data platform user group community in Singapore. In June, we held free live webinars every Tuesday and live-streamed it on Facebook and YouTube. I…

Let’s revisit our options when moving your SQL Server workloads to Azure and check out ways to migrate on each of them. Let’s break them down into sections in case you want to jump to specific ones. Deployment Options SQL…

Migrating to Microsoft SQL Server or Azure SQL Database – a webinar by Warner Chaves Register today Are you considering a migration to Microsoft SQL Server or Azure SQL Database? Before you go any further, join Warner Chaves, Pythian’s Microsoft…

Welcome to the July 2020 episode of the Datascape Cloud Update Podcast. This is the podcast where we distill the latest Cloud announcements from the leading public Cloud vendors and help to inform you about what matters and what to…

In this post, we will explore one approach to Migrate PostgreSQL DB on EC2 instance to RDS instance using AWS Data Migration services. Amazon Relational Database Service (Amazon RDS) is quite popular because of its easy setup, operation, and auto-scalability….

Here we will see how the deployment process of the new Exadata X8M works.   RoCE issues from the factory Exadata X8M servers are coming from the factory with the RoCE private network disabled. In case the Field Engineer assigned…