Every professional programmer (and DBA) should have a library of books on SQL fundamentals. There are many SQL titles to choose from, and a lot of them are very good. But this month's column will ...

A fundamental skill for DBAs is to have a firm understanding of the SQL Server database engine's system databases. Tim Chapman discusses these system databases. A fundamental skill for DBAs is to have ...

At the Ignite conference today, Microsoft made a series of announcements about Azure databases. It announced a brand-new Azure database called HorizonDB, which is a fully managed PostgreSQL database ...

The structured query language is a powerful tool for connecting to many database systems that store data in tables organized into rows and columns. It's often used on the backend of business websites ...

DBeaver is a free, open-source, cross-platform SQL client and database administration tool. It is designed to support a wide variety of SQL and NoSQL databases, including MySQL and PostgreSQL. Its key ...

Online analytical processing (OLAP) databases are purpose-built for handling analytical queries. Analytical queries run on online transaction-processing (OLTP) databases often take a long time to ...

Data estates are expansive. Organizations in all business verticals are operating data stacks that run on a mixture of legacy technologies that work effectively but aren’t always easy to move or ...

Having recently set up an old desktop as a dev machine in order to avoid trashing my main computer with evaluation software (don't get me started), I decided it was time to try out Visual Studio 11 ...