Introduction to the Modern Data Warehouse
In the past, the traditional data storage mechanisms were often cleanly divided between file storage, NoSQL and relational transactions, and data warehouses. The data warehouse was often a monolithic system, […]
Restricting Azure App Service Access to Azure Front Door
Securing an Azure App Service is a common requirement. If you’re not familiar with Front Door, it combines a web application firewall (WAF), content distribution network (CDN), traffic manager, and […]
Automating SQL Server 2019 Docker Deployments
In a previous article, I walked through deploying to SQL Server 2017 containers and provided an overview of deploying DACPACs and BACPACs in containers. Since that time, SQL Server 2019 […]
Restoring Azure Tests for SonarQube
Continuing from the previous post, SonarQube expects a certain set of files to be present in $(Common.TestResultsDirectory). When it doesn’t find the files in the folder, it can prevent it […]
Missing Tests on Azure DevOps
The customer was having a rough day. They had lots of unit tests, but were seeing an unexpected behavior from Azure DevOps and SonarQube. Because some tests were written in […]
Understanding ARM Templates _artifactsLocation
I’m someone that is always interested in seeing what’s behind the curtain, pulling apart designs to understand the why and the how. When I began working with ARM templates, I […]
ARM Templates and Cloud Init
If you’ve been spending much time with Linux VMs, you may have encountered Cloud-Init. Cloud-Init is an easy way to specify the configuration which needs to be applied to a […]
Data DevOps: Deploying SQL Server DACPACs to Docker
In order to truly optimize the workflow and create a culture of DevOps, we need to be able to quickly build and deploy databases. To automate this process, we need […]
DevOps and Documentation
Just because your software iterations are fast and lean doesn’t mean that you shouldn’t have good documentation. In fact, with shorter release cycles documentation becomes even more important. Consequently, it’s […]