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… Continue reading 🌎 AI Bootcamp – Tomorrow in Fort Lauderdale!
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… Continue reading 🏹 SQL Audit – See Through Walls
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