Sites Microsoft


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 …

SQL Server Management Studio 18.7 now generally available

Publié le 20 octobre 2020 sur SQL Server Blog
 

The release of SQL Server Management Studio (SSMS) 18.7 is now generally available for download. Today we’re sharing some of the updates from the release and the ongoing work in SQL Server Management Studio. Download SSMS 18.7 and read on for some high …

Microsoft Azure at PASS Virtual Summit 2020

Publié le 20 octobre 2020 sur SQL Server Blog
 

It is almost time for PASS Virtual Summit 2020, the premier learning event for the data professional. Similar to the in-person event, this virtual conference will include the latest SQL Server and Azure Data innovations, practical training, and network …


Pages :