Introduction to the Modern Data Warehouse
With the rise of big data, new ways of processing data emerged. This series of articles will introduce you to the principles of the MDW design pattern.
Architecting Data Storage Solutions with Cosmos DB
Cosmos DB provides a multi-model database for building highly responsive, scalable applications. The key to getting the most out of Cosmos DB is understanding how to design a database that can take advantage of the platform. In this session, you will learn the basics of the platform, the secrets to effective data models, and how…
GitHub and Azure DevOps – Better Together
With Microsoft acquiring GitHub, many teams struggle to understand whether to adopt GitHub or Azure DevOps, especially if there’s already an investment in Azure DevOps or Team Foundation Server (TFS). There is a third option that is often overlooked – the platforms are better together! Join Ken Muse, an ALM | DevOps Ranger, to learn…
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 routing rules into a single service. This makes it a perfect choice for protecting a web site. In using this, we want to ensure that…
Automating SQL Server 2019 Docker Deployments
Previously, I've discussed how to automate deploying a DACPAC to a SQL Server 2017 container in Docker. Now, learn how this works with SQL Server 2019.
Restoring Azure Tests for SonarQube
The vstest task in Azure DevOps doesn't guarantee an output location. Learn how to ensure that SonarQube will see your test results correctly.
Missing Tests on Azure DevOps
Trying to integrate unit tests and code coverage Azure DevOps to other systems and things seem to be disappearing? Learn why it happens and how to fix it...
Understanding ARM Templates _artifactsLocation
A lot of people are not familiar with the variable _artifactsLocation in their ARM templates. In this post, we're going to attempt to shed some light on this standard ARM template parameter.
ARM Templates and Cloud Init
It's easy enough to utilize the inline Cloud-Init in your ARM templates to configure your site. But how do you develop and deliver your Cloud Config outside of your ARM templates?
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 to rely on improving our ability to utilize infrastructure as code. In this post, I’m going to show you how to use sqlpackage to automate…
DevOps and Documentation
Good software requires good documentation. And good documentation requires a DevOps process to ensure you always have the latest version...
Mastering Azure Network Addresses
If you want to master Azure, you must first understand how to master Azure networks and addresses.