SQL Database DevOps (2 of 2)

How to automatically refresh a QA sql database from Prod by leveraging Azure DevOps and/or GitHub.

ADX conditional format a Multi-Stat visual 🚀

IntroStart with a free database at aka.ms/adx.free & run this demo query. let mytable = datatable(key:string, number:int) [ 'one', 1, 'two', 2 ]; mytable Press Shift + Enter on your keyboard to see result.Click Share on the top right > Pin to dashboardQuery name: demoDashboard > Create newName: demoCheck View dashboard after creation PinClick Edit…

Synapse CICD – Manage Triggers

Manage the Synapse pipeline triggers as part of your CICD DevOps process. Context I use an Azure Automation account to host my PowerShell script because it provides reusability and management of required modules. Schedules and logging are included but most importantly, it provides a REST API webhook that I can call from pipelines if necessary.…

Azure Cert: AI – 102

Just sharing a quick note, I passed the exam ai-102 on June 10th, 2021. The exam doesn’t cover predictive analytics in SQL like I had hoped, but this exam covers a ton of Cognitive Service scenarios and materials. Primarily on Computer Vision, Conversational AI (translator/speech) and Cognitive Search. It covers the whole gamut of the…

🔐Security in a shared workspace

Well, why?... perhaps you prefer not spinning more resources to segmentate the environment or decouple the workloads, but you still need to enforce data security across domains. Lets look at how to secure an HR container in a shared Azure Synapse Analytics workspace that serves mixed workloads by using only RBAC permissions at the storage,…

🗺️Guide: Synapse Spark ✨ – Getting Started

Pls feel free to share with others and spread the word. Step 1 watch this video https://www.youtube.com/embed/8-mdnw_L91Y Step 2 skim through these slides for more context: Coming soon... The rest is all hands-on stuff - if you get stuck at any point lmk. Step 3 do this learning path: Perform data engineering with Azure Synapse…

My pipeline is slow, what do I do?

It was a Sunday, I was working on my tile as usual. Pulling a double shift on weekends has become a norm, but enough about that. This isn't my construction blog. The email came in about Azure Data Factory. My friend happened to watch my video and reached out for help. Watch it on YouTube…

Protected: Plano 505

There is no excerpt because this is a protected post.

Protected: Registration: Sealand Maersk – Power BI Advanced Data Modeling

There is no excerpt because this is a protected post.

🌎 AI Bootcamp – Tomorrow in Fort Lauderdale!

I'll be speaking at Global AI Bootcamp this weekend in the Microsoft Fort Lauderdale office. My session will be at 1:30 pm in Room 3, tomorrow, Saturday. It's free to attend. I am very excited to cover new material on Spark and Azure Data Studio Machine Learning Services extension which is soon to-be-announced. I hope…