I spent last Friday & Saturday writing some SQL code for client to make finding historical data “outages” quicker and easier. They wanted to know where all of the time spans where the quality wasn’t good. I was thinking it was a little like a needle in a haystack problem, but it’s not. It’s harder than that. It’s more like measuring every piece of hay in the haystack.
6 Comments | 
SQL | 
Permalink
Posted by David Goodman
In our work we do a lot of interfacing with SQL databases (usually MS SQL Server). Being able to interface with SQL from IAS is a big weapon in one’s arsenal. You can retrieve data from a table or view, execute stored procedures and functions, and virtually anything else you can dream of doing with T-SQL.
We’ve wrapped most of the code to do the SQL DB interfacing into a DLL for simplicity and error trapping. However, this post is intended to give a basic example on executing a simple query from an IAS script using the .NET objects.
6 Comments | Leveraging .NET, SQL | Permalink
Posted by David Goodman
