If you have a SQL Server 2019 named instance with Polybase feature, you may fail to restart the PolyBase Data movement service after running the sp_polybase_join_group. You… Read more “Failed to restart Polybase Data Movement service after running sp_polybase_join_group”
Category: Polybase
Failed to create ‘CREATE EXTERNAL DATA SOURCE’
Let’s say you have a SQL Server 2019 installed in Windows server. The Windows server is not in domain, and you are connecting SQL Server using windows… Read more “Failed to create ‘CREATE EXTERNAL DATA SOURCE’”
Fail to start ‘PolyBase Engine’ and ‘PolyBase Data Movement’ if TCP/IP is disabled.
These two services are in stopped state or ‘Change pending’ Please enable SQL Server TCP/IP protocol and restart SQL Server service.
An example of Polybase for Oracle(TSQL)
Here is the topology of the environment SQL Server Oracle SQL Server 2019 RTM Oracle 11g Platform:Windows 2016 IP:192.168.1.31 Port:1521 SQL 2019 RTM does not support versions… Read more “An example of Polybase for Oracle(TSQL)”
Use Azure Data Studio to create external table for Oracle server.
Use T-SQL to create external tables for Oracle is cumbersome and error-prone. You may refer the article if you are interested. Today I’m going to show you… Read more “Use Azure Data Studio to create external table for Oracle server.”
SQL Server 