Database Blog

  • Database Patch News — June 2020 (Issue 4)

    Jun 29, 2020

    Reading Time: 2 minutes Welcome to Database Patch News, Buda Consulting’s newsletter of current patch information for Oracle and Microsoft SQL Server.

    Read more Add new comment
  • In-Place Oracle Database Encryption with Zero Downtime

    Jun 8, 2020

    Reading Time: 2 minutes Did you know that you can now encrypt existing tablespaces in-place, either online or offline in Oracle?

    Read more Add new comment
  • Is a Cloud Data Warehouse Right for My Company?

    May 29, 2020

    Reading Time: 6 minutes This post compares on-premises versus cloud data warehouse architectures and explains the pros and cons of each.

    Read more Add new comment
  • Is AI Going to Dumb Down the Internet?

    May 26, 2020

    Reading Time: 2 minutes 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. 

    Read more Add new comment
  • Schemas, Databases and Instances—Defined and Discussed

    May 12, 2020

    Reading Time: 5 minutes 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.

    Read more Add new comment
  • Which Edition of Oracle RDBMS is Right for My Business?

    May 11, 2020

    Reading Time: 8 minutes 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.

    Read more Add new comment
  • Ensure Redundant Database Coverage, During Covid-19 and Always

    Apr 9, 2020

    Reading Time: 2 minutes During this health crisis and always, ensure that at least two people know how to access and manage your database.

    Read more Add new comment
  • It’s in the Database

    Mar 3, 2020

    Reading Time: < 1 minute Managed Health Systems of Indiana patient health information, July-September, 2019; Microsoft customer service and support records, January 22, 2020; Wyze email addresses, December 30, 2019; Georgia Tech student data, March 2019. What do all of these breaches have in common? The data that was stolen was inside a database. Yet when most companies think about data security, they still focus on securing the network, and spend very little time and energy making sure the databases—where…..

    Read more Add new comment
  • Cloud Customers Need to Secure Their Own Data

    Jan 31, 2020

    Reading Time: 2 minutes The key takeaway is that if you have your data in any cloud service, you must be as rigorous in securing that data as if it were in your own data center—and in some cases even more so.

    Read more Add new comment
  • MySQL and MariaDB Encryption Options

    Dec 10, 2019

    Reading Time: 4 minutes MySQL and MariaDB Encryption Options Encryption remains one of the most widely used cornerstones of data security across organizations of all sizes and industries. Why? In many cases it’s both effective and relatively simple to implement. There are two fundamental encryption capabilities that are almost universally necessary for basic data security: The ability to encrypt sensitive data “at rest”—that is, where it resides on disk—is a critical security capability for many organizations and applications, as…..

    Read more Add new comment