Author Chris Albert
Intro You want to start using Terraform to manage your Azure infrastructure. To get started you will need to get your local development environment setup. In this post I will walk you through setting up Terraform and the Azure CLI… Continue Reading →
Intro In our previous post we discussed the difference between the AthenaHealth data delivery options. In this post we are going to cover how to connect Power BI to Data View. This post assumes you have already installed Power BI… Continue Reading →
Intro Athenahealth offers two options for receiving data from their EMR. They offer either the Data Warehouse Feed or Data View. This post will describe each option and the difference between the two. Data Warehouse Feed The data warehouse feed… Continue Reading →
Intro In some scenarios a vendor or other 3rd party will send you a copy of their log shipping backups so you can keep a reporting copy of their database. Today’s post will cover how we can use dbatools to… Continue Reading →
Intro In this post I will describe how to manage the state of a VM with Azure Data Factory (ADF). I was inspired to write this post after reading a very similar walk through on Tech Talk Corner. A VM… Continue Reading →
Intro SQL Server Management Studio (SSMS) is a great product. Out of the box SSMS is an awesome tool that many of us have come to know and love. In my quest for efficiency I have found some very helpful… Continue Reading →
I had some issues installing dbatools over the weekend and wanted to share my experience. If you have not heard of dbatools I encourage you to go check it out and see what it can do. The easiest method to… Continue Reading →
You are handed a SQL Server that someone else set up and has, or more likely has not, maintained over time. You are now responsible for this server, but have limited time to check it out because of your busy… Continue Reading →
Ever wish your data was a little different so it is easier to query? Don’t fret, we have all had those queries that are gigantic and become too cumbersome to read through or modify. A CTE, a.k.a. Common Table Expression,… Continue Reading →
Once upon a time a vendor set up a new SQL Server at the company I was working for. For whatever reason they decided it best to not work with the local DBA. A few weeks later a server admin… Continue Reading →