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…

SQL Saturday – Charlotte (918)

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…

Protected: Upgrade SQL Server “In-Place” with Skip Over (on Windows)

There is no excerpt because this is a protected post.

Power BI Fest 2019🎊

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…

🏹 SQL Audit – See Through Walls

It's #TSQLTuesday and I received a question that occurs any day of the week. I hadn't posted anything in a few days, so I thought I'd share this one. Hope it helps. A Friend Asked Does the native audit feature has any GUI where we can see the reports ( example:- List of the users…

PASS Summit 2019

Sentiment Prediction - Real-time in SQL Server Power Platform - The Game Changer

Microsoft Data & AI South FL (Nov 2019) Azure Data Factory

Azure Data Factory From On-Prem to Data Warehouse Agenda: Azure Data Factory Data store Connectors 80x On-Premises DevOps Automation Notifications Resources by: Hiram Fleitas Twitter: @hiramfleitas Blog: http://fleitasarts.com Video Recording https://youtu.be/TXxssUeqsOA Resources fleitasarts.com github.com/hfleitas/rig netflix.com/trollhunters Azure Data Factory: GitHub Integration Azure Data Factory: Documentation Azure Data Factory: Copy Activity Performance Azure Data Factory: Connector Azure SQL Data Warehouse Connector…

DW Table Distribution Options ⚡

Replicated (optional) vs Round Robin (default) vs Hash (optional) The statement about replicated vs round robing is simply a storage distribution setting. In the data warehouse world due to the massive parallel processing capabilities these distribution settings help us do performance tuning so queries run optimal at a lower cost. Azure SQL Data Warehouse has…

Get Cognitive API 📺

In this short video, I explain how to call the Azure Cognitive Services - Text Analytics API from SQL Server by using T-SQL and Python in a Stored Procedure. In the demo, I first cover the prerequisite steps and create a view to prep data in JSON format. Then, I use the Sentiment Analysis API…