SQL server 2008 based application development

Anton Šivic (2010) SQL server 2008 based application development. EngD thesis.

PDF Download (4Mb)

Abstract

In my thesis i tried to present some functionality from SQL Server 2008 platform and some new functionality and extensions that were introduced in Microsoft.NET framework version 3.0, 3.5 sp1 and 4.0. Things most interesting to me were SQL Server Integration Services, SQL Server Reporting Services and SQL Server Analysis Services. I think SQL Server Integration Services are interesting because you can create custom work flow diagrams and event handlers with which you can capture a lot of your business logic without any addtional programming. I decided to also use SQL Server Reporting Services because of it's great reporting system. With the use of SQL Server Reporting Services we get a great reporting system without a need to have IIS intalled and at the same time we can still implement a lot of security features. With this security features and settings we can assure that in our business environment only those who have suficient privileges can see the reports. The reports we do with SQL Server Reporting Services are as good as they were made inside applications that were specially designed for that purpose. With SQL Server Analysis Services we can analize our database data and the do different optimizations. This makes our work a bit easier because we do not need any aditional tools for analysing data. With SQL Server Analysis Services we can do different pivot tables. Additionally I decided to include a chapter about Entity Framework and with that in mind also about LINQ technology. I find this technology very interesting because it makes it possible to work with database table and other database objct as regular objects.

Actions (login required)