Category Archives: SQL Server

Where’s my data?

When designing reports, one of the trickiest aspects is often just finding the data. There may be no database schema or the original designer is unavailable, often unhelpful. I’ve used the free version of Redgate’s SQL Search for some time. It’s great for finding column or table names. Especially useful if you want to find all tables that… Read More »

Design and development of Data Warehouse including ETL using SQL Server Integration Services. Design of Web Intelligence Reports.

Customer: Market Leading Leisure Organisation We  planned and implemented data migration from multiple source systems into a final data warehouse from which Web Intelligence Reports were created using Universes. Some additional Crystal Reports were also created. Much of the data came from legacy systems so robust procedures were put in place to ensure the accuracy of the data.… Read More »

Caching queries using SQL views

A customer approached us as they were having problems with report performance. The problem related to a report being based upon a view that took 90 seconds to run. I didn’t think that was too slow until they told me that there were hundreds of concurrent reports all hitting the same query. First response was to rewrite the view… Read More »

End to end reporting solution, from data warehouse design through to SharePoint integration

Customer: Diagnostic Imaging Provider Project: End to end reporting solution, from data warehouse design through to SharePoint integration. Pursuit Technology were responsible for enabling reporting across multiple disparate systems. A reporting database (datamart) was designed in Microsoft SQL Server, loaded on a daily basis using Microsoft SQL Server Integration Services. The reports were initially intended to be produced… Read More »