MS SQL Server – SQL, T–SQL, VBA
t–cos GmbH, Feldbrunnen
PROJECT LINK: Not available
Persons in the PROJECT: Stefan Troehler
PROJECT Duration: Feb 2004 - Dec 2005
PROJECT value: SFR. 00,000.00
Persons in the PROJECT: Stefan Troehler
PROJECT Duration: Feb 2004 - Dec 2005
PROJECT value: SFR. 00,000.00
0
HOURS REQUIRED
0
CUP OF COFFEE
0
LINES IN THE CODE
0
EXPERTS IN THE PROJECT
Implementation of a performance recording for the company t-cos Feldbrunnen. In a first prototype Microsoft Access is used as a database, the user interfaces are already being developed in this prototype using VB .NET. In version 2 the Microsoft Access database is replaced by a Microsoft SQL Server and a large part of the logic is transferred from the user interfaces to the backend in the form of stored procedures and functions.
- Developing a performance record as a supplement to the worldwide
- patented systems from t-cos GmbH (working time recording using
- biometric data).
- Times recorded by biometric data are assigned to a project or an order using a service catalog.
- Services defined in this way are in turn assigned to a customer via project or order.
- The customer administration takes place via client administration.
- The time recording data is stored in a Microsoft SQL Server.
- The performance recording data is saved in a Microsoft Access 2000 database.
- There is an automated synchronization (trigger) between time recording data and performance data.
- The user interfaces are developed using VB.NET.
- Requirement engineering, data model using design.
- Implementation of customer requirements using Microsoft SQL Server, Microsoft Access 2000, Microsoft Visual Basic for Application, T-SQL and Microsoft VB.NET.
- Testing and documentation (user and technical).
Stefan Tröhler
Microsoft SQL Server development
03 Feb09:57:19 AM
Developer SQL Server - SQL, T-SQL
03 Feb09:57:19 AM
Access, VBA, Microsoft SQL Server – Microsoft Competence
12 Jan09:34:09 AM
Microsoft Access, VBA, SQL Microsoft SQL Server / Consultant
11 Nov09:34:09 AM
Microsoft Access, VBA, Microsoft SQL Server - Developer / Consultant
13 Sep10:34:09 AM
Microsoft SQL Server DWH Developer - T-SQL, ETL
13 Feb09:34:09 AM
Microsoft Access, VBA, Microsoft SQL Server - Developer / Consultant
13 Feb09:34:09 AM
Developer POSTGRES - PENTAHO
13 Feb09:34:09 AM
Developer SQL Server - MIS
13 Feb09:34:09 AM
Microsoft SQL Server consultant
13 Feb09:34:09 AM
Microsoft SQL Server Specialist - DBA Admin
13 Feb09:34:09 AM