Learn how and why to convert a scalar user-defined function to a table-valued one

My name is Angelo Martinez and I am new here at Falafel Software. I have known Lino Tadros for a long time and I can assure you that this is a great place to be! My hope is to start blogging on new ideas/tools/technologies that I discover along the way. With that in mind... I had a requirement to build a generic MRU (Most Recently Used) class based on a Key/Value pair. Among other things, the class contains methods such as Add(), Find() and a Count property that reports the number of items currently in the list. It would be nice to be able to build a set of unit tests to verify the functionality of the new class. For this, Visual Studio 2008 comes to the rescue!

Prior to 2005, if you needed to access the value of a newly inserted IDENTITY column, you were bound to row-based operations so you could access each value using the SCOPE_IDENTITY() function. But now, there is another way...

Santa Cruz, CA— Falafel Software , a Microsoft Gold Certified Partner providing consulting, training, and software development for enterprise and small business customers, is proud to announce the renewal of its Microsoft Gold Certified Partner membership for 2008.

I was reading some articles recently regarding what companies are doing to collaborate, not just with their team, but with their company and clients. Project management and collaboration software is becoming more mainstream as technology has advanced allowing more tasks to be automated as well as making it much easier for teams to work together remotely. I came across an article from CIO talking about a large upswing in companies with 1,000 employees or more that will be implementing a formal collaboration technology strategy for 2008. This was from a survey taken from Forrester Research and shows that the value of proper collaboration tools are starting to really penetrate the market, which should help to spur strides in social technologies even more.

Santa Cruz, CA March 16th 2008 — Falafel Software Inc, a Microsoft Gold Certified Partner providing consulting, training, and software development for enterprise and small business customers, today announced the world wide release of the official training material for AutomatedQA's TestComplete product.

An another FAQ asked question about TestComplete is "Why when I check the Exists property of my [Insert UI element here] do I get an error message in the Test Log?".

ControlParameters are a really nice way to declaratively define the behavior of DataSources, but often you need values that aren't directly in controls. Here is how to bind a ControlParameter so that it reads any page property you define.

Today I learned how to compare text columns in different SQL server databases that use different collations.

A question that comes up fequently about TestComplete is; "How do I call a script routine in another project from the project I am currently working in?"