Thursday, August 14, 2008

Virtual PC 2007 Laptop Install Mouse Hesitation Fix

If you are running Virtual PC 2007 on a laptop and are experience mouse stutter or hesitation (no matter how much memory or how powerful your laptop), there is a fix.  Here is a link to the explanation, but the short version is find the options.xml file on your C:\ drive (in my case it is in c:\Users\Josh\AppData\Roaming\Microsoft\).  Add the following section immediately after the last </virtual_network> tag:

   <virtual_machines>
    <enable_idle_thread type="boolean">true</enable_idle_thread>
  </virtual_machines>

Monday, August 4, 2008

Useful Visio stencil set for SQL Server 2005

I am putting this here for my own future reference.  There is a useful set of Visio stencils for SQL Server 2005 at Visio Toolbox.  Here is a link to the page that they are on, and a direct link to the .zip file.  These stencils appear to have actually been created by Microsoft directly, since the page is on a Microsoft website.

There is also a page on the site that shows how to work with Visio and SQL Server.  There are several videos and a couple of downloads.

Tuesday, July 29, 2008

Post SR1 Rollup Package 1 for Data Dude available


If you are using Visual Studio 2005 Team Edition for Database Professionals (Data Dude), you might be surprised to know that there is a post-SR1 Rollup Package 1 update available.  It can be download here.  The list of fixes can be found here, and I have pasted it in below:

Inconsistent revalidation of database object definitions when you close and then reopen a Visual Studio database project

A database project cannot be deployed if the project contains interdependent inline functions

If you use a four-part name to reference a table, you may receive an incorrect syntax exception

Database Professional Interpreter does not handle the "sp_executesql" parameter correctly

In a Visual Studio 2005 database, you cannot import a schema that was created by using the SQL Server 2000 compatibility mode

Error message when you use Design-Time Extensibility (DTE) objects: "Do you want to reload"

Cross-database references cause slow performance when you load a project

Schema Compare crashes the Visual Studio IDE when databases contain different versions of assemblies

Schema Compare does not correctly generate the update script for a stored procedure

The schema script is not generated when triggers or views that have the same name exist

Error message when you build a deployment script: "MSB4018: The 'SqlBuildTask' task failed unexpectedly"

After Schema Compare obtains the latest project files from Source Control, Schema Compare indicates that databases are different

Saturday, June 14, 2008

How to fix Hyper-V error “Failed to add device Microsoft Synthetic Ethernet Port”

Hyper-V Beta, and RC0 worked great.  I recently upgraded to RC1, and in the process of both trying to move a VHD from another server and trying to create a new VM from scratch I repeated received the following error:

Failed to add device ‘Microsoft Synthetic Ethernet Port’

Here’s what I figured out: The Microsoft Forefront Client Security that was running on the host machine was interfering.  Once I excluded both .XML and .VHD files in Forefront, everything started working again.  That was an easy fix.

Tuesday, June 10, 2008

SQL Server 2008 RC0 is available for public download

Surprisingly, I haven’t heard much buzz around this, but SQL Server 2008 RC0 is now available for public download at this link.  I haven’t had a chance to look at it yet, but supposedly this is the final release before RTM later this year.

Thursday, April 3, 2008

Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables

My buddy Wayne just brought to my attention a white paper that came out just a year ago from Microsoft that describes how to design SSAS 2005 cubes for use with Excel 2007.  I'm posting it here for my own future reference.  Here is the description:

Overview

Microsoft Office Excel 2007 takes advantage of most of the features in Microsoft SQL Server 2005 Analysis Services. To take full advantage of these features, it is important to keep in mind the end-user experience in Office Excel 2007 when you are designing cubes.
This document outlines how you can create a good end-user experience by optimizing the cube design for Office Excel 2007 PivotTable dynamic views.