Subscribe
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.
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.
06/02/2025
From .NET to Azure: How Did Microsoft Compete with Oracle Database Over the Years?
For a long time, talk of database supremacy circled around Oracle’s hold on mission-critical workloads. Then Microsoft stepped up with SQL Server, coaxing DBAs away from Unix systems by leaning heavily on a Windows ecosystem that many found simpler to manage. Fast-forward to the present, and the contest has expanded into cloud territory, culminating in an unexpected partnership that underscores just how practical both tech giants have become. How did Microsoft compete with Oracle Database throughout this journey?
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.
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.
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…
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.
18/07/2024
The Replication Dichotomy: Logical vs Physical Replication
There’s a peculiar habit among some database professionals occasionally to toss logical and physical replication into the same bin. One might as well say socks and shoes are the same because, after all, they both go on your feet, right? But as anyone who’s tried wearing socks in the snow can attest, similarities on the surface can hide a whole universe of differences between logical vs physical replication.
Blurring together logical and physical replication, or neglecting their differences can lead to inefficient data management strategies. Each method has its merits and ideal scenarios of use. Knowing just when to apply each one—understanding their unique roles in the spectrum of data management—helps avoid unnecessary workload, optimizes performance, and ensures data integrity.
04/07/2024
Execution Plan Changes in SQL Server: Reasons and Solutions
Executions plan—complex maps charted by the SQL Server optimizer, dictate the most efficient route for data retrieval. However, the plans are not static. They morph and adapt, influenced by a host of factors ranging from data volume changes to system upgrades. Each of the execution plan changes in SQL Server has the potential to sway performance dramatically.
Understanding the reasons behind these shifts, and more importantly, how to effectively manage them translates to maintaining optimal performance in SQL Server environments.
27/06/2024
The Domino Effect in the T10 Database on g1rush Server
Performance issues rarely occur in isolation. Often, a single problem can trigger a cascade of related issues, each compounding the overall impact on the system. This case study explores such a scenario in the T10 database on the g1rush server.
06/07/2018
DBPLUS partner webtelligence on SQLSaturday in Paris
On July 7, 2018, the sixth Microsoft Data User Community meeting in France will take place. Participants will meet in…
12/06/2018
webtelligence at SOUG Day in Baden, Switzerland
The meeting of the Swiss community of Oracle users will take place on June 14, 2018. Our partner webtelligence will…
15/05/2018
A new DBPLUS Client in Austria
In May 2018, webtelligence, a German business partner of DBPLUS, began implementing the DBPLUS Performance Monitor solution for MS SQL…
16/04/2018
Another success for DBPLUS in the German market
On April 12, 2018, we began implementing the DBPLUS Data Replicator solution for the customer in the financial sector in…
03/01/2018
DBPLUS at SQLSaturday #679 in Vienna
SQLSaturday is an all-day conference and training event which is taking place in 2018 for the fifth time in Austria….
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….
09/07/2021
New version Performance Monitor (Release 2021.2)
On July 9, 2021, we published a new version of Performance Monitor for Oracle, Microsoft SQL Server and PostgreSQL databases….
27/04/2021
New version Performance Monitor (Release 2021.1)
On April 9, 2021, we published a new version of Performance Monitor for Oracle, Microsoft SQL Server and PostgreSQL databases….
15/01/2021
New version Performance Monitor (Release 2020.4)
On December 31, 2020, we published a new version of Performance Monitor for Oracle, Microsoft SQL Server and PostgreSQL databases….
28/10/2020
New version Performance Monitor (release 2020.3)
On October 9, 2020, we released a new version of Performance Monitor for Oracle, Microsoft SQL Server and PostgreSQL databases….