I'm supposed to be a software developer/consultant. However, I'm also the guy people look at when the application isn't running "fast enough." With business applications, speeding up the application ...

Optimizing the performance of operational databases and the applications that access them is a constant battle for DBAs. Of course, writing efficient SQL is the most important aspect of ensuring ...

There are plenty of ways to get the most out of SQL Server without just upgrading to the latest version. For database admins working with older (maybe much older) SQL Server systems, here are four ...

The role of the DBA is complex, requiring expertise in designing, implementing, managing, and tuning database systems. DBAs are also tasked with supporting developers, so they need to understand how ...

Everyone wants faster database queries, and both SQL developers and DBAs can turn to many time-tested methods to achieve that goal. Unfortunately, no single method is foolproof or ironclad. But even ...

Even if generative AI hides SQL behind the curtain, it will continue to play a critical role in how we interact with and use data. In May 1974, Donald Chamberlin and Raymond Boyce published a paper on ...