In this guide, I'll explain that there's a better way to handle changes to your database and how to get it under version control, tested, and deployed along with application code.

Read More

Companies that develop custom software for other companies have a lot of experience working with their clients. In this article, I've asked a range of them to provide their advice for working with clients.

Read More

The SQL Server DATEDIFF function lets you find the difference between two dates in a range of different units. Learn how to use it and see a range of examples in this guide.

Read More

Do you want to know what the SQL data types are in different database vendors? Learn all about them and how they compare in this guide.

Read More

Do you need to convert data in SQL Server? Looking for the format codes for the CONVERT function? Learn all about the SQL Server CONVERT function in this guide.

Read More

Many programming languages allow you to comment out code so that it does not run. SQL allows comments as well. Learn how to add SQL comments in this article.

Read More

This list has all of the currently available ETL tools. Use this for your research to help you decide which tool to use.

Read More

Are you considering using either MySQL or PostgreSQL for your next project? Read this article to find out the differences between these two databases and help decide which one to use.

Read More

Learn all about the SQL Alter Table statement.

Read More

Learn all about data warehouses in this guide.

Read More