Sites Microsoft


SQL Server Cumulative Updates (CU) through the end of calendar year 2020

Publié le 30 novembre 2020 sur MS Tech Community
 

This has been a tough year and we are supporting our teams to spend time with their families. Due to minimal operations over the upcoming holidays and new year, we will not be releasing any additional SQL Server Cumulative Update (CU) releases for …

Patch upgrade failed. ‘Error:574 CONFIG statement cannot be used inside a user transaction.’

Publié le 28 novembre 2020 sur SQL Server Support Blog
 

  Customer failed to apply patch. SQL Service cannot start. They received below errors in SQL Error logs.   2020-11-24 20:09:21.59 spid5s      Configuration option ‘show advanced options’ changed from 1 to 1. Run the …

Released: General Availability of Microsoft.Data.SqlClient 2.1

Publié le 19 novembre 2020 sur MS Tech Community
 

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

Microsoft Azure at Data Platform Virtual Summit 2020

Publié le 19 novembre 2020 sur SQL Server Blog
 

Data Platform Virtual Summit 2020 (DPS 2020) is just a couple of weeks away. A global learning event for data professionals, DPS 2020 features a keynote from Rohan Kumar, Microsoft Corporate Vice President of Azure Data, as well as 200 breakout session …

Building and sharing Jupyter Books in Azure Data Studio

Publié le 16 novembre 2020 sur SQL Server Blog
 

The notebook experience in Azure Data Studio allows users to create and share documents containing live code, execution results, and narrative text. Potential usage includes data cleaning and transformation, statistical modeling, troubleshooting guides …

The November 2020 release of Azure Data Studio is now available

Publié le 12 novembre 2020 sur SQL Server Blog
 

The November release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started.Azure Data Studio is a multi-database, cross-platform desktop environment for data professionals using the Microsoft fami …

What is Azure Arc Enabled SQL Managed Instance | Data Exposed

Publié le 12 novembre 2020 sur MS Tech Community
 

In this episode of Data Exposed with Vin Yu, we’ll introduce Azure Arc enabled SQL Managed Instance and provide an overview of its capabilities. We’ll also share how you can get started with Azure Arc enabled SQL Managed Instance.Watch on D …

SSDT DacFx Pre/Post Deployment scripts containing DML for Always Encrypted columns

Publié le 11 novembre 2020 sur SQL Server Support Blog
 

Unlike SSMS 17.xx onwards; SSDT/DACFx currently doesn’t have « Parameterize for Always Encrypted » setting. This causes DACPAC/DACFx deployments to fail when Pre/Post deployment scripts have DML (INSERT, UPDATE) on Always Encrypted columns. We know Alway …

Announcing Azure Marketplace images for SQL Server Analysis Services 2019 virtual machines!

Publié le 10 novembre 2020 sur MS Tech Community
 

Today we are announcing new Analysis Services virtual machine images for SQL Server 2019. Now customers have the ability to deploy an Analysis Services virtual machine (SSAS) using pre-configured Standard and Enterprise edition image types for eas …

« Unsupported IIS Security Modes for Report Server » failed When you try to upgrade SQL 2005 to 2014

Publié le 6 novembre 2020 sur SQL Server Support Blog
 

Issue Background: ======= Customer is running SQL Server 2005(X64) on Windows Server 2008, and they want to upgrade to SQL Server 2014 with in-place(can’t accept side by side). But during the upgrading, the following rules are failed, this is related t …

What is Azure Arc Enabled PostgreSQL Hyperscale? | Data Exposed

Publié le 5 novembre 2020 sur MS Tech Community
 

In this episode with Jean-Yes Devant, we’ll introduce Azure Arc enabled PostgreSQL Hyperscale and provide an overview of its capabilities. We’ll also share how you can get started with Azure Arc enabled PostgreSQL Hyperscale.   Watch on Data Expos …

Creating index becomes extremely slow when all rows are in one partition

Publié le 31 octobre 2020 sur SQL Server Support Blog
 

A customer reported that they found creating indexes sometimes become very slow in SQL2017. We analyzed this issue and found below symptom This issue happens when creating index on partition table. But all rows are in one partition. This issue happens …

Understanding Azure Arc Enabled SQL Server | Data Exposed

Publié le 29 octobre 2020 sur MS Tech Community
 

In this episode of Data Exposed with Sasha Nosov, learn how Azure Arc allows you to leverage Azure Services for your existing database applications hosted on-premises or in other public clouds, without changing or even stopping them.   Watch on Da …

Common Criteria Certification for SQL Server 2019

Publié le 26 octobre 2020 sur MS Tech Community
 

We are very pleased to announce that SQL Server 2019 has obtained Common Criteria certification for the Windows and the Linux version.   SQL19 on Windows certificate   Overall, SQL Server 2019 is the 7th major release that has successfully co …

Released: Microsoft.Data.SqlClient 2.1 Preview 2

Publié le 26 octobre 2020 sur MS Tech Community
 

A new preview of Microsoft.Data.SqlClient was recently released. The SqlClient team is moving forward with continuous updates and improvements to the Microsoft.Data.SqlClient data provider for SQL Server. Our plan is to provide GA releases twice a year …


Pages :