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 ...
-
0 Votes
Download DTU Max Metrics Last 30 days
Hi All, I want to do some analysis of DTU for the last 30 days. When i try to download per minute metrics it throws error "The chart ...Unanswered | 2 Replies | 72 Views | Created by GKS001 - Friday, February 22, 2019 5:38 PM | Last reply by GKS001 - 15 hours 54 minutes ago -
1 Votes
Getting Azure SQL Database Disabled frequently
Hi Team, Getting Azure SQL Database disabled issue frequently in the West Europe region. Also getting, "The resource operation completed with terminal ...Proposed | 4 Replies | 139 Views | Created by Sundar85 - Wednesday, February 20, 2019 10:26 AM | Last reply by Mike Ubezzi (Azure) - 20 hours 19 minutes ago -
0 Votes
Migrate TDE enabled database using HSM device to Managed instance
Hi Guys, We have a database which has TDE enabled and uses an external hsm device to encrypt the database key. We are looking at migrating this to azure without having to ...Proposed | 3 Replies | 147 Views | Created by DennisMorton22 - Tuesday, February 19, 2019 11:48 AM | Last reply by Mike Ubezzi (Azure) - 20 hours 24 minutes ago -
0 Votes
Please enter a valid agent key to proceed. The key must be generated from SQL Data Sync web portal.
Hi, I would like to ask your help in the following issue. I have installed the SQL Data Sync 2.0 agent on my on-prem SQL server and I try to make a connection to my Azure SQL database. I generate a ...Unanswered | 3 Replies | 170 Views | Created by matepol_oct - Thursday, February 14, 2019 10:13 AM | Last reply by Mike Ubezzi (Azure) - 20 hours 39 minutes ago -
2 Votes
Azure SQL Managed Instance Service Broker External Activator Support
Hi, I created a managed instance and enabled service broker , I would like to know the support for external activator and how to use it on Azure in Webjob or Azure ...Unanswered | 4 Replies | 263 Views | Created by Anass Kartit - Thursday, February 7, 2019 3:42 PM | Last reply by Mike Ubezzi (Azure) - 20 hours 52 minutes ago -
0 Votes
Azure Data Tracking
A bit of an unusual question, I think. We have a new Azure database that is fed data from an external source. We are looking for a way to alert on NON-changes to the tables that the ...Proposed | 4 Replies | 132 Views | Created by MarvelM - Tuesday, February 19, 2019 7:52 PM | Last reply by MartinJaffer-MSFT - 21 hours 8 minutes ago -
0 Votes
Need more clarity with SQL server Managed Instance - General Purpose storage...
Hi We are considering moving some of our workload to SQL server MI - GP. As per the documentation this instance leverages premium BLOB storage for MDFs and ...Proposed | 4 Replies | 212 Views | Created by nipunravi - Sunday, February 10, 2019 7:56 PM | Last reply by nipunravi - 23 hours 30 minutes ago -
0 Votes
Send email using Store Procedure in Azure SQL Database
Is it possible to write a store procedure in Azure SQL database to run a query, then send the result to emails in a particular time every day, or at a particulate ...Proposed | 2 Replies | 124 Views | Created by knguyenva - Tuesday, February 19, 2019 5:48 AM | Last reply by Kalyan Chanumolu-MSFT - Friday, February 22, 2019 3:52 AM -
0 Votes
Unable to connect to the destination mentioned in the KeyVault URL- Azure SQL
I am trying to use the Dynamics 365 Data export service to connect with my Azure SQL with Azure AD connection. When following this tutorial ...Unanswered | 4 Replies | 257 Views | Created by Deploy ARM templatefile with multiple par, files - Monday, February 4, 2019 9:18 AM | Last reply by Mike Ubezzi (Azure) - Thursday, February 21, 2019 7:46 PM -
1 Votes
Azure Monitor - "metric" source not available for SQL Database, SQL Servers, SQL Elastic Pools
I want to create an Alert Rule to monitor the storage-used percentage metric in Azure Monitor. However when selecting databases, servers or elastic pools, only "activity ...Proposed | 5 Replies | 105 Views | Created by Kieren_Johnstone - Wednesday, February 20, 2019 4:08 PM | Last reply by JRStern - Thursday, February 21, 2019 6:47 PM -
0 Votes
I deleted an Azure SQL Database but I still can access it via SSMS. I can't delete it nor create it again.
I deleted an Azure SQL Database in the Azure Portal. Now I am trying to create an empty database with the same name but it fails (conflict error). If I connect to ...Answered | 7 Replies | 189 Views | Created by AurelioGL - Tuesday, February 19, 2019 2:22 PM | Last reply by AurelioGL - Thursday, February 21, 2019 5:35 PM -
1 Votes
Hyperscale with 0 read replicas deletes all tables/views/users?
Testing out the new Hyperscale SQL database. In the azure portal you can change the Secondary read replicas (it's 1 by default) so I tried to set it to 0 because we are testing the ...Unanswered | 7 Replies | 159 Views | Created by XIU - Tuesday, February 19, 2019 4:03 PM | Last reply by Mike Ubezzi (Azure) - Thursday, February 21, 2019 5:26 PM -
0 Votes
Additional charge on monthly subscription in azure sql server
HI All, i am new in Azure SQL server. want to know, i have purchase basic tier monthly with price-~$4.8971/month i got 2GB of ...Proposed | 2 Replies | 211 Views | Created by manish0000 - Thursday, February 21, 2019 4:58 AM | Last reply by Alberto Morillo - Thursday, February 21, 2019 2:38 PM -
1 Votes
Importing a BACPAC gives an empty database
I exported a BACPAC database file from my SQL Server successfully, and uploaded it to Azure Storage, then created a new database in Azure SQL with 'Import database'. Everything ...Proposed | 4 Replies | 232 Views | Created by Bernil - Tuesday, February 12, 2019 3:08 PM | Last reply by Bernil - Thursday, February 21, 2019 9:02 AM -
0 Votes
Multiple Copies of SQL Database appearing in my DB list
About area is: Microsoft SQL Server Management Studio 13.0.15600.2) (SSMS), one of my databases is randomly duplicated with a GUID appended to the name. (eg. DBName is duplicated to ...Answered | 3 Replies | 91 Views | Created by CEOExpressJEB - Wednesday, February 20, 2019 3:56 PM | Last reply by Mike Ubezzi (Azure) - Wednesday, February 20, 2019 11:49 PM -
0 Votes
How to connect to Azure SQL DB using Active Directory Password Authentication through SSIS
Hi All, I am trying to connect to Azure SQL DB using Active Directory Password Authentication through SSIS using ADO.NET connection but getting failure error. I am looking to ...Answered | 1 Replies | 100 Views | Created by Abhiyanta - Wednesday, February 20, 2019 6:19 PM | Last reply by Mike Ubezzi (Azure) - Wednesday, February 20, 2019 11:18 PM -
0 Votes
Microsoft SQL Data Sync Agent 2.0 keeping old Configuration and not using new one
Hello, I'm configuring SQL Data Sync between Azure SQL Server instance and On Premise SQL Server instance. I have installed Microsoft SQL Data Sync 2.0 into On ...Proposed | 1 Replies | 180 Views | Created by Michael_laanti - Tuesday, February 19, 2019 1:32 PM | Last reply by Mike Ubezzi (Azure) - Wednesday, February 20, 2019 11:00 PM -
0 Votes
Azure DMS connectivity with IBM DB2(LUW) version - V9.7.0.11
Hi, I am working on a database migration solution where I have to migrate 222 GB of data , 851 tables from DB2(LUW) to Azure SQL.I want to check if Azure DMS ... -
0 Votes
sql server create is hanging in Cloud Shell
Hi, I'm new to Azure and I can't find an example this problem on either of the forums. I'm following this tutorial to deploy a web app and SQL ...Answered | 4 Replies | 107 Views | Created by Matthew Steer - Wednesday, February 20, 2019 9:48 AM | Last reply by Alberto Morillo - Wednesday, February 20, 2019 2:30 PM -
0 Votes
Bandwidth requirement for SQL availability group copy
Hi Guys, We are setting up SQL alwaysON availability group between on-premise sql and SQL db on Azure. Is there anyway I can estimate the bandwidth required for ...Unanswered | 2 Replies | 127 Views | Created by Mohammad Thahif - Tuesday, February 19, 2019 8:34 AM | Last reply by Mohammad Thahif - Wednesday, February 20, 2019 11:52 AM - Items 1 to 20 of 9660 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