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)… Continue reading Using SQL Service Broker for asynchronous external script (R / Python) execution in OLTP systems

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)… Continue reading Performance implications of using multi-Statement TVFs with optional parameters

Secure your on-premises network outbound connection to Azure SQL Database by locking down target IP addresses

First published on MSDN on Oct 06, 2017

Authored by Kun Cheng

Reviewed by: Dimitri Furman, John Hoang, Mike Weiner, Rajesh Setlem

Most people familiar with Azure SQL DB (aka SQL Database) are aware o… Continue reading Secure your on-premises network outbound connection to Azure SQL Database by locking down target IP addresses

Unattended install and configuration for SQL Server 2017 on Linux

First published on MSDN on Oct 03, 2017

SQL 2017 bits are generally available to customers today. One of the most notable milestones in the 2017 release is SQL Server on Linux. Setup has been relatively simple for SQL Server on Linux, … Continue reading Unattended install and configuration for SQL Server 2017 on Linux