Using the Simple Recovery Model for SharePoint Development Environments

A little more than three years ago, I blogged about the default recovery model for various SharePoint databases. In that post, I described how I would often toggle the SQL Server databases in SharePoint development environments from the default Full recovery model to Simple before migrating content. Since you typically don’t care about potential data…


Analyzing Database Roundtrips with SQL Server Profiler

One of the “good habits” I’ve developed over the years while creating applications is scrutinizing the interaction between logical or physical tiers. Given the nature of solutions that I’m typically involved with, this often involves examining how many roundtrips are required to the database in order to render a single Web page on a site….


Reporting Errors with TFS Migration/Upgrade

When upgrading Team Foundation Server (TFS) — or, really, any application that utilizes SQL Server Reporting Services — you might choose to restore your data to a new environment (for example, to migrate to new hardware, or to validate the upgrade in Development and Test environments before upgrading your Production environment). Depending on the exact…


Save Significant Disk Space by Setting MaxPatchCacheSize to 0

A little over two years ago, I wrote a post about installing Visual Studio 2005 Service Pack 1, in which I mentioned setting the MaxPatchCacheSize registry setting to 0 (in order to save some significant disk space while installing the service pack). [Note that the credit for this trick really goes to Heath Stewart –…


Lessons Learned Moving TFS to Windows Server 2008 and SQL Server 2008

I’ve been a bad blogger this month. Almost a month ago, I wrote a post about using Web standards with Microsoft Office SharePoint Server (MOSS) 2007, but I noted that there would be more to come on that subject in the near future. Well, almost a full month has passed and I still haven’t posted…


Bug Deploying SQL Server Database Using VSDBCMD.EXE

Yesterday we encountered a bug while trying to deploy a new SQL Server database from a Visual Studio database project using the VSDBCMD.EXE utility, following the prescriptive guidance on MSDN: How to: Prepare a Database for Deployment From a Command Prompt by Using VSDBCMD According to this MSDN article, all you need to do…


Error Installing KB 970892 When Reporting Services Configured with Domain Account

For a little over a month, Windows Update was failing on one of the servers in the “Jameson Datacenter” (a.k.a. my home lab). Specifically, KB 970892 simply would not install on JUBILEE — my Systems Center Operations Manager (SCOM) 2007 VM, that I use to monitor a number of physical and virtual machines. Here’s the…


Database Default Locations in SQL Server

I’ve mentioned before the importance of using multiple “spindles” when working with large SQL Server databases. Generally speaking, the recommendation is to use different RAID 1+0 arrays for data and log files — and depending on the size and load of your database, you may also need to isolate data files on individual RAID 1+0…


Environment Naming Conventions

One of the challenges I see in organizations that I work with is the lack of naming conventions for various environments — or sometimes naming conventions that provide little or no value. For about the last ten years, I’ve been a strong proponent of a simple “-suffix” naming convention that is not only very easy…


Add sysadmin in SQL Server 2008 Using Local Administrator

A couple of months ago, I had to SysPrep a copy of one of my VMs in order to remove dependencies on my home domain (I had to work out of the Microsoft office for a couple of days because my DSL router cratered). However, while the SysPrep process was quick and painless, after the…