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

SQL databases have constraints on data types and consistency. NoSQL does away with them for the sake of speed, flexibility, and scale. One of the most fundamental choices to make when developing an ...

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

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

I've installed Horizon View, VMware's Virtual Desktop Infrastructure (VDI) product, dozens of times over the past decade. With each release, for the most part, the installation process gets easier and ...

Even after 50 years, Structured Query Language, or SQL, remains the native tongue for those who speak data. It’s had impressive staying power since it was first coined the Structured Query English ...

The information below serves as a brief primer to help you better understand the database terms you’ll most often encounter. Relational Databases. Relational databases became the database of choice ...

As SQL Server 2008 and 2008 R2 reach the end of support in 2019, you’ll have an opportunity to upgrade to a cloud database service. Follow this step-by-step guide to manage change effectively as you ...