Practical guides and insights for modern data practitioners
For this months T-SQL Tuesday contribution I cover managing Database/SQL Pool/Data Warehouse code. To clarify, this post focuses on managing code for SQL Server databases, Azure Synapse SQL Pools and Microsoft Fabric Data Warehouses. Since they all work with T-SQL and this is a T-SQL Tuesday post. Before I go any further, I want to … Read more
In this post I want to cover one way you can migrate dedicated SQL Pool objects to a Microsoft Fabric Data Warehouse using Azure DevOps. I thought I better do this post since I showed how to do something similar for serverless SQL Pool objects in a previous post. To clarify, when I say dedicated … Read more
In this post I want to cover one way you can migrate serverless SQL Pool objects to a Microsoft Fabric Data Warehouse using Azure DevOps. Since I was able to get this working. To clarify, when I say serverless SQL Pools I mean the ones that are part of Azure Synapse Analytics. Which I covered … Read more
In this post I want to cover spreading your SQL Server wings with serverless SQL Pools. As part of a series of posts about spreading your SQL Server wings with the Microsoft Intelligent Data Platform. Since I covered dedicated SQL Pools in my last post I thought I it was only fair that I covered … Read more
In this post I want to cover spreading your SQL Server wings with dedicated SQL Pools. As part of a series of posts about spreading your SQL Server wings with the Microsoft Intelligent Data Platform. Since I covered Azure Synapse Analytics in my previous post I thought I would go a bit deeper into dedicated … Read more
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 how to install SqlPackage to work with dacpacs for serverless SQL Pools. I decided to do this post after some feedback I received about SqlPackage after a series of posts about deploying dacpacs to serverless SQL Pools. For example, my post about deploying a dacpac to a serverless … Read more
For this months T-SQL Tuesday contribution I want to cover when I had fun with T-SQL by querying a delta table. Reitse Eskens hosts this months T-SQL Tuesday. Reitse invites us to blog about having fun with T-SQL. Which I definitely had making the video for last years Festive Tech Calendar. You can read the … Read more
In this post I want to cover common Azure Synapse Link for SQL storage permission issues. Since I helped a fellow MVP out with this recently. To be more precise, I want to show how you can fix one of the most common issues I tend to encounter with Azure Synapse Link for SQL. Which … Read more
In this post I want to cover how you can deploy a dacpac to a serverless SQL pool using GitHub Actions. Yes, you are reading that right. It is now possible thanks to a SqlPackage update. Which you can download this update on the ‘Download and install SqlPackage‘ page. In a previous post I covered how … Read more