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.
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 –...
In case you missed the first post with the Database Glossary of Terms, you can see it here. Here are some popular databases that the Virtual-DBA team supports along with some feature or terminology highlights (usually relative to the most recent version of said...
There are times when a Developer or DBA needs to determine the best performance options with transferring data through a linked server from point A to point B but may not know the best way to do it. In the following example, I am going to show you the differences...
Switching database engines—for instance, going from a MySQL-compatible database to an Amazon Aurora MySQL DB cluster—and migrating data can be a long and confusing process. For the purpose of offering a little clarity, this article will go through and highlight...
Directory Tree: In Microsoft (MS) Windows, the C:\ drive is where your operating system (OS), programs, and other files typically reside. In Linux, this is known as the "root" directory and is represented with the forward slash character ( / ). In Windows, your...
Creating a new database in SQL server is a very common and general task for professionals dealing with SQL in an environment. There could be different ways of creating a new database. You can literally run a basic create DB statement, which will follow the default...
This series is designed to be a database reference guide, covering databases from the very beginning. We're calling it Database 101. There will be eight sections in this series. Part 1: Database Glossary of Terms Let's start with some background for people who know...
It can be helpful to compare and contrast two similar pieces of software, such as MySQL and MariaDB. Competition in the open business market often leads to innovation and breakthrough technology. Yet, when two competing companies go head-to-head, offering similar...