microsoft

Developing a concept for the cost-effective migration of 600 SSIS packages, consisting of an analysis of all existing packages, dividing the packages into three groups, underpinning the concept including calculating the time needed for migration, and developing several options for a cost-effective implementation of the entire migration. The implementation is partly done with in-house staff, with students and with migration specialists. The concept also takes into account performance optimisation of the individual SSIS packages.

Creating a prototype of a database compiler that is able to convert process-oriented flow structures and flow diagrams into stored functions. The application is used to register the signatures of employees with regard to the legal templates in the commercial register. In doing so, a rule management of more than 2000 active rules is taken into account when registering employees. Not only the database compiler is ordered, but also various auxiliary programmes, which are necessary for the automated process from the mail to the published signature on the Internet. The application is realised using Microsoft SQL Server, SQL, T SQ, .NET and C#.

Support of the company Hörservice AG in the realisation and implementation of requirements in the area of Microsoft SQL Server developments, independent of the application. Complex stored functions and complex dynamic SQL statements are realised.