Practical guides and insights for modern data practitioners
In this post I want to cover spreading your SQL Server wings with Azure Synapse Analytics. As part of a series of posts about spreading your SQL Server wings with the Microsoft Intelligent Data Platform. You can find out more about this series of posts in an introductory post I published about the series. In … Read more
In this post I want to cover spreading your SQL Server wings with Azure SQL Managed Instances (aka Managed Instances). As part of a series of posts about spreading your SQL Server wings with the Microsoft Intelligent Data Platform. You can find out more about this series of posts in an introductory post I published … Read more
In this post I want to cover spreading your SQL Server wings with Azure SQL Database. As part of a series of posts about spreading your SQL Server wings with the Microsoft Intelligent Data Platform. You can find out more about this series of posts in an introductory post I published about the series. By … Read more
Consider this post as an introduction to upcoming spreading your SQL Server wings with the Microsoft Intelligent Data Platform series that I will be publishing. I want to publish this post to raise awareness about a series of future posts that are coming. Plus, I want to make those posts more efficient by sharing a … Read more
In this post I want to cover performing CI/CD for SQL Server 2022 using GitHub Actions. For a couple of reasons. First one is due to the fact that last week I was answering a query on the well known SQLHelp hashtag about deploying updates to SQL Server using GitHub Actions. That is when it … Read more
In this post I want to cover using the sql-action v2 GitHub Action for Azure SQL Database deployments using GitHub Actions. Which is the GitHub Action that is also known as Azure SQL Deploy. Back in 2020 I did a post about how to deploy to Azure SQL Database using GitHub Actions. Afterwards, I shared … Read more
In this post I want to cover using Azure SQL Deploy v2 for dedicated SQL Pool deployments using GitHub Actions. Which is the GitHub Action that is also known as sql-action. This post provides an overview of what is new and provides plenty of links along the way. I wanted to do this post due … Read more
I want to cover recommended Microsoft SQL Server certifications and badges. For a few good reasons. First of all, to answer the very popular question about which Microsoft role-based certification to do for SQL Server. Since the exams for the previous MCSA/MCSE certifications have since retired. Secondly, in a previous post I provided some advice … Read more
For this months T-SQL Tuesday contribution I want to explain why I tend to spend a lot of time finishing off outstanding tasks for my Data Platform environment towards the end of the year. Garry Bargsley hosts this months T-SQL Tuesday. Garry invites us to write about what we have planned for end-of-year activities for … Read more
In this post I want to show how a GitHub CI/CD experience for Azure Synapse Link for SQL Server 2022 can look. Which uses GitHub Actions. Including how to automatically stop and start it in the pipeline. In my last post I showed a complete CI/CD experience for Azure Synapse Link for SQL Server 2022 … Read more