A (somewhat opinionated) list of SQL tips and tricks that I've picked up over the years. There's so much you can do with SQL but I've focused on what I find most useful in my day-to-day work as a data ...

This system stored procedure takes a table name as a parameter and generates a MERGE statement containing all the table data. This is useful if you need to migrate static data between databases, eg.

SQL is neither the fastest nor the most elegant way to talk to databases, but it is the best way we have. Here’s why Today, Structured Query Language is the standard means of manipulating and querying ...

What a great last few days for PowerApps! I hope you have been enjoying the announcements in the Spring Update Blog bundle. Have you seen Satya’s video? This blog doesn’t quite rise to the level of ...

One of the most interesting trends in the computer world during the past few years has been the rapid growth of NoSQL databases. The term may be accurate, in that NoSQL databases don't use SQL in ...

Null values indicate that data is missing or unknown, and if you don’t take steps to handle them, you could wind up with runtime errors or erroneous data. These Access pointers will help you ...

How many null values exist? What is the difference between a null value and a blank entry? This article answers those questions and more by discussing what to look for when creating Access apps that ...