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 🚀
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
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
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
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
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?
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!
I'll be speaking at Charlotte this weekend and it'll be a first for me there. This is again quite exciting. I hope you get the chance to join me and come the conference. Repo https://github.com/hfleitas/charlotte918 Prev Post: https://dba2o.wordpress.com/2019/06/10/going-big-real-big-power-platform-resources/ Slides Photos Another great session at #SQLSaturdayCharlotte @HiramFleitas showing how to use #PowerApps and #PowerAutomate and use… Continue reading SQL Saturday – Charlotte (918)
This year we're having the first ever Power BI Fest in South Florida and I was lucky to have been invited to speak at the event. I will be giving 2 talks in the morning. More info and registration around the event can be found on the event's website https://powerbifest.com/home/presenters. Space is very limited. Sessions… Continue reading Power BI Fest 2019🎊
Sentiment Prediction - Real-time in SQL Server Power Platform - The Game Changer