Our SQL specialists solve all tasks within design and installation of SQL Servers, performance optimisation, troubleshooting and support. Regardless the size of the task, we have a consultant with the right competences.

In addition to having deep knowledge about the SQL Server, our SQL specialists also have specialist knowledge about the areas that interact with SQL, among others Microsoft AX & NAV and BI.

If you are a new customer to us, we always suggest starting off our cooperation with an SQL analysis. It provides the best launch pad for us to create real value to your business. The SQL analysis will always result in a report describing the current setup, suggestions for future setup, a plan with time estimates for external as well as internal time and an actual business case.

Exploit your Microsoft license agreement in the best way possible. Let your SQL Server Deployment Planning Services (SSDPS) vouchers pay for analysis and planning of your company’s SQL upgrade/migration.

Several of Microsoft’s license agreements provide access to SQL Server Deployment Planning Services (SSDPS/DDPS) vouchers. So, if you are considering upgrading your current SQL-installation or wish to migrate to SQL there might be financial support waiting for you in your license agreement. Due to our close cooperation with Microsoft – and our status as Managed Partner within SQL – as one of very few suppliers, we can offer you an analysis of your SQL environment for free, i.e. paid by Microsoft’s vouchers. Your SQL Server Deployment Planning Services (SSDPS) vouchers can be used as payment for

• Data collection and analysis of existing setup.
• Workshop with focus on requirements and wishes for future setup. Participants will be one of our SQL specialists together with the decision makers and technical staff from your organisation.
• Preparation of plan for upgrading/migration in relation to sizing, version, Cloud/Hybrid/on-premise, requirements and wishes from the organisation, licensing, etc.

Get an overview of your server’s current condition with a condition report from the SQL specialists. The report is a tailored snapshot, which takes its point of departure in your specific needs, and the consultant thoroughly goes through the report with you.

Choose SQL condition report, if

• You have a new SQL Server (installed by you or a third party) and you want to ensure it has an optimal set up and correct configuration.
• You have an existing SQL Server and want to get good advice on performance optimisation.
• You experience long response times in an application based on an SQL Server. 

The condition report can contain

• Review of disc configuration as well as other configuration of the operative system relevant to the SQL Server.
• Control of the SQL Server’s general settings and configurations.
• Advice on use of available updates for the SQL Server.
• Review of maintenance plans and backup methods.
• Review of other jobs and their operational condition.
• Check and evaluation of indexing and other performance parameters on all databases.
• Basis performance review of the server.
• Review of SQL-logs.
• Review of SQL-related backup logs.
• Review of SQL-related Windows logs.
• Setup of our standard maintenance, including e.g. index and statistics optimisation.
• Suggestions for optimisation, e.g. creation of index, disc setup, etc.

Note: A condition report applies to one SQL Server (instance) only. If you need an overview of your entire server environment, you should choose to have an SQL analysis prepared.

You might already know. The number of SQL Servers has accumulated over the years and each individual application provider required an SQL Server on their own. Or maybe it just seemed easier to install a new server instead of placing several databases on an existing server.

Besides getting a disproportionate large license bill, the issue of having many SQL Servers may be that you are not maintaining them. Lacking patching can result in a server that is vulnerable to hacker and virus attacks, and if you do not maintain it with indexing, SQL does not function optimally. This will result in overspending of resources and performance problems.

Unit IT’s SQL specialists are highly experienced within optimisation and consolidation of SQL environments. We typically initiate our cooperation with an analysis resulting in a report with design propositions, time estimate for internal and external hours as well as a business case. You thereby know the detailed scope of the project before we start.

We use a thoroughly tested and safe way to get you an optimised and modern SQL Setup.

Microsoft’s SQL Servers constantly undergo changes, both regarding functions, safety and performance. An SQL Server 2017, for instance, is up to 30% faster than SQL 2012. At the same time, please note, that it is not possible to safety update expired versions of SQL Servers. Watch the below table for support expiry dates of each version.

