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 VotesFailover Groups
If a SQL database has an automatic fail over group came into effect. Would the automatic fail over to logged into the activity log? I'm trying to create an alert ...Unanswered | 2 Replies | 96 Views | Created by Zoe.Mac - Friday, January 24, 2020 12:13 PM | Last reply by NavtejSaini-MSFT - 11 hours 48 minutes ago
-
0 Votes
How to create table for Complex JSON
Dear All. i have data as below :-how can we create table with columns :- Identifier and active that ...Unanswered | 2 Replies | 94 Views | Created by HadoopHelp - Friday, January 24, 2020 2:00 PM | Last reply by NavtejSaini-MSFT - 12 hours 21 minutes ago -
0 Votes
Change Tracking on Readable Secondary of Business Class Managed Instance?
Hopefully a quick question. I see that Change Tracking is supported on Managed Instances. I see also that Business Critical Tier gets you a readable secondary. With on-prem, to use the CT ...Unanswered | 2 Replies | 89 Views | Created by kstuber - Thursday, January 23, 2020 1:33 PM | Last reply by NavtejSaini-MSFT - 12 hours 23 minutes ago -
0 Votes
Error on connection to SQLServer on Azure Portal
Error - The Authorization header was not found. While trying to connect to SQLServer on Azure Portal from SQL Database Query ...Unanswered | 2 Replies | 93 Views | Created by KuljeetSachar - Friday, January 24, 2020 5:56 PM | Last reply by NavtejSaini-MSFT - 12 hours 33 minutes ago -
1 Votes
Do metrics 'Percentage CPU(Avg)' under Virtual Machine Host namespace & '\Processor Information(_Total)\% Processor Time' (CPU usage) under Guest classic namespace represents the same value ?
Summary : CPU Percentage metric (Virtual Machine Host vs Guest Classic) Karthik_Varma -
0 Votes
Used space same as allocated space
Hi. We have a SQL Azure Database, Standard S2: 50 DTUs. Max storage size is 250GB, currently using 6.61GB. I noticed that both the used space and the allocated ...Unanswered | 3 Replies | 140 Views | Created by Yolanda Cerón - Friday, January 24, 2020 8:56 PM | Last reply by Dan Guzman - Saturday, January 25, 2020 10:10 PM -
0 Votes
Cannot connect to MySQL Server, Firewall port 3306 opened, IP address added and get: ERROR 2005 (HY000): Unknown MySQL server host
Cannot connect to MySQL Server, Firewall port 3306 opened, IP address added and get: ERROR 2005 (HY000): Unknown MySQL server host I have no issues connecting with my MS SQL ...Answered | 3 Replies | 291 Views | Created by Jon2015 - Friday, January 24, 2020 8:45 PM | Last reply by Jon2015 - Saturday, January 25, 2020 4:35 PM -
0 Votes
Commercialization of an Analytical Solution
I'm looking for guidance on transferring a Resource Group to (our) Client Azure environments. The product, we provide,Mov being a Resource Group containing a number of resources (data ...Proposed | 3 Replies | 203 Views | Created by JaseJacksonUS - Wednesday, January 22, 2020 7:24 AM | Last reply by Kalyan Chanumolu-MSFT - Saturday, January 25, 2020 3:29 AM -
0 Votes
Unable to select target platform Microsoft Azure SQL Database V12 on VS2019 (SSDT)
I am trying to build a database using Visual Studio 2019 and SSDT and then publish to Azure SQL DB. When I build the database I am getting errors as I am using a temporal table, error message ...Answered | 9 Replies | 718 Views | Created by IamWestd - Tuesday, December 31, 2019 9:48 AM | Last reply by JP Hellemons - Saturday, January 25, 2020 3:08 AM -
0 Votes
Is Read Scale-Out part of Azure included with SQL DTU and does Azure Metrics for dtu_used include these read replicas?
Hi Team, Can you advise is the Read Scale-Out part of Azure included with SQL DTU and does Azure Metrics for dtu_used include these read ...Proposed | 2 Replies | 99 Views | Created by F C (MSFT CSG) - Wednesday, January 22, 2020 6:50 PM | Last reply by NavtejSaini-MSFT - Friday, January 24, 2020 4:20 PM -
0 Votes
Long term retention backups arm template
I've configured LTR backups but no changes are appearing in the arm template, are the LTR settings not support in the template export? What's the recommended way for deploying such a change as code?Proposed | 3 Replies | 85 Views | Created by cja1001 - Thursday, January 23, 2020 9:01 AM | Last reply by NavtejSaini-MSFT - Friday, January 24, 2020 4:19 PM -
0 Votes
Copying Databases
As an Azure Account administrator, I am able to make copies of my databases in the Portal. However, my team members, who have access to the server and databases on it, nevertheless ...Proposed | 3 Replies | 87 Views | Created by MaxDavies - Thursday, January 23, 2020 1:58 PM | Last reply by NavtejSaini-MSFT - Friday, January 24, 2020 4:18 PM -
0 Votes
Initial Migration .NET Core 2.2 when deploying from linux
I just deployed a .NET Core API the other day on Azure App Services from a Ubuntu 18.04, and I can't figure out how to run the initial database migration. I can ...Unanswered | 1 Replies | 80 Views | Created by Dtripodi93 - Thursday, January 23, 2020 8:36 PM | Last reply by Gonzalo Bissio - Friday, January 24, 2020 1:37 PM -
0 Votes
What is the file synchronization/replication mechanism used in Azure?
What is the file synchronization/replication mechanism used in Azure? Suppose one has 2 VMs in Azure and he needs to keep 2 folders on Windows Server 2008 R2 ...Unanswered | 5 Replies | 410 Views | Created by What is the file synchronization solution in Azure - Monday, March 27, 2017 9:37 AM | Last reply by NavtejSaini-MSFT - Thursday, January 23, 2020 10:11 PM -
0 Votes
AlwaysOn cluster in Azure
We're designing SQL 2017 AlwaysOn clusters - PROD and TEST environments. Purpose for TEST cluster is to test application upgrade functionality, test cluster failover behavior, and test ...Answered | 2 Replies | 108 Views | Created by District9 - Wednesday, January 22, 2020 6:29 AM | Last reply by NavtejSaini-MSFT - Thursday, January 23, 2020 4:34 PM -
0 Votes
DB Performance after Copy
We have a SQL database which is effectively a data capture system, main table has around 77k rows at present. The DB was created under my personal Azure Subscription and has become production, ...Proposed | 5 Replies | 174 Views | Created by JonnyC - Monday, January 20, 2020 10:48 AM | Last reply by Kalyan Chanumolu-MSFT - Thursday, January 23, 2020 4:47 AM -
0 Votes
Does Microsoft.EntityFrameworkCore.Cosmos nuget package supports Azure Cosmos DB Gremlin API
Hi, May I please know does Microsoft.EntityFrameworkCore.Cosmos nuget package supports Azure Cosmos DB Gremlin API ?Proposed | 2 Replies | 108 Views | Created by hrishi t t - Tuesday, January 21, 2020 6:37 AM | Last reply by Kalyan Chanumolu-MSFT - Thursday, January 23, 2020 4:47 AM -
0 Votes
Entity Framework Code First for Azure
Is it possible to use Entity Framework Code First for an Azure database in a WPF application? I have used Entity Framework Code First for my local SQL Server. I have ...Unanswered | 1 Replies | 91 Views | Created by Simple Samples - Wednesday, January 22, 2020 6:37 PM | Last reply by NavtejSaini-MSFT - Thursday, January 23, 2020 12:02 AM -
0 Votes
Removing a target database from a SqlShardMap in order to a scheduled job stop running in the removed target
I have an ElasticJobAgent pointing to an ElasticJobDatabase, the ElasticJobDatabase uses SqlShardMap to run jobs against all the databases that belong to that SqlShardMap, the problem is the ...Unanswered | 4 Replies | 240 Views | Created by ing.ortiz - Thursday, January 16, 2020 2:11 PM | Last reply by Mike Ubezzi (Azure) - Wednesday, January 22, 2020 9:52 PM -
0 Votes
SQL Health Check not pulling in any Data
Hi, We have an Alanlytics workspace setup which is working fine for normal data for VMs. When adding the SQL Health Check solution to the analytics, we are no getting any data ...Proposed | 2 Replies | 146 Views | Created by Matt Skews - Monday, January 20, 2020 3:00 PM | Last reply by NavtejSaini-MSFT - Wednesday, January 22, 2020 3:18 PM - Items 1 to 20 of 10556 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
