Slight update to the below #AzureSynapse post about creating a Homemade serverless SQL Pool Database Project.

Now explains what was created when I ran the dotnet command to create the Database Project #Azure #SynapseInfluencer

https://www.kevinrchant.com/2023/02/28/homemade-serverless-sql-pool-database-project/

Since people like trilogies, here is my third video for the March edition of the Azure Synapse Analytics and Microsoft MVP video series.

Which covers a complete CI/CD experience for Azure Synapse Link for SQL Server 2022. #AzureSynapse #SynapseInfluencer

https://www.youtube.com/watch?v=wakDmLYxSD0

Been busy answering some of the questions in the comments for this video about CI/CD for #AzureSynapse dedicated SQL Pools.

Feel free to reach out if any further wuestions. #SynapseInfluencer

https://www.youtube.com/watch?v=Dcpd4Z783Zs

Published yesterday. Covers how I created a homemade serverless SQL Pool database project.

It also reveals what name of the new Database Schema Provider for serverless SQL Pools #Azure #AzureDevOps #AzureSynapse #SynapseInfluencer

https://www.kevinrchant.com/2023/02/28/homemade-serverless-sql-pool-database-project/

One thing I forgot to add earlier. This post shows you how to do it using both GUI-based pipelines and YAML pipelines in #AzureDevOps #SynapseInfluencer

#Microsoft just gave #AzureSynapse users an early valentine's day present.

Something tells me I will be putting the second feature listed in this sqlpackage update very soon #SynapseInfluencer

https://learn.microsoft.com/en-us/sql/tools/sqlpackage/release-notes-sqlpackage?view=sql-server-ver16#16180890-sqlpackage?WT.mc_id=DP-MVP-5004032

Covers using the Azure SQL Deploy v2 #GitHub Action for dedicated SQL Pool deployments (aka sql-action).

Which you can use for both #AzureSynapse and #SQLServer deployments.

Also mentions #SQBits and #DataSaturdayDenmark #SynapseInfluencer

https://www.kevinrchant.com/2023/02/08/using-azure-sql-deploy-v2-for-dedicated-sql-pool-deployments/

Published recently and thought appropriate to share again after #DataToboggan. Covers recommended #Microsoft certifications for Azure Synapse Analytics.

Includes a suggested route if intending to do both the DP-203 and DP-500 exams. #Azure #AzureSynapse #DP203 #DP500 #MicrosoftLearn #SynapseInfluencer

https://www.kevinrchant.com/2023/01/05/recommended-azure-synapse-analytics-certifications/

Pleased to present in the January edition of our Azure Synapse Analytics and Microsoft MVP series.

Covering CI/CD for #AzureSynapse dedicated SQL Pools in both #AzureDevOps and #GitHub.

Feel free to reach out if any questions #SynapseInfluencer #mvpbuzz

https://www.youtube.com/watch?v=Dcpd4Z783Zs

Published yesterday. Covers recommended #Microsoft certifications for Azure Synapse Analytics.

Includes a suggested route if intending to do both the DP-203 and DP-500 exams. #Azure #AzureSynapse #DP203 #DP500 #MicrosoftLearn #SynapseInfluencer

https://www.kevinrchant.com/2023/01/05/recommended-azure-synapse-analytics-certifications/

New blog: Azure Synapse Analytics in 2022 - A Retrospective... https://www.serverlesssql.com/general/azure-synapse-analytics-in-2022-retrospective/ #Azure #SynapseAnalytics #SynapseInfluencer #DataCommunity

Published earlier this year. To save others from testing if there is a tipping point for file types when using Azure Synapse Link for SQL Server 2022. #Azure #AzureSynapse #SQLServer #SynapseInfluencer

https://www.kevinrchant.com/2022/08/22/file-tests-for-azure-synapse-link-for-sql-server-2022/

Published yesterday. A six-minute crash course about Synapse Studio.

Consider this a follow-up highlighting new features such as Azure Synapse Link for SQL #Azure #AzureSynapse #SynapseInfluencer

https://www.kevinrchant.com/2022/12/08/six-minute-crash-course-about-synapse-studio/

A six-minute crash course about Synapse Studio.

Consider this a follow-up highlighting new features #Azure #AzureSynapse #SynapseInfluencer

https://www.kevinrchant.com/2022/12/08/six-minute-crash-course-about-synapse-studio/

Updated this post to reflect the fact that a newer version of the sql-action #GitHubAction is now used in the public template that is available in #GitHub #AzureSynapse #SynapseInfluencer

https://www.kevinrchant.com/2021/06/15/create-a-dacpac-for-an-azure-synapse-analytics-dedicated-sql-pool-using-github-actions/