Expert Knowledge
SQL Server forms a critical part of an organisation's IT infrastructure. Its performance and availability can directly affect the bottom line. Being both database developers and infrastructure specialists, Citric Technology understand all aspects of SQL server, giving us a 360 degree view of how SQL servers should perform.
Available Services
Platform Design & Installation
If you are considering a SQL server installation, call us for expert SQL consultancy services, to ensure you maximise the solution's capabilities.
- Complete service, from planning and sizing to commission and data migration.
- We can advise on hardware configuration and acquisition.
- We use load-simulation tools to baseline and optimise hardware performance prior to SQL installation.
- We aim to maximise the 4 critical factors: performance, availability, recovery and growth.
Performance Report
This is a one-day on-site service with a follow-up report, for companies experiencing problems with SQL server performance, or who are considering changes to the SQL infrastructure.
- Investigates every aspect of the SQL infrastructure including:
- Network environment
- Hardware performance and configuration
- Server configuration
- SQL configuration
- Database design
- Client access and design
- Performance monitoring of database and server over the day, and longer periods if required.
- Performance results presented and explained.
- Recommendations presented, along with explanations, benefits, and implementation plans.
- Report presented in format suitable for management, but contains full technical details.
The above is available for £1000 for up to three SQL instances on a single server or cluster, excluding VAT and travel costs. More complex installation may require additional hours/days - please call us for further details.
Mirroring/Clustering (advanced installations)
If you looking to implement advanced SQL functionality, such as mirroring and clustering, but don't fancy going it alone, call us in for expert assistance. We are used to performing the required steps of extending the database platform, and can ensure you avoid the pitfalls of a major infrastructure change without risking the company data. We can also use our expertise in virtual server to build affordable standby servers.
Backup and Recovery Solutions
In addition to the availability solutions above, good backup and recovery solutions for SQL server are essential, particularly as the size of your data grows. We can implement backup plans for traditional tape backup systems and autoloaders, and backup to online systems, such as disk-based backup or remote backup services to ensure you always have a backup file close at hand.
We can also offer assitance in recovery scenarios, by providing anything rapid-build service where a whole new SQL server is required, to side-by side data recovery where individual rows need recovering.
Reporting Services
Reporting services is a powerful feature of SQL 2005 that is often overlooked for alternatives such as proprietry client-side reports, Crystal Reports, and even Excel. However, we think Reporting Services represents the most extensible reporting solution available on SQL server if you know how to get the most out of it - we've been developing solutions on it for three years and wouldn't use anything else. If you require a reporting solution, or your current reports aren't up to scratch, talk to us about SQL Reporting Services today.
Features of Reporting Services:
- On demand and scheduled subscription based delivery of reports.
- Export to a variety of formats, including Acrobat PDF, Excel and Word.
- View reports in a web browser.
- Active directory integrated security.
- Edit report definitions in Visual Studio, or give users the ability to create their own reports in a controlled environment using a simple web-based editor.
- Reports can include datasets from other sources, including DotNet classes.
- Licensed with SQL Server (depending on version).
Data Migration Services
If you are moving from a legacy or proprietary system, or merging data from other sources, we can offer you design and support services for data migration and transformation packages. We can design these for one-off scenarios, or as part of a regular import/export routine, putting in place the necessary security and transfer protocols for moving data between systems. This is an area where our SQL development crosses with our consultancy and infrastructure roles.