In most cases programming is not needed when working with Azure Data Factory. In the rare situations where it is necessary, Python and Azure Batch Service are a viable option. Let's do a deep-dive!
In most cases programming is not needed when working with Azure Data Factory. In the rare situations where it is necessary, Python and Azure Batch Service are a viable option. Let's do a deep-dive!
Managers, analysts, engineers and information workers, who use it, know that SQL Server Analysis Services Tabular (SSAS Tabular) is a valuable ICT asset. On the other hand, Power BI (PBI) is a great tool too that has a bit more functionality under its belt. Yet, there’s cases where SSAS Tabular might prove useful which we’ll detail in this blog.
APIs are one of the things we often come across when working with data. In this blogpost we’ll have a look at some ways of extracting data out of them with Python in an efficient way.
When trying to do a standard install of SQL Server, you may have noticed that the 2017 or newer versions of SQL Server Reporting Services (SSRS) aren’t installed as well. That’s because SSRS now has its own separate installer. In this blog, we’ll show some of the changes compared to older versions.
Weirdly formatted files, we’ve all had to import them into our reports at some point. Luckily, Power BI has new option that might make our lives easier: import text/CSV by example. We’ll show you how to use it in this blog.
There's plenty of updates to Databricks. And that sometimes leaves users frazzled. his begs the questions, why are there updates so often? And what is the impact on maintenance of your dearest Databricks-projects?
Splitting datasets and reports into separate PBIX files is a very common way of managing Power BI reports. But dividing sets and reports can result in a headache or two. Let our blog be your Power BI painkiller.
Al zolang Kohera bestaat, staat Microsoft als leider in de rechterbovenhoek van Gartner’s Magic Quadrant voor Analytics en BI Platformen. Net daarom hebben we bij Kohera een bewuste keuze gemaakt voor Microsoft Power BI. Het is zowaar de cola van de BI-tools.
We and several other Koherians once again spent New Year’s Eve glued to our radios, wondering if we’d adapted the predictive model successfully enough to get De Tijdloze Top 100 from Studio Brussels right? Find out if we did!
Azure Resource Manager templates are great. Managing the resulting JSON files not so much. So Microsoft launched Azure Bicep. Read how it will help with maintaining your infrastructure as code.
Recently, a long-awaited feature was added to Power BI: Small Multiples. Time to explore our new options of visualizing data!
Deze eindejaarsperiode is er een waarbij heel wat tradities gesneuveld zijn. Gezellig samenzijn met de hele familie of lekker gaan eten op restaurant zitten er niet in dit jaar. Gelukkig zijn er ook nog zekerheden, zoals De Tijdloze van StuBru, die ook dit jaar voor muzikaal vertier zorgt in de laatste dagen van het jaar. En daarbij hoort natuurlijk ook onze voorspelling.
Always wanted to run Python on Azure? We'll show you how with Azure Container Instances.
Microsoft has recently taken us on a word lingo with the launch of Azure Synapse Analytics. At Kohera, we've experienced some confusion in the market between Azure Synapse as a standalone product and Azure Synapse Analytics as a SaaS platform. We guess it's time to set things straight once and for all, or at least for a while.
A client asked if we could provide a simple form of monitoring on a part of a provided solution. For this particular source, our client asked us to send a simple email with record counts to a mailing list. No problem! Let's get to work
Sometimes, Databricks can be a bit sluggish. Caching with, for instance, the Delta Cache Accelerated Worker can help you speed it up. We'll explain how it does that.
For some reason developers like stuffing their SQL with SVFs, and that... makes... it... so... slow. Are SVFs really that bad? And is scalar-valued function inlining useful at all? Let’s walk through it together and find out!
While XML has been suitable as a SQL Server native datatype since SQL 2005, for one reason or the other it’s not often used - with only a very few working examples. This blog post is meant for T-SQL teams looking for a working XML example on SQL Server, including schema binding and XML indexes.