07/11/2024
ORA-00600 Exposed: Understanding and Resolving Oracle’s Internal Error Code
The ORA-00600 error presents itself as a catch-all for a variety of unforeseen conditions that the Oracle database software cannot process normally. While not quite the apocalyptic “kiss of death,” it is certainly viewed with a mix of dread and resignation. It is Oracle’s not-so-subtle way of throwing up its digital hands and admitting that something has gone awry. And that something, wasn’t a thing that Oracle had every anticipated.
It could be said that encountering an ORA-00600 is a bit like hearing ominous rumbles from your car’s engine right after you’ve bragged about its reliability.
30/10/2024
Database Security in the Era of IoT and Edge Computing
Every refrigerator, smartwatch, or industrial sensor that connects to the internet streamlines our lives, Yes, that’s true. However, by doing so, they also add to the growing pile of concerns in regard to database security. As we integrate more devices and decentralize data processing, the potential for breaches expands exponentially. This seismic shift demands a reimagined approach to security. One that transcends conventional methods and addresses the issues of protecting data. Even among the expanse of IoT devices and edge nodes.
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.
17/10/2024
Through Data Reliability: What is ACID When it Comes to Databases?
What is ACID when it comes to databases? Atomicity, Consistency, Isolation, and Durability are the pillars that keep database transactions from descending into chaos. These properties form the foundation of reliable database systems, ensuring that every operation follows the rules. That’s how we can handle every failure with precision, and leave no transaction incomplete or in a corrupt state. Without them, the data world would be a mess of half-executed actions, inconsistent records, and data loss that could bring even the simplest system to its knees.
10/10/2024
Oracle vs SQL Server: Which One Wins for Your Business?
Oracle vs SQL Server—two goliaths clashing over the supremacy of database management. These platforms emanate from the venerable houses of Oracle Corporation and Microsoft, respectively. They have evolved through decades, consistently pushed by the relentless pursuit of excellence and the demands of a data-driven world. This ongoing battle shaped their capabilities and influenced a great part of the technological choices of organizations around the globe.
We will get into their origins, architecture, and the nuances that dictate their adoption in various enterprise contexts.
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…
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.
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.
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.
08/08/2024
The Toughest Performance Challenges of SQL Server
SQL Server has a stellar reputation among the suits in the boardroom—lauded for its architecture and the ability to juggle massive datasets with the grace of someone who can juggle quite well. Yet, those who actually wrestle with the data, know a different story. They understand that SQL Server, like any towering giant, has its own set of quirks and foibles that can keep database professionals on their toes. Welcome to the performance challenges of SQL Server.
01/08/2024
That’s How Effective Query Monitoring Can Prevent Locks
In the complex ecosystem of SQL Server, performance issues can sometimes feel like detective work, especially when tracking down the elusive culprits behind system locks. This time, we’re exploring how ineffective queries (and poorly executed query monitoring) can grind operations to a halt, and how to identify the “how” and “why” behind the halt.
From scrutinizing load trends to dissecting lock histories and refining execution plans, we’re making sure that no stone—or should we say, no data block—remains unturned in our quest to keep SQL Server zipping along like a sports car rather than trudging like a pack mule.
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…
10/10/2022
New version Performance Monitor (Release 2022.3)
On October 10, 2022, we published a new version of Performance Monitor for Oracle, Microsoft SQL Server, PostgreSQL and SAP…
10/07/2022
New version Performance Monitor (Release 2022.2)
On July 10, 2022, we published a new version of Performance Monitor for Oracle, Microsoft SQL Server, PostgreSQL and SAP…
10/04/2022
New version Performance Monitor (Release 2022.1)
On April 10, 2022, we released a new version of Performance Monitor for Oracle, Microsoft SQL Server and PostgreSQL databases….
30/12/2021
New version Performance Monitor (Release 2021.4)
On December 30, 2021, we released a new version of Performance Monitor for Oracle, Microsoft SQL Server and PostgreSQL databases….
08/10/2021
New version Performance Monitor (Release 2021.3)
On October 8, 2021, we published a new version of Performance Monitor for Oracle, Microsoft SQL Server and PostgreSQL databases….