Our blog is an invaluable resource for anyone struggling with the challenges of managing a database, applications, or clouds.
We understand the difficulties involved in troubleshooting, building, improving, securing, and operating these platforms,
and we’re here to share our insights and expertise with you. Browse through our collection of blog posts below,
and don’t hesitate to leave your comments and feedback.
Transparent Data Encryption(TDE) encrypts SQL and azure database files by encrypting data at rest. In a situation where your physical media such as data, log and backup files get stolen the malicious party can restore/attach the database and retrieve data. TDE...
For more than two decades, MySQL has been a staple of the open-source database community. As a brainchild of the database greats, David Axmark, and Michael Widenius, MySQL has been a prominent database choice for millions of users since the mid-90s. MySQL is a free...
The purpose of this article is to review the three approaches to working with crontab. The first is the mainstream proposed best practice of using crontab -e. The second is to edit the crontab file directly. The third method is to use your text editor to create files...
What's in a name? When it comes to different Relational Database Management systems (RDMS) it can be confusing. The same words have different meaning depending on the software. SQL Server Database Engine has Instances, Logins, Databases, Schema, and User. When a DBA...
Today I wanted to talk about some terminology that applies to multiple database platforms, however, I want to talk specifically to how it relates to the Oracle RDBMS. These four words seem to cause a lot of confusion and are often misused. The specific terminology or...
How do I grant a user SYSADM, SYSCTRL, SYSMAINT, or SYSMON privileges in Db2? As a newbie to the database administration world, I was tasked with giving a pretend user the ability to create databases in a virtual environment setup for learning. I easily found that the...
After applying a Db2 fixpack, you can get SQL0443N when calling the get_dbsize_info() stored procedure. Cause and resolving the problem: get_dbsize_info() uses the system catalogs internally which do not get updated as part of a fix pack update, and should be updated...
You may have heard a lot of talk about some new features and enhancements coming with SQL Server 2017 and for good reason. From database administrators to developers and report writers, there's something new and exciting for just about everyone. While the spotlight...
Oracle is another popular database the Virtual-DBA team supports. With more than 310,000 businesses in 175 different countries using Oracle Database — many of them on the Fortune 100 list — it's one of the most widely used databases in the world. Oracle Database...
While implementing HADR for multiple standbys, there could be potential issues if the HADR ports are not hard-coded on the HADR settings. Here's what the issue looks like: The primary is dbpp.example.com The standbys are: 1st - dbps.example.com 2nd –...