Get Cognitive API by Python T-SQL

In this short video, Hiram Fleitas will explain how to call the Azure Cognitive Services - Text Analytics API from SQL Server by using T-SQL and Python in a Stored Procedure.
During the demo, Hiram will first cover the pre-requisite steps and create a view to prep data in JSON format. He will then use the Sentiment Analysis API to score unstructured text and save the API result(s) for further ML. The use of Sentiment Analysis can help developers build applications that reduce churn, improve customer satisfaction, and display customer feedback in real-time. Bonus resources included.  

24 Hours of PASS: Summit Preview 2019

Still undecided about which sessions to attend at PASS Summit? Join us for 24 Hours of PASS: Summit Preview for a sneak peek of some of the top speakers presenting at this year's PASS Summit in Seattle.

Test Driving Always Encrypted with Secure Enclaves in SQL Server 2019

SQL Server 2019’s new security feature, Always Encrypted, (currently still in preview) protects sensitive data from highly privileged but unauthorized users, while preserving SQL Server’s ability to perform rich queries against the very same data. Leonard Lobel walks through the steps for setting up your environment enabling you to start working with Always Encrypted using secure enclaves. 

A Start-To-Finish Guide to Docker for .NET

Docker: it’s one of those technologies that seems to be everywhere. Whether you’re a junior developer just starting out or a seasoned .NET developer, at some point in your career, you’ll most likely come across Docker for .NET. This article will walk you through what Docker really means. 

ASP.NET Core 3.0 Exception Handling

Dealing with errors is one of the essential elements of programming applications. In this article, Dino Esposito discusses how handle exceptions with ASP.NET Core 3.0. 

Announcing the Preview of GitHub Actions for Azure

On Thursday, August 8, 2019, GitHub announced the preview of GitHub Actions with support for Continuous Integration and Continuous Delivery (CI/CD). Actions makes it possible to create simple, yet powerful pipelines and automate software compilation and delivery. A few days later, on August 13, 2019, Microsoft announced the preview of GitHub Actions for Azure. 

Build Blazing Fast Data-Driven Web Apps with Blazor and OData

Jeremy Likness demonstrates an alternative method of building data-driven web apps with Blazer and OData. 

Advanced Dapper in C#

Dapper is a micro-Orm built by the team behind Stack Overflow for the purpose of moving data in and out of databases. In this video, Tim Corey covers some of the advanced scenarios that you can use Dapper with, including User Defined Table Types, Transactions, multiple data sets, and more.

Soft Skills Every Developer Should Have

What are the soft skills that every Developer should have? Thomas Lombart discusses the importance of soft skills,which ones you need most, and why.

Upcoming Virtual Events

T-SQL Tune-Up Tips – Bert Wagner

Tuesday, September 10. 16:00 UTC.

 

We are recruiting community contributors for all PASS Insights newsletter editions:

DBA, BI, Developer, and Analyst.
We’re looking for engaging, in-depth, and technically-focused ideas to feature each month. If you are interested, submit your ideas to insights@pass.org.
You just might see yourself featured in an upcoming edition!

Looking for more than just Developer educational and technical content?
Log in to your PASS account and subscribe to the new Analyst, BI, and DBA PASS Insights newsletters.