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.

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

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

For the past fifty years, SQL has helped us understand, manipulate and use our data to our advantage.

The world of the data professionals and DBAs is swirling with threats and risks, and those dangers are on the rise. You're probably accustomed to using longstanding database fea­tures to secure your ...