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
How to limit DTU per job/task for SQL on Azure
Hello I am wondering if there is a way to set a limit on a per job or task basis that a job or task on a SQL DB that is hosted on Azure. So, something ...Proposed | 1 Replies | 91 Views | Created by Jason Johnson1834 - 8 hours 50 minutes ago | Last reply by Mike Ubezzi (Azure) - 9 minutes ago -
0 Votes
Hyperscale sql server hooks on insert
Hi, I want to know if there is a way to define hooks on my hyperscale ms sql DB. I want to manipulate all my insert events. Whats ...Unanswered | 4 Replies | 223 Views | Created by Elad IS - Wednesday, December 11, 2019 8:36 AM | Last reply by Mike Ubezzi (Azure) - 4 hours 50 minutes ago -
0 Votes
SSMS crashes when 'Object Explorer Details' is opened
When using SQL Server Management Studio 18.4 to access an Azure SQL server, I am able to login successfully and can expand the Databases list in Object Explorer. However, when I attempt to open Object ...Unanswered | 4 Replies | 173 Views | Created by stevetroughton - Thursday, December 12, 2019 10:11 AM | Last reply by Mike Ubezzi (Azure) - 5 hours 3 minutes ago -
0 Votes
Reading Extended Events Files from Blob Storage in Azure SQLDB and parsing to JSON with Spark/hadoop
Hi, We need to process the Event logs stored in blobs using Spark for the audit purpose. Is there any documentation about how to read the XEL file programatically ? or is there any ...Answered | 2 Replies | 161 Views | Created by shettyh - Thursday, December 12, 2019 10:16 AM | Last reply by Mike Ubezzi (Azure) - 5 hours 24 minutes ago -
0 Votes
Many unavailability issue over the past few days
Hello, We have many unavailability issue with our azure database located in france central over the past 3 ...Proposed | 3 Replies | 198 Views | Created by yousfi.youssef - Thursday, December 12, 2019 10:47 AM | Last reply by Mike Ubezzi (Azure) - 5 hours 33 minutes ago -
0 Votes
How can you alias connecting to a Managed Instance?
instead of name.xxxxxxxxxxxxxxxx.database.windows.net Is there some way to add a dns entry where it will respond to name.domain.com ...Proposed | 5 Replies | 237 Views | Created by Goofoff - Wednesday, December 11, 2019 5:29 PM | Last reply by Mike Ubezzi (Azure) - 8 hours 20 minutes ago -
0 Votes
Cant find sql version to match azure manged instance
Azure DB managed instance have updated the version to 15.00.2000.[8]? but cant find this version on onpremise version so backup from AZURE DB MANAGED INSTANCE to SQL ONPREMISES cant be restore because ...Proposed | 3 Replies | 202 Views | Created by aner santana - Thursday, December 12, 2019 8:58 PM | Last reply by Mike Ubezzi (Azure) - 8 hours 40 minutes ago -
0 Votes
CREATE STATISTICS on external table in same elastic pool
Is it not possible to create statistics on an external table located in the same elastic pool in Azure? according ...Unanswered | 1 Replies | 102 Views | Created by WMP i no understand - 14 hours 41 minutes ago | Last reply by Gonzalo Bissio - 10 hours 56 minutes ago -
0 Votes
The Authorization header was not found - Azure Sql DB
The Authorization header was not found - Azure Sql DB I am using Query editor (preview) in Azure portal and also trying to connect the sql server management studio ...Unanswered | 2 Replies | 106 Views | Created by shivanish2019 - 20 hours 0 minutes ago | Last reply by Kalyan Chanumolu-MSFT - 15 hours 49 minutes ago -
0 Votes
Geo-Replication works, but server isn't registered as a secondary
Hi, I've tried multiple variations and have geo-replication working using the docs. When I update data on my primary, the secondary database is also updated. No issue there. ...Answered | 5 Replies | 519 Views | Created by qnal - Tuesday, December 10, 2019 3:30 AM | Last reply by qnal - Friday, December 13, 2019 2:24 AM -
1 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 | 8 Replies | 608 Views | Created by Gerri M - Thursday, December 5, 2019 12:20 AM | Last reply by Gerri M - Thursday, December 12, 2019 10:38 PM -
2 Votes
SQL "USE" statement is not supported in azure sql database for selecting different databases in a single azure sql server
SQL "USE" statement is not supported in azure sql database for selecting different databases in a single azure sql server. I have to run different SQL queries on different ...Proposed | 12 Replies | 11175 Views | Created by Adeel Rehman Sheikh - Wednesday, December 13, 2017 5:28 AM | Last reply by robert-tonnessen - Thursday, December 12, 2019 11:50 AM -
1 Votes
database id gets changed
From @ahunjet via Twitter I have an Azure website and app that checks database ID. For some reason database id gets changed. Can you tell me why? ...Answered | 5 Replies | 1654 Views | Created by Estela Virko Microsoft (MSFT CSG) - Tuesday, May 3, 2016 6:55 AM | Last reply by SeanDecker - Thursday, December 12, 2019 12:41 AM -
0 Votes
SQL 2008RT linked to Azure DB
Hi, this is the question, i have a SQL 2008rt databse getting continuesly data from a productive process, i want to make a copy and update it each 1 min in a azure db to acees it from app or ...Discussion | 3 Replies | 478 Views | Created by Julio.Laguardia - Monday, December 2, 2019 1:27 AM | Last reply by Kalyan Chanumolu-MSFT - Wednesday, December 11, 2019 10:53 AM -
0 Votes
How to copy google sheets data to azure data warehouse via azure data factory?
Proposed | 1 Replies | 137 Views | Created by Avi21 - Wednesday, December 11, 2019 7:07 AM | Last reply by Vaibhav-Chaudhari - Wednesday, December 11, 2019 7:12 AM -
0 Votes
Can I use Azure Lighthouse to provide delegated access to an Azure SQL DB?
This question is partly related to Azure SQL and partly to Azure Lighthouse. I'd like to use Azure AD Authentication with an Azure SQL database in my customers ...Unanswered | 2 Replies | 258 Views | Created by George Wieggers - Tuesday, December 10, 2019 8:29 AM | Last reply by Mike Ubezzi (Azure) - Wednesday, December 11, 2019 2:03 AM -
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 | 5 Replies | 802 Views | Created by SamDany - Tuesday, November 19, 2019 8:23 PM | Last reply by Mike Ubezzi (Azure) - Tuesday, December 10, 2019 7:09 PM -
4 Votes
SQL Managed Instance PITR Backup Costs September 1 2019 - Help me understand the architecture
Hi I am trying to forecast the costs of our PITR backups on Azure SQL Managed Instance (MI). As per MS documentation it states that as of September 1st 2019 customers will be ...Answered | 4 Replies | 1201 Views | Created by CloudMatt - Thursday, July 11, 2019 12:18 AM | Last reply by KehaDK - Tuesday, December 10, 2019 4:03 PM -
1 Votes
TDE (encryption at rest) with SSMS (management studio)
Hi, I'd like to enable TDE on my SQL database. My question is: Can I still use SQL Server management studio to do basic support tasks such as looking up user ...Answered | 2 Replies | 208 Views | Created by BTI1 - Tuesday, December 10, 2019 9:31 AM | Last reply by BTI1 - Tuesday, December 10, 2019 10:10 AM -
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 ...Answered | 4 Replies | 648 Views | Created by Bill Blakey FA - Tuesday, December 3, 2019 12:43 AM | Last reply by Kalyan Chanumolu-MSFT - Tuesday, December 10, 2019 8:41 AM - Items 1 to 20 of 10480 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