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

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

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

Microsoft SQL Server R Services - Internals XVIII

A look at how output parameters are handled in SQL Server R Services

Posted by nielsb on Wednesday, January 10, 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.