User Profile

NathanMSFT

Microsoft

Joined 7 years ago

13 Posts5 Likes

View All Badges

User Widgets

Recent Discussions

No content to show

Recent Blog Articles

Generic ODBC external data sources may not work after installing Cumulative Update
Symptoms After you install SQL Server 2019 CU19 or SQL Server 2022 CU2, external data sources using generic ODBC connector may no longer work. When you try to query external tables that were cr...
Mar 30, 2023 Place SQL Server Support Blog
14KViews
1like
8Comments
[Data Virtualization] May need to update Java (JRE7 only uses TLS 1.0)
TL;DR - if you have an old Azure Storage account you've been using for PolyBase queries and suddenly start encountering the error "com.microsoft.azure.storage.StorageException: The server encountered...
Feb 27, 2023 Place SQL Server Support Blog
5.3KViews
0likes
0Comments
PolyBase Generic ODBC - Error calling: SQLSetDescRec - The driver does not support this function.
You may see the following problem when querying a PolyBase external table pointing to a generic ODBC external data source. We have observed this error for three different PolyBase generic ODBC extern...
Mar 30, 2022 Place SQL Server Support Blog
5.5KViews
0likes
1Comment
PolyBase error - 100001;Failed to generate query plan.
Problem We've seen several cases come in lately where customers have been trying to use PolyBase feature and encountering "Failed to generate query plan" error. Depending on which command you run, ...
Mar 01, 2021 Place SQL Server Support Blog
7.6KViews
1like
2Comments
PolyBase Service Account Permissions and Common Errors Observed When They Are Missing
We have seen a number of PolyBase cases in SQL Server Support related to logins or permissions created and set during installation that are missing. It is quite common for organizations to want to lo...
Feb 03, 2021 Place SQL Server Support Blog
12KViews
0likes
1Comment
SQL CLR .NET Framework runtime fatal error due to Uneven Number of CPUs Across Processor Groups
If you're using SQL CLR, you may have encountered an unexpected SQL Server service termination issue on SQL Servers with a large number of CPUs that are unevenly distributed across the processor grou...
May 29, 2020 Place SQL Server Support Blog
5.2KViews
1like
0Comments
PolyBase External Objects in an AlwaysOn Availability Database
Problem I was recently helping a customer with an issue where he was using PolyBase external objects in an AlwaysOn Availability Database. After setting up a readable secondary replica, when trying...
Mar 27, 2020 Place SQL Server Support Blog
4.8KViews
1like
0Comments
SQL 2019 PolyBase: Fractional Truncation Issue When Using Data Virtualization in Azure Data Studio
My colleague Liwei Yin recently blogged about how to use the Data Virtualization extension in Azure Data Studio for creating PolyBase external tables for Oracle data sources. If you've done any work ...
Mar 27, 2020 Place SQL Server Support Blog
4.4KViews
0likes
0Comments