Latest
Events
Products
Partners
Release info
The Easy Way and the Hard Way to Optimize an Oracle Database

11/04/2024

The Easy Way and the Hard Way to Optimize an Oracle Database

It may seem that the companies entangled in the web of Oracle and its ecosystem have a limited set of options when it comes to performance tuning. It’s either – pay for extra functionalities and navigate Oracle’s complex licensing, risking non-compliance penalties. This often leads to a conservative approach to optimization, stifling innovation due to the fear of overstepping licensing terms.

But do we always have to go the hard way? 

There’s a much simpler route that doesn’t involve trembling with fear of clicking the wrong thing. That’s what we will be talking about today. 

04/04/2024

Performance Monitor (Release 2024.1)

In April 2024, we published another version of the Performance Monitor for Oracle, Microsoft SQL Server, PostgreSQL, and SAP Hana…

Cloud Databases

To Cloud or Not to Cloud: Pros and Cons of Cloud Databases

While big players have little to no choice but to go for the cloud, some businesses might weigh the choice between traditional on-premises setups and cloud solutions. On one hand scalability, flexibility, and cost savings that traditional databases struggle to match. The ability to scale resources up or down on demand, pay only for what you use, and offload maintenance and security tasks to experienced providers presents a compelling case for moving to the cloud.

On the other hand, traditional on-premises databases offer a level of control and security that some businesses are reluctant to use. The physical control over the database infrastructure can provide a sense of security, particularly for organizations with highly sensitive data or stringent regulatory compliance requirements. Additionally, for companies with stable data loads that don’t require frequent scaling, the initial investment in on-premises hardware might not seem as daunting.

Technical Documentation

28/03/2024

From Tutorials to AI: Approach Technical Documentation From a Different Angle

The only thing more abundant than coffee in a developer’s life is, well, technical documentation. It seems simple enough – you have a problem, you go through a few pages, and get your answer, that simple. Is it, though? Anyone who’s ever tumbled down the rabbit hole of Stack Overflow threads at 2 AM or squinted at API docs with the growing suspicion they’re written in an ancient, forgotten dialect will tell you: not quite.

Tutorials skip crucial steps, reference guides resemble dense textbooks, and help forums, while helpful, can send you on a wild goose chase for that one golden nugget of information. But there’s a light in the tunnel, and we’re here to help you find it.

Discover the intricacies of the 'IS NULL Condition' in SQL queries and learn effective optimization techniques to boost your database performance. This guide offers insights into overcoming common pitfalls associated with 'IS NULL' and enhancing query efficiency.

20/03/2024

‘OR’ and ‘IS NULL’ Might Be Holding You Back

Where “OR” and “IS NULL” condition frolic unchecked, queries often find themselves stumbling down the performance rabbit hole—a place where CPU cycles burn faster than a comet tail and I/O operations multiply with the fervor of rabbits in spring.

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…

Databases in 2025: New Architectures, Smarter AI, and Stronger Security

19/12/2024

Databases in 2025: New Architectures, Smarter AI, and Stronger Security

The year is 2025, and the databases that once seemed so clever have gotten old and cranky. They’re no longer content with sitting there, quietly holding onto rows and columns like good little librarians. Nope. Now they’ve got opinions. They’ve got styles. They’ve got ideas about how to organize themselves, how to spread out across the clouds, how to speak human language, and how to lock the door behind you when you’re done rummaging through their shelves.

The old way of doing things — shoving everything into a single warehouse and hoping for the best — is about as appealing as canned spinach.  So, what will we do instead?

DBPLUS PERFORMANCE MONITOR Release 2024.3

14/11/2024

What’s New in DBPLUS Performance Monitor 2024.3

In the latest update of DBPLUS PERFORMANCE MONITOR, version 2024.3, we’re rolling out exciting enhancements and brand-new features. All are designed to elevate your database monitoring and management capabilities to the next level. 

From real-time online monitoring improvements to smarter notification systems, we’re excited to walk you through what’s new, what’s better, and how these changes can make a big difference in managing your databases.

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.

Performance Monitor Changes in Version 2024.2—Part I: Online Monitor

22/08/2024

Performance Monitor Changes in Version 2024.2—Part I: Online Monitor

Statistics can lie—” The only statistics you can trust are those you falsified yourself” This old adage attributed to Sir Winston Churchill rings especially true if you’re dealing with daily database monitoring. When data is only captured in 15-minute intervals, transient issues that can severely impact performance might slip through the cracks, unnoticed and unaddressed until they’ve already caused significant problems.

In the newest release of the DBPLUS PERFORMANCE MONITOR, we’re extremely excited to show you the solution that the new functionality brings to the table.

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…

09/07/2019

Performance Monitor (release 2019.2)

On June 28, 2019, we released a new version of Performance Monitor for Oracle and Microsoft SQL Server databases. The…

20/03/2019

Performance Monitor (release 2019.1)

March 16, 2019, we have released a new version of Performance Monitor for Oracle and Microsoft SQL Server. The most…

21/12/2018

Performance Monitor (release 2018.4)

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

08/10/2018

Performance Monitor (release 2018.3)

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

08/06/2018

Performance Monitor (release 2018.2)

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