Our expertise is SQL server from administration to development with a special focus on performance monitoring and solving bottlenecks. We are able to assist you with your SQL server on a one-off or ongoing basis. Some of the scenarios when we usually start working with our clients are;

  • you need to monitor SQL server as a business-critical system and you require more information in case something goes wrong.
  • your system running on SQL server is slow constantly or at specific moments. 
  • you would like to evaluate the state of your SQL server using our SQL audit.
  • you require custom development to connect your data with a new system or process.
  • your server is out of date and you are looking at upgrading it. 

SQL server monitoring

To be able to tell you where is the problem and what is going to be a solution to it we need to collect data and see what is exactly going on at your server. To do this we use SMT developed by Woodler.eu company, that we cooperate with closely. SMT is a unique tool developed by administrators and SQL tuners not by managers. We can provide a license and you can use it on your own or we can add our services as part of your contract. SMT runs continuously on your server and gives you the opportunity to explore information by more than 55reports with live and historical views.

SQL server audit

This is a cousin of SQL monitoring, which runs only for 24 hours and at the end there is a Power BI report prepared for you and presented so you know exactly what were the findings and potential issues with the server that you should look at. SQL-A is another product of Woodler.eu that we offer in Australia.

Performance tuning

Usually, our process utilizes data from server monitoring or audit provided by SMT or SQL-A report. Generally, performance tuning can be done in multiple ways and it depends if it is supposed to happen on a query or database/server level.
Even without our monitoring or outcomes of SQL audit we can collect ad-hoc data and speed up processes that you experience issues with.

Development

We are very strong here. In a relation to SQL server we can develop the solution for you or tell you what would be the best option so you can evaluate proposals from your IT suppliers. We know how to develop working and efficient code, we use our development skills in our tuning jobs almost every day when one of the options of the performance tuning is a refactoring of the existing code. We can develop any of the following;

  • Processes using only SQL
  • Reports.
  • Interfaces to import or export data to connect your SQL database with other applications.
  • Custom development using other languages like C# to either run directly on your SQL server or next to it.

Server administration

Database administration is part of our portfolio and we can work on an ongoing basis or project based on issues that are related to it. We will make sure your server maintenance, backup strategy and disaster recovery are set properly and are well designed for your business needs.

Projects

Most of the projects are related to upgrading SQL server and we can assist you here on multiple levels. We can handle the whole upgrade project for you or just assist you with particular parts. For example, we can measure for you a performance using new server settings and tell you what processes will slow down because of changes in a new version of SQL server. We can also deliver SQL compatibility audit, which is another product of our friends and colleagues from Woodler.eu.