Niels Berglund

Interesting Stuff - Week 22

Kafka, event driven architectures, books, how to fix R issues after applying CU7, and other interesting topics.

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.

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.

SQL Server Machine Learning Services and Extended Events

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

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

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

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

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.

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.

Microsoft SQL Server R Services - Internals XVIII

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