SQL Homework – September 2017 – Create a home lab


September 5, 2017 by Kenneth Fisher

As I wrote my post about installing the latest version of SSDT I realized that my homework posts missed something important at the start. It’s pointless to ask someone to create a table when they don’t have someplace to do it.

There is no need to go as far as David Klee (b/t) and his home lab. For our purposes a cheap laptop (mine cost me $300 about 3 years ago) with one or more SQL Server instances and of course SSMS and SSDT is good enough.

So no grade this month but it’s time to set up your home lab.

There is no cost for any of this, other than as I said, the cost of a cheap laptop and maybe a few hours of labor.

You can, of course, go the other direction and build something like David (and this is an old picture, it’s gotten more impressive since).

Or you can go somewhere in between. It’s entirely up to you.

One of the best things you can do for your career is to set yourself up a home lab. So while there is no grade on this assignment it’s still vitally important.

3 thoughts on “SQL Homework – September 2017 – Create a home lab

  1. […] a plan here at some point. So far I’ve been just putting down things as I think of them. In September I had you set up a home lab, and in October I had you download and attach some sample databases. […]

  2. […] you created your home lab last September you probably installed a version of SQL 2016. Well, SQL 2017 was released almost immediately […]

  3. […] So let’s give this a shot. Remember you want to be making these changes in a private sandbox, or your home lab. […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,755 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: