A book that aims to introduce the defensive programming philosophy to database developers. Is it for you? This book is like treasure discovered by accident. It’s published by Redgate, which I knew as ...

Take any social media app, every tax preparation app or banking app, look to where the data is stored and you'll find a database that supports the application. The following example of SQL code ...

SQL Prompt recently reached Version 6. An add-in for SQL Server Management Studio and Visual Studio, it is designed to "strip away the repetition of coding". What exactly does it offer the SQL ...

Some folks think that DBAs and application developers inhabit different universes. At times this may seem to be the case, but the successful DBA must understand application development and the issues ...

Developers often dispute the merits of SQL as a legitimate programming language, but this misses the point. SQL is a powerful 4GL for accessing data. Let’s face it: Bigotry within the ranks of the ...