In the intricate world of software development, bugs are the elusive creatures that can disrupt the smooth operation of applications and systems. At times my co-journey with a bug begins...
In March of 2024 CISA issued the following advisory related to SQL injection (SQLi): Secure by Design Alert - Eliminating SQL Injection Vulnerabilities in Software. SQL Injection is one...
I am always fascinated by the “Search” in this digital world. When I think about text as data, I always believe that Text is Data born for search ☺ compared...
Introduction
Many organizations are realizing the benefits of migrating from Oracle to the cost-effective and powerful open-source PostgreSQL database. EDB Postgres Advanced Server (EPAS), with its Oracle compatibility features, makes...
Beyond the technical considerations for a database migration it is critical to understand how to manage what is effectively a transformation exercise at scale
1 Introduction
The migration of legacy...
The TPC Benchmark(TM) E (TPC-E) was released back in 2007 as the successor to the TPC Benchmark(TM) C (TPC-C) for an OLTP type workload. To briefly recap, the TPC-E models...
2024 is the year of the dragon. But it may also be the year of the cloud, as more and more organizations move their open source databases there. In 2023...
Have you ever searched for unnecessary granted privileges in your database? To find these, you need to know 1. The granted privileges 2. How many of the granted privileges have...
Enterprise-class databases require DBAs who are responsible for maximizing query performance. Therefore, when it comes to large scale deployment of databases, minimizing the work of DBA is important. One of...
You’ve likely heard of Software as a Service (SaaS), but have you heard of Database as a Service (DBaaS)? With DBaaS, your database management system can benefit from the cost and agility benefits of cloud computing.
DBaaS is a cloud...
