If I have an application that uses a database as its data store (and ultimate source of truth) that brings some obvious issues when developing tests: In the applications, objects should ONLY be ...

Testing and tuning SQL is an often-overlooked aspect of incorporating the database into your DevOps pipeline. It is important to be able to analyze and optimize SQL performance within your application ...

There’s a very handy new tool from Microsoft called the Database Experimentation Assistant (DEA). The DEA makes it very easy to conduct A/B testing for SQL Server upgrades, providing quantitative ...

I recently wrote a .NET web application for work. I always make a data access class with methods for getting data, but I usually just point the methods to stored procedures. This time, I decided to ...

Follow this step-by-step guide to install PostgreSQL, load data, connect to a database, and execute SQL queries including table joins PostgreSQL is an open-source, object-relational (also called ...