Database Blog
Managing Server Sprawl with AWS Management Console Alerts
This blog focuses on database monitoring and management using the AWS CloudWatch service. CloudWatch ingests performance data from a wide range of AWS resources, applications and services, sends alerts when needed, and keeps a 15-day historical record of performance information.
Migrating an Oracle Schema to PostgreSQL with Partitioning Table(s) in an On-Premises Data Center
Many companies are looking for open source database solutions to help shrink the IT budget by minimizing or avoiding support costs. One such solution would be migrating an Oracle database to PostgreSQL. PostgreSQL is a widely used open source RDBMS, and the PostgreSQL...
Watch Your FRA!
Now the FRA may sound like a magical area that should never run into storage-related issues—but that could not be farther from the truth.
Database Patch News — June 2020 (Issue 4)
Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server.
In-Place Oracle Database Encryption with Zero Downtime
Did you know that you can now encrypt existing tablespaces in-place, either online or offline in Oracle?
Is a Cloud Data Warehouse Right for My Company?
This post compares on-premises versus cloud data warehouse architectures and explains the pros and cons of each.
Is AI Going to Dumb Down the Internet?
Google’s new mobile-first index changes the way content relevance is derived. … I am not sure, but it sounds like that may mean that in order to get our pages to appear to the readers we want, we have to make it understandable (according to the AI) to the general public.
Database Patch News — May 2020 (Issue 3)
Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server.
Schemas, Databases and Instances—Defined and Discussed
What is a schema as opposed to a database as opposed to an instance? And how do schemas differ between Oracle and MSSQL? Or between Oracle and PostgreSQL? Or between PostgreSQL and MongoDB?These terms are very important when planning a database architecture, so let’s explore them.
Which Edition of Oracle RDBMS is Right for My Business?
Do I really need Oracle Enterprise Edition? Do I need Oracle Enterprise Edition in order to have a standby database? What version of Oracle do I need? Oracle’s editions and features can be a bit overwhelming. This post shares some key information that I hope will make your choice easier.