Loading

Sharp data-driven decisions

We turn your data into better insights

Call +32 (0)3 451 23 91

What we do

Our technical and consultancy services provide your people with quick and straightforward access to their valuable internal and external data to help them make better informed decisions.

Discover our offering

Kohera specializes in the design, implementation and support of information systems based on the Microsoft BI portfolio, the SQL Server database system and Prophix CPM software. Being the largest Belgian company with 100% focus in these areas, we have built up the extensive expertise needed to help you find the best and most affordable solutions for SQL Server consultancy, Business Analytics and Corporate Performance Management.

SQL Server consultancy

When you think SQL Server, think Kohera. Whether you're looking for expert SQL database administrators, an audit of your systems, any type of performance tuning, database consolidation and migration, on-premises or hybrid our cloud software, high availability or disaster recovery set-ups, we will always find the best solution at the lowest cost.

Read more

Business Intelligence

Successful companies make the right decisions faster, using business analytics. Whatever your aspirations, analytics is an essential element in defining your strategy and helping you achieve your goals. Give your people easy-to-use business analytics tools which turn data into stunning visualizations that lead to valuable insights, and collaboration tools that make all data – big data and small data – accessible to everyone. This smarter way of working will generate one great idea after another.

Read more

Corporate Performance Management

CPM Software empowers business users. Designed to operate with minimal IT support, it automates timeconsuming processes and so improves accuracy and the ability to respond to changes. CPM is your solution for easier budgeting, planning, forecasting, reporting and financial consolidation.

Read more

SQL Server as a Service

You can use your SQL Server databases in the cloud without any upfront investment. You can also stop worrying about your hardware, servicing, security, software issues, patching, updates, upgrades and back-ups. We can help you make the right choices for the most suitable cloud model.

Read more

What our customers say

News

25 Apr 2017
SQL Server problem tombola: giant reads

A SQL Server is as fast as you tune your workload. One of the things I try to do is tune the workload, a.k.a. the queries executing on my SQL Server, in order to get a better performing server. I start by looking atqueries that do too many reads to retrieve a small result set. A possible obstacle, however, when working with vendor applications, is that you might not be able to tune the applications queries. This definitely limits your options, but there are still a lot of thing you can do to optimize your workload. Today we will do some testing with a giant read query and tune it in different ways by using real life scenarios.

18 Apr 2017
An overview of working with files in SQL Server

When you are responsible for databases on a project (as an architect, administrator or developer), you sometimes have to store documents (Files) which are linked to structured data. These data often have to be accessible outside SQL Server (Windows API’s). Storing BLOBs in the database, especially the ones over 1MB, can consume large amounts of file space and expensive server resources. Within SQL Server and Azure, there are different solutions to solve this kind of issues.

11 Apr 2017
SQL Spot – Part 3

The growth spurt of SQL Server 2016 and all its related dimensions is hard to follow. Yet with our SQL spot we try to gather some intel for all SQL Server enthusiasts. As always, we try to share some interesting articles, which crossed our paths recently, either professionally or out of personal interest. The gathered community information addresses a healthy BI perspective, ranging from business to technical insights on various topics: SQL Server news, Power BI, SQL Server BI stack, features, data science topics, accidental DBA stuff and interesting learning or study materials.

04 Apr 2017
Protect your most valuable business asset

Big data has become big business. Almost every company has transformed into a digital company these days. But how do you turn large volumes of information to your advantage?

News

25 Apr 2017
SQL Server problem tombola: giant reads

A SQL Server is as fast as you tune your workload. One of the things I try to do is tune the workload, a.k.a. the queries executing on my SQL Server, in order to get a better performing server. I start by looking atqueries that do too many reads to retrieve a small result set. A possible obstacle, however, when working with vendor applications, is that you might not be able to tune the applications queries. This definitely limits your options, but there are still a lot of thing you can do to optimize your workload. Today we will do some testing with a giant read query and tune it in different ways by using real life scenarios.

18 Apr 2017
An overview of working with files in SQL Server

When you are responsible for databases on a project (as an architect, administrator or developer), you sometimes have to store documents (Files) which are linked to structured data. These data often have to be accessible outside SQL Server (Windows API’s). Storing BLOBs in the database, especially the ones over 1MB, can consume large amounts of file space and expensive server resources. Within SQL Server and Azure, there are different solutions to solve this kind of issues.

11 Apr 2017
SQL Spot – Part 3

The growth spurt of SQL Server 2016 and all its related dimensions is hard to follow. Yet with our SQL spot we try to gather some intel for all SQL Server enthusiasts. As always, we try to share some interesting articles, which crossed our paths recently, either professionally or out of personal interest. The gathered community information addresses a healthy BI perspective, ranging from business to technical insights on various topics: SQL Server news, Power BI, SQL Server BI stack, features, data science topics, accidental DBA stuff and interesting learning or study materials.

04 Apr 2017
Protect your most valuable business asset

Big data has become big business. Almost every company has transformed into a digital company these days. But how do you turn large volumes of information to your advantage?