Sites Microsoft


Early technical preview of JDBC Driver 9.1.1 for SQL Server released

Publié le 3 décembre 2020 sur MS Tech Community
 

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

Publié le 2 décembre 2020 sur MS Tech Community
 

  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

Publié le 2 décembre 2020 sur MS Tech Community
 

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

Publié le 2 décembre 2020 sur MS Tech Community
 

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)

Publié le 2 décembre 2020 sur MS Tech Community
 

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

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 …


Pages :