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!
The most satisfying meal is the one you make yourself, and database backup jobs are no different. Many DBAs use maintenance plans as a "one-stop-shop" for maintaining their SQL Server databases. After all, they do backups, integrity checks, index maintenance... What...
There are many reasons to install Windows Guest Additions for Oracle VM VirtualBox: mouse pointer integration, enable shared folders and clipboard, optimal video support, as well as generic host/guest communications. The most notable feature is the ability to resize...
This checklist outlines the steps I took to migrate SQL Server Always On 2017 Enterprise to 2019 Enterprise edition. Having mixed versions of AG's is a temporary solution meant for upgrading or migration purposes only and is not intended for long term use. Preparing...
July 13th, 2021 is quickly approaching. This is the date Microsoft has announced as the end of Mainstream Support for SQL Server 2016. What does this mean for the large number of Servers and applications using SQL Server 2016? You feel like you just completed your...
Starting from Oracle19c cloning your oracle home is a bit different, whether you use this method for out of place patching or rolling out patches to multiple servers we no longer use clone.pl, instead oracle recommends using the software-only install option, available...
Recently while applying a fixpack, I encountered this error: ERROR: An error occurred while setting DB2 runtime path. Contact a technical service representative. Setting DB2 library path :.......Failure DB2 Fix Pack Update log file finished at: Sat Aug 1 18:23:29 2020...
People choose to get certified for a variety of reasons. Many IT Professionals get certified to update their skills and give their resume the automatic boost that comes with certification. Other technology users may choose to get certified to become more well-rounded...
The Oracle error ORA-04031: unable to allocate nn bytes of shared memory is telling us that Oracle tried to allocate a specific amount of memory for a process and it was unable to do so. I see this more often with legacy or very large and complex ETL processes. The...
The SQL Server Migration Assistant (SSMA) is a tool for transitioning from other platforms like Db2 to Microsoft SQL Server. A reference guide for the SSMA can be found in Microsoft's SQL Docs. This article addresses the issue of failed migrations without warnings or...
This post has been updated from the original content here. When getting an ORA-12560 for an Oracle database on windows, there are a couple of things we should check before doing anything else. The error is telling us that we are trying to connect to the wrong...
