My #GitHub repos have come a long way since this one for #AzureSynapse.

I now have some for #sqlserver and #MicrosoftFabric as well, which have been spotted out in the wild.

Plus, a lot of them have populated wikis.

If you do use any of them feel free to give them a star in #GitHub #AzureDevOps #GitHubActions

https://github.com/kevchant

Found the blog post where I first shared a public #GitHub repository people can use as a template to perform CI/CD for a #Microsoft Data Platform service earlier #AzureDevOps #AzureSynapse

https://www.kevinrchant.com/2021/06/03/create-a-dacpac-for-an-azure-synapse-analytics-dedicated-sql-pool-using-azure-data-studio

Pro tip, you can create tables in #AzureSynapse serverless SQL Pools, you just can't view them in Synapse Studio.

Instead, you can use an external app like SSMS to navigate to them.

Here’s a promo card to the thing that we did:

https://promocards.byspotify.com/share/c09e2e8141fafc81cc09ec3752375d43afc4ab85

Takes you direct to the podcast :-)

Have a listen. We cover a whole range of subjects: When does Fabric go GA ? How much might it cost me ? How do I get the InfoSec team to calm down ? And much more…
#MicrosoftFabric #AzureSynapse

Published yesterday. Covers my route to passing the DP-500 exam again.

Also includes exam updates and advice if using cam software. #Azure #AzureSynapse #DP500 #PowerBI #Purview

https://www.kevinrchant.com/2023/07/31/passing-the-dp-500-exam-again

So, we (Data Toboggan) did a thing, and here’s a link to the thing:

https://open.spotify.com/show/75FrdApJNItF9rU9Fgb2fY?si=8c_cggqnRcWcR4y6WgTBzQ

We’ll be doing more things like this.

This thing is a panel discussion on #MicrosoftFabric and ##AzureSynapse with some MVPs and other notable.

Thanks for watching :-)

Just a reminder that I have various #GitHub repositories that you can use as templates to perform CI/CD for both #SQLServer and #AzureSynapse databases using #GitHubActions.

If any prove to be useful feel free to give them a star in GitHub.

https://github.com/kevchant?tab=repositories&q=github&type=&language=&sort=

Covers my route to passing the DP-500 exam again. #Azure #AzureSynapse #DP500 #PowerBI #Purview

https://www.kevinrchant.com/2023/07/31/passing-the-dp-500-exam-again

Took a while to figure out how to migrate an #AzureSynapse dedicated SQL Pool to a #MicrosoftFabric Data Warehouse using an #AzureDevOps pipeline.

Which is why made template below available in #GitHub.

https://github.com/kevchant/AzureDevOps-dedicatedSQLPoolToFabricDW

A #GitHubActions alternative for those looking to deploy dacpacs to #AzureSynapse serverless SQL Pools #GitHub

https://www.kevinrchant.com/2023/03/09/deploy-a-dacpac-to-a-serverless-sql-pool-using-github-actions/

Updated this post about deploying dacpacs to #AzureSynapse serverless SQL Pools.

Now includes a link for newer post about how to configure installing #SqlPackage in a deployment pipeline #AzureDevOps

https://www.kevinrchant.com/2023/02/15/deploying-a-dacpac-to-a-serverless-sql-pool/

Covers one way you can migrate dedicated SQL Pool objects to a Microsoft Fabric Data Warehouse using Azure DevOps. #Azure #AzureDevOps #AzureSynapse #MicrosoftFabric

https://www.kevinrchant.com/2023/07/19/migrate-dedicated-sql-pool-objects-to-a-microsoft-fabric-data-warehouse

Since my #GitHubActions posts for #Microsoft Intelligent Data Platform deployments appear to be more popular as of late, here's a post about how to keep good #GitHub hygiene for your repositories. #AzureSynapse #SQLServer

https://www.kevinrchant.com/2022/07/05/github-hygiene-for-microsoft-data-platform-repositories/

Covers one way you can migrate serverless SQL Pool database schema objects to a Microsoft Fabric Data Warehouse using Azure DevOps.

In addition, this contains plenty of links. Including one to a GitHub repository that contains the code used in this post. #Azure #AzureDevOps #AzureSynapse #MicrosoftFabric

https://www.kevinrchant.com/2023/07/05/migrate-serverless-sql-pool-objects-to-a-microsoft-fabric-data-warehouse/

Even though I have been sharing a fair bit about #MicroosftFabric recently, I still have my #GitHub site available that contains plenty of #GitHub & #AzureDevOps CI/CD templates for #SQLServer and #AzureSynapse that you can download and use for free.

https://github.com/kevchant

Been busy working on updating our #ApacheSpark #Excel data source reader to support Spark 3.4

FileSourceOptions and SparkPath throwing up some changes needed, but prompted a rewrite of the options class which was needed anyway. Unit tests are all passing now for Spark 3.0.1 up to 3.4.0 which is good, now for some manual testing on #Databricks and #AzureSynapse

https://github.com/elastacloud/spark-excel

Looking at my #AzureSynapse T-shirt this morning and wondering if I will get a #MicrosoftFabric one in the future.

Then I will have Fabric on fabric...

Published yesterday. Covers 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. #Azure #AzureSynapse #SQLServer

https://www.kevinrchant.com/2023/05/22/spreading-your-sql-server-wings-with-serverless-sql-pools/

Covers 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. #Azure #AzureSynapse #SQLServer

https://www.kevinrchant.com/2023/05/22/spreading-your-sql-server-wings-with-serverless-sql-pools/

I have updated this post to highlight the fact that those who work with deploy dedicated SQL Pools might also be interested in upgrading SqlPackage for deployments.

Due to fact it now supports a setting required Multi-Column Distribution. #AzureDevOps #AzureSynapse

https://www.kevinrchant.com/2023/04/28/install-sqlpackage-to-work-with-dacpacs-for-serverless-sql-pools/