Case Studies

From Warehouse to Working Collections

By fully automating the data transfer process, the client reduced turnaround time of official monthly numbers from two weeks to just one day after approval…

A Modern Marvel of Direct Data Consumption

…With a goal of having the 3M processing occur on a separate server, we exposed the necessary methods through Windows Communication Foundation (WCF) end points, and consumed them directly from SQL Server via CLR procedures.

A Hospital’s Data Gets a Clean Bill of Health

…A solution that would enable non-programmers to tackle 80 percent of the data mapping needed when setting up a new engagement — yet offer the flexibility of custom programming.

Packing Up and Moving Up to SQL Server

Through code profiling and SQL server tracing, we were able to determine that the pain point was with the use of XML data type methods introduced in SQL Server 2012… The client realized a 10-fold increase in performance after refactoring.