This service provides expert support and assistance with all aspects of SQL Server databases potentially running on cloud-based infrastructure. From database design through to physical build, performance tuning and security optimisation. In-life operations such as upgrades and one-off or regular ETL (Extract, Transform and Load) operations can also be supported.
- SQL Server database design, sizing, performance analysis and tuning
- Both private and public cloud infrastructures are supported
- Access expertise in other platforms like Teradata, Ingres, and MongoDB
- Delivery from our Leeds location or any UK customer premises
- Access to SQLServer expert DevOps, 2000, 2005, 2008, 2012, 2014
- Consultancy and support for ETL (Extract, Transform and Load) operations
- Hand-holding, consultancy and support through system upgrades
- Data migration and data cleanse consultancy, hand-holding and support
- Data mining, data engineering, data mart, data warehouse consultancy support
- Free up your own staff to undertake more strategic work
- More reliable, perfomant and secure SQL Server databases
- Exploit economies from scalable cloud-architectures
- Enables exploitation of Amazon Web Services and Google Cloud Platform
- Enables exploitation of the Microsoft Azure (formerly Windows Azure) platform
- Enables exploitation of Software as a Service (SaaS) based architectures
- Enables Business Intelligence reporting
- High performance NoSQL database systems
£395 to £875 per person per day
- Education pricing available
BLUESMITH INFORMATION SYSTEMS LTD
|How the planning service works||
Regardless of what services we are providing we always seek to initiate our relationship with our customers by gaining an understanding of their business priorities and objectives. This can be achieved through workshops, questionnaires, desk research, one-to-one / group interviews and structured discussions. The precise mix of techniques we use is based on customer preference and is agreed at the outset of each assignment.
Based on an understanding of the customer's objectives and priorities we normally formulate a number of optional project approaches along with a summary of the respective strengths and issues associated with each option. These optional approaches are used to inform further discussion with the customer to arrive at a preferred option.
Based on the customer's preferred option we will develop a detailed implementation plan to support the cloud hosting or software services that are to be implemented. The plan will typically be based on PRINCE2-type principles and will normally include Gantt charts to show schedules; Product Descriptions, to help clarify deliverables; Management Plans, to communicate how the customer's staff, Bluesmith and any third parties will work together; and, where applicable, financial and budget schedules.
|Planning service works with specific services||No|
|Training service provided||Yes|
|How the training service works||
We work with customers to undertake a thorough Training Needs Analysis to understand the different categories of users and the specific training needs for each different cohort within the customer's organisation. We can employ a range of different and flexible training options in order to deliver a tailored training programme which will be an excellent fit for each customer's particular requirements.
Our training methods are drawn from; classroom-based at customer premises or Bluesmith premises; development of self-paced CBT and paper-based training materials; coaching and mentoring style training to individuals or small groups.
We integrate monitoring and feedback mechanisms into whatever training methods are employed. This enables us to give assurance that students have taken on board and understood the training materials and that training objectives are met. It also allows us to adapt and improve training programmes flexibly through the life of each implementation.
|Training is tied to specific services||No|
Setup and migration
|Setup or migration service available||Yes|
|How the setup or migration service works||
The first step in helping our customers migrate to, or between, cloud hosting / software services is for us to work jointly with the customer to undertake a Discovery Audit. Through this process we will jointly catalogue all of the Applications (including underlying databases, system software and operating systems), Data, Users and Security Aspects that will be in scope for the migration. Armed also with a thorough understanding of the customer' business objectives and priorities (gleaned from separate work on joint planning) we would then be able to develop a range of Migration Strategy options for review and discussion with the customer.
Our experience tells us that the complexity of any particular migration will sit on a spectrum. At one extreme is a straightforward re-hosting where applications and technologies are unchanged and customers just move from a legacy infrastructure platform to a cloud environment. At the other extreme, underlying technologies might be changed, new functionality developed, and additional interfaces built as part of the migration project. Bluesmith has experience of working with customers at all points on this spectrum and we have developed tools and methodologies which can be reused to effect a smooth and efficient migration.
|Setup or migration service is for specific cloud services||No|
Quality assurance and performance testing
|Quality assurance and performance testing service||Yes|
|How the quality assurance and performance testing works||
Central to our approach to Quality Assurance is that we build quality into every aspect of what we do. In the context of our cloud support services, this starts with ensuring plans, specifications and design documents are thoroughly and effectively peer-reviewed to ensure they are of good quality within themselves (to assure we are 'doing things right') and that they are fully reflective of predecessor and successor documents (to assure we are 'doing the right things'). This approach is carried through to all subsequent implementation stages, in particular into our software and system testing methodologies, which are based on layered and incremental testing stages with predefined exit and entry criteria. We have well developed processes and systems to record, allocate and monitor resolution of any quality assurance and testing issues.
With regard to Performance Testing (which sits within our overall Quality Assurance processes) we make extensive use of software automation and measurement tools in order to ensure Performance Testing is comprehensive, repeatable and efficient. Our Performance Testing addresses transaction, concurrency, load, capacity, reliability and resilience aspects of performance. Our emphasis during performance testing is to ensure bottlenecks are rapidly identified and addressed in order to assure acceptable fitness for purpose.
|Security testing service||Yes|
|Security testing type||
|Accredited security testers||No|
|Certified Professional (CCP) risk analysts||No|
|Ongoing support service||Yes|
|Types of service supported||
|How the support service works||
We can provide User Management, Service Management and Helpdesk Support of cloud hosting and software services. Our service methodologies are based on an ITIL-type approach. Our User Management services typically allow for creation, update and removal of user accounts. Our Service Management services typically consist of proactive monitoring and management of cloud hosting and software services to ensure they operate within agreed service levels. Our Helpdesk Support services typically allow for incident reporting and resolution along with root cause analysis to ensure that service improves over time.
For each of our customers we develop a specific Service Management Definition with agreed SLAs which is particular to the cloud hosting and software services that have been deployed.
We can provide ongoing support for all common hosting and software support services but we have particular expertise in Amazon Web Services, Google Cloud Platform, the Microsoft Azure platform, and Microsoft technologies such as SQL Server, .NET (DotNet), C# (CSharp) and ASP.NET technologies.
|Service constraints||We are a UK business based in Leeds and as such would be constrained in providing rapid onsite support to geographically distant sites. Apart from this, we believe we can normally develop service approaches that overcome most other typical constraints.|
|Email or online ticketing support||Email or online ticketing|
|Support response times||Support levels up to 24 by 7 can be agreed per order in line with customer needs, with initial response times as low as one hour, during support availability periods. Weekday and weekend support can be different or identical as determined by customer need and as agreed in our Service Management Definition.|
|User can manage status and priority of support tickets||Yes|
|Online ticketing support accessibility||None or don’t know|
|Phone support availability||24 hours, 7 days a week|
|Web chat support||No|
|Support levels||Support levels up to 24 by 7 can be agreed per order in line with customer needs, with initial response times as low as one hour, during support availability periods. Weekday and weekend support can be different or identical as determined by customer need and as agreed in our Service Management Definition.|
|Supplier type||Not a reseller|
|Staff security clearance||Other security clearance|
|Government security clearance||Up to Developed Vetting (DV)|
|Price||£395 to £875 per person per day|
|Discount for educational organisations||Yes|
|Pricing document||View uploaded document|
|Skills Framework for the Information Age rate card||View uploaded document|
|Service definition document||View uploaded document|
|Terms and conditions document||View uploaded document|