Our blog isn’t just a record. It’s a resource.
We know how difficult managing a database can be. Luckily, we’re here to share our experiences troubleshooting, building, improving, and operating them. Browse blogs below, and feel free to comment!
Database 101, Part 2: Popular Databases – Microsoft SQL Server
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...
read more
Linked Server Push Pull Blog
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...
read more
Migrating MySQL Data to Amazon Aurora
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...
read more
Linux Directories: Files and Permissions for the SQL Server DBA
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...
read more
Best Practices for a Database Creation in SQL Server
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...
read more
Database 101, Part 1: Database Glossary of Terms
This series is designed to be a database reference guide that's all about 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 that...
read more
Noting the Difference: A ‘Compare and Contrast’ of MySQL and MariaDB
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...
read more
How To for Replication
Replication is a great way to copy tables/data from one server to another so you can do reporting on the second server. Within replication tables, stored procedure, functions, views, and indexed views are called articles but in this blog tables and articles mean the...
read more