Hear from our thought leaders, stay up to date with company news, and learn more about how we’re impacting our community.

Image
May 18, 2023

What is the Role of a DBA in a Cloud Migration?  

What is the Role of a DBA in a Cloud Migration?   As businesses increasingly adopt cloud computing and leverage cloud services, one crucial responsibility that falls under the purview of a Database Administrator (DBA) is facilitating the migration of databases to the cloud. Database migration to the cloud involves transferring a company’s existing databases, applications, and related components from on-premises
Tags:
Cloud Computing
Cloud Migration
DBA
Read More
Image
May 8, 2023

Software Licensing Auditing: Why it’s Necessary, Challenges, and Best Practices

Being audited is normal, even if it is not fun. Whatever database you use, or whatever your team looks like (in-house DBA or a Managed Service Provider), software licensing auditing must be on the radar.   What is a software licensing audit?  A software license audit is a formal, mandatory compliance review of a company’s use of products and services. Every software company
Tags:
Audit
Database Audit
Software Audit
Read More
Image

What is a relational database and how does it work?

What is a relational database?  A relational database is a type of database in which data points are connected to each other. Inside a relational database there are rows set up in tables. Each row in the table is a record with an ID (the “key”) and each column in the table holds data attributes. Structured Query Language (SQL) is
Tags:
Read More
Image
April 17, 2023

Top Common Errors in SQL and Oracle

Whether you’re speeding through your work, 60 hours deep into your work week, or just have brain fog – accidents happen. It can be easy to make a mistake when it comes to working in a database. One minute you’re double fisting coffee and taking on your work like a champ, the next you’re fighting error messages. Here are the
Tags:
Oracle
SQL Server
Read More
Image

How do you resolve an ORA-00054 error?

When a DDL and DML run into a lock in Oracle, the ORA-00054 error appears. An ALTER SESSION command allows the DDL to succeed. When encountering an ORA-00054 error in Oracle, it indicates that the table you are attempting to access is currently locked by another query. Typically, waiting for a few minutes and reattempting the query resolves the issue
Tags:
Read More
Image

What are examples of business process reengineering?

Business process reengineering (BPR) is the redesigning of business processes to achieve significant improvements in performance, productivity, and quality. BPR can help a CIO achieve dramatic improvements in productivity, cycle times, quality, and employee and customer satisfaction.  Examples of Business Process Reengineering These are just a few examples of business process reengineering initiatives that organizations may undertake. The key is
Tags:
Read More
Image

What does a database administrator do?

A database administrator monitors, maintains, and troubleshoots data systems. They also optimize the physical database structure for space management, I/O distribution, and parameter tuning.   A database administrator (DBA) is a professional responsible for managing and maintaining databases within an organization. Their role involves various tasks related to the efficient and secure operation of databases. These tasks are critical for storing
Tags:
Read More
Image

What is a runbook?

A runbook is a detailed “how-to” guide for completing a commonly repeated task or procedure within a company’s IT operations process (e.g. provisioning, software updates/deployment, change configs, and opening ports). Runbooks are part of IT Infrastructure Library (ITIL) protocols, which incorporate information from IT processes, such as knowledge management and problem management. Runbooks can be manual, semiautomatic, or automatic, depending on
Tags:
Read More
Image

 What is a database monitoring system? 

A database monitoring system tracks database performance using standard criteria. Database monitoring tools help track database performance and resources in order to create and maintain a high-performance and highly available application infrastructure.  What Makes Up A Strong Database Monitoring System? What Does A Healthy Database Look Like? What Are Database Monitoring Tools?  Database monitoring tools help track database performance and
Tags:
Read More
Image

What is a SQL server bottleneck?

A SQL Server bottleneck happens when SQL Server is asked to retrieve or process more data than it can handle and one of the vital resources it needs becomes overloaded. When that happens, queries will wait until they can be processed. Then, when the bottleneck is finally removed, SQL will attempt to process all the waiting queries at once, which
Tags:
Read More