THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Paul Nielsen

www.SQLServerBible.com

Extensive library of Excel functions for SQL Server

When SQL Server 2000 introduced user-defined functions I predicted that a few companies would release sets of cool financial/mathematical/statistical functions. It didn’t happen. When SQL Server 2005 introduced the CLR, I again predicted that a few companies would release sets of cool financial/mathematical/statistical functions written in CLR. It didn’t happen.

Enter www.WestClinTech.com. These guys have done it. They’ve released sets of Financial, Statistical, Math & Trig, Engineering, Unit Conversions, and String CLR functions. And they’re smart about it too. Rather than reinvent the wheel, they replicated most of Excel’s function, so when the business analyst’s model a formula, you’re all set.

I’ve started testing them and so far I’m impressed. If your application could benefit from moving complex calculations into the database instead of passing all the data to an iterative tier, then I suggest you take a good hard look at this company. This is exactly the kind of third-party product I want to see around SQL Server. Well done.

Published Tuesday, March 02, 2010 5:27 PM by Paul Nielsen

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

About Paul Nielsen

Paul Nielsen believes SQL is the romance language of data. As such he’s a hands-on database developer, Microsoft SQL Server MVP, trainer, and author of SQL Server Bible series (Wiley). As a data architect, he developed the concepts of Smart Database Design and Nordic – an open source O/R dbms for SQL Server. He lives in Colorado Springs.

This Blog

Syndication

News

news item test
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement