How It Works: Temporary Objects – User Transaction Scope
Temporary tables (create table #tmp, select into #tmp, declare @t table, internal worktables from sorts, internal spills from hashes, table valued parameters, cursors, etc.) are commonplace for SQL Server applications. There are many discussions pertai …
Cumulative Update #16 for SQL Server 2019 RTM
The 16th cumulative update release for SQL Server 2019 RTM for Windows is now available for download at the Microsoft Downloads site available. The blog will be updated when the improvements and fixes are available for Linux and Big Data Clusters. Plea …
Released: Microsoft.Data.SqlClient 5.0 Preview 2
Microsoft.Data.SqlClient 5.0 Preview 2 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 …
SQL Server 2022 Early Adoption Program Update – Applications Now Closed
Since announcing SQL Server 2022 at Ignite in November 2021, the Early Adoption Program (EAP) has received over 2,500 applications to join the Private Preview. The excitement from data professionals, customers, and the SQL Server community for the …
Early technical preview of JDBC Driver 11.1.0 for SQL Server released
We have released a new early technical preview of the JDBC Driver for SQL Server which contains several additions and changes. Precompiled binaries are available on GitHub and also on Maven Central. Encrypt = strict There i …
Announcing general availability of the Ebdsv5 series Azure VMs!
This past November at Ignite we announced the public preview of the new Ebdsv5 series of VMs which are ideal for database and other I/O intense workloads because they offer higher remote storage throughput and IOPS per vCPU than any other VM series in …
Cumulative Update #29 for SQL Server 2017 RTM
The 29th cumulative update release for SQL Server 2017 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing m …
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 …