Sites Microsoft


Unlock your free Azure replica for SQL Server with DH2i

Publié le 29 juin 2020 sur SQL Server Blog
 

Are you aware that you may be entitled to a free SQL Server license in the cloud for disaster recovery? Recently-announced licensing benefits enable this scenario, and a third-party offering from DH2i can help you set up this configuration to ensure bu …

Released: Public Preview for SQL Server Management Pack (7.0.23.0)

Publié le 29 juin 2020 sur MS Tech Community
 

We are getting ready to release a new version of SQL Server Management Pack. Please install and use this public preview and send us your feedback (sqlmpsfeedback at microsoft.com)! We appreciate the time and effort you spend on these previews whic …

DBF file name is truncated to 8 characters

Publié le 26 juin 2020 sur SQL Server Support Blog
 

Recently a customer raised a case to us. They need to import a lot of DBF files into SQL SERVER. But they found when DBF fine name is longer than 8 characters they received below error: SELECT  * FROM OPENROWSET (‘MICROSOFT.ACE.OLEDB.12.0’,’dBase …

Elastic Jobs in Azure SQL Database (Part 2) | Data Exposed

Publié le 25 juin 2020 sur Azure SQL Database Blog
 

In the second part of this two-part video series, Kate Smith discusses what two things you should understand before beginning with Azure SQL Database Elastic Jobs: Idempotence, and Credentials. We explain why they are important and how to think about t …

Data Exposed | Elastic Jobs in Azure SQL Database (Part 2)

Publié le 25 juin 2020 sur Azure SQL Database Blog
 

In the second part of this two-part video series, Kate Smith discusses what two things you should understand before beginning with Azure SQL Database Elastic Jobs: Idempotence, and Credentials. We explain why they are important and how to think about t …

Released: SSRS and SSAS Management Packs now monitoring 2012 and up (7.0.22.0)

Publié le 24 juin 2020 sur MS Tech Community
 

This update enables the new version-agnostic management packs for SSRS and SSAS to monitor versions 2012, 2014, and 2016 in addition to already supported 2017, 2019. The old management packs for SSRS and SSAS 2008-2016 – version-specific ones …

Apache Spark Connector for SQL Server and Azure SQL is now open source

Publié le 22 juin 2020 sur SQL Server Blog
 

Accelerating big data analytics with the Spark connector for SQL ServerWe’re happy to announce that we have open–sourced the Apache Spark Connector for SQL Server and Azure SQL on GitHub. Born out of Microsoft’s SQL Server Big Data Clusters …

Cumulative Update #5 for SQL Server 2019 RTM

Publié le 22 juin 2020 sur MS Tech Community
 

The 5th 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 mo …

The June 2020 release of Azure Data Studio is now available

Publié le 18 juin 2020 sur SQL Server Blog
 

The June release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started.Note: After downloading Azure Data Studio, say Yes to enabling preview features so that you can use extensions.Azure Data Stu …

Data Exposed | Elastic Jobs in Azure SQL Database (Part 1)

Publié le 18 juin 2020 sur Azure SQL Database Blog
 

In the first part of this two-part video series, Kate Smith gives an introduction to what Azure SQL Database Elastic jobs are, and when you should consider using them, as well as what products support Elastic Jobs.   Watch on Data Exposed   A …

Elastic Jobs in Azure SQL Database (Part 1) | Data Exposed

Publié le 18 juin 2020 sur Azure SQL Database Blog
 

In the first part of this two-part video series, Kate Smith gives an introduction to what Azure SQL Database Elastic jobs are, and when you should consider using them, as well as what products support Elastic Jobs.   Watch on Data Exposed   A …

Join Microsoft at PASS Virtual Summit 2020

Publié le 17 juin 2020 sur SQL Server Blog
 

This year’s PASS Summit conference, the largest gathering of data professionals focused on the Microsoft platform, will be a virtual-only event for the first time.This will make PASS Virtual Summit 2020 more accessible than ever, giving attendees from …

Released: SQL Server Assessment Extension for Azure Data Studio (Public Preview)

Publié le 17 juin 2020 sur MS Tech Community
 

SQL Server Assessment Extension for Azure Data Studio provides a user interface for evaluating your SQL Server instances and databases for best practices. It uses SQL Assessment API to achieve this. In this preview version, you can: – Assess a SQL Serv …

Released: General Availability of Microsoft.Data.SqlClient 2.0

Publié le 16 juin 2020 sur MS Tech Community
 

We have released for general availability Microsoft.Data.SqlClient 2.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 …

Expanding SQL Server Big Data Clusters capabilities, now on Red Hat OpenShift

Publié le 16 juin 2020 sur SQL Server Blog
 

SQL Server Big Data Clusters (BDC) is a new 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 …


Pages :