Welcome to SQL Clinic
This is a website about the SQL language
Latest from the Blog
SQL Tip – CONVERT_TZ in MySQL
Working with time zones has generic and platform-specific challenges. This SQL tip involves some design aspect not only the specific SQL code. Namely taking care to have a method to determine the original local used to create the date time entry.
Design Tip – None or NA Instead of NULL
We are working in a world of existing applications with known technical issues couple with development and business techniques that emphasize moving quickly to fail quickly and learn from the mistake. Now that does not mean you should be selectively ignorant when beginning a new design and forget all the fundamentals. If you are the…
SQL Tip – Working With the UNION Clause
I have been working with the SQL language for very many years. I take for granted that most developers are not very experienced in using commands outside of simple select, insert, update and delete statements. Certainly, this can be a disadvantage… (Click for more)
MySQL News
Microsoft SQL Server Blog
Get new content delivered directly to your inbox.
SQL Clinic 