Sites Microsoft


Selectivity and Estimated Row: Variable

Publié le 27 mai 2021 sur SQL Server Support Blog
 

SQL Server does not sniff for variable, it just simply uses the fixed value.   I’m going to use AdventureWorks 2019 in this post. ——————–Please run this script————— use AdventureWorks2019 go IF exists(select 1 from sys.table …

Released: Microsoft.Data.SqlClient 2.1.3

Publié le 21 mai 2021 sur MS Tech Community
 

We have released an update to Microsoft.Data.SqlClient, version 2.1.3. The update addresses a couple of issues that are important to our customers.   Updates in Microsoft.Data.SqlClient 2.1.3 include:   Fixed Fixed wrong data blended with tra …

Released: Microsoft.Data.SqlClient 3.0 Preview 3

Publié le 21 mai 2021 sur MS Tech Community
 

Microsoft.Data.SqlClient 3.0 Preview 3 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 preview releases in between. …

Error: 17053 -UpdateUptimeRegKey: Operating system error 5(Access is denied.) encountered, messages

Publié le 21 mai 2021 sur SQL Server Support Blog
 

Recently we have fixed an very interesting issue for a customer. ; sharing the details below   ISSUE: SQL Server generates below error for every one minute.   2021-05-20 08:15:09.96 spid32s Error: 17053, Severity: 16, State: 1.2021-05-20 08:1 …

Microsoft SQL Server Linux-based container images to be available only from the Microsoft Container Registry

Publié le 20 mai 2021 sur SQL Server Blog
 

Traditionally, SQL Server Linux container images could be downloaded from Microsoft Container Registry (mcr.microsoft.com) and mssql-server-linux. However, as you might be aware, we stopped updating the old repo, Microsoft/mssql-server-linux, a couple …

Cumulative Update #24 for SQL Server 2017 RTM

Publié le 11 mai 2021 sur MS Tech Community
 

The 24th 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 …

Accelerate SQL Server to Azure migration with Pure Cloud Block Store

Publié le 10 mai 2021 sur SQL Server Blog
 

Many organizations have either moved or extended their SQL Server operations from an on-premises data center into Azure. There are many reasons why you might be considering this move for your organization as well. Hosting SQL Server on Azure lets you f …

Early technical preview of JDBC Driver 9.3.1 for SQL Server released

Publié le 29 avril 2021 sur MS Tech Community
 

We have released a new early technical preview of the JDBC Driver for SQL Server which contains a few additions and changes.   Precompiled binaries are available on GitHub and also on Maven Central.Below is a summary of the new addi …

Inference of ML Models in SQL Server via External Languages

Publié le 26 avril 2021 sur MS Tech Community
 

In this blog post, we describe our work on enabling machine learning (ML) inference (aka scoring) of previously trained ML models using the newly introduced language extensions of SQL Server 2019. By implementing a set of APIs, users can inte …

Released: Microsoft.Data.SqlClient 3.0 Preview 2

Publié le 19 avril 2021 sur MS Tech Community
 

Microsoft.Data.SqlClient 3.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 preview releases in between. …

Azure SQL digital event: Innovate today with Azure SQL

Publié le 12 avril 2021 sur SQL Server Blog
 

In today’s data-driven world, companies are increasingly looking to the cloud to reduce their infrastructure and administrative costs and provide the on-demand scalability to match their customers’ ever-changing requirementswithout sacrificing security …

SQL Server 2019 on Ubuntu 20.04,python2 dependency removed for SQL Server 2019 across distributions.

Publié le 7 avril 2021 sur MS Tech Community
 

  SQL Server 2019 on Ubuntu 20.04 We are happy to announce the official production support and availability of SQL Server 2019 package native to Ubuntu 20.04 distribution starting with CU 10. You can read more about the SQL Server 2019 CU 10 relea …

What’s new with SQL Server Big Data Clusters—CU10 release

Publié le 7 avril 2021 sur SQL Server Blog
 

SQL Server Big Data Clusters is a new capability brought to market as part of the SQL Server 2019 release. Big Data Clusters extends SQL Server’s analytical capabilities beyond in-database processing of transactional and analytical workloads by uniting …

Cumulative Update #10 for SQL Server 2019 RTM

Publié le 7 avril 2021 sur MS Tech Community
 

The 10th cumulative update release for SQL Server 2019 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 …

Early technical preview of JDBC Driver 9.3.0 for SQL Server released

Publié le 1 avril 2021 sur MS Tech Community
 

We have released a new early technical preview of the JDBC Driver for SQL Server which contains a few additions and changes.   Precompiled binaries are available on GitHub and also on Maven Central.Below is a summary of the new addi …


Pages :