Let’s Talk Types

Without a doubt, the most common and most egregious problem I see repeated over and over in database design is using the wrong data types.  This lesson will explore computer and SQL data types and provide some guidelines to avoid these common problems.  The next lesson will be a “deep …

One: Setup Developer SQL 2016 Machine

Set Up SQL Server In this lesson, we’ll install and configure a basic SQL 2016 developer machine. Note that this is NOT the same configuration we would use for a production system; but instead is simply a fundamental single machine developer configuration. You can use the following screencast video to …

A Quick (and incomplete) Look at the SQL Editions

Developer Edition/Enterprise Edition The developer edition of SQL is generally the best alternative to use when developing a new site.  As of the current release (SQL 2016), this product is free for development purposes and the functionality matches the top-of-the-line SQL Enterprise version.  Since the SQL products seem to vary …