Getting started with SQL Server at home.

Recently several people looking to jump into SQL development have asked me about resources for at-home practice. I’ve shared these resources via email for some time. The next logical step was a webpage to compile those resources as an easy-access point for anyone looking to set up SQL at home.

Firstly, SQL Server Express is freeware.  You can install an instance of it on your home machine entirely free. SQL Server Express does have its limitations.  Usable space (10GB in 2014) and features namely. Even with those limitations it can be a great tool for learning to write SQL at home.

Freeware aside, it is my humble opinion that the best way to play with SQL at home is SQL Server Developer Edition. It has all the features Enterprise Edition does and is just 60 bucks.. Maybe you are just getting started with SQL Server.  Perhaps those extra features seem unnecessary for your needs. If SQL is something you intend to pursue seriously you will, in time, want to work with Integration Services, Analysis Services Cubes and Availability Groups.  The Developer Edition has you covered.

Once you’ve decided what version suits your needs, simply install. When you install be sure to disable the setting that starts SQL Server automatically, as it is a resource-intensive program.

Your server is now set up, now you need some data. The data sets I use for all of my at home testing come from either Adventure Works or the Stack Exchange Data Dump however the later will be in XML which means you will need to extract them to a database using code similar to this. Keep in mind: you will need to modify this code to work in your particular instance and may want to add structure to your tables as well.

Advertisements

Yet another SQL blog?!

Yes. You read that correctly. I’m making a SQL blog.

“But Zane,” you ask, “why make a SQL blog when there are already so many?”

“Lovely reader, the answer is simple: because I want to.”

I like writing about SQL Server. I have been doing it for an inter-company website for about a little over a year. The time has come to branch out.

“Okay. So what do comics have to do with SQL?” Easy answer: nothing. I plan on updating this site three times a month. Writing about SQL Sever involves loads of research so I thought I’d break up the grind by writing about something else I love. Comic Books!

Maybe you’re here to learn something new about SQL Server.  Maybe you’re here to get recommendations for comic books. In both instances I will attempt to educate and entertain.