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. If there’s anything recorded that you find should be redacted, please email redact@fleitasarts.com.
DISCLAIMER: The following video is a candid capture of me giving the live presentation. It’s not super professional in any way. The audio or video may not be perfect, so adjust the volume on your device as needed during playback. The video and slides are not licensed for distribution, edit or sell for anyone, except the owner Hiram Fleitas. This video is not intended to exceed the quality of attending a live presentation.
Video 1st Part (30 minutes):
Video 2nd Part (30 minutes):
Slides:
Summary:
- Add ML Features (exe components)
- Grant Access (users, groups, add login & user)
- Config (external scripts enabled, working directory)
- Install Pre-Trained & Open Source ML Models (DNN) (PowerShell, rsetup.exe)
- Code in Python and T-SQL (Visual Studio, SSMS)
- Python Profiling (Visual Studio, execution plan, CPU)
- Real-time scoring (rx_serialize_model, realtime_scoring_only = True)
- Review Sentiment Results (sp_rxPredict wins!)
- Resources
Resources:
- Blog: https://dba2o.wordpress.com
- Slides & Scripts: https://goo.gl/BqfYSi
- SQL Server R Services Samples: Microsoft Repo
- Visual Studio 2017: Download
- Microsoft AI: AI School Learning Paths
- 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 Resource Pool
- Interactive deep learning: Learn alert
Enjoy,
Hiram
[…] Prev Videos: https://dba2o.wordpress.com/2019/04/17/video-real-time-sentiment-prediction-in-sql-server […]
LikeLike