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’”
Month: December 2019
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.
Realcase: Failed to upgrade SQL Server 2016 SP2 CU11. (Installation success or error status: 1648)
One of my customer failed to upgrade SQL Server 2016 SP2 CU11. Here is the troubleshooting steps 1.Check SQL Server setup log(C:\Program Files\Microsoft SQL Server\130\Setup Bootstrap\Log\) Detailed… Read more “Realcase: Failed to upgrade SQL Server 2016 SP2 CU11. (Installation success or error status: 1648)”
Connect SQL Server from Linux Client using Windows Authentication and troubleshoot steps
Connect SQL Server from Linux Client using Windows Authentication is supported. Here are the Prerequisites. 1.As Kerberos is the only one supported, the Kerberos authentication needs to… Read more “Connect SQL Server from Linux Client using Windows Authentication and troubleshoot steps”
Different AG groups have the exactly same group_id value if the group names are same and the ‘CLUSTER_TYPE = EXTERNAL/NONE’
For external/none cluster type, since there is no orchestration, each replica needs to know how to independently determine the AG ID, thus the AG group name is… Read more “Different AG groups have the exactly same group_id value if the group names are same and the ‘CLUSTER_TYPE = EXTERNAL/NONE’”
An example of SQL Linux Windows Authentication configuration using Managed Service Accounts
Environment === Domain:contoso.com Linux server:red1(Redhat 7.6) MSA:msa01 SQL Server 2017 CU17 Red1 has joined the domain contoso.com(For information on how to join an active directory domain, see… Read more “An example of SQL Linux Windows Authentication configuration using Managed Service Accounts”
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 