Sites Microsoft


Making sense of Azure and Azure Arc deployment options for SQL Server

Publié le 30 septembre 2020 sur MS Tech Community
 

For some years Microsoft Azure has been offering several different deployment and management choices for the SQL Server engine hosted on Azure. With the release of the Azure Arc support for SQL Server, the range of different options has grown even furt …

Cumulative Update #15 for SQL Server 2016 SP2

Publié le 29 septembre 2020 sur MS Tech Community
 

The 15th cumulative update release for SQL Server 2016 SP2 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates. To learn more about the release or servicing m …

Cannot find SQL instance when applying patch

Publié le 26 septembre 2020 sur SQL Server Support Blog
 

One customer had a SQL2016 SP1 instance. We can login this instance without any issue. But when we tried to apply SQL2016 SP2 in this server. We cannot find SQL instance in below panel. Only ‘Shared Features’ are listed.   I decompiled …

Released: Public preview of Azure Arc enabled SQL Server

Publié le 25 septembre 2020 sur MS Tech Community
 

Azure Arc enabled SQL Server is now in public preview. It extends Azure services to SQL Server instances deployed outside of Azure in the customer’s datacenter, on the edge or in a multi-cloud environment.   The preview includes the followin …

Open sourcing the R and Python language extensions for SQL Server

Publié le 24 septembre 2020 sur SQL Server Blog
 

For the past decade, data science has become integral to many enterprise applications. Languages such as R and Python have left the realm of data scientists and are being used more frequently by data engineers supporting them. R and Python are the most …

Analyze data in Azure Data Explorer using Kusto Query Language (KQL) extension in Azure Data Studio

Publié le 24 septembre 2020 sur SQL Server Blog
 

The Kusto (KQL) extension in Azure Data Studio is now available in preview. This native Kusto (KQL) support brings another modern data experience to Azure Data Studio, a cross-platform client for Windows, macOS, and Linux. Users can now connect and bro …

TodoMVC Full Stack with Azure Static WebApps, Node and Azure SQL #beginners #node #sql #serverless

Publié le 24 septembre 2020 sur Azure SQL Database Blog
 

TodoMVC is a very well known (like ~27K GitHub stars known) application among developers as it is a really great way to start to learn a new Model-View-Something framework. It has plenty of samples done with different frameworks, all implementing …

How to Secure Azure SQL Database by Setting Minimal TLS Version | Data Exposed

Publié le 24 septembre 2020 sur Azure SQL Database Blog
 

In this episode with Rohit Nayak, we will cover the Minimal TLS Version setting for SQL Database. Customers can use these features to enforce a TSL version at the logical server level to meet their compliance needs.   Watch on Data Exposed Resourc …

Change Locale/language of SQL Server on Azure VM

Publié le 24 septembre 2020 sur SQL Server Support Blog
 

Currently Azure marketplace SQL Images are only available in English locale. If you want to change your SQL locale to any other than English, then you can deploy a virtual machine that contains SQL Server initially. We will wal …

Rehost your SQL Server to Azure Virtual Machines for manageability and cost optimization

Publié le 23 septembre 2020 sur MS Tech Community
 

Running SQL Server on Azure Virtual Machines provides a suite of free manageability capabilities that are available only on Azure, and which make it easier to run in a cost effective, secured and optimized manner. Microsoft introduced the Azure SQ …

What’s new in Azure SQL Managed Instance at Ignite 2020

Publié le 23 septembre 2020 sur Azure SQL Database Blog
 

Azure SQL Managed Instance is a fully managed, secure, and always up-to-date SQL instance in the cloud, providing an ideal destination for modernizing your SQL Server applications at scale. SQL Managed Instance is part of the Azure SQL family of databa …

Announcing major performance improvements for Azure SQL Database Managed Instances

Publié le 23 septembre 2020 sur Azure SQL Database Blog
 

Azure SQL Managed Instance is a fully-managed, secure, and always up-to-date SQL instance in the cloud. It provides state-of-the-art capabilities and industry-leading SLAs, allowing you to easily migrate and modernize your mission-critical applications …

パフォーマンスログ採取手順

Publié le 23 septembre 2020 sur SQL Server Support Blog
 

こんにちは。SQL Server サポート チームです。 今回は、SQL Server で問題が起きた際 …

Why my transaction promoted to DTC transaction?

Publié le 23 septembre 2020 sur SQL Server Support Blog
 

Recently we received such kind of issue that, when you simply just open a connection to SQL Server, you can see there was DTC transactions enlisted.   However, this only happened for the SQLOLEDB drivers, the SQL Native Client doesn’t have same be …

Hosting SSRS databases in Azure SQL Managed Instance

Publié le 22 septembre 2020 sur Azure SQL Database Blog
 

Hosting SSRS databases in Azure SQL Managed Instance   This article outlines the spectrum of options available for migrating your solutions based on the SQL Server Reporting Services (SSRS) to Microsoft cloud, with focus on the newly-introduced su …


Pages :