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!
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...
Db2's Database Partitioning Feature (DPF) allows a single Db2 instance to span multiple physical servers — allowing a single Db2 database to scale out to sizes well beyond what is possible on a single physical server. To manage a DPF environment, Db2 needs to be able...
This post has been updated from the original content here. The ORA-00257 error is a very common Oracle database error. The error is basically trying to tell us that we have run out of logical or physical space on our ASM diskgroup, mount, local disk, or...
Every environment is configured differently; however, we have all experienced alerts being triggered due to unfavorable performance. Oftentimes, before our root cause analysis begins, the issue has resolved itself and/or someone may have rebooted. Although current...