# Thursday, 29 June 2006

SqlpromptI’m currently working on my zero day install list of software I cannot live without but I simply cannot wait to point out this nifty piece of software a colleague just showed me. The premise is simple: Intellisense for SQL Server. Red Gate delivers on this as they have done so many times before on other products for SQL Server, best of all, it’s free. Can you believe that?

Now on to the important stuff: SQL Prompt which is the name of this delicious tool. It’s a whole bag of tricks for your SQL statements:

  • Intellisense on tables, columns, and even joins.
  • Auto capitalization of keywords like SELECT, INSERT, and so on.
  • Keyword formatting, code snippet integration other extended features.
  • Works in SQL Management Studio, Query Analyser, Enterprise Manager, Visual Studio .NET 2003, Visual Studio 2005, UltraEdit, and surprisingly EditPlus 2 which is my text editor of choice.
  • It’s free for now. You can grab a copy for the price of nothing until September 1st.


I give this tool a solid ThumbupThumbupThumbupThumbupThumbupThumbupThumbupThumbupThumbupThumbupthumbs up.

Red Gate SQL Prompt.


posted on Thursday, 29 June 2006 09:36:52 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback
# Wednesday, 28 June 2006

Nf500Anandtech has a first look at the nForce 5xx platform for Intel. Of course the nForce platform has been available for AMD forever and to some extent for the Intel platform as well. However I feel that the nForce 5xx is the first true NVidia SLI platform for Intel which is comparable on both the AMD and Intel sides of the fence. With this chipset the Core2 Duo gets what it deserves in terms of features and performance. The 975X went 90% of the way but with NVidia not wanting to approve it for SLI you’re only real choice was the AMD platform as NVidia IMO is the only way to go when it comes to SLI.

nForce 590 SLI Intel Edition: NVIDIA prepares an Intel 975X Killer


posted on Wednesday, 28 June 2006 15:38:31 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback

CommerceServerI can never remember what the different class types in the catalog table means, and finding the information in the documentation takes forever, so here they are for my own benefit more than anything else:

  • i_classType 4 == Product
  • i_classType 8 == Product Family
  • i_classType 2 == Variant
posted on Wednesday, 28 June 2006 10:41:33 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback

Ted Neward has a great article on Object-Relational Mappers or the Vietnam of Computer Science as he calls it. He lists many alternative solutions to different problematic areas which we all to some extent know instinctively are there but can’t quite put our finger on. It’s a long read but definitely worth it. You’ll be much the wiser for it.

My favorite part is his code for QueryExecution engines.

The Vietnam of Computer Science

posted on Wednesday, 28 June 2006 09:47:30 (Romance Daylight Time, UTC+02:00)  #    Comments [1] Trackback

If you visit the site regularly you’ve probably noticed that Google ads have appeared at the top of the site. I figured that I’d give them a try and see what happens. I must say that I’m pretty impressed by the targeting at this point. For one thing one of the first ads I see is one for Vertica ApS and our Commerce Server consulting and hosting business. That’s pretty accurate if you ask me

Getting started was easy as one, two, three. Created an account, watched a video about optimizing the ads, and finally implemented a small piece of javascript on the site. A couple of hours later targeted ads started showing up, please note that a couple of hours need to pass before real ads start getting displayed. Until that time only informational ads are displayed, it had me scratching my head for a while.

posted on Wednesday, 28 June 2006 08:47:08 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback
# Tuesday, 27 June 2006

CommerceServerJeff Lynch has some pretty sound advice for developing Commerce Server solutions, and I’d go as far as to say any solution which requires integration with some kind of backend system.

As many of you know, I develop business-to-business e-commerce solutions for the company I work for. These solutions are generally built using Microsoft's SQL Server, BizTalk Server and Commerce Server products. My overall goal when developing an e-commerce solution is to automate B2B transactions between trading partners in our supply chain. In doing this, I've found that "beginning with the end in mind" is the only way I know to ensure the success of our development projects. In Commerce Server 2007, following Stephen Covey's 2nd Habit has been absolutely vital to our success.

Commerce Server 2007: Begin with the End in Mind!

posted on Tuesday, 27 June 2006 20:40:55 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback




Finally something that looks like hard facts on how to create SO using .NET. At Vertica we’ve been working with this for a while now but I always feel that some kind of validation of our techniques would be nice. I can’t wait to dive into the guidance from the patterns and practices group.

For those who are new to the Service Factory, it's a collection of integrated guidance (including guidance packages, reference implementation and written guidance) to help you efficiently build consistent and high quality service-oriented applications on .NET Framework 2.0. Currently we are focusing most of our efforts on ASMX for the service interface, but we'll also be releasing guidance for WCF when this technology is released (and one of our older community drops includes an early version of our WCF guidance).

July Community Drop of Web Service Software Factory

