Welcome to MSDN Blogs Sign in | Join | Help

January 2009 - Posts

Thoughts about building a SQL Server 2008 cluster in Hyper-V

Having built a SQL Server 2005 cluster on virtualized hardware, using Virtual Server, i thought it was time to do this on hyper-v with SQL 2008. Here’s some thoughts to get you thinking about trying this. The one single most important point here, is how
Posted by grahamk | 1 Comments
Attachment(s): hyperv_sql2008_cluster.pdf

Hypothesis Confirmed - Skiing in Sweden is better than SQL Server Support

So as per my post on 2nd January, I'm happy to confirm that skiing in Sweden is definitely better than SQL Server support, however much I do enjoy my job at times :-) Here's a picture of me learning to cross country in Klövsjö, near Vemdalen in central
Posted by grahamk | 0 Comments

Problems executing maintenance plans in SQL Server 2008 - Resolved by SQL 2008 CU#3

In November I wrote here about problems executing maintenance plans due to Integration Services edition compatibility issues. Last night we released cumulative update #3 for SQL Server 2008 RTM, and it contains a fix / design change for this problem.

Error 29528. The setup has encountered an unexpected error while Setting Internal Properties

We've just published a change to KB925976 on how to work around the following setup error: Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation. We've also just published
Posted by grahamk | 0 Comments
Filed under: , ,

Sample Application to test database mirroring failover

Here's the source for a tiny C# app I wrote to test database mirroring failover at the application level, including a sample database mirroring connection string. It assumes that you have already set up a mirroring partnership. It doesn't matter whether

Starting SQLDIAG or PSSDIAG automatically using SQL Alerts

This is something I was thinking about this week whilst chatting with a customer. I've done it before on occasions, but never really documented it. Consider the fact that you have a problem which occurs extremely intermittently, let's say on average every

Come and meet the Stockholm PSS teams on 17th and 18th March

Myself and several colleagues from various support teams (not limited to SQL) will be at Microsoft tech days on 17th and 18th March 2009 at Västerås in Sweden. We'll be doing a few mini presentations on the side of the main event, and just hanging out
Posted by grahamk | 0 Comments
Filed under:

Is Skiing in Sweden better than SQL Server support?

Of course it is! So, no posts for a few weeks right now as I'm hanging at home in Stockholm enjoying some family time and general relaxation. It's been below zero for about 3 weeks now here, and the skies have been stunningly clear and beautiful, leading
Posted by grahamk | 0 Comments
Filed under: ,
 
Page view tracker