Shelley Doll finishes her coverage of SQL data types with an overview of datetime and interval data types. Learn more about the basic syntax of these standard SQL types.

Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

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

Here is a list of common wait types and techniques that every DBA (or wannabe DBA) should know. While there are many more wait types than listed here, understanding these will give you a leg up when ...

In response to previous SQL lessons, TechRepublic members including Michael M. and Jason P. have posted comments requesting a basic explanation of the types of JOINs available in SQL. If you use ...