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 📺
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.
Here's my Resources slide from this weekend's presentation. Stay tuned - live recording coming soon. Resources: fleitasarts.com andy.pt 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 Interactive deep learning: Learn alert… Continue reading Hack / Protect SQL Server – Resources 💎
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 😃
Here's my resources slide from this weekend's presentation. Stay tuned - live recording coming soon. Resources: fleitasarts.com github.com/hfleitas/GameChanger Microsoft Learn Pricing Integrating Bing Maps into PowerApps with GPS Scrolling Screen (infinite scroll) Display User Profile Photo (for authentication) Modal (Pop-up) Screen Image Circle Crop Cortana Intro Sample canvas apps (Expense Report, Help Desk, Meeting Capture) Webinar Listing ROI… Continue reading Going big…REAL BIG. Power Platform – Resources 🚀
This is candid recording of the live presentation I gave at Nova University on the morning of March 2nd, 2019 with South Florida Code Camp 2019. You can see the event info in my previous post. I am made this recording for the attendees that were interested to play it back at their own pace.… Continue reading Video: Real-time Sentiment Prediction in SQL Server
In short, this is an example of how you do it. Set a couple of variables, use -v parameter sqlcmdVariable="%batVariable%". The following contains more details on how to use SQLCMD variables for an input SQL file. Note, I am not advising you to you use this as your routine backup method. If you're looking for… Continue reading SQLCMD variables for input SQL file
Not too long ago, I had a conversation with a friend about how SQL Server Always On Availability Groups and how they could be configured for Read-Only routing. This is a typical scenario when folks want to leverage their secondary replicas (nodes) for read-only workloads. This allows you to build an active-active cluster where one… Continue reading SQL Server Read-Only Routing
On Saturday, March 2nd of 2019 I'm presenting 2 sessions. Join me for South FL Code Camp 2019 at Nova South Eastern University in the Carl DeSantis building. You can register for this one-day free learning event here. This year I am presenting 2 sessions. Real-time Sentiment Prediction in SQL Server Track: SQL/BI - Room 2067 Time: 9:50AM-11:00AM… Continue reading Wanna join me at South Florida Code Camp?
This was my 2nd time attending the annual conference and I barely got a chance to plan my schedule ahead of time. I pretty much selected the pre-con(s) the same day they were announced months prior, but not the general conference sessions until 2 days before my flight to Seattle, WA. I compiled this list… Continue reading My Schedule @ PASS Summit 2018