SQL Server Cumulative Updates (CU) through the end of calendar year 2020
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.’
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
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
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
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
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
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
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!
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
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
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
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
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
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
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 …