Relational databases and the SQL language are still the architecture and lingua franca for the design, development and management of database applications.

Stay tuned for “The end of SQL databases – part 2” (of a 3 part series) where we will take a walk through some of the currently available open and closed source NoSQL databases.

Here are the details to two versions of Product Tables, one for Access 2000/97 and one for SQL Server 7. Not all of these fields are necessary in one database. For example, with Size and color you can ...

Joey on SQL Server A Deep Dive Inside Azure SQL Database, Part 1 Microsoft promises 99.995 percent uptime for the Azure SQL platform, which is incredible.

The term 'NoSQL' is widely acknowledged as an unfortunate and inaccurate tag for the non-relational databases that have emerged in the past five years. The databases that are associated with the NoSQL ...

Databases and languages that are used to communicate with databases, like SQL, can handle significantly more data than spreadsheets and manage the back-end of most modern-day web applications.

SQL databases have constraints on data types and consistency. NoSQL does away with them for the sake of speed, flexibility, and scale.

In part 2 of a series, On VB columnist Joe Kunk provides a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database.