A “lesson learned” on the importance of keeping your DBAs in the loop when making system changes, so you can avoid causing database issues.
Types Of Virtualization There are many types of virtualization. Storage, network, server, database. For the purposes of this article I will discuss server virtualization, but with a special focus on servers that will house databases. Server virtualization...
At the end of the day, if we look beneath the surface-level issues, the main reason for database project failure — by far — is poor communication.
Even though we have all heard many times how important password protection is, we still see basic password protection rules broken ALL THE TIME. So here is a quick refresher.
New privacy regulations and other compliance and data governance mandates are driving more and more SQL Server users to leverage Always Encrypted. It can be a big help with separating those who own and can view the data from those who manage the data but should otherwise not access it.
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.
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...
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.
Did you know that you can now encrypt existing tablespaces in-place, either online or offline in Oracle?
This post compares on-premises versus cloud data warehouse architectures and explains the pros and cons of each.
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.
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.
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.
One of our customers had issues over the past several months with Oracle Active Data Guard replication to a standby server. The database on the standby server would intermittently fall out of sync with the database on the primary server, and log files were not consistently shipping to the standby server.
During this health crisis and always, ensure that at least two people know how to access and manage your database.
As the old saying goes, “It’s better to be safe than sorry,” and testing your disaster recovery data is essential to keeping you and your data safe!