T-SQL Training for Government IT System Upgrade
16/01/2018: Data Analysts at a Government establishment required the ability to respond rapidly to ad-hoc requests for information, including parliamentary questions. To this end, a new Data retrieval application was required with access to information in multiple locations. Situation A major upgrade to one of the client's IT system was delivered in Nov 2017 by a third party supplier. This provides a public web front-end and secure database back-end on Microsoft SQL Server. The legacy reporting platform based on SAP Business Objects, was replaced with SQL Server Reporting Services (SSRS). Problems...