PolyBase Generic ODBC – Error calling: SQLSetDescRec – The driver does not support this function.
Problem When trying to query an external table created for a generic ODBC external data source, the following error can be observed: Message 7320, level 16, state 110, line 87 Unable to execute query « Remote Query » against OLE DB provider « MSOLE …
Troubleshooting for SQL Server 4014 error message
Some times you may observe 4014 error messages in SQL Server errorlog, like belowError: 4014, Severity:20, State: 11. A fatal error occurred while reading the input stream from the network. The session will be terminated To continue analyze it, …
FDLauncher cannot be stopped automatically
If you are using Full text index, then you should have a service named ‘MSSQLFDLauncher’, and usually it should be stopped automatically when you stop SQL Server serivce. This is the expected behavior because SQL Server will send request to service con …
Move end-of-support SQL Server 2012 to Azure Virtual Machines and save
The end of support for SQL Server 2012 is rapidly approaching on July 12, 2022. After end of support, no more security patches will be issued unless you take action to protect your SQL Server 2012 with Extended Security Updates (ESU). If you’re st …
Configure MSDTC to run Distributed transactions for SQL Server Linux Containers on Azure Kubernetes
It’s been a while since I’ve had the opportunity to write and share a blog post about SQL Server containers and Linux. Today, I’d like to show you how to set up and use MSDTC (Microsoft Distributed Transaction Coordinator) to execute distributed transa …
SQL Server Database Mail Failure Troubleshooting & Two Common Issues
This blog discusses troubleshooting steps to investigate the failure of SQL Server Database Mail service on sending email. It also discusses 2 special scenarios with SQL Server Database Mail that commonly cause mail sending failure General Troub …
TSQL Scripts for Troubleshooting Common Issues with SQL Server
This blog provides TSQL samples for troubleshooting common SQL Server issues as listed below. You can modify the parameters (i.e. database name, table name, keyword name, duration, etc.) based on customized environment settings and requirements. (Test …
GA: SQL best practices assessment for SQL Server on Azure VMs
Wouldn’t it be great if there was a way to learn if your SQL Server on Azure Virtual Machines was configured optimally? Do you have the right options set? Do you have your tempdb on the right disk? Can your queries perform better? All these and more ca …
Released: Microsoft.Data.SqlClient 5.0 Preview 1
Microsoft.Data.SqlClient 5.0 Preview 1 has been released. This release contains improvements and updates to the Microsoft.Data.SqlClient data provider for SQL Server. Our plan is to provide GA releases twice a year with two or three preview releases in …
Windows のバージョンアップにより SQL Server 関連のパフォーマンスカウンターが表示されなくなる現象について
こんにちは、 SQL Server サポートチームです。 今回は SQL Server 関連のパフォーマ …
Capture a Call Stack Without Generating A Dump
Warning (Beta): The RVA feature set is in rollout and subject to change and limitations. XEvent and other outputs (errorlog, sqldump*.txt, …) contain call stack outputs. Some of these outputs are easy to symbolize while others are more d …
SQL 2016 – It Just Runs Faster: XEvent Linq Reader
Moved from: bobsql.com SQL Server 2016 improves the XEvent Linq reader scalability and performance. The XEvent UI in SQL Server Management Studio uses the XEvent Linq reader to process the events for display. …
SQL 2016 – Leverages On Demand MSDTC Startup
Moved from: bobsql.com SQL Server leverages MSDTC for distributed transactions (begin distributed transaction, remote proc trans, etc.) Prior to SQL Server 2016 the MSDTC service must be running (started) prior to any SQL Server …
SQL 2016 – It Just Runs Faster: In-Memory Optimized Database Worker Pool
Moved from: bobsql.com SQL Server leverages a worker pool for the In-Memory Optimized Database capabilities. Prior to SQL Server 2016, increasing the size of the pool required you to enable a startup trace flag. SQL Server 2016 …
SQL 2016 – It Just Runs Faster – AlwaysOn AES-NI Encryption
Moved from: bobsql.com The SQL Server 2016, AlwaysOn, log transport takes advantage of hardware based encryption to significantly improve scale and performance. SQL Server 2016 development efforts continued focusing on the AlwaysOn log sh …