Sites Microsoft


Recent updates for Data-Tier Application Framework and SqlPackage

Publié le 19 juillet 2021 sur SQL Server Blog
 

In this article, we will cover some recent changes to the Data-Tier Application Framework (DacFx) and SqlPackage. DacFx is a library that provides APIs for database deployment and development scenarios and SqlPackage is a command line interface to DacF …

Know your options for SQL Server 2012 and Windows Server 2012 End of Support

Publié le 14 juillet 2021 sur SQL Server Blog
 

Customers trust Windows Server and SQL Server for their business-critical workloads. With SQL Server 2019, customers like Ita Unibanco are taking advantage of the built-in intelligence, industry-leading performance, and security across both structured …

Cumulative Update #25 for SQL Server 2017 RTM

Publié le 13 juillet 2021 sur MS Tech Community
 

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

Scheduled refresh issue with pbix report that connects to Access DB data source in PBIRS

Publié le 12 juillet 2021 sur SQL Server Support Blog
 

This article discusses about the error “The login failed for data source ‘Unknown’ that occurs with scheduled refresh of pbix report that uses Access database as the data source and the solution to get the refresh to work.   Erro …

What’s new with SQL Server Big Data Clusters—CU11 Release

Publié le 8 juillet 2021 sur SQL Server Blog
 

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

Update- Beta program for SQL Server on Windows container is suspended.

Publié le 5 juillet 2021 sur MS Tech Community
 

As you may be aware, the SQL Server on Windows Containers Beta program began in 2017. It has remained in Beta mode meant for only test and development environment until now. , due to the existing ecosystem challenges and usage patterns we have decided …

Looking to the future for R in Azure SQL and SQL Server

Publié le 30 juin 2021 sur SQL Server Blog
 

Data science, machine learning, and analytics have re-defined how we look at the world. The R community plays a vital role in that transformation and the R language continues to be the de-facto choice for statistical computing, data analysis, and many …

Released: SCOM Management Packs for SQL Server, Reporting Services, Analysis Services (7.0.32.0)

Publié le 29 juin 2021 sur MS Tech Community
 

Updates to SQL Server, Reporting Services, and Analysis Services Management Packs are available (7.0.32.0). We also released an update to SQL Server Dashboards MP. You can download the MPs from the links below. Majority of the changes are based on your …

Update Stats Sample Rate does not work

Publié le 23 juin 2021 sur SQL Server Support Blog
 

Create/Update statistics allows users to speicfy the sample rate. However, the sample rate may not work as you expected in some scenarios.     1.Tables that have not greater than 1024 pages I’m going to use the table Production.Product  …

SQL Server 2016 Service Pack 3 release schedule update

Publié le 17 juin 2021 sur MS Tech Community
 

SQL Server 2016 mainstream support is scheduled to end 7/13/2021 as defined by the lifecycle policy.   With the crossover to extended support, Microsoft is committed to providing a final service pack for SQL Server 2016 to all customers.  The …

Cumulative Update #11 for SQL Server 2019 RTM

Publié le 11 juin 2021 sur MS Tech Community
 

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

Released: General Availability of Microsoft.Data.SqlClient 3.0

Publié le 9 juin 2021 sur MS Tech Community
 

We have released for general availability Microsoft.Data.SqlClient 3.0. This .NET Data Provider for SQL Server provides general connectivity to the database and supports all the latest SQL Server features for applications targeting .NET Framework, .NET …

Released: Public Preview for SQL Server Management Packs (7.0.31.0)

Publié le 8 juin 2021 sur MS Tech Community
 

Updates to Management Packs for SQL Server, Reporting Services, and Analysis Services (7.0.31.0) are available for public preview. Please install this public preview version and provide us feedback. We appreciate the time and effort you spend on t …

DISABLE_PARAMETER_SNIFFING

Publié le 31 mai 2021 sur SQL Server Support Blog
 

According to MSDN article, ‘DISABLE_PARAMETER_SNIFFING’ instructs Query Optimizer to use average data distribution while compiling a query with one or more parameters. This instruction makes the query plan independent on the parameter value that was fi …

SQL Server R Services またはSQL Server Machine Learning Servicesをオフラインでインストールまたは更新プログラムを適用するための方法について

Publié le 28 mai 2021 sur SQL Server Support Blog
 

  こんにちは SQL Server サポートチームです。   今回は、SQL Server R Services またはSQL Server Machine Learning …


Pages :