Business Applications - Microsoft ApplicationsSQL Server Application Solutions
Database design for application vendors and in house application design
Using DBAs rather than a developer to produce your application database allow 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.
SQL server Development
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