Intel’s Meltdown and database performance

Unless you’ve been on an extended Christmas break with no TV or Internet, you’ll have heard of Intel’s recent troubles. While it’s true that most computers will not be noticeably affected, servers that read and write large amounts of data to disk will be impacted. In my world, that affects two things – databases and…

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…

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…

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…