Vagrant Troubleshooting

For all your high tech troubleshooting needs!

Ok, here is the theory.  I’ve seen it with every decent technical person I’ve ever worked with.  The easiest way to troubleshoot something is just to “show” someone what you’re working on, and talk the problem through while you’re doing it.  So for all those laptop toting techies a new solution has been created!  Vagrant Troubleshooting.  Don’t get me wrong, it costs a little money, but is definitely worth the investment.  The theory goes something like this.

The next time you’re walking down the street and are approached for some “change” by a bum, homeless person, or other various vagrant, tell them you have work for them.  Go ahead and pay them a good solid 50 cents and then pull that laptop out and start explaining what you’ve been working on.  When you get to the nitty gritty problem let them talk a bit, because then you’ll get a little bit of completely arbitrary insight.  Within no time you’ll stumble into the solution!

Since a technical person doesn’t always have another cohort or coworker around, the vagrant troubleshooting methodology would work perfectly!  So next time you’re out there taking a stroll down your favorite city street, remember to whip that computer out for your troubleshooting needs!

Technorati Tags: Bum Troubleshooting , Techie , Techy , Tech Troubleshooting

del.icio.us Tags: Bum Troubleshooting , Techie , Techy , Tech Troubleshooting

T-SQL Date Range Usage :: Tip o' The Day

Often times a date range is used in a where clause with a start date and an end date that are the same.  The dates however are entered with the intention of getting that single day worth of data.  By default T-SQL will look at that but not give you the full 24 hours worth of data.  To fix that, toss in an IF statement early in the query to check and fix this problem.  The code below is uber easy to just copy and paste into a SQL query for confirmation, then just alter for your custom needs.

DECLARE @EndDate datetime DECLARE @StartDate datetime

SET @StartDate = ‘1/1/07’ SET @EndDate = ‘1/1/07’

PRINT ‘Start Date: ‘ PRINT @StartDate PRINT ‘End Date: ‘ PRINT @EndDate

IF  DATEPART(hh, @EndDate) = 0 BEGIN     SET @EndDate = DATEADD(hh, 23, @EndDate)     SET @EndDate = DATEADD(mi, 59, @EndDate)     SET @EndDate = DATEADD(ss, 59, @EndDate)     SET @EndDate = DATEADD(ms, 99, @EndDate) END

PRINT ‘Start Date: ‘ PRINT @StartDate PRINT ‘End Date: ‘ PRINT @EndDate

Cube Design Best Practice :: Tip o' The Day

Do not put too many parent-child dimensions in a cube.

This tip is magnified when the dimension contains custom rollups or unary operators.  Yes, some of you might say, “but they are so powerful!”  Well with power comes responsibility!  In this case the responsibility is to safe guard against poorly performing queries.  So keep in mind that these parent child dimensions should only be used when absolutely necessary.

More New News and BAD Standards Use by SOA Standards Company

So it really isn’t news, but VS.NET 2008 is really coming from what I can tell.  I’m stoked about this, I’m really looking forward to doing Silverlight work too.  I think I’ll probably even hack together a solution in VS 2005.  I’ve seen a few entries out there recently which I could pull on to get that put together.

Another point of interest, especially with my keen interest and past work with SOA, is the release of Microsoft‘s Managed Services Engine (Repository).  I got tipped off on this release from the InfoQ Article “Microsoft Releases Managed Services Engine (Repository)“.  Even though Microsoft doesn’t state or even elude to the idea that they are going to provide governance management for services they do have partnerships with Amberpoint.

But then of course on the flip side Microsoft has added management for SOA into BizTalk as I read in SOA Software Adds SOA Management for BizTalk Server.  They’re currently working with SOA Software on this.

Which leads me to the dilemma of web/HTML/XML and compliance of standards in general.  SOA Software does a really bad job of this.  I pulled up the web site in Opera and it has text all over the regular page text, a total mess.  This is a company that specializes in SOA but doesn’t have basic web site interoperability?  This leaves me very suspicious.  With that in mind I put together an e-mail to notify them of their inconsistency which I sent to their sales at soa dot com.

“I went to your website to contact you in regards to a possible discussion of products.  However your website doesn’t display properly in Opera Browser, which leads me to believe that the site does not support proper web standards.  I’d really love it if you guys could forward to your “web group” that the site is totally hosed by compliance standards and you are most likely losing business because of it.

The SOA realm is NOT Microsoft centric.  I’ll check back, and possibly contact SOA Software again in regards to doing business when the site is fixed.

Thanks, — Adron Hall my blog: http://adronbhall.com/blogs/technology__software_development/default.aspx my site: http://adronbhall.com Software Architect & .NET Developer”

Within about 15 seconds of sending this I get a return e-mail from their postmaster account stating;

“This is an automatically generated Delivery Status Notification.

Delivery to the following recipients failed.

      sales@soa.com

Final-Recipient: rfc822;sales@soa.com Action: failed Status: 5.7.1 X-Display-Name: Sales”

That really instills confidence in their SOA abilities.  This is basic e-mail and basic web site standards compliance.  Come on SOA Software, get yer act together!

On that note, keep up keeping up and watch out for the companies that you do business with.  Sometimes they aren’t cracked up to be all they’re supposed to be.

Multi-Cube

So I got to thinking, and after searching around a bit, I didn’t find much, “A blog post is in order!”  So here is what I was researching.

Where and when is it a good idea to start breaking out to multiple cubes?

What is the best practice about splitting up cubes or segmenting data into different cubes?

What are some of the reasonable limitations of Microsoft SQL Server Analysis Services?

…as I dig more, a write up will follow!  Smile [:)]