Early technical preview of JDBC Driver 9.1.1 for SQL Server released
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 additi …
Logging Schema-changes in a Database using DDL Trigger
The article is published here on the Azure SQL Blog: Logging Schema-changes in a Database using DDL Trigger – Microsoft Tech Community
Microsoft Drivers 5.9.0 Preview/Beta 2 for PHP for SQL Server Released
We recently released the next preview/beta of the Microsoft Drivers for PHP for SQL Server, version 5.9.0-beta2. This preview/beta release has been built with PHP 7.3+ and tested on all supported platforms. Note: We have changed from « preview » to …
Released: Public Preview for SQL Server Analysis Services Management Pack
We are getting ready to update SQL Server Analysis Services Management Pack. Please install this public preview version (7.0.27.0) and provide us feedback. We appreciate the time and effort you spend on these previews which make the final product …
Released: Public Preview for SQL Server Replication Management Pack (7.0.27.0)
We are getting ready to update SQL Server Replication Management Pack. This release will bring support for older SQL Server versions (2012, 2014, 2016) into the version agnostic MP. That is, going forward just like SQL Server MP, we will have version-a …
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 …