Niels Berglund

sp_execute_external_script and SQL Compute Context - III

We use WinDbg, Process Monitor and WireShark to look in detail what happens in SQL Server when we use RxSqlServerData to pull data.

Posted by nielsb on Saturday, August 4, 2018

sp_execute_external_script and SQL Compute Context - II

We look in detail why we see performance differences when using SQL Server Compute Context.

Posted by nielsb on Saturday, July 7, 2018

sp_execute_external_script and Permissions

We look at what permissions a non-admin user needs to execute sp_execute_external_script

Posted by nielsb on Sunday, June 24, 2018

sp_execute_external_script and SQL Compute Context - I

A drill-down into how SQL Server Compute Context works when executing sp_execute_external_script.

Posted by nielsb on Sunday, May 20, 2018

Microsoft SQL Server R Services - sp_execute_external_script - III

A lowdown of sp_execute_external_script and the @parallel and @r_rowsPerRead parameters, the SQL Server compute context, using Process Monitor and Process Explorer

Posted by nielsb on Wednesday, March 21, 2018

Microsoft SQL Server R Services - sp_execute_external_script - II

A lowdown of sp_execute_external_script and its @params and @parameter1 parameters, using Process Monitor and WireShark

Posted by nielsb on Sunday, March 11, 2018

Microsoft SQL Server R Services - sp_execute_external_script - I

A lowdown of sp_execute_external_script and its different parameters, using Process Monitor and WireShark

Posted by nielsb on Wednesday, March 7, 2018

Interesting Stuff - Week 30

F# coverage, together with .NET in general, SQL Server R Services, Azure Functions, and other things.

Posted by nielsb on Sunday, July 30, 2017

Creating R Stored Procedures in SQL Server 2016 Using sqlrutils

We look at how to use sqlrutils to create SQL Server stored procedures from inside an R environment.

Posted by nielsb on Sunday, June 25, 2017

Technology musings about coding and data. Some topics: .NET, SQL Server, AI/ML, Big Data, Streaming, Kafka, Azure Data Explorer, and a lot more.