How to automatically refresh a QA sql database from Prod by leveraging Azure DevOps and/or GitHub.
Author: Hiram
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… Continue reading ADX conditional format a Multi-Stat visual 🚀
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.… Continue reading Synapse CICD – Manage Triggers
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… Continue reading Azure Cert: AI – 102
🔐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,… Continue reading 🔐Security in a shared workspace
🗺️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… Continue reading 🗺️Guide: Synapse Spark ✨ – Getting Started
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… Continue reading My pipeline is slow, what do I do?
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… Continue reading 🌎 AI Bootcamp – Tomorrow in Fort Lauderdale!
You must be logged in to post a comment.