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 http://msdn.microsoft.com/en-us/library/dd193258.aspx According to this MSDN article, all you need to do…

0

Forced to Decline KB948014 and KB972493 in WSUS

In last night’s post, I discussed the solution for an issue I encountered installing KB 970892 on one of my servers. Thankfully, this morning I confirmed the server no longer increments the Computers with Errors column in the daily report I receive from Windows Server Update Services (WSUS). I should also mention that in order…

0

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…

2

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…

0

Bug with Duplicate Field Names in MOSS 2007

I encountered a rather nasty bug in Microsoft Office SharePoint Server (MOSS) 2007 yesterday that occurs when a custom field (i.e. site column) has the same name as an existing field. Note that this issue will also occur in Windows SharePoint Services (WSS) v3. I initially created the following Fields.xml file: <?xml version=“1.0“ encoding=“utf-8“ ?>…

0

Escaping from Double-Click Purgatory

A few weeks ago I started experiencing an incredibly frustrating problem on my laptop. When I clicked the mouse, instead of responding with a single-click (e.g. to select an item), it acted as if I double-clicked the mouse button. At first I thought that I was simply losing control of my motor reflexes (in other…

0