Thomas was finally first, the first to experience a decent injury.

What comes up, must come down, in this case, Rock meets open toed sandals....

Very nice picture of a toe, i'm sure he'll loose the nail, but hopefully it'll all grow back normally..

SQL Server 2005, Cumulative Update 7.

We downloaded and applied for testing, all tested well.

We tried to implement, and ran into a problem with a vendor install for Symantec End Point reporting database.

We could not figure out the issue, the vendor recommended reverting back to SQL Server 2005, without CU7.  Installation completed succesfully.

We never fullly figured out what was in the vendor script that caused it to fail under CU7 and work in CU6, but obviously something was different.

Based on this "unknown" factor we have not standardized on CU7, in the past none of the CU's have ever broken the functionality of an application, but something in CU7 sure does with Symantec End Point reporting.

SQL Server 2005 Cumulative Update 8 release recently.

Found out that CU8 is available, looks like it may address some issues we are experiencing, hopefully all will test out well, i really wish they were releaseing this sql server service pack 3...this is an indication to me that there are more issues and testing yet to be rooled into SP3.

http://support.microsoft.com/kb/951217

http://robbieroberts.wordpress.com/2008/06/18/cumulative-update-package-8-for-sql-2005-sp2/ 

Interestingly we are on CU6, because we had issues with CU7.

Up to CU6, I always believed in applying and being on the latest CU, if possible (not in peak, time to apply through dev and qa).

After the issue we saw with CU7, I'm now of the opinion of being more cautions and trying to determine if the issues in the CU are resolving problems we experience, than apply it.

FIX: The compilation time of some queries is very long in an x64-based version of SQL Server 2005

http://support.microsoft.com/kb/953569/LN/

FIX: The performance of a query in SQL Server 2005 Service Pack 2 Cumulative Update 6 is slow

http://support.microsoft.com/kb/953721/LN/

50002710 953841 (http://support.microsoft.com/kb/953841/LN/) FIX: E-mail replies are sent to the sender address instead of to the address that is specified in the database mail profile in SQL Server 2005 after you install the .NET Framework 2.0 Service Pack 1

50002753 The Database Mail feature in SQL Server 2005 may access data in the memory that is already freed

Received the following error on installing cumulative update 8

This was on a sql server installation under polyserve, and sometimes they (the instances) get screwed up.

I tried to start the instance manually and it would not start (net start mssql$Instance).

I checked the error log and found 4 entries:

When starting the index tuning advisor, the following error was received:

R6031- Attempt to initialize the CRT more than once.  This indicates a bug in your application.  

Well no sh** sherlock !  Whoever rights these error messages needs their heads examined.

Found a Microsoft KB Article that seems to apply, but we found the key to delete at another location; we have not deleted the key, as we did not want to have the system become unstable, and deleting keys, that were not specified is not advisable.

We found the key at:
HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers

KB Article says to find key at:
HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\AppCompatFlags\Layers

KB Article: http://support.microsoft.com/kb/913395 

Picture of Error:

The old craftsman mower finally reached the point of not working, the mower continues to run great, but the safety mechanism is broken.  I rigged it to run without the safety, but since there is no on/off switch, you have to pull the wire to the spark plug (tingly !).  Though it was nice to mow and not have to turn the mower off to empty the bag, but definetly a bit unsafe.  The wife was not pleased...and I guess with 3 kids, it's probably a good thing to have that little bar working so you can just let go and turn the mower off.

My neighbor Jimmy has almost the exact same craftsman mower, but his handle broke where it attaches to the mowing deck and purchased a new mower this spring.  A 12 pack of beer later, and i've succesfully bartered for his mower.

Now I have two POS mowers!  Not for long, I put the boys to work, turning some wrenches and now I have one working mower and the old mower parts (wheels [ever price one of those big wheel $10.00 each and self propelled parts are not cheap either), and some nice big items for the recycler center (too bad steel doesn't pay anything unless you 100's of pounds, but at least it'll be better than burying it in the landfill).

Pictures below:

I have a mystery wire in my 77 Volkswagen Bus, Westfalia.

I can't figure out where it goes, and have been unable to identify what it goes to.  It is a positive wire, coming out of an inline fuse, right under the steering wheel, it is black with green and white stripe.

Everything works fine, which confounds me even more !

Any help is appreciated:

When you extend an instance of SQL Server on Polyserve, to a new server the startup procedure in the master database is not installed, which if the new instance, on the new server is installed to a different MSSQL.x path, the sql agent service may have issues running jobs, as the sub systems will have different paths.

For my scenario I had 7 machines in a cluster, with an instance SQLTest1 installed on servers 1,2 and 3, with a directory of mssql.3.  This all previously existed and worked flawlessly for many months, but then I needed to setup SQLTest1 on server number 7, this required installing SQL on server 7, and then adjusting the properties in Polyserve to include 7, than failing over to 7.  All this worked great, but further inspection showed that the there were some SQLAgent jobs failing and/or entering a "suspended" state.

A quick review showed that server 7 installed to mssql.1.  Polyserve is supposed to handle this, it does this through a procedure in the master database that is set to startup automatically.  I've seen other instances installed to mssql.1,mssql.2 and mssql.1 and there is no issue, as that stored procedure in the master database handles adjusting sql agent sub systems.  I reviewed the SQLTest1 instance and the procedure was definetly missing.  I manually added the procedure and ran it, now the fail over between any of the servers work.

I can only surmise that the initial virtualization did not add the procedure, because it was not needed, all the sub systems were the same mssql.3. 

I think this may be a bug, it is very simple to fix, the difficult part is recognizing the problem and knowing what the fix is!

I contacted Polyserve on this, and the thinking is that this was caused by the 3.4 to 3.6 upgrade and would not happen on an instance that was "fresh" on 3.6 from day zero, makes sense.

Upgrading Team Foundation Server to 2008.  The install / upgrade fails with the following sharepoint error:

User, group, or role 'WSS_Content_Application_Pools' already exists in the current database.

When we installed SP2 it uninstalls the 32bit DTS.dll file and replaces it with the 64 bit version. The BIDS tool uses the 32bit version. So the fix was to re-registar the 32bit dll using the following command: %windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll"

http://support.microsoft.com/kb/919224

   Some would consider the engine the heart, but the engine is the machine, the closest analogy to the heart is a fuel pump (or maybe Oil pump), but in this case I replaced the fuel pump on my 1977 Volkswagen type II, westafalia camper.

This thing was the factory original, you can tell by the clamps.  That's a pretty good run for a factory fuel pump if you ask me.

Hopefully this will solve the mystery fuel inject cut-out i've been experiencing.

The original fuel pump pictures are below, notice the white material on the outside, is this some type of asbestos ring ?  Not sure, but the new pump wouldn't tighten up with the clamp, whatever that white ring is, it was under the ring / clamp that holds the fuel pump on to the vehicle, without it there is too much play.  Not sure what to use to replace this, so currently I just cut a peice of fuel line, lengthwise and put that under the clamp to bring it in tight.

Welcome to the EEC, Microsoft Enterprise Engineering Center.  Somehow I was reminded of the turtle in the movie Nemo, when the turtle with the Australian accent welcomed Nemo's father, "Welcome to the EAC Dude !".

The Microsoft Campus is impressive.  The EEC is awesome, the employees were most knowledgeable and a pleasure to work with.

We took an application and database out to the EEC Lab to load test it for a week.  We learned an incredible amount of information and had quite an experience.

I've put some pictures of it off my main site.