Niels Berglund

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

Installing R Packages in SQL Server Machine Learning Services - I

How can we install R packages in SQL Server Machine Learning Services

Posted by nielsb on Saturday, June 23, 2018

SQL Server Machine Learning Services and SQL Server 2017 CU7

We look at how we can fix issues with the R engine after installing SQL Server 2017 CU7.

Posted by nielsb on Friday, June 1, 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

SQL Server Machine Learning Services and Extended Events

SQL Server extended events (XEvents) and SQL Server Machine Learning Services

Posted by nielsb on Sunday, April 8, 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

Microsoft SQL Server R Services - Internals XX

A drill down, using WinDbg, WireShark, Process Monitor, into how error messages in the external engine is handled by SQL Server.

Posted by nielsb on Friday, February 2, 2018

Microsoft SQL Server R Services - Internals XIX

A drill down, using WinDbg, into how print statements in the external engine together with ack messages comes back to SQL Server.

Posted by nielsb on Saturday, January 20, 2018

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