Azure SQL Database announcement
-
Link
While it has been 3+ years since we last announced an update to SQL Data Sync service, we have been continuously deploying updates to the backend service to address top customer issues. We are listening to your feedback, and today we are happy to announce the latest update which includes both service changes and a new SQL Data Sync agent install. This update includes two main enhancements:
- Support for synchronizing tables that have column collations:
- If the selected sync schema tables do not already exist in your hub or member databases, upon deploying the sync group, SQL Data Sync will automatically create corresponding tables and columns in the empty database with the same collation settings as the select sync schema.
- If the tables to-be-synced are already created in both hub and member databases, SQL Data Sync requires the primary key columns have the same collation between hub/member databases to successfully deploy the sync group. There is no collation restriction on the non-primary key columns.
- Improvements to performance and resilience:
- We enhanced batch transfer of serialized changes from source to destination, so you should see faster sync throughput.
- We improved transient error handling logic when reading from the source or writing to the destination.
The new version of SQL Data Sync agent in the download center. Please follow the step-by-step instructions here to install a new Data Sync agent. If you have an existing agent, you can refer to this MSDN article for detailed upgrade procedures. A previous version of Data Sync agent will continue to work until it expires on 8/18/2015.
-
Link
Microsoft Azure provides you two options when hosting your SQL Server-based data: Azure SQL Database and SQL Server in Azure Virtual Machine. This new article explains how each option fits into the big picture in Microsoft’s Data Platform, and then discusses the common business motivations that might affect your choice. Please take a look at it!
Selcin Turkarslan
Found 10899 threads
-
0 VotesDTU went down for a while - caused sql server unaccessible
Hello, yesterey our production cloud had errors with accesing azure sql server (a few during one minute): Type ...Proposed | 3 Replies | 2472 Views | Created by Jindrich Pastorek - Tuesday, May 26, 2020 2:09 PM | Last reply by Qinghui Meng - Tuesday, August 2, 2022 12:42 AM
-
0 Votes
Azure SQL Sync - Cross Tenant
I want to setup a sync scenario where a customer has a copy of my azure database, synced weekly to their azure sql. I cannot find any documentation or scenarios to explain how this ...Proposed | 2 Replies | 3236 Views | Created by IvanNel1980 - Friday, June 5, 2020 9:00 AM | Last reply by Kalyan Chanumolu-MSFT - Monday, June 8, 2020 5:50 AM -
0 Votes
Automate data extract from sql database
Hi All, In azure PaaS, I will like to know the most secure way to run a SQL query and extract the ...Proposed | 3 Replies | 3936 Views | Created by MrFlinstone - Monday, June 1, 2020 10:51 PM | Last reply by Uri Dimant - Monday, June 8, 2020 4:00 AM -
2 Votes
Error - The X-CSRF-Signature header could not be validated
Hi Guys, I am a beginner to Azure and trying to connect to the SQL Server DB using SQL Server authentication which is throwing the below error. The ...Proposed | 18 Replies | 9550 Views | Created by Sarat2701 - Friday, August 2, 2019 4:11 AM | Last reply by mihai.sarlea - Wednesday, June 3, 2020 7:34 PM -
0 Votes
Server in DB Issue
Hello Team, I have two servers(S1 and S2) AND 5 Databases(D1,D2,D3,D4,D5) and in server S1 have 3 database(D1,D2,D3) and in server S2 have 2 ...Proposed | 8 Replies | 3020 Views | Created by Rohitk77 - Friday, May 29, 2020 6:50 AM | Last reply by NavtejSaini-MSFT - Wednesday, June 3, 2020 12:56 PM -
0 Votes
Trying to delete a SQL Server and getting an error code 409 in the response
Hi all, I am trying to delete a SQL Server that I created for testing purposes, but when I try to delete the Server (from both UI and CLI) I ended up getting a message indicating ...Unanswered | 3 Replies | 3576 Views | Created by acezar - Thursday, May 28, 2020 1:40 PM | Last reply by Kalyan Chanumolu-MSFT - Wednesday, June 3, 2020 6:05 AM -
0 Votes
Virtual machine scale sets for web servers - back end SQL server AG/Azure SQL Database
Hello All, Hope safe and well We are planning to use VM scale set for web servers as front end and back end covered by SQL ...Proposed | 1 Replies | 3136 Views | Created by AzureJourney - Thursday, May 28, 2020 8:21 AM | Last reply by pituach - Wednesday, June 3, 2020 2:22 AM -
0 Votes
Migration from SQL Server to Azure SQL Database or Azure Managed instance
Please let me know which one as PAAS(Azure SQL database or Azure SQL database managed instance) supports the below features. When we create Azure SQL database or Azure SQL database ...Proposed | 3 Replies | 3846 Views | Created by Dan.Thiru - Friday, May 29, 2020 5:28 AM | Last reply by NavtejSaini-MSFT - Wednesday, June 3, 2020 1:31 AM -
0 Votes
SQL Managed Instance deployment taking too long
I have deployed Azure SQL Managed Instance, and on document it is written it will taking around 24 hours for it to get deployed. But in my case, it is well over 48 hours but still the status is ...Proposed | 7 Replies | 4566 Views | Created by KundanMore - Thursday, July 12, 2018 9:38 AM | Last reply by Gayan Dasanayake - Tuesday, June 2, 2020 1:10 PM -
0 Votes
oData service for Azure SQL Database
Hi, Apologies if this question has previously been asked and replied to, I've searched but couldn't find any information relating to it. So here goes my ...Unanswered | 4 Replies | 3190 Views | Created by RaceBennon - Thursday, May 28, 2020 3:26 PM | Last reply by Mike Ubezzi (Azure) - Monday, June 1, 2020 7:53 PM -
0 Votes
Azure SQL blocking SPO requests.
Hi, my SQL DW is firewall is blocking SPO. I can see under SQL Metrics the blocked firewall requests I've added the IP ranges from ...Unanswered | 2 Replies | 2906 Views | Created by Will Holani - Thursday, May 28, 2020 12:14 AM | Last reply by Mike Ubezzi (Azure) - Monday, June 1, 2020 7:45 PM -
0 Votes
Connection to Azure SQL Database via VPN Gateway and Private Endpoint
We are trying to access our azure sql database via VPN. Therefore we set up a private network, a vpn gateway an a private endpoint for our sql database ...Proposed | 2 Replies | 8107 Views | Created by hoebd - Wednesday, May 27, 2020 8:37 PM | Last reply by Mike Ubezzi (Azure) - Monday, June 1, 2020 7:43 PM -
0 Votes
Proper Procedure to restore a SQL VM
I have a SQL VM. I found that there is 2 entries related to this SQL VM. One is type = Virtual Machine and the other entry type is SQL Virtual Machine. Then, I have dump and ...Proposed | 4 Replies | 2986 Views | Created by Ocean - Wednesday, May 27, 2020 9:59 AM | Last reply by Mike Ubezzi (Azure) - Monday, June 1, 2020 7:40 PM -
0 Votes
Cannot connect to Azure SQL DB from on-premise ADFS joined device
Hi, We have joined our Azure AD to our on premise Active Directory with ADFS. We would like to access a Azure SQL Db from an on premise device using Azure Integrated ...Proposed | 2 Replies | 3582 Views | Created by Kellyr247 - Thursday, May 21, 2020 11:22 PM | Last reply by Mike Ubezzi (Azure) - Monday, June 1, 2020 6:53 PM -
0 Votes
Push updates to SAP Tables from Azure SQL
Hello Team, I'm trying to prepare design for pushing updates to SAP Tables from Azure SQL on schedule basis. I need your help to see what are the option I can go with in terms of ...Unanswered | 2 Replies | 3208 Views | Created by abc67 - Thursday, May 28, 2020 5:49 PM | Last reply by abc67 - Monday, June 1, 2020 6:48 PM -
0 Votes
If there are some features to track user's login and logoff activities for Azure Sql Database?
I saw that there is a audit feature for azure sql database. I've checked this feature and found that the audit log have users login, login fail and any query operations records. But i didn't find any ...Answered | 9 Replies | 3525 Views | Created by Leon Toredo - Friday, May 22, 2020 9:55 AM | Last reply by Leon Toredo - Monday, June 1, 2020 9:26 AM -
3 Votes
Azure Database Migration
Hi, We are planning to migrated database from on premises to Azure. our current DB is on SQL Server 2016.Can you please share what are the options available to migrate to ...Answered | 6 Replies | 3153 Views | Created by Ashu-clouddev - Saturday, May 30, 2020 4:00 PM | Last reply by Malleswara Reddy [MCTS, MCP] - Sunday, May 31, 2020 4:21 AM -
0 Votes
Connection error between Data Sync agent and metadata database through VPN Gateway and a private endpoint
I have a hybrid architecture between Azure and on-premises servers that are connected to each other through a VPN Gateway. I want to deploy the SQL Data Sync service, for this I ...Proposed | 4 Replies | 3618 Views | Created by maria martomar - Wednesday, May 13, 2020 8:42 AM | Last reply by Mike Ubezzi (Azure) - Friday, May 29, 2020 5:19 PM -
0 Votes
Job Database can be same as Target Database
Hello, I have a small purge job to be triggered on schedule on one of the table in Azure SQL Database. My database is an unmanaged instanced so we have created Elastic Job Agent ...Proposed | 3 Replies | 3560 Views | Created by andypalrecha - Friday, May 15, 2020 5:34 AM | Last reply by Mike Ubezzi (Azure) - Friday, May 29, 2020 5:10 PM -
0 Votes
SQL multiple instances on Azure
Hello! Is it possible to have multiple instances of SQL server installed in Azure - IaaS model? Is there any limitations on it? Please suggest. Thanks!Proposed | 2 Replies | 3752 Views | Created by Chakra1983 - Thursday, May 28, 2020 4:26 AM | Last reply by Vaibhav.Chaudhari - Friday, May 29, 2020 1:22 PM - Items 1 to 20 of 10899 Next ›
Azure SQL Database announcement
-
Link
While it has been 3+ years since we last announced an update to SQL Data Sync service, we have been continuously deploying updates to the backend service to address top customer issues. We are listening to your feedback, and today we are happy to announce the latest update which includes both service changes and a new SQL Data Sync agent install. This update includes two main enhancements:
- Support for synchronizing tables that have column collations:
- If the selected sync schema tables do not already exist in your hub or member databases, upon deploying the sync group, SQL Data Sync will automatically create corresponding tables and columns in the empty database with the same collation settings as the select sync schema.
- If the tables to-be-synced are already created in both hub and member databases, SQL Data Sync requires the primary key columns have the same collation between hub/member databases to successfully deploy the sync group. There is no collation restriction on the non-primary key columns.
- Improvements to performance and resilience:
- We enhanced batch transfer of serialized changes from source to destination, so you should see faster sync throughput.
- We improved transient error handling logic when reading from the source or writing to the destination.
The new version of SQL Data Sync agent in the download center. Please follow the step-by-step instructions here to install a new Data Sync agent. If you have an existing agent, you can refer to this MSDN article for detailed upgrade procedures. A previous version of Data Sync agent will continue to work until it expires on 8/18/2015.
-
Link
Microsoft Azure provides you two options when hosting your SQL Server-based data: Azure SQL Database and SQL Server in Azure Virtual Machine. This new article explains how each option fits into the big picture in Microsoft’s Data Platform, and then discusses the common business motivations that might affect your choice. Please take a look at it!
Selcin Turkarslan
