Database Fundamentals #1: Install SQL Server

Database Fundamentals
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. 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.…
Read More

Installing SQL Server 2012 RC0

SQL Server 2012
Very short informational post. If you’re like me and you’ve been running the public Client Technology Preview (CTP3) of SQL Server Denali, uh, I mean 2012, then the news about the release of RC0 is pretty exciting stuff… until you realize that you’re going to have to tear down your virtual test machine, removing the CTP in order to prep for the install of RC0. I love playing with the toys, but I hate working on the toys, if you know what I mean. Great news. You can upgrade from CTP3 to RC0 in place. I know because I’ve done it. When you run the install and you get to the screen that asks what type of install you want, select Upgrade, as highlighted below: I know it doesn’t say…
Read More

SQL Server 2008 Install, cont.

SQL Server 2008, Tools
OK. Hopefully you're all reading this stuff BEFORE trying to do the install and certainly BEFORE uninstalling everything in sight. The latest version of SQL Prompt, version 3.9, is 2008 compatible AND doesn't cause this problem with the install. So, I've got to reinstall the software. Time to track down my license. I hope I kept that email.
Read More

SQL Server 2008 Install, cont.

SQL Server 2008, Tools
OK. I found some information. The first suggests uninstalling SQL Prompt. I tried it and that did the trick. The second suggest was to do a brute-force removal of the registry key: HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\90. I didn't get there.  Install is running on the desktop now. That seems a bit mean of Microsoft, requiring me to uninstall Red Gate's SQL Prompt, especially since it's such a great little tool. I wonder if I can install it on top of 2008? Time for some more research.
Read More

SQL Server 2008 Install

SQL Server 2008
I just finished the install of SQL Server 2008 RTM on my laptop. No real issues except that it wanted SP1 of Visual Studio installed before it would complete. Once I had that done, everything was up and running. The new install routines are nicer than the old ones if a bit more detailed. My desktop is another matter. SQL Server 2008 objected to a SQL Server 2005 Express install. I removed that. It still thinks Express is installed. I'm removing all of SQL Server 2005 to see what happens.  The error reported was pretty non-helpful. This is a bit odd since the laptop also has a copy of Express installed. Well, uninstalling all things SQL Server didn't work. Sql2005SsmsExpressFacet is failing. It simply states: "The SQL Server 2005 Express…
Read More