Database Fundamentals #1: Install SQL Server - Grant Fritchey

To get started with SQL Server, you need to install it. However, I’m not going to teach you how to do a SQL Server install. Instead, I want to point you towards a couple of sources of information, and, give you some alternatives to installing SQL Server.

Install SQL Server

As much as I enjoy sharing information with you through this blog, and despite the fact that I read a lot of other technology blogs and other resources online, the single best source of information on SQL Server remains Microsoft and their SQL Server Documentation[1]. This information is up to date and very well maintained. Yes, I’m sure you can find somethings to complain about in there, but overall, it’s the starting point for all SQL Server learning and understanding. I will refer to it frequently within my Database Fundamentals blog posts. Plan on starting there.

You first have to download a copy of SQL Server. Go here[2] and get a copy of the Developer’s Edition. That will come with everything you need to learn SQL Server.

To get SQL Server installed, let’s start with Microsoft’s documentation[3] on the topic.  Then follow the instructions in that link. It’s for the standard, wizard driven, GUI version of the installation of SQL Server, but it’s good enough for most of us to get started on.

Alternatives

Another alternative is to skip doing SQL  Server installations entirely. Instead, if you have an MSDN account (and you can get a free account, just sign up with Microsoft), each account comes with free credits on Azure. With that, you can create a SQL Server virtual machine[4] instance on Azure with everything installed. You can then go there and start learning immediately.

Another choice is to skip the server entirely and go with Azure SQL Database[5]. The majority of the fundamentals I’m going to cover in this series are absolutely the same if you’re using Azure SQL Database of an actual instance of SQL Server. If you search my blog, I have quite a large number of Azure SQL Database posts that can help.

Conclusion

You can download and install SQL Server or use one of the cloud based solutions. Either way, you should now have an instance of SQL Server on which we can begin to play. The next post will introduce you to the primary tool you’ll be playing with, SQL Server Management Studio.

References

  1. ^ SQL Server Documentation (docs.microsoft.com)
  2. ^ Go here (www.microsoft.com)
  3. ^ Microsoft’s documentation (docs.microsoft.com)
  4. ^ SQL Server virtual machine (azure.microsoft.com)
  5. ^ Azure SQL Database (azure.microsoft.com)

Comments

Post a Comment

Popular posts from this blog

New Article Posted: Seven Things You Should Do in Your AMS

Given how advanced and thorough the modern association management software (AMS) system has become, there are many opportunities for your organization to leverage it. Here are seven ways I believe every association should be using their AMS. Click here to read the rest of the article . Of course, if you’re already on my  announcements list , you would have received notice of this new article right in your email box. Not signed up yet?  Click here to sign up . Go to the article
Read more

10 Common Mistakes Biblical Counselors Sometimes Make, Part 8

Image
A Word from Bob: You’re reading Part 8 of a 10-part blog series on 10 Common Mistakes Biblical Counselors Sometimes Make . Mistake #1: We Elevate Data Collection Above Soul Connection . Mistake #2: We Share God’s Eternal Story Before We Listen Well and Wisely to Our Friend’s Earthly Story . Mistake #3: We Talk at Counselees Rather Than Exploring Scriptures with Counselees . Mistake #4: We Practice Half-Biblical Counseling If We Address Sin but Neglect Suffering . Mistake #5: We Fail to Follow the Trinity’s Model of Comforting Care . Mistake #6: We Tend to View People One-Dimensionally . Mistake #7: We Devalue Emotions Rather Than Seeing Emotions as God’s Idea . Mistake #8: We Minimize the Complexity of the Soul-Body Interconnection Because we are soul physicians and soul care-givers, our tendency is to focus on matters of the soul. Most biblical counselors are not trained in the medical field, so we wisely avoid offering medical guidance. Yet, that appropr...
Read more