We solve any task within SQL development whether it is a large development project as extra resources to your existing development team or as a support/mentor for your SQL developers. Working targeted with development in SQL, we have deep knowledge about its opportunities as well as knowledge to most recent functions and best practice within SQL development. We have high experience in the development of solutions adjusted to customer needs as well as optimisation of existing solutions.

We can help you

• Optimisation of SQL requests
• Review of existing solution
• Generation of data for reports
• Professional sparring to your SQL development team.

Every day, all year round, the SQL specialists solve specific SQL-related tasks for our customers. Another thing we also excel at is teaching. Both solving consultancy tasks and carrying out tailor-made workshops, seminars and courses for customers all over Denmark.

Do you want us to arrange a specific course or seminar for your organisation, please contact us on tel.: + 45 70 27 70 22.

We know our operational customers’ SQL Servers down to the smallest detail. For the business-critical systems to function optimally, it is essential to have a good foundation which is being proactively maintained. This makes it easier to carry out troubleshooting should an operational problem occur.

Continuous performancemonitoring

We know that performance is important to you. Therefore, our operational services focus on exactly that. By use of our own tool SQL Autotune, we collect data daily from SQL Servers on missing indexes, IO, CPU-consumption, etc. This gives us the relevant data that our technicians need for troubleshooting and performance tuning. In close dialogue with you, we suggest and implement continuous improvements that optimise your system.

Active response on alarms

Our technicians contact you within four hours (8 am to 4 pm all weekdays) if an alarm occurs.  

Operational status

Receive a report with the operational status of the server.

Free visit by an it architect

We would love to arrange an SQL-workshop with your organisation, focusing on news and trends within the different versions of SQL, highlighting how they can bring value to you. The point of departure is a dialogue on what major things are going on in your business with relation to SQL operation, e.g. a new version of business systems, new hardware etc.  

Application-specific SQL optimisation

If you wish to focus on specific applications’ use of SQL Servers, we go into depth and focus specifically on the cooperation between them and the server.

Scope and frequency of the mentioned services depend on the type of subscription agreement.

Tailor-made solutions kræddersyede løsninger

If you need something other than our normal SQL operational service offers, we help you find a solution that matches your organisation.

SAs the name indicates, a subscription on SQL emergency response covers you 24/7/365 in case of urgent need for help. In addition, you get priority access to our support team from 8 am to 4 pm on weekdays. Our response guarantee means that you can rest assured that we will begin solving the problem within four hours from the first telephone call.  

Please note: Activating of response guarantee costs a fee + applicable hourly rate.

Who is going to look after your SQL Servers when your colleague or the IT department are not available? Are you or your colleagues vacating or is the department down due to illness and do you have particularly critical servers that have to perform in a stable manner and with high availability? Our specialists are at your service.

SQL temporary employee service keeps you covered 24/7 during the period in question in case of urgent need for help. In addition, you get priority access to our support team from 8 am to 4 pm on weekdays.

Our response guarantee means that you can rest assured that we will begin solving the problem within four hours from the first telephone call. No activation fees. If help is needed in the hours after 4 pm and before 8 am, double hourly rate applies.

Remember, you can always contact us at + 45 70 27 70 22 Monday – Thursday 8 am to 4 pm and Friday 8 am to 3.30 pm.

Outside normal opening hours, you can contact our hotline on + 45 70 27 70 13.

Book your temporary employee today and ensure a stable SQL operation in your organisation while you and your colleagues are off work.

SQL temporary employee service must be booked at least one week in advance.

For you who do not have the time or the competences in-house to optimise your SQL environment. With SQL-IN-A-BOX, we handle EVERYTHING, including hardware, licenses, backup, upgrades, continuous optimisation, etc.

Sizing, licensing and operation of an SQL Server is a difficult and demanding task, requiring both good insight in the SQL Server versions and license opportunities and that you continuously maintain and optimise the installation.

With SQL-IN-A-BOX you get a solution where all elements related to the SQL Server installation are included along with operation and optimisation by Denmark’s best SQL specialists in an accessible solution.

SQL-IN-A-BOX is available in three different versions. Contact Unit IT SQL Specialists on sqlsupport@unitit.dk or telephone + 45 70 27 70 22 if you need advice on which version fits your organisation.