Binary eXchange Language format,data coming back to SQL Server from SqlSatellite | Continue reading
More about Binary eXchange Language, we're looking at packet sizes - and what happens inside SQL Server. | Continue reading
Binary eXchange Language format, and strange packet sizes. | Continue reading
When is SQL statements executed when executing external scripts? | Continue reading
Kafka streams, Azure Databricks Delta, lots of SQL Server 2019, and other interesting topics! | Continue reading
More about the TCP/IPpackets sent from SQL Server to SqlSatellite. | Continue reading
A look at how to run SQL Server 2019 for Linux in a Docker container on a Windows machine. | Continue reading
What are the two strange TCP/IP packets sent from SQL Server to SqlSatellite, and who sends them? | Continue reading
Here we look at how data is sent to SqlSatellite. We use WinDbg, WireShark and other cool stuff! | Continue reading
Where we look at SqlSatellite and communication between SQL Server R Services components | Continue reading
Here we look at some of the components the launchpad service loads; Rterm.exe, BxlServer.exe, etc. | Continue reading
We look at the files and sub-directories created when executing sp_execute_external_script. | Continue reading
This post looks at the directories created by the launchpad service in SQL Server R Services when executing an external script. | Continue reading
More about the launchpad service and RTerm processes in relation to parallelism in SQL Server R Services. | Continue reading
Using WinDbg to find out what happens inside SQL Server when data is returned from SqlSatellite | Continue reading
A look at how output parameters are handled in SQL Server R Services | Continue reading
Launchpad service, number of processes, process pool. More about process creation in the launchpad service | Continue reading
SQL Server R Services series. Here we look at what happens when the launchpad service creates processes in SQL Server R Services. | Continue reading
A very initial investigation of what is new in SQL Server 2019 Machine Learning Services. | Continue reading
SQL Server extended events (XEvents) and SQL Server Machine Learning Services | Continue reading
Kafka and Donuts (I am serious), Docker on Windows, | Continue reading
SQL Server R Services series. In this post we look at what happens inside the launchpad service. | Continue reading
SQL Server R Services series. Today we look at what happen in the SQL Server engine when we execute sp_execute_external_script. | Continue reading
How to use Facebook Prophet in Microsoft R Server / SQL Server R Services | Continue reading
SQL Server and XACT_ABORT(). Here we discuss the dangers of using XACT_ABORT in SQL Server OLTP databases. DO NOT DO IT!! | Continue reading
We look at how we can install Kafka on Windows in Windows Subsystem for Linux. | Continue reading
SQL Server and XACT_STATE(). A blog-post about doomed transactions in SQL Server and XACT_STATE() | Continue reading
We continue looking at installing R packages. This post is all about using RevoScaleR functionality. | Continue reading
SQL Server R Services series. This first post look at installation of SQL Server R Services. | Continue reading
Transactions in SQL Server seems to be a difficult topic to grasp. This weekend I came across a blog-post where the poster showed a “solution” to the “The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION” error we sometimes see when various stored procedures ca … | Continue reading
SQL Server and error handling. How error handling in SQL Server can trip you up! | Continue reading
Python in SQL Server 2017. Here we have a brief look at the Python support in SQL Server 2017. | Continue reading
Kafka and KSQL, Azure Data Lake Storage Gen2, SQL Server Query Plans, and other interesting topics! | Continue reading
SQL Server to RabbitMQ. A post about how SQL Server can communicate with RabbitMQ to push data out of the database. | Continue reading
We discuss the use of TRUSTWORTHY and certificates in SQL Server when deploying SQLCLR assemblies. | Continue reading
Kafka, SQL Server Machine Learning Services, SQL Saturday, Hadoop and other interesting topics. | Continue reading
.NET monitoring, chaos engineering, Pat Helland, stream integration, serverless, and other cool topics! | Continue reading
How can we install R packages in SQL Server Machine Learning Services | Continue reading
A lowdown of sp_execute_external_script and its @params and @parameter1 parameters, using Process Monitor and WireShark | Continue reading
Weekly roundup of what interesting stuff I have read in blogs etc. | Continue reading
SQL Server to RabbitMQ. A post about how SQL Server can communicate with RabbitMQ to push data out of the database. | Continue reading
SQL Server 2017 RC1 has added new functionality for SQLCLR security; sp_add_trusted_assembly. | Continue reading
Cool Pulumi code, Kafka, Azure AI services, R and Python in Docker, and other interesting topics! | Continue reading
Kafka in Azure, Kafka on Windows, ML.NET R new version and other interesting topics. | Continue reading
Apache Kafka, Azure Event Hubs, Databricks, event driven microservices, SQL Server Machine Learning Services and other interesting topics. | Continue reading