Category Archives: SQL Server

Team Foundation Server 2010 Installation Experiences and Lessons Learned

Do it right the first time! 🙂

There’s quite a few posts on Team Foundation Server 2010 (TFS) and how to install and configure it, as well as a really good CHM file from Microsoft on the same topics, so I won’t go through duplicating what everyone else has done and will link to one at the bottom of this post.  I’m writing this just to relay the experience I had with getting the product configured just the way I wanted it, or some facsimile thereof and some lessons learned.

 tfs001

After viewing some videos on YouTube of TFS, reading some of the Microsoft marketing material, and some of the posts on it, I decided to stand up TFS in my environment to see how well it works and to explore changes since the last version.  Right now, the team I lead isn’t really using any ‘set’ collaborative product.  We tend to work in small teams on projects so the need isn’t really there, though I’m sure the organization wouldn’t hurt.  We’re currently using Subversion as our source repository and occasionally use MOSS or WSS to collaborate.  Otherwise it’s phone calls and emails since we also tend to bounce around the country.  Enough background, on to TFS installation…

After reading through a few blog posts and Microsoft’s documentation on how to install and configure TFS, I stood up a Windows Server 2008 R2 VM and installed SQL Server 2008.  I was going with a single server install.  I followed the documentation to the letter for a single server install, and everything worked out just fine.  WONDERFUL!  GREAT!  So far…

Continue reading Team Foundation Server 2010 Installation Experiences and Lessons Learned

SQL Server 2008 Installer Fails on Windows 7 and Windows Server 2008 R2

Have you tried rebooting?

I ran across an issue on Windows Server 2008 R2 but also found the issue to happen on Windows 7 installations.

Apparently this will be fixed in the R2 releases of SQL but since those aren’t available yet for the enterprise and similar versions, there’s a pretty simple fix.  I found an article that references a few fixes that I’ll link to here in case the fix that I have doesn’t work.

The error states that “Invoke or BeginInvoke cannot be called on a control until the window handle has been created.”

Continue reading SQL Server 2008 Installer Fails on Windows 7 and Windows Server 2008 R2

SharePoint Virtualized = Excellent For Production

Though it goes against my better nature, as it is not like me to go against what some really big brains say, I’m tired of hearing from many people as well as ‘company lines’ that SharePoint and SQL Server are not good candidates for virtualization.  It’s easy to sell it that way, but it’s just not true.

The simulations and production deployments that I have been a part of speak otherwise, along with candidate architectures and testing that have been conducted by EMC.  As a matter of fact, I would say that SharePoint and SQL Server are excellent candidates for virtualization, as every production implementation should consider their COOP (Continuity of Operations) and DR (Disaster Recovery) scenarios as a major point of design.

Continue reading SharePoint Virtualized = Excellent For Production

Tutorial: Creating A MOSS Development Environment Part I – SQL Server Installation

One of the questions I get the most is how exactly do you create a Microsoft Office SharePoint Server 2007 (MOSS) development environment and what software should be used / included.  Since I usually create a new environment for every client, I get a lot of practice at it and I thought I’d document the process.  I’ve included screenshots for every touch point in the SQL install and will do the same for the following Parts. You can click on the thumbnails to view a larger version.  I assume no prior knowledge of SQL, MOSS, or Visual Studio in these tutorials.  If anything I’ve noticed out there is most tutorials assume product familiarity.  This will help novices as well. 🙂

Continue reading Tutorial: Creating A MOSS Development Environment Part I – SQL Server Installation