How to get started with SQL Server

Part 1 – Installation

“The journey of a thousand miles begins with a single step” – Lau Tzu

Ok, so you’ve decided to check out some SQL. Let’s get you set up.

Click right here and get yourself a copy of SQL Server Developer Edition, straight from Microsoft. This is a free version of the SQL Server Enterprise software that can be used for educational or development purposes. Yay free!

Once the download completes, we’re going to install it as follows:

Select the Basic install option.

Keep it simple, stupid!

Accept the legal jumbo. Or read it. Some people like pain.

Yes, I’ll be sure to read all of that.

Pick an install location, probably a folder somewhere out of the way.

Put it over there somewhere.

Let it cook for a few minutes, stirring occasionally.

Things are happening…

Great success! But we aren’t quite finished yet. We still need to install a tool to interface with our new database software. The default tool for this is SQL Server Management Studio (SSMS). You can see a link to install it below:

Almost done now.

Or go ahead and click right here to download the latest version directly.

You know the drill by now, just install and let it cook:

And that’s it! You now have a fully functional SQL Server installation on your machine. In the next post, we’ll start using it to build a database.

Stay Tuned!

Published by Nate Harting

I'm an all-American, self-taught technology professional. I've worked with SQL Server for over a decade in reporting, ETL, data analysis, and DBA roles. I enjoy making SQL more efficient, and helping out new folks to the field.

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 )

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s

%d bloggers like this: