2010Unpublished venueRequires access

SQL server 2008 based application development

Anton Šivic

Open publisher page 0 citations

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.

About this research paper

What this paper is about

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.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available 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.

Key concepts: Data Transformation Services, Business Intelligence Markup Language, User-defined function, Computer science, Language Integrated Query, SQL injection, Stored procedure, Autocommit

Related papers

Back to paper searchBrowse research topicsOriginal source
SQL server 2008 based application development — Research Paper | ScholarLens