SQL Server 2008 Management and Administration

SQL Server 2008
I just got a book in the mail from a friend, Todd Robinson, who was the technical editor. The name of the book is Microsoft SQL Server 2008 Management and Administration. The book was written by Ross Mistry and Hilary Cotter. I don't know Ross Mistry and I think I met Hilary Cotter once, although I know who he is. However, since Todd was involved, I'm pretty sure this is going to be a high-end, must read. I just started and the initial chapter's discussion on using Windows Server 2008 sparked a few questions for my local admin team. I'm looking forward to more. Thanks Todd.
Read More

SQL Server 2008 Upgrade Lab at Microsoft

SQL Server 2008, Tools
I got an invite to take part in a lab at the Microsoft Technology Center in Waltham. I took advantage of it. I'll use this post to describe the experience so that anyone else with the opportunity will know what to expect.  [caption id="attachment_333" align="alignnone" width="450" caption="They knew I was coming"] [/caption] First, you recieve a very explicit set of pre-requisites. You need to install the SQL Server Upgrade Assistant, a tool that Microsoft licensed Scalability Experts to create for them. You have to run this against a small database, >25gb. The tool backups up all the databases from the server (so you need to put it on to a test box, rather than try to move an entire production system worth of databases). It then starts a trace that captures all the…
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