Sites Microsoft


How It Works: Temporary Objects – User Transaction Scope

Publié le 20 avril 2022 sur MS Tech Community
 

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

Publié le 19 avril 2022 sur MS Tech Community
 

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

Publié le 13 avril 2022 sur MS Tech Community
 

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

Publié le 11 avril 2022 sur MS Tech Community
 

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

Publié le 6 avril 2022 sur MS Tech Community
 

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!

Publié le 5 avril 2022 sur MS Tech Community
 

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

Publié le 31 mars 2022 sur MS Tech Community
 

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.

Publié le 30 mars 2022 sur SQL Server Support Blog
 

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

Publié le 30 mars 2022 sur SQL Server Support Blog
 

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

Publié le 30 mars 2022 sur SQL Server Support Blog
 

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

Publié le 24 mars 2022 sur SQL Server Blog
 

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

Publié le 17 mars 2022 sur MS Tech Community
 

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

Publié le 16 mars 2022 sur SQL Server Support Blog
 

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

Publié le 16 mars 2022 sur SQL Server Support Blog
 

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

Publié le 14 mars 2022 sur MS Tech Community
 

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 …


Pages :