SQL Server: database owner SID issue

If you restore a database on a different SQL Server you may see the following error message:

The database owner SID recorded in the master database 
differs from the database owner SID recorded in database...

The solution is to change the authorization on the database to a known SQL account:

alter authorization on database::{databasename} to {username}

Simply replace the {databasename} and {username} with the appropriate names; the brackets should not appear in the SQL query.

Installing .Net 3.5 on Win8 using DISM

To install the .NET Framework 3.5 from installation media located in the D:sourcessxs directory, use the following command:

DISM /Online /Enable-Feature /FeatureName:NetFx3 /All /LimitAccess /Source:d:\Sources\SxS


  • /Online targets the operating system you’re running (instead of an offline Windows image).
  • /Enable-Feature /FeatureName:NetFx3 specifies that you want to enable the .NET Framework 3.5.
  • /All enables all parent features of the .NET Framework 3.5.
  • /LimitAccess prevents DISM from contacting Windows Update.
  • /Source specifies the location of the files needed to restore the feature (in this example, the D:\Sources\SxS directory).

For more information about DISM parameters and options, see How to Enable or Disable Windows Features

from: http://msdn.microsoft.com/en-us/library/hh506443(v=vs.110).aspx

Windows Explorer: open at Computer instead of Libraries

One of the changes in Windows 7 that really annoyed me (and continues to annoy me in Win8 RTM and Server 2012) is that the Windows Explorer insists on opening up in the libraries area instead of the computer (drives, etc) that was the previous default.

You can change that behavior by right-clicking on the Windows Explorer icon in the task bar and then right-click again on Windows Explorer (or File Explorer in Win8) and selecting Properties.

Replace the value listed in the Target field with the following string:

%windir%explorer.exe ::{20D04FE0-3AEA-1069-A2D8-08002B30309D}

This will force Explorer to open in the Computer area which is far more useful given the way I work.

Add/remove GUI in Windows Server 2012

In Windows Server 2012, Microsoft made it easy to add and remove the graphical user interface (GUI) using simple powershell commands.  Running a server without the overhead of the GUI (called Server Core) helps keeps the server more secure since less programs are running that could be exploited.  Running without a GUI should also help limit the number of reboots required every Patch Tuesday, but in truth I haven’t yet seen that many reductions in reboots on my Server Core systems.

To install the user interface, open powershell and type the following cmdlet:

Install-WindowsFeature Server-Gui-Shell, Server-Gui-Mgmt-Infra

Similarly, you can uninstall the user interface with the following cmdlet:

Uninstall-WindowsFeature Server-Gui-Shell, Server-Gui-Mgmt-Infra

Of course, running these cmdlets will require a reboot to finish the configuration.

Patch Tuesday: problems with KB2840628

Microsoft generally does a pretty good job at testing patches before they are released, making Patch Tuesday pretty effortless (except for the persistent need to reboot servers — wish they’d adopt a method like Linux where we could just restart the affected service after the update is installed).

But this month was different.  I applied the July 2013 patches first to a development system and no issues were reported.  So a few days later I pushed them out to production only to find the .Net Framework was broken; every managed procedure/trigger failed with the infamous .Net “Object reference not found” error.

It took me a while to pin down the problem.  It was caused by MS13-052 (KB2840628).  Uninstalling that patch and rebooting fixed the errors.

Microsoft mentions the problem in a related document and they mention a workaround in scenario 2.

Good customer service: Comcast

Like other people, I sometimes have issues with Comcast, mainly due to their antiquated billing system — making any change on your account seems to break something else.  On several occasions, making a simple change to our service (like adding HBO, etc) dropped NFL Network and the Sports package.  But when they deliver a good product or service they deserve to get a compliment.

We called them in January to inquire about Xfinity Home Security; our existing security system used copper phone wires for all connectivity and our phone company was driving me crazy with overbilling and blatant lies from their customer support.  I wanted to dump our landline but that would break our existing security system.

During the discussion with Comcast, they discovered that we could move up to the Triple Play and still save us about $15 from our current bill (HD-DRV rentals are expensive!)  So we had our service upgraded in February.  And other than a couple of quickly-resolved network issues, the new services have been very stable and problem-free.

Part of the triple play included moving us to Blast Internet.  With their recent speed increase, we are supposed to be getting up to 50 Mbps download.  Yesterday I started having problems with my Skyrim game so I decided to delete the local content and re-download the game from Steam.  During the download I consistently received data at 57 Mbps; the entire 12GB download took less than half-an-hour, which is amazing considering the Summer Sale is going on now.  🙂

Keep up the good work Comcast!  And if you feel the need to lower prices in the near future, I’d be interested!  🙂

Well, I had to try.  *laughs!*

Cool: low flying C-17

Yesterday I was heading into work after lunch and saw a C-17 flying very low overhead.  It had everybody standing outside watching it as it performed its maneuvers.

Low-flying C-17

The full picture can be seen by clicking on the above image; it is a large picture (2560 × 1920) so you might not want to click on it on a mobile device.

Read the full story at WLFI-TV

Disabling the new typing animation in Office 2013

One of the new “features” of Office 2013 is a new animation that occurs as you type.  If you are typing quickly, the cursor seems to lag behind; that’s quite disconcerting.

The good news is that you can disable it; the bad news is that you have to edit the registry to do so.  Add the following new key to disable the animation:

Add new DWORD: "DisableAnimations" = 1

Then you have to reboot (this is Windows, after all).  This new setting disables all animations, but honestly I don’t see much difference.

If you want to want to reverse this change, simply modify the new key and set it to zero.

New Lync 2013 notification icon

File this one under “what were they thinking?”

After applying a July 2013 security update for Lync 2013 (MS13-054), the notification area icon was changed.  It used to show your current status (available, busy, etc) but now it only shows the Lync icon itself.  You now have to hover over the icon to see your current status.

Microsoft has made some good decisions lately but this isn’t one of them.  🙂