Using SQL Service Broker for asynchronous external script (R / Python) execution in OLTP systems
First published on MSDN on Oct 19, 2017 Authored by Arvind Shyamsundar (Microsoft)Credits: Prasad Wagle, Srinivasa Babu Valluri, Arun Jayapal, Ranga Bondada, Anand Joseph (members of the Sayint by Zen3 team)Reviewers: Nellie Gustafsson, Umachandar Jayachandran, Dimitri Furman (Microsoft)This blog post was inspired our recent work with the Sayint dev team, who are a part of Zen3 Infosolutions.Performance implications of using multi-Statement TVFs with optional parameters
First published on MSDN on Oct 16, 2017 Authored by Arvind Shyamsundar (Microsoft)Credits: Prasad Wagle, Srinivasa Babu Valluri, Arun Jayapal, Ranga Bondada, Anand Joseph (members of the Sayint by Zen3 team)Reviewers: Rajesh Setlem, Joe Sack, Dimitri Furman, Denzil Ribeiro (Microsoft)This blog post was inspired our recent work with the Sayint dev team, who are a part of Zen3 Infosolutions.Collecting performance data with PSSDIAG for SQL Server on Linux
First published on MSDN on Aug 11, 2017 Reviewed by: Suresh Kandoth,Rajesh Setlem, Steven Schneider, Mike Weiner, Dimitri FurmanWhen analyzing SQL Server performance related issues, customers often have their tools of choice, which can be a feature within the product, a third-party performance monitoring tool, or a home-grown tool that assists in monitoring live performance.
How the SQLCAT Customer Lab is Monitoring SQL on Linux
First published on MSDN on Jul 03, 2017 Authored by Steven SchneiderReviewed By: Denzil Ribeiro, Dimitri Furman, Mike Weiner, Rajesh Setlem, Murshed ZamanBackgroundSQLCAT often works with early adopter customers, bring them into our lab, and run their workloads.
