SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

SQL Homework – September 2017 – Create a home lab

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.

Filed under: Microsoft SQL Server, SQLServerPedia Syndication, SSMS Tagged: microsoft sql server, SSDT, SSMS


My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at www.sqlstudies.com.


Leave a comment on the original post [sqlstudies.com, opens in a new window]

Loading comments...