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
-
2 VotesMigration from Azure SQL to Azure SQL performance issue
Hi. I´m in process of migrating a Azure SQL Database from one subscription to another. Since they are not in the same tenant this requires a ...Unanswered | 5 Replies | 114 Views | Created by Tommy...h - Friday, September 29, 2017 8:48 AM | Last reply by JRStern - 2 hours 6 minutes ago -
0 VotesPAGEIOLATCH_SH and PAGEIOLATCH_EX in Azure DB
Hi, I scaled (with difficulty, ...Answered | 5 Replies | 61 Views | Created by Asmine - 10 hours 17 minutes ago | Last reply by JRStern - 2 hours 11 minutes ago -
0 VotesSQL Azure Data Sync Error No DataSync - Azure SQL DB provisioning failed
I have set up a new sync on a PC Tables are OK, but no data is synced Does anyone have an ...Unanswered | 2 Replies | 126 Views | Created by Armin Ebner - Wednesday, September 27, 2017 3:24 PM | Last reply by Armin Ebner - 4 hours 23 minutes ago -
1 VotesDB scaling take excessive time to complete
Hi, I have a 10Gb database, 5.77GB used. I started a scale up from S0 to S1 around 2pm today and it is still going now, 1h15min later. Is this ...Answered | 4 Replies | 110 Views | Created by Asmine - Tuesday, October 03, 2017 4:16 AM | Last reply by Asmine - 9 hours 30 minutes ago -
0 VotesCannot Verify Connection String when adding new Database
I am following an online guide about setting up a mobile backend on Azure. I would post the link but it wont let me. I am at the part where I will be adding a SQL Database. I have ...Unanswered | 4 Replies | 130 Views | Created by jlovatt121 - 18 hours 28 minutes ago | Last reply by Alberto Morillo - 10 hours 7 minutes ago -
2 VotesPrimary key check when the field is updated
How do I do to get the primary key check for doublettes when the field (or control ) is updated? I have very long forms and the primary key is the first in order, and a check for doublettes is ...Proposed | 4 Replies | 53 Views | Created by MR_ANDERSSON - 21 hours 42 minutes ago | Last reply by Alberto Morillo - 10 hours 43 minutes ago -
0 VotesConnecting Azure SQL Database from Azure Data Factory
<g class="gr_ gr_55 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" data-gr-id="55" id="55">Hello</g> ...Unanswered | 1 Replies | 38 Views | Created by Karthi Kuppuraj - 20 hours 45 minutes ago | Last reply by Estienne Granet - 14 hours 13 minutes ago -
0 VotesAzure Fail over Group connection Issue for secondary server database
Hi, I am successfully created failover group for a production sql server , but i am facing issue to connect to the secondary server database through SQL Server Management studio.I ...Unanswered | 1 Replies | 35 Views | Created by Praveenm05 - 18 hours 9 minutes ago | Last reply by Estienne Granet - 14 hours 35 minutes ago -
0 VotesAbout Migration to Cloud
Team I have a Asp.net web application that uses SQL server 2012 for dBASE since this is critical application a we are getting high amount of request to ...Unanswered | 1 Replies | 36 Views | Created by shreebharaath - 17 hours 32 minutes ago | Last reply by Estienne Granet - 14 hours 39 minutes ago -
1 VotesCreate Data Sync Group - "Sync Metadata Database" Option Grayed Out
I was trying out the "Sync to other databases" option on the new Azure portal however, when I'm creating the Sync Group, the "Sync Metadata Database" option is ...Answered | 3 Replies | 209 Views | Created by Rick Su - Friday, August 11, 2017 1:02 AM | Last reply by Kruti D Mehta - 17 hours 51 minutes ago -
2 VotesBulk Insert from storage account 'files' not 'blobs'
Hello I've successfully imported files using bulk insert where the file is in a 'blob' in a storage account. My question is can we bulk insert from 'files' in a storage account and ...Proposed | 4 Replies | 49 Views | Created by Brian Searle - 22 hours 12 minutes ago | Last reply by Brian Searle - 18 hours 24 minutes ago -
0 VotesMigrating SQL database to Azure using SSMS fails with "login failed"
In SSMS, I'm trying to use the "Deploy Database to SQL Azure Database" utility. I'm moving a small local database in SQL 12 to Azure for hosting. But after entering the ...Unanswered | 13 Replies | 1140 Views | Created by Karl K - Tuesday, September 06, 2016 5:02 AM | Last reply by GearWorld - 20 hours 20 minutes ago -
1 VotesUsing Microsoft Azure - MySQL In App to create database, php code cannot see it?
Hi there, I'm relatively new to PHP but have set up an Azure web app with a MySQL In App database. There is no db icon in the resources panel, although I assume that the in app function does not ...Proposed | 3 Replies | 74 Views | Created by Alex BPC - Tuesday, October 03, 2017 1:58 PM | Last reply by Alex BPC - Wednesday, October 04, 2017 8:04 AM -
0 VotesBest way to control DTUs while inserting records in Azure SQL Table
I have an Azure service that can be modeled as follow: N instances of a cloud service insert the IP of each visit coming on the HTTP interface in a queue (Azure Storage). A worker role, processes the ...Unanswered | 10 Replies | 123 Views | Created by dsmwb - Tuesday, October 03, 2017 4:36 PM | Last reply by JRStern - Wednesday, October 04, 2017 6:58 AM -
0 VotesAZURE STACK ISSUE - CONFIGURING SQL AS A SERVICE FAILED: Use SQL databases on Microsoft Azure Stack
Hi Team, When trying to add a Hosting Servers to Resource Providers after filling the server name, login, password etc. we're getting this ...Unanswered | 2 Replies | 76 Views | Created by Mayank Dhama - Tuesday, October 03, 2017 12:09 PM | Last reply by Mayank Dhama - Wednesday, October 04, 2017 4:50 AM -
0 VotesAzure Data Sync messed up in Azure SQL DB
I was trying to set up Azure Data Sync to sync a DB _from_ Azure SQL to a local db. I had gone through a couple of false starts and had finally gotten to the point where I was asked what tables ...Unanswered | 11 Replies | 353 Views | Created by Peter A. Schott - Tuesday, August 01, 2017 4:26 PM | Last reply by Alberto Morillo - Wednesday, October 04, 2017 4:39 AM -
0 VotesAzure Data Sync messed up in Azure SQL Data Base
I was trying to set up Azure Data Sync to sync a Database from azure and a local Database, I have created a sync agent, and a sync group, but something happened and now i can't see or edit that data, ...Unanswered | 2 Replies | 83 Views | Created by Enrique Rubio - Tuesday, October 03, 2017 6:50 PM | Last reply by Alberto Morillo - Wednesday, October 04, 2017 4:36 AM -
0 VotesFatal error: Call to undefined function mysqli_connect()
I am running a Linux Web App + mysql. I have a php app. My app works great on localhost. I use a MacBook Pro. I was given this link by the CSR on twitter. ...Unanswered | 3 Replies | 105 Views | Created by stevenmaberry - Tuesday, October 03, 2017 2:50 AM | Last reply by Alberto Morillo - Wednesday, October 04, 2017 4:19 AM -
1 VotesAzure SQL Server OData Service
Hey guys, Some searching on SQL Azure OData provided me with some information that there was an OData overlay to SQL Azure at one point, that allowed a no code OData feed of a ...Proposed | 1 Replies | 76 Views | Created by andrewtobin - Tuesday, October 03, 2017 9:30 PM | Last reply by Alberto Morillo - Wednesday, October 04, 2017 3:34 AM -
1 VotesOnly a handful of my databases show up when I click SQL DATABASES in Azure Portal
If I click SQL DATABASES I see a list of 5 databases. I have 10. If I click on SQL Servers and choose the proper database server I see all ...Answered | 2 Replies | 75 Views | Created by Jerrak - Tuesday, October 03, 2017 1:49 PM | Last reply by Kapil.Kumawat - Tuesday, October 03, 2017 8:19 PM - Items 1 to 20 of 8288 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
