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… Continue reading DW Table Distribution Options ⚡
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… Continue reading Get Cognitive API 📺
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… Continue reading Recent Benchmark Studies 🧩
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 after your… Continue reading Copy from On-Prem to Azure SQL with Azure Data Factory 📺
July 10th at 11 AM Eastern. I'll be giving a live webinar on PowerApps, Microsoft Flow and Power BI in Spanish for the global LATAM - Dynamics 365 community. Calendar Invite: Download D365UG: Event Dynamic Communities: Link GotoWebinar: Join All the resources (slides & scripts) are already accessible on my previous blog post. El 10 de julio… Continue reading Webinar – This Wednesday 11am EST.
I'm very excited to announce that I've been accepted as a speaker at PASS Summit 2019. I'm extremely grateful for the opportunity and look forward to PASS Summit 2019. Category Session Title Status General Session The Power Platform Game Changer Accepted General Session Real-time Sentiment Prediction in SQL Server Accepted See you in Seattle, WA… Continue reading 📡 BIG News – PASS Summit 2019!
Here's my Resources slide from this weekend's presentation. Stay tuned - live recording coming soon. Resources: fleitasarts.com github.com/hfleitas/SentimentPrediction ailab.microsoft.com SQL Server R Services Samples: Microsoft Repo Pre-Trained ML Models: Install in SQL Server SQL Server Machine Learning Services: Tutorials SQL Server Components to Support Python: Interaction of Components Threading ML: Logistic Regression Resource Governor: Alter External… Continue reading Sentiment Prediction – Resources 😃