posted on Tuesday, 27 June 2006 11:13:07 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback
# Monday, 26 June 2006
Digg 3.0 has released moments ago introducing new categories and an updated user interface. Looks pretty neat.
posted on Monday, 26 June 2006 15:11:38 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback
posted on Monday, 26 June 2006 14:50:08 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback
# Thursday, 22 June 2006

A customer needed Reporting Services 2005 but was running SQL Server 2000 and didn’t want to invest in a 2005 license as 2000 fits their needs just fine. Naturally I was exited to learn that Reporting Services would be available for SQL Express. That however was several months ago.

Now it seems the support has finally been released allowing us to use SQL Server 2000 as data backend and SQL Express as reporting frontend.

SQL Server Express with Advanced Services

posted on Thursday, 22 June 2006 13:40:33 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback

CommerceServerThere have been a couple of questions about how to use and integrate MSCS Authentication with ASP.NET Authentication.  For those of you that don't know, MSCS Authentication is Microsoft Commerce Server's authentication cookie/ticket that is used to identify Commerce Server Profile users.  With Commerce Server 2007, we recommend you use the ASP.NET's membership provider but then the question arises, how does our web analytics use and decode this cookie? “

Read more on Commerce Server 2007 Authentication with ASP.NET Authentication.

posted on Thursday, 22 June 2006 13:37:26 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback

Visualstudio_logoEverybody should have a version control strategy so Roy Osherove’s post entitled A Simple Version Control Strategy Using Team System is basically a must read even if you don’t use Team System.

posted on Thursday, 22 June 2006 13:37:13 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback
# Tuesday, 20 June 2006

Darrel Norton has a very informative post called Seeing Double: An Unbiased View on the Benefits of Multiple Monitors which details an experiment they did where they put developers in front of dual monitors and watched the number of bugs and code churn.

Most importantly they saw the following numbers:

  • Productivity in lines of code per day increased 10%.
  • Defect levels decreased by 26%.

Very interesting.

posted on Tuesday, 20 June 2006 15:57:43 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback
# Monday, 19 June 2006

WesterndigitalI’ve been swearing to the Samsung Spinpoint P120 drives for very quiet PCs in the past but have been frustrated with the low max capacity of the drive (250GB). Now it seems I’ve found a great alternative in the Western Digital Caviar SE16 500GB.

SilentPCReview basically says that this drive is the quietest of all desktop drives available today, it even comes close to the good old Seagate Baracuda IV which has been reigning king forever. I know it’s bad form but I couldn’t resist taking this snip,

For once, a hard drive has lived up to its marketing claims. The 500 GB Caviar SE16 is the quietest 3.5" desktop drive that we know of on the market today. Not only is it quieter than all of the other high capacity drives that we've looked at, it also beats the Samsung Spinpoint P80 and gives the venerable Barracuda IV a run for the money. These are old drives with fewer platters that have less than one sixth the capacity of the new Western Digital.

Western Digital Caviar SE16 500GB: Big Low-Noise Champ?

posted on Monday, 19 June 2006 13:02:01 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback
# Sunday, 18 June 2006

Well maybe not exactly but Windows Vista does come with an implementation of Launchy which to me is great news seeing as Launchy is the best thing which has happend since sliced bread

Basically you pop up the startmenu using the WIN key and you’re ready to type just like you are with the Lacunhy shortcut. In previous builds of Windows Vista I didn’t even consider using the feature it was so slow, not so with beta 2. Everything is snappy and happends instantaneously.

I do believe that the startmenu search feature will be my favorite feature of Vista.

Oh yeah, did I mention that Vista is fast on a desktop machine? Stay tuned for more posts about Vista, the next one will probably be about how I lost all my data due to running beta versions of both my OS and Office

posted on Sunday, 18 June 2006 21:42:41 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback

Up until this point I've only ever tried out Windows Vista on my laptop and have found the performance to be lacking. I'm pleased to inform you that Windows Vista runs sooo much more smoothly on a desktop machine. I mean we're talking leaps and bounds here. Granted my laptop is getting a bit long in the tooth but we're still talking 1.5GHz Penitum-M with a 7200 RPM hard drive, and a gig of memory. Not too shabby even for a two year old laptop.

My desktop machine is equipped with a Pentium 4 with Hyperthreading, and my guess is that the hyperthreading is making all the difference in the world, seeing as the only difference between my laptop and my dekstop machine is the CPU. My desktop is even older than the laptop in any case :) Vista seems to be much more comfortable in a hyperthreaded or even better a dual core environment.

If you were to ask me about one thing to make sure to get for your Vista machine it would definitely be a dual core CPU of some kind.

posted on Sunday, 18 June 2006 19:42:16 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback

I forgot to point out one important piece of information from Ryan Donovan's CS 2007 release post. What I failed to mention because my job generally doesn't entail having to deal with licenses and such is that pricing and the editions of CS will remain the same for 2007 as they were for 2002. So that's good news :) Now we can back to the regular scheduled programming involving all the fun technical stuff :)

posted on Sunday, 18 June 2006 19:35:22 (Romance Daylight Time, UTC+02:00)  #    Comments [0] Trackback