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…

Recent Benchmark Studies 🧩

Perhaps you haven't seen it. Hopefully it helps someone as it has others. It is specific to APS (Analytics Platform System) and PDW (Parallel Data Warehouse), even if you're assessing other items. Want to evaluate your cloud analytics provider? Here are the three questions to ask. By Julia White, Corp VP, Microsoft Azure. Independent benchmark results Company-wide…

Copy from On-Prem to Azure SQL with Azure Data Factory 📺

PASS Insights In this short video, I demonstrate how to copy data or multiple tables from an on-prem SQL Server, through a self-hosted run-time integration to Azure SQL DB Hyperscale and/or Azure SQL Data Warehouse with Azure Data Factory. Plus, how to automate tasks like Resuming or Pausing your Azure SQL Data Warehouse before or…