If you are a SQL programmer, learning recursive SQL techniques can be a boon to your productivity. A recursive query is one that refers to itself. I think the best way to quickly grasp the concept of ...

Get an overview of JDBC's architecture, then learn how to connect to a database and handle SQL queries and responses with PreparedStatements, transactions, connection pooling, and more. JDBC (Java ...

In the open-source world, much has been made about the need for a full-featured, robust and reliable database that can handle substantial loads and yet be able to play well with such open-source tools ...

Let’s talk about database application benchmarking. This is a skill set which, in my opinion, is one of the major differentiators between a journeyman-level DBA and a true master of the trade. In this ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

In database management, it’s easy to assume that newer technologies are always better. While many database solutions have gained popularity in recent years, MySQL—one of the oldest and most widely ...

I'm a big fan of MySQL. The community edition of the MySQL server, as the open-source database is formally known, is a popular choice for both development and deployment because it checks all the ...

How to Create a MySQL 8 Database User With Remote Access Your email has been sent At some point, you're going to need to connect to a MySQL 8 database remotely to manage your databases. Here's how to ...

One of the ways we measure applications is through performance. One of the metrics for application performance is user experience, which generally translates to “did the user need to wait longer than ...