O'Reilly logo

Applied Architecture Patterns on the Microsoft Platform - Second Edition by Gregor Noriskin, Dmitri Olechko, Andre Dovgal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Building the payroll processor application

We will be working with the use case from the previous chapter, the solution for Reliable Payroll Pro Inc.—also known as RPP. Refer to Chapter 3, The SQL Server Primer, for the full details of this use case.

To briefly refresh your memory, we were building a system to process payroll data from the various sources and clients of RPP. We built a solution using the capabilities of MS SQL Server alone. We created SQL scheduled tasks that are running T-SQL scripts to import data from Excel spreadsheets into the RPP database and process it as required.

Adding more details to the RPP use case

Let's imagine that we have an additional requirement in our use case. We made a tacit assumption that our scripts would ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required