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

Building SharePoint WSPs with Team Foundation Build

As I noted in my previous post, I recently discovered that my approach for building Web Solution Packages (WSPs) in Microsoft Office SharePoint Server (MOSS) 2007 isn’t compatible with Team Foundation Build. I’m actually a little embarrassed to say this, but when I created the original “DR.DADA” approach for MOSS 2007 development back on the…

3

The "Copy Local" Bug in Visual Studio

If you’ve ever worked with me on a Microsoft Office SharePoint Server (MOSS) 2007 project — or if you’ve read my Sample Walkthrough of the DR.DADA Approach to SharePoint — then you’ve probably seen the following comment: Note: Referenced assemblies must be specified with a path corresponding to the build configuration. If the path is…

0

SketchPath – The XPath Tool

I added another tool to my Toolbox yesterday: SketchPath. The SketchPath site labels it as “The XPath Tool” but I’d say it more like “The XPath Tool.” I’ve seen a few other tools for quickly building and testing XPath expressions against an XML document, but they pale in comparison to SketchPath. There are a number…

0

SharePoint Web Part to Redirect from HTTP to HTTPS

Yesterday, I detailed the steps I recommend for configuring SSL on sites built on Microsoft Office SharePoint Server (MOSS) 2007. I also mentioned that users won’t automatically be redirected from HTTP to HTTPS, and how I’ve previously used a little bit of code to automatically perform this redirection. Here is a base class that contains…

0