Automate Azure SQL user creation nowPosted on Updated September 21, 2020September 21, 2020 by niktho@gmail.com Did you hear about the feature that allow you to assign cloud groups to built-in roles in Azure? Neither did I, but why should we as Azure SQL developers or database administrators care? Simply put, it allows you to create active directory users in an Azure SQL database using a service principal. In other words […]
Database migrations using FlyWayPosted on Updated August 25, 2019August 24, 2019 by niktho@gmail.com In the world as a developer you have a big toolbox in front of you, constantly evolving. As a result it’s not always easy to navigate between everything and sometimes hard to find out where to start. You may remember that I previously blogged about testing using the tSQLt framework. At the point I assumed […]
Azure Data Explorer Series, Part 1Posted on Updated March 31, 2019March 31, 2019 by niktho@gmail.com Have you heard about Azure Data Explorer, formerly known as project Kusto? The new PaaS from Microsoft that enables fast and highly scalable data exploration? The service that empowers Azure Monitor and Time Series Insights? Fear not! As of 7 February 2019 it was announced to be General Available, meaning that it’s the new kid […]
Azure SQL unit testing with tSQLt using Azure DevOpsPosted on Updated February 27, 2019February 26, 2019 by niktho@gmail.com Working as a Data Engineer I often see that unit tests are written for the applications that are developed, but often forgotten about when doing database development. We would assume that it’s the de facto standard in 2019 if the target is to be fully DevOps as a development team. There are many great third […]
Azure DevOps with Data FactoryPosted on Updated January 30, 2019January 20, 2019 by niktho@gmail.com In many organization a common misconception is that DevOps is about the tools we use, so let’s use a second to read the citation from Microsoft. DevOps brings together people, processes, and technology, automating software delivery to provide continuous value to your users. Microsoft Of course this post will not be about what DevOps is […]
