🌎 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 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…

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…

Webinar – This Wednesday 11am EST.

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…

Hack / Protect SQL Server – Resources 💎

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…

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/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…

Going big…REAL BIG. Power Platform – 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…

Video: Real-time Sentiment Prediction in SQL Server

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.…

SQLCMD variables for input SQL file

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…

SQL Server Read-Only Routing

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…