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.Improve query performance on memory optimized tables with Temporal using new index creation enhancement in SP1
First published on MSDN on Dec 08, 2016 Reviewed by: Dimitri Furman,Sanjay Mishra, Mike WeinerWith the introduction of the Temporal feature in SQL 2016 and Azure SQL Database, there is an ability to time travel through the state of data as it was at any given point of time.Do it right! Deploying SQL Server R Services on computers without Internet access
First published on MSDN on Oct 20, 2016 Reviewed by: Sanjay Mishra, Umachandar Jayachandran, Dimitri Furman, Jeannine Nelson-Takaki, Joe Sack, Kun Cheng, Eric BurgessOne of the most exciting features in SQL Server 2016 is R Services (in-database).SQLSweet16!, Episode 10: "I can eat glass …", but can I load it into a database?
First published on MSDN on Oct 19, 2016 Authored by Sanjay MishraSanjay MishraReviewed By: Dimitri Furman, Murshed Zaman, Kun Cheng If you have tried to use BULK INSERT or bcp utilities to load UTF-8 data into a table in SQL Server 2014 or in an earlier release (SQL Server 2008 or later), you have likely received the following error message:Msg 2775, Level 16, State 13, Line 14The code page 65001 is not supported by the server.SQLSweet16!, Episode 9: Scripting Always Encrypted operations
First published on MSDN on Oct 07, 2016 Authored by Sanjay MishraAuthors: Arvind Shyamsundar, Sanjay Mishra, Subodh Patil (iCertis), Mukesh Singh (iCertis), Ravi Kumar (iCertis)Reviewers: Dimitri Furman, Benjin Dubishar, Raghav Kaushik, Jakub SzymaszekAlways Encrypted is one of the highly acclaimed features in SQL Server 2016.
