Business Applications - Microsoft Applications - SQL ServerSQL Server Application Consulting
As a Microsoft Gold Partner, Quantix’s Application Consulting team is at the forefront of SQL Server technology. Our pre and post sales (vertical market) consultants use their vast experience and expertise to assess your business requirements to help deliver your software strategy impartial advice to implement the latest in SQL Server Application Software to maximise on your SQL Server Application Investments and SQL Server experience.
Our Application Consultants are here to add value to your SQL Server investments, and with our Knowledge Transfer service we can help your in-house DBAs understand your software.
Our service is built to revolve around you, utilise our consulting expertise on either an ad-hoc / project based requirement or on an ongoing 24*7 contract basis.
Key consultation areas
Service orientated consultancy includes:
- Strategic Services
- Upgrade Services
- Organizational Change Management Services
- Extended Services
- Implementation Services
Product orientated consultancy includes:
Performance Tuning & Database Admin
Although some clients have DBA’s onsite, having access to third party skills with multi-project experience is often crucial to solve testing issues of availability, performance, speed & resilience. Quantix provide these resources to clients of all sizes, some of whom use us when specific issues arise and others in a more pro-active fashion. Key services to assist SQL Server performance include:
- SQL Health Checks
- Database upgrades and migrations
- Database Log analysis
- Application Enhancements
- DR Testing
Quantix consulting services, together with technology such as SQL LiteSpeed can reduce storage costs and backup/recovery time times by up to 75%. Typically an implementation of LiteSpeed can backup a Terabyte in under an hour.
Replication
SQL server can be used as a high availability platform for databases using the following technologies
- Replication
- Clustering
- Log shipping
- Database Mirroring (SQL server 2005)
- 3rd party clustering and replication tools
Use of these technologies requires considerable planning and maintenance to avoid a poor implementation. Quantix consulting services can assist throughout the entire project lifecycle or be used to deliver distinct phases.
Database Security & Encryption
SQL server will include a secure encryption system, however 3rd party applications allow SQL server 2000 to be used with encrypted data.
Sarbannes-Oxley compliance and general security audits can be tied into SQL server security health checks or can be delivered as discrete services. Penetration testing is a service that can be carried out for applications as well as servers and is an exercise that we recommend is performed on a quarterly basis where possible.