Technological and coding misadventures!
In my always continuing efforts to keep up with the coolest frameworks, architecture, and other tidbits, I rolled into these “must review/read” how-to entries from Scott Hanselman, Scott Guthrie, and Brad Abrams. If you are planning to do any ASP.NET/C# MVC work with the latest and greatest go and check em’ out!
Of course, just to rewind a bit, if you haven’t read ScottGu’s initial once over of the MVC Framework coming down the pipe, check it out.
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
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
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.
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.