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.
This is candid recording of the live presentation I gave at Nova University on the afternoon 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: It’s a’Bot Time
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
Keeping a good thing going. Register here (FREE): https://www.sqlsaturday.com/755/registernow.aspx You can extend the invite to your friends and colleges if you think they’ll be interested in the topics. I'll be presenting at Nova South Eastern this Saturday afternoon at 1:30pm in Room 3046 of the Carl DeSantis Building (3301 College Avenue, Carl DeSantis Building, Davie, FL 33314). Here's my… Continue reading I’ll be presenting Saturday 6/9/2018 @NovaSE – 1:30pm Room 3046
My friend asked, does SQL Server have a data type or type of index it can use to search for text in a field? Yes, use varchar. If possible, create a non-clustered index on the column or use a full-text search catalog index. You can use the Like operator or the Contains operator if you… Continue reading SQL text search – 3x faster CONTAINS vs LIKE.
Hi, I just received the news that I got selected to speak at University of South Florida Saturday, 2/24/18 at 8:30am in Room 118 (USF School of Business - BSN, 12212 USF Maple Drive, Tampa, Florida, 33620). Here’s the event info: http://www.sqlsaturday.com/699/EventHome.aspx Register here (FREE): https://www.sqlsaturday.com/699/registernow.aspx Pls fwd this invite to your friends and colleges… Continue reading I’ll be presenting Saturday 2/24/2018 @USF School of Business – 8:30am Room 118 (Tampa, FL)
Well, that turned out much better than expected. After receiving the news, the day before the conference, that I was selected to speak at South Florida Code Camp 2018, I shared the news with friends and colleagues inviting them to the event. Immediately, I rushed to prepare the necessary equipment and pick up my speaker… Continue reading 1st Time Presenting at SFCodeCamp 2018
Delete ApexSQL or the particular add-in subfolder. From: 1. C:\Program Files 2. C:\Users\username\AppData\Local\ApexSQL 3. C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Extensions 4. C:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions 5. C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions 6. C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\Extensions Run cmd as administrator VS2015 "C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\devenv.exe" /setup "C:\Program Files (x86)\Microsoft Visual Studio… Continue reading ApexSQL Add-in Errors Post-Uninstall