New GitHub certifications for Azure partners

In this post I want raise awareness about the new GitHub certifications for Azure partners. Since I have gained the two below recently. One key point to remember is that you can only gain these certifications if you work for an Azure partner. Which you can think of as a Microsoft partner that specializes in … Read more

Keep your Azure Synapse secrets secret in GitHub

In this post I want to cover how you can keep your Azure Synapse secrets secret in GitHub. Because you need to do this if you are working with sensitive information in GitHub. For example, things like connection strings. I thought I better write this post for a couple of reasons. First of all, I … Read more

More tips about using Azure Test Plans with GitHub

In this post I want to provide a couple more tips about using Azure Test Plans with GitHub deployments. Since I have been asked a couple of times about this since the SQLBits conference. In reality, I did a post a while ago about using Azure Test Plans with GitHub deployments. Plus, I covered it … Read more

Version control for SQL Server Management Studio templates using GitHub

In this post I want to cover how to do version control for SQL Server Management Studio templates using GitHub. I wanted to do this post for various reasons. Previously I wrote a post about how to do version control for SQL Server Management Studio templates using Azure Repos. I wanted to highlight some things … Read more

CI/CD for serverless SQL pools using GitHub Actions

I want to cover one way you can do CI/CD for Azure Synapse Analytics serverless SQL pools using GitHub Actions in this post. For various reasons. For a start, in a previous post I wrote about how you can CI/CD for serverless SQL pools using Azure DevOps. So, I thought I would balance things out … Read more

Update a Database Project within the GitHub website

In this post I want to cover a couple of ways you can update a Database Project within the GitHub website. Because both ways can be useful. I know most of the time files are updated using development tools on your own computer. However, it can be useful to know how you can update files … Read more

T-SQL Tuesday 140 – Easy demos using containers

My T-SQL Tuesday contribution for this month is about doing easy demos using containers. Which is hosted by Anthony Nocentino this month. Anthony has invited us all to share your experiences using containers, and not just SQL Server in containers. You can find out more about the invite by clicking this link about his T-SQL … Read more

Create a dacpac for an Azure Synapse Analytics dedicated SQL Pool using GitHub Actions

In this post I want to cover how you can create a dacpac for an Azure Synapse Analytics dedicated SQL Pool using GitHub Actions. By the end of this post, you will know how to create a dacpac for a dedicated SQL Pool within GitHub Actions for your CI/CD deployments. Creating database project for Azure … Read more

Using GitHub CLI with GitHub Actions for Data Platform deployments

In this post I want to share some advice about using GitHub CLI with GitHub Actions for Data Platform deployments. Because I showed that at SQLDay last week. About GitHub CLI For those who were not aware, there is a GitHub CLI you can use from the command line. You can download GitHub CLI from … Read more