Here's an alternative post which covers spreading your #PowerBI wings with #MicrosoftFabric.
https://www.kevinrchant.com/2023/05/31/spreading-your-power-bi-wings-with-microsoft-fabric/
First time been on here for a while, so thought be a good idea to share more recent #MicrosoftFabric posts.
Here's one that covers spreading your SQL Server wings with Microsoft Fabric. As part of a series of posts about spreading your SQL Server wings with the #Microsoft Intelligent Data Platform.
https://www.kevinrchant.com/2023/05/24/spreading-your-sql-server-wings-with-microsoft-fabric/
Published yesterday. Covers 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. #Azure #AzureSynapse #SQLServer
https://www.kevinrchant.com/2023/05/09/spreading-your-sql-server-wings-with-azure-synapse-analytics/
Published yesterday. Covers spreading your #SQLServer wings with #Azure SQL Database.
As part of a series of posts about spreading your SQL Server wings with the #Microsoft Intelligent Data Platform.
https://www.kevinrchant.com/2023/04/25/spreading-your-sql-server-wings-with-azure-sql-database/
Pleased to announce that myself and Sander Stad will be presenting a new session at Data Ceili in June amongst other great sessions as below:
https://www.dataceili.io/schedule-2023
You can register using the link below:
https://www.dataceili.io/
Looking forward to presenting in Ireland again for the first time in a while #AzureDevOps #SQLServer #DataCeili
Are you are looking to expand your #SQLServer skills or formalize your knowledge? If so, this post about certifications and badges can help point yu in the right direction:
https://www.kevinrchant.com/2023/01/12/recommended-sql-server-certifications-and-badges/
Those who have read my posts might notice the subtle picture change. After four and a half years of delivering content I thought my site could do with a change.
Fresh content coming soon...
Updated this post about using the Sql-action v2 #GitHubAction for #Azure SQL Database deployments.
Now contains bit more info about the GitHub-AzureSQLDatabase #GitHub repository that is available #SQLServer
@sqlcheesecake I am not too surprised, it use to be a big hit on the old Nokia 3310 phones
Since I highlighted this again this week, this post also contains a link to reasons why YAML is better from a security perspective #AzureDevOps
https://www.kevinrchant.com/2023/03/02/thoughts-about-disabling-classic-pipelines-in-azure-devops/
Released couple new repositories recently.
So if you are looking to perform CI/CD for either #SQLServer or #Azure_Synapse SQL Pools using either #AzureDevOps or #GitHub plenty here you can use as starting point.
Including repositories to deploy dacpacs to serverless SQL Pools.
Published yesterday. Covers how you can deploy a dacpac to an Azure Synapse serverless SQL pool using GitHub Actions.
Also contains a link to a GitHub repository that you can download and use as a template #Azure #AzureSynapse #GitHub #GitHubActions
Covers performing CI/CD for SQL Server 2022 using GitHub Actions. For a couple of reasons.
First one is due to the fact that when I answered a question on the well-known SQLHelp hashtag last week I realized I had never shared about deploying updates to SQL Server using GitHub Actions before.
Second reason is due to the fact that I wanted to show how to create an SDK-style database project for SQL Server 2022.
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
Since I got asked about #AzureSynapse Link internals recently:
All, I have updated my post from last month about deploying a dacpac to a serverless SQL pool.
It now makes it clear that must deploy a dacpac especially created for serverless SQL Pools.
Plus, contains link to my homemade serverless SQL Pool Database Project post. #Azure #AzureDevOps #AzureSynapse
https://www.kevinrchant.com/2023/02/15/deploying-a-dacpac-to-a-serverless-sql-pool/
Published yesterday. Covers my thoughts about disabling classic pipelines in Azure DevOps.
Which disables both the Classic Editor and Releases in Azure Pipelines. #Azure #AzureDevOps
https://www.kevinrchant.com/2023/03/02/thoughts-about-disabling-classic-pipelines-in-azure-devops/
All, during this lovely fresh morning here in the Netherlands I have updated the below #GitHub repository.
Which contains a homemade database project for an #AzureSynapse serverless SQL Pool, as well as a YAML pipeline to perform CI/CD in #AzureDevOps
Readme now contains a link to the blog post.
https://github.com/kevchant/AzureDevOps-ServerlessSQLPool-HomemadeDBProject
For those wondering what syntax has changed if you want to deploy to #Azure SQL Database using the newest version of the Azure SQL Deploy #GitHubAction (aka sql-action V2) #GitHub #SQLServer
Covers using the sql-action v2 GitHub Action for Azure SQL Database deployments using GitHub Actions.
It also contains a link to the GitHub repository that you can use as a starting point to perform CI/CD for Azure SQL Database using GitHub Actions.
Which has now got a new workflow (yaml file) that uses sql-action v2.
Technology enthusiast.
Active in Microsoft Data Platform community, Data Platform & Developer Technologies MVP.
Status updates are my own.