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.

In SQL 7 and other high-end relational databases, each table is required to have a Unique Row Identifier or Primary Key in order to interact with other tables. Access does not require this and will ...

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.

Inside the TFS Databases, Part 2 Jeff continues his exploration of the TfsWorkItemTracking database by showing you how to retrieve a record from a given point in time using some helpful SQL statements ...

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