This year we had the pleasure of enjoying Microsoft Ignite’s plethora of release already in March, only six months after the previous event in September 2020. For me the best part of these Microsoft conferences is always getting my hands on the book of news and going through it, looking for new upcoming things that … More Ignite 2021 – My top three things to look out for
Microsoft released the serverless compute tier for Azure SQL databases to General Availability a little over a year ago, back in November 2019. Despite the fact that it’s been a while already, based on my personal experiences people are still a bit unfamiliar with serverless Azure SQL – what it is, how it works and, … More Getting the most out of serverless Azure SQL
Azure Data Factory is the de facto service to use when you want to orchestrate data movement and transformation in Azure. From a design and architecture point of view, my favourite thing about Data Factory is that it lets you do ETL – or ELT – in many different ways, leaving it up to you … More How to: Building robust and cost-effective Azure SSIS runtime automation in Data Factory
One common concern people often have with the cloud is security: Is moving business data – or any data in general – to the cloud from on-premises secure? The short answer is, yes, it is secure. Or in more detail: It is secure, often even more secure than on-premises, but that is assuming your data platform is designed and built with security in mind. … More Building a secure Azure data platform
Knowledge is power, and in business knowledge comes from data-driven insights. We are often accustomed to having an onlook into our data in singular applications, separated from each other, even though their data is contextually connected and related: A sales system, a billing system, various production pipelines and a logistics system, just to name a few. We may have powerful reports on our sales pipelines, and another set on production or logistics, and these reports do provide us with information on how these processes work in vacuum. But the truth is that nothing happens in a vacuum, instead, everything we do is connected. … More Consolidating our enterprise data in the Azure Data Lake to enrich our data-driven solutions
You may have heard the saying ”Data is the new oil”, which has been spreading around the last few years. This word “data” in this statement has usually referenced to the data that you and I leave behind when using technology, to be then made use of by advertisers, influencers, and other parties. … More Building a real-time, cloud-based monitoring solution using Power BI and Microsoft’s data offerings
Joonas Äijälä 