RIGHT JOIN (or RIGHT OUTER JOIN): It’s the opposite of a LEFT JOIN. It keeps all rows from the right table and matches from the left. Less common than LEFT JOIN, but good to know it exists.

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

Search has become an integral part of Windows, particularly in later versions. While the major search improvements began with Windows Vista and were backported to Windows XP, it’s really only with ...