Distributed SQL is an evolution of the database for cloud native, distributed transactions. It can implement a standard SQL interface, ease operational complexity of scale, is geo-replicated, always ...

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 ...

Now that you've gotten a brief introduction to SQL, its time to get some hands-on practice connecting to a database and executing some queries. SQLite databases are stored as files on disk. The one we ...

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 ...

Community driven content discussing all aspects of software development from DevOps to design patterns. The easiest way for a Java developer to learn Java Database Connectivity (JDBC) is to experiment ...

Note – This book abbreviates SQL Server 2008 Reporting Services as SSRS and SQL Server 2005 Reporting Services as SSRS2K5. New features available in SSRS and not in SSRS2K5 are labeled with “New in ...

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 ...