Archive for the ‘Testing’ Category

SQL 2005 Try/Catch

Friday, May 1st, 2009

How stupid do I feel for just now finding that T-SQL 2005 has try/catch?

http://www.sqlservercentral.com/articles/Testing/66553/

VS Live In San Francisco

Thursday, March 22nd, 2007

I will be at VS Live in San Francisco next week focusing on the Team System and SQL Server 2005 tracks. I’m most interested in getting ideas & hearing about others’ experiences with automated testing of SSIS ETL packages. If you’ll be there and are interested in such discussions, I’d be happy to meet up and talk further– just drop me a line in the comments or via email: tito/at/titoperez/dot/com. SSIS and (especially) VSTS are relatively new to me, and I’m part a nascent BI/DW project using both.

Of course, I’m still open to ideas from those who won’t be there, too.

roundup

Friday, March 16th, 2007

Using SQL Server Files for Unit Testing in VS2005 TS

One of the nice features of VSTS is data-driven testing. It’s as easy as hooking up a couple of attributes to the test classes, which then allows tests to be run for multiple sets of input data. The problem is when you want to include data with the test project.

(a solution follows)


Using capistrano to manage EC2 instances (amazon.com’s “virtual computing environment”). The comments also have some interesting discussion about the considerations made in choosing to use Amazon’s services for a startup. See also: Building a Web Application with Ruby on Rails and Amazon S3.

Dare Obasanjo pondering the future of Amazon’s S3 & EC2 services:

What I suspect is that without some catalyst (e.g. the next YouTube is built on S3 + EC2)these services will not reach their full potential. This would be unfortunate because I think in much the same way we moved from everyone rolling their own software to shrinkwrapped software, we will need to move to shrinkwrapped Web platforms in the future instead of everyone running their own ad-hoc cluster of Windows or LAMP servers and solving the same problems that others have solved thousands of times already.