Latest
Events
Products
Partners
Release info
Types of Indexes and When to Use Them

26/09/2024

From Clustered to Specialized: Types of SQL Indexes and When to Use Them

Considering the sheer volume of data slugging through the digital pipelines, knowing your indexes shou be your bread and butter. Here, we’re slicing through the thick crust of complexity to expose clustered and non-clustered indexes and their cousins.

Why bother? Because we live at the age of instant grafitication. The speed at which you can retrieve data can be the difference between leading and trailing behind. That’s why we will be going through the ins and outs of clustered and non-clustered indexes and their specialized kin. On they way, keep in mind that each type has a role. For every one there is a specific scenario where its purpose becomes the most obvious.

It’s about knowing who to tap for the performance you crave, at precisely the right moment.

Performance Monitor Changes in Version 2024.2—Part III: OS Stat Page

19/09/2024

Performance Monitor Changes in Version 2024.2—Part III: OS Stat Page

In the high-tech tangle of our time, more cores usually mean a slower tick-tock in the CPU clock. The sage database administrators find themselves revisiting the old battleground of processor usage. The latest update to DBPLUS Performance Monitor (Version 2024.2) includes significant enhancements that aid in this monitoring. Particularly through its dedicated page for OS statistics—OS Stat Page.

10 Good Practices for Database Backups

12/09/2024

10 Good Practices for Database Backups

The act of backing up databases may seem like a routine chore but it’s an art form, practiced by those who maneuver through the digital aisles with the finesse of a cat burglar and the foresight of a chess master. Much like a well-timed joke or a perfectly brewed cup of coffee, timing in backups is everything.

It ensures that the digital lifeblood of your business keeps pulsing through the veins of your operations, even when fate throws a wrench in the works. This set of good practices for database backups may not make you a master of all, but it will certainly steer you clear of the most dangerous (and costly) mistakes.

Performance Monitor Changes in Version 2024.2—Part I: Grouping

05/09/2024

Performance Monitor Changes in Version 2024.2—Part II: Grouping

We’ve been tinkering with DBPLUS PERFORMANCE MONITOR, again, and this time it’s all about getting a handle on those elusive user sessions with a feature that’s as adaptable as a chameleon in a rainbow—session grouping.

When the Intern Deletes the Entire Database

29/08/2024

When the Intern Deletes the Entire Database

We’ve all been the rookie, the greenhorn, the junior in the office. Some of us may have stumbled through minor blunders, but few can claim their mistakes shut down entire systems or wiped clean a whole database. Such extreme cases, we will be focusing on today, demonstrating the fragile boundary that exists in the digital environments of modern corporations. Let’s see what happens when the intern deletes the entire database.

On-site Database Events to Attend in 2025

24/10/2024

On-site Database Events to Attend in 2025

From Wales to London, Orlando to Stockholm, and beyond, 2025 promises a smorgasbord of data-driven sagas across various locales. Here’s a peek at the not-to-miss database events set to sprinkle some intellectual stardust on your next year’s calendars.

08/02/2021

Manage your database performance and data accessibility today…alive tomorrow.

Webinar date: Wednesday 10th March, 11:00am CET Your business growth demands efficient IT services with upgrades and enhancements delivered on…

16/09/2020

Actinium Consulting GmbH and DBPLUS enter into partnership

Actinium Consulting GmbH specializes in business intelligence and ERP. The software developments by DBPLUS for database optimization and real-time data…

07/01/2020

dbi services with real-time replication using the DBPLUS Data Replicator

dbi services described our solution for real-time data replication on their blog. dbi services was founded in 2010 and is…

16/10/2019

Partner for Performance representing DBPLUS at the DOAG Conference and Exhibition 2019 in Nuremberg

Partner for Performance representing DBPLUS at the DOAG Conference and Exhibition 2019 in Nuremberg You wish to become more familiar…

Key Metrics for Reliable Database Replication

20/02/2025

Key Metrics for Reliable Database Replication

