Nathan Schoenack warns us of a bug in SQL Server:
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 created before installing the cumulative update, you receive the following error message:
Msg 7320, Level 16, State 110, Line 68
Cannot execute the query “Remote Query” against OLE DB provider “MSOLEDBSQL” for linked server “(null)”. Object reference not set to an instance of an object.
If you try to create a new external table, you receive the following error message:
Msg 110813, Level 16, State 1, Line 64
Object reference not set to an instance of an object.
Click through to learn the cause of the issue and a workaround to resolve it.
Accessing MongoDB Arrays from SQL 2022 is rough
Yeah, arrays aren’t a native T-SQL type, so the array gets flattened and you see the results in columnar form. PolyBase assumes the underlying data source has data stored structured in a way which is at least SQL Server-friendly, if not exactly how you’d store it in a relational database.