Sites Microsoft


How to provision a Linux SQL Server Virtual Machine in Azure

Publié le 19 mars 2020 sur SQL Server Blog
 

You’re an existing SQL Server customer and are looking to explore the fast-growing Linux operating system. Whether on-premises or in the cloud, Microsoft has you covered. With SQL Server 2017, and now SQL Server 2019, SQL Server is available on R …

Tips to select the best Azure SQL deployment option

Publié le 17 mars 2020 sur SQL Server Blog
 

When it comes time to migrate your SQL workloads to Azure, you have a choice of two main deployment options: SQL Server on Azure Virtual Machines and Microsoft Azure SQL Database. Each offers its own benefits, so how do you know which is right for your …

SQL Server 2019 now available on Ubuntu 18.04, supported on SLES 12 SP5

Publié le 17 mars 2020 sur MS Tech Community
 

SQL Server on Ubuntu 18.04 We are happy to announce the availability of SQL Server 2019 package native to Ubuntu 18.04 ecosystem, fully supported for production use, starting with CU3. You can read about SQL Server 2019 CU3 release at following page. h …

SQL Server Alwayson primary replica failed to create diagnostics log.

Publié le 15 mars 2020 sur SQL Server Support Blog
 

SQL Server Alwayson diagnostics log is a useful tool to troubleshoot SQL Server Alwayson related issue. It saves the result of stored procedure system stored procedure sp_server_diagnostics (Transact-SQL)  to SQLDIAG file, the namin …

Azure SQL Database Connectivity and Network Security improvements

Publié le 13 mars 2020 sur Azure SQL Database Blog
 

Azure SQL Database Connectivity and Network Security improvements Reviewers:- Andreas Wolter, Rajesh Setlem We are proud to announce several improvements to Azure SQL Database and Azure Synapse Analytics (formerly Azure SQL DW) in the areas of Connecti …

When to use SQL Server on Azure Virtual Machines

Publié le 12 mars 2020 sur SQL Server Blog
 

Rearchitecting applications to run in the cloud can be a significant undertaking requiring time, money, and the appropriate skills. If you want to move existing on-premises apps to the cloud, but don’t have the necessary resources to rearchitect your a …

Cumulative Update #3 for SQL Server 2019 RTM

Publié le 12 mars 2020 sur MS Tech Community
 

The 3rd cumulative update release for SQL Server 2019 RTM is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.  CU3 KB Article: https://support.microsoft …

Update: ODBC Driver 17.5.2 for SQL Server Released

Publié le 9 mars 2020 sur MS Tech Community
 

Version 17.5.2 of the Microsoft ODBC Driver 17 for SQL Server has been released. Version 17.5.2 brings a couple minor updates and one fix to the driver. FeaturesSupport authentication with Managed Identity for Azure Key VaultSupport for addit …

Sync Mobile Apps with Azure using Change Tracking API

Publié le 6 mars 2020 sur Azure SQL Database Blog
 

If you are creating a mobile app that will work sending data back and forth from the cloud (I guess that 99% of the apps fall into this use case), you will have at some point the need to sync data between the app and the cloud itself.   If you are …

SQL Server Licensing: High Availability and Disaster Recovery benefits

Publié le 5 mars 2020 sur MS Tech Community
 

One of the most popular software assurance benefits for SQL Server customers is the ability to deploy SQL Server High Availability and Disaster Recovery architectures with the best TCO. Starting November 1st, 2019, every Software Assurance customer of …

Troubleshooting Common issues with Elastic Jobs in Azure SQL Database

Publié le 5 mars 2020 sur Azure SQL Database Blog
 

Elastic Jobs are currently in public preview.  The feature is ready and we are preparing to make it officially generally available.  No extra steps are required to get started.   Determining the Cause of Failure Assume for the purposes o …

Management operations and data access for Azure SQL Database with Golang

Publié le 4 mars 2020 sur Azure SQL Database Blog
 

  Goal for this post is to introduce how to start interacting with Azure SQL through Go (https://golang.org/), an open source programming language gaining lots of traction in developers’ community thanks to its simplicity and efficiency in s …

Running, Scheduling and Monitoring Elastic Jobs in Azure SQL Database

Publié le 3 mars 2020 sur Azure SQL Database Blog
 

Elastic Jobs are currently in public preview.  The feature is ready and we are preparing to make it officially generally available.  No extra steps are required to get started.   In previous posts, I have demonstrated how to create an El …

Hotfix: JDBC Driver 8.2.1 for SQL Server Released

Publié le 27 février 2020 sur MS Tech Community
 

An issue was reported in the recent 8.2.0 release which required a fix. So we’ve released 8.2.1 to correct the issue. We also took the opportunity to add new default trusted endpoints for Azure Key Vault when using Always Encrypted. AddedAdded new …

Creating an Elastic Jobs Agent, Credentials, and Jobs for Azure SQL Database using T-SQL

Publié le 27 février 2020 sur Azure SQL Database Blog
 

Elastic Jobs are currently in public preview.  The feature is ready and we are preparing to make it officially generally available.  No extra steps are required to get started.   In part 4 of my blog series on Elastic Jobs for Azure SQL …


Pages :