Database replication sounds simple enough: take data from one place and make sure it appears somewhere else, quickly and correctly. But anyone who’s spent time monitoring and troubleshooting replication knows it’s anything but straightforward. Networks fail, logs get backed up, and suddenly your secondary database is minutes (or hour) behind.

That’s why replication metrics matter.

ORA-00904: Invalid Identifier in Oracle Databases

13/02/2025

ORA-00904: Invalid Identifier in Oracle Databases

When you’re working with Oracle databases, some errors pop up so regularly that DBAs almost recite them in their sleep. ORA-00904: invalid identifier is certainly one of those classic offenders. On the face of it, ORA-00904 indicates you’ve referenced a column or other identifier that Oracle can’t locate or doesn’t consider valid. Straightforward enough—maybe there’s a simple typo, or a missing column in your table. But there are subtler corners of Oracle that can trigger the same error even when you think you’ve done everything right.

Achieve Database Optimization Without Abandoning Normalization

30/01/2025

Achieve Database Optimization Without Abandoning Normalization

High concurrency, scattered queries, unpredictable data growth—the usual suspects. When everything’s slow and your tables are bursting, you face a tough choice: enforce strict normalization for pristine data integrity or optimize aggressively to wring out every last drop of performance. Overly normalized schemas may lead to a maze of joins and hamper speed under heavy loads. Performance-driven shortcuts—like denormalizing key data—can bloat storage and complicate updates.  Balancing database optimization and normalization isn’t always straightforward, but it is possible. 

Database Performance Tuning - the Sensible Way: Collaborative Strategies, Clear Metrics, and Tested Changes

23/01/2025

Database Performance Tuning – the Sensible Way: Collaborative Strategies, Clear Metrics, and Tested Changes

Databases are either the invisible workhorse that keeps everything running smoothly or the ticking time bomb that wakes you at 3 a.m. with catastrophic slowdowns. There’s rarely a middle ground. Performance tuning makes all the difference—especially when you combine actual metrics, meaningful collaboration, and a dash of common sense. A few checks here and there can save hours of panic later on, and nothing beats a stable, responsive system for making you look like the hero of the IT team. 

Of course, it helps to have a reliable way to see what’s going on under the hood while performance tuning, keep everyone on the same page, and avoid applying fixes blindly. After all, a well-tuned database is happier, and so are the people who rely on it every day.

Performance Monitor 2024.4: What’s New

09/01/2025

Performance Monitor 2024.4: What’s New

Managing database performance is rarely straightforward, and the demands only keep multiplying. In response, DBPLUS Performance Monitor 2024.4 introduces new features that help you see exactly how queries behave across different platforms, track CPU usage at a glance, refine how and when alerts reach you, and unify session data.

If you prefer a monitoring tool that shows critical insights with less hassle, the latest version deserves your attention.

16/09/2020

Actinium Consulting GmbH and DBPLUS enter into partnership

Actinium Consulting GmbH specializes in business intelligence and ERP. The software developments by DBPLUS for database optimization and real-time data…

31/03/2020

dbi services and DBPLUS enter into a partnership

Delémont, March 31, 2020 – dbi services has secured a partnership with DBPLUS, a software development company which specializes in…

16/10/2019

Partner for Performance representing DBPLUS at the DOAG Conference and Exhibition 2019 in Nuremberg

Partner for Performance representing DBPLUS at the DOAG Conference and Exhibition 2019 in Nuremberg You wish to become more familiar…

16/07/2019

DBPLUS on “IT Tage” in Frankfurt

“Everything under one roof!” is the motto of the IT-Days 2019 from December 9th to 12th in the Cape Europa,…

17/06/2019

DBPLUS expands partner network

Another companies from the CEE region joined the group of DBPLUS partners. As a result, DBPLUS Clients gain access to…

15/04/2018

Performance Monitor (release 2018.1)

15 April 2018, we have released a new version of Performance Monitor for Oracle and Microsoft SQL Server. The most…