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
-
0 Votes
Announcements & News
Good day all, It is highly recommended to follow the relevant Announcements & News. You are welcome to follow the following blogs: Azure SQL ...
-
1 Votes
Azure SQL DB Firewall rules using P2S VPN
Hi, i have a Azure SQL DB...and i wanted to use the firewall rules by giving P2S VPN which is created from VNET. Everytime my IP used to change dynamically. So i ...Unanswered | 3 Replies | 227 Views | Created by Vignesh Arvind - Wednesday, December 4, 2019 9:45 AM | Last reply by Hari VS_Kid - 28 minutes ago -
0 Votes
Azure Data Sync Error - The INSERT statement conflicted with the FOREIGN KEY constraint
I'm using Azure Data Sync to synchronise two databases which also contain ASP.NET Identity Tables. Everything was working fine until a few days ago when I inserted around ...Unanswered | 8 Replies | 1875 Views | Created by Alon_ko - Thursday, January 26, 2017 6:16 PM | Last reply by Com_Soft - 55 minutes ago -
0 Votes
getting error at initial stage while adding azure database in azure service
Dear All. I having issue while adding the services AZURE DATABASE in my Azure resources . Error: Something went wrong while creating ...Answered | 3 Replies | 696 Views | Created by HadoopHelp - Friday, October 18, 2019 10:52 AM | Last reply by HadoopHelp - 5 hours 0 minutes ago -
0 Votes
RBAC Role that will allow for Logical Server management but not allow for the changing of the serveradmin password
RBAC Role that will allow for Logical Server management but not allow for the changing of the serveradmin password 'If this was helpful, please mark and an answer or as being ...Proposed | 3 Replies | 378 Views | Created by Etienne Oosthuysen - Thursday, November 28, 2019 11:07 AM | Last reply by Kalyan Chanumolu-MSFT - 8 hours 38 minutes ago -
0 Votes
Identity seed is incorrect after restore of Azure SQL Database from bacpac
We have bacpac files for database backup retention for more than 35 days as part of our DRP, and for restoring into test environments. What we have found is that after restoring a ...Unanswered | 1 Replies | 79 Views | Created by Gerri M - 15 hours 12 minutes ago | Last reply by Uri Dimant - 10 hours 46 minutes ago -
0 Votes
SQL custom query 'watchdog' with email alerts
Good day, was directed here by the Twitter support team. I'm looking to see if there is any functionality under the Azure portal to setup custom Microsoft SQL db queries that will ...Proposed | 2 Replies | 1107 Views | Created by Jeffrey Paranich - Friday, November 29, 2019 9:13 PM | Last reply by Kalyan Chanumolu-MSFT - Wednesday, December 4, 2019 2:45 PM -
6 Votes
Project Design Concept
I have a project in mind which I am looking for some advice on what ...Discussion | 9 Replies | 512 Views | Created by epod184 - Wednesday, June 28, 2017 3:53 PM | Last reply by YigitK - Wednesday, December 4, 2019 1:33 PM -
1 Votes
Azure SQL stored procedure ridiculously slow called from C#
Summary: We have two identical databases, one on a local server, one on Azure. We have a C# system that accesses these databases, calling stored ...Unanswered | 3 Replies | 668 Views | Created by IWantedToBeALumberjack - Friday, November 29, 2019 5:33 PM | Last reply by Uri Dimant - Wednesday, December 4, 2019 4:53 AM -
0 Votes
Slow synchronisation of member database
I am managing the following setup: I have a SQL Server database that runs on a local server and manages our business critical data (1). I have a SQL Server sync ...Proposed | 7 Replies | 870 Views | Created by bh4017 - Thursday, October 24, 2019 10:36 AM | Last reply by Mike Ubezzi (Azure) - Wednesday, December 4, 2019 12:38 AM -
0 Votes
Google Sheets to Azure database connection error (Jdbc)
Hi, I am using the following code in google sheets to connect to an azure database, but the connection errors and doesn't establish. function onOpen() { ...Answered | 2 Replies | 294 Views | Created by SQL Server 2012 Exploring Transact SQL Expired - Monday, December 2, 2019 11:49 PM | Last reply by SQL Server 2012 Exploring Transact SQL Expired - Tuesday, December 3, 2019 9:49 PM -
0 Votes
SQL Azure (SSAS) with multidimensional model support? (not tabular)
Just wanted to know is SQL Azure (SSAS) will ever support multi-dimensional models in the near future or will they keep it tabular models? Asking because I need to make a ...Unanswered | 3 Replies | 385 Views | Created by Marineheiro - Thursday, November 28, 2019 12:41 PM | Last reply by Mike Ubezzi (Azure) - Tuesday, December 3, 2019 8:09 PM -
0 Votes
How to move Azure MY-SQL server to another subscription?
Hi I have 2 subscriptions and I want to move Azure MY-SQL server to the second subscription? How can I do it?, as I don't see the option to move it on from ...Unanswered | 6 Replies | 1488 Views | Created by moon78 - Wednesday, July 5, 2017 6:29 AM | Last reply by Charles Christian - Tuesday, December 3, 2019 5:43 PM -
0 Votes
How can I see the actual problem/error from a logged exception?
On my Azure SQL "Server" I have a few SQL Databases, on the "Server" I have enabled Server-level auditing. On the SQL Database I click "Auditing" then "View ...Unanswered | 2 Replies | 332 Views | Created by Bill Blakey FA - Tuesday, December 3, 2019 12:43 AM | Last reply by Bill Blakey FA - Tuesday, December 3, 2019 5:39 PM -
0 Votes
Connection between azure sql database and unity
I'm developing a unity project and need to read data from my azure sql databsase, any help how can i do this?Proposed | 1 Replies | 185 Views | Created by nournabhan - Tuesday, December 3, 2019 8:45 AM | Last reply by Vaibhav-Chaudhari - Tuesday, December 3, 2019 8:53 AM -
0 Votes
Azure SQL Database connection with Azure AD (Best Security Approach)
Hi, In Azure SQL Database (Single Instance) what is the best approach for connecting to a Database ? I want to maintain a connection string with Azure SQL DB ...Proposed | 4 Replies | 620 Views | Created by Rahul Benjamin - Wednesday, November 20, 2019 8:26 PM | Last reply by Mike Ubezzi (Azure) - Monday, December 2, 2019 7:50 PM -
1 Votes
Cannot access azure sql table from android by following quickstart guide
https://fabnewsapp.azurewebsites.net/tables/TodoItems?$filter=(complete%20eq%20false) this query returns "The resource you are looking for has been removed, had its name changed, ...Proposed | 7 Replies | 692 Views | Created by abhigpcdnmi07 - Thursday, November 21, 2019 7:50 PM | Last reply by Mike Ubezzi (Azure) - Monday, December 2, 2019 7:14 PM -
0 Votes
how to read and write to Azure SQL from MS Flow SharePoint Online
Hi All, I need to read and write in a azure sql table from SharePoint Online list. How to achieve this?Unanswered | 4 Replies | 584 Views | Created by SamDany - Tuesday, November 19, 2019 8:23 PM | Last reply by SamDany - Monday, December 2, 2019 7:09 PM -
0 Votes
Hide connection strings
I would like to encrypt my connection strings in the web.config file. With azure is this the best way to do this. I am trying to add them in my app service as shown below but I am ...Answered | 5 Replies | 520 Views | Created by Paul_Di - Saturday, November 16, 2019 1:15 AM | Last reply by Mike Ubezzi (Azure) - Monday, December 2, 2019 6:46 PM -
0 Votes
Restore database service-managed error
I have a database backup from sql server 2012 in Azure storage. If I restore backup to sql server installed on a Azure virtual machine it works OK but I restore backup to Azure database ...Proposed | 4 Replies | 712 Views | Created by C.Domínguez - Friday, November 15, 2019 6:59 AM | Last reply by NavtejSaini-MSFT - Monday, December 2, 2019 4:29 PM -
0 Votes
Configuration BASIC to SERVERLESS
I am trying to reconfigure my basic database to a configuration using Serverless. I am getting the following error each time: Failed to ...Answered | 4 Replies | 686 Views | Created by ipulsetv - Thursday, November 28, 2019 8:24 PM | Last reply by ipulsetv - Monday, December 2, 2019 3:31 PM - Items 1 to 20 of 10463 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