Microsoft SQL Server Application Solutions

Database design for application vendors and in house application design

Using DBAs rather than a developer to produce your application database allows you to leverage the features of SQL server, implement a solid security scheme and ensure database design meets the Normalisation standards required to make a database scalable and extensible.

MS Access
Primarily used for small databases and rapid application development of prototype systems. These databases are generally migrated to SQL server as they become business critical.

Application Creation

MS Office Based
Many prototype applications or RAD applications are based around Microsoft office. Office based applications can also link into Outlook, Excel, Word, SQL server and other systems.

Visual Studio Based
Solid platform for business critical applications. Using the .Net framework applications modules can be developed in C++, C#, VB and ASP and interlinked to form an application framework.

Reporting & analysis

SQL server analysis and reporting services
SQL server reporting and analysis services can be used to implement an enterprise wide reporting system. These reports are either integrated into your company's intranet or embedded in applications. Reports can be also auto-emailed to users.

Crystal Reports
As per the SQL server version, however Crystal reports is a much easier product to write reports with.

Procedural Code
Building T-SQL code from established business logic or functional requirements

Business Logic
Building both business logic and T-SQL code from user requirements