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 VotesDo you want to be acknowledged as Microsoft Azure Database Guru? Submit your work to Sep 2019 competition!
What is TechNet Guru Competition? Each month Microsoft TechNet Wiki council organizes a contest of the best articles posted that month. This is your ...
-
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 App Service Certificate configuration with Azure Application Gateway
Hi Background I am trying to implement a WAF in font of a web app hosted in azure app service. This app is configured to force https so the WAF needs to pass ...Unanswered | 1 Replies | 51 Views | Created by CloudMatt - Thursday, September 19, 2019 5:58 AM | Last reply by Mike Ubezzi (Azure) - 50 minutes ago -
0 Votes
File share witness is in failed state in windows 2012 r2
Hello , server : 2012 r2 , azure what could be the reason for why file share witness is in failed state : we found below on event logs ...Unanswered | 1 Replies | 79 Views | Created by swatsaswath - Tuesday, September 17, 2019 8:49 PM | Last reply by Mike Ubezzi (Azure) - 4 hours 32 minutes ago -
0 Votes
Listing Json arrays as rows
Hi I have stored jsons in a column "json_query" in table b. This ...Unanswered | 1 Replies | 23 Views | Created by AzureNick - 11 hours 41 minutes ago | Last reply by pituach - 5 hours 54 minutes ago -
0 Votes
List Permissions in a Role
I have a database role that appears not to be a fixed role, probably created by a contractor some time ago. I need to list the permissions granted by membership in this role, so far have not been able ...Unanswered | 1 Replies | 31 Views | Created by aerickson5 - 11 hours 15 minutes ago | Last reply by pituach - 5 hours 57 minutes ago -
0 Votes
Elastic Pool
Our elastic pool has grown and keeps growing without reusing its allocated space. Looing at the imag, you can see that we have 53Gb used pace, 102Gb ...Unanswered | 3 Replies | 219 Views | Created by Raven Peaks - Friday, September 13, 2019 4:30 PM | Last reply by NavtejSaini-MSFT - 8 hours 56 minutes ago -
0 Votes
Azure Custom Policy - Help
Hello All, We would like to implement a Custom Policy which will deploy SQL DB with PITR retention period of 21 days. (We don't want to do this ...Proposed | 4 Replies | 369 Views | Created by Raag007 - Tuesday, August 27, 2019 3:38 PM | Last reply by NavtejSaini-MSFT - 9 hours 48 minutes ago -
0 Votes
Query optimizer bug? SELECT TOP 1 <1sec. SELECT TOP 2? 3 hours and counting
My query - https://gist.github.com/kierenj/f39cd052197249e4277976bc44bb9c16 My schema - https://gist.github.com/kierenj/e6a3a74188fdc11c15daa8dd39341836 My query ... -
0 Votes
Virtual Machine with Sql Server Licensing
We use SSRS(SQL SERVER REPORTING SERVICES) for reporting in a multi-tenant environment in Azure. All of our Databases use Azure Sql Server. In order to host SSRS we created a virtual machine and ...Unanswered | 3 Replies | 78 Views | Created by Dom98 - Wednesday, September 18, 2019 5:19 PM | Last reply by NavtejSaini-MSFT - 15 hours 59 minutes ago -
0 Votes
Connection lost during task using DTU 100% for 30 minutes
Hi, I work with Microsoft Dynamics NAV and I have an installtion on Azure using Azure SQL for the database. Looking at the performances looks that the resources assigned are enought ...Proposed | 2 Replies | 458 Views | Created by Eclipses - Thursday, March 21, 2019 7:40 PM | Last reply by ASTARK1 - 18 hours 17 minutes ago -
0 Votes
Query editor (Preview) stopped working
Hi, I was using the Query Editor (Preview) for last few months on my Azure SQL database. However, it seems to have stopped working now. My client IP is already added to the SQL ...Unanswered | 1 Replies | 44 Views | Created by gacrow - 23 hours 17 minutes ago | Last reply by Uri Dimant - 21 hours 25 minutes ago -
0 Votes
Sync MySQL to SQL Server within Azure
Hi, I have MySQL database running in Azure SQL and want to synchronize the data to a SQL Server database also running in Azure SQL. Is this possible? I have read that this works ...Unanswered | 3 Replies | 83 Views | Created by ktsk - Wednesday, September 18, 2019 7:01 AM | Last reply by Uri Dimant - Thursday, September 19, 2019 3:56 AM -
0 Votes
Production to Pre Production Data replication
I have TBs of SQL DBs on Azure IAAS. I would like to have these production DBs to be replicated to my Pre prod IAAS SQL environment on daily or weekly intervals. Since DBs are in TBs I don't want to ...Unanswered | 1 Replies | 102 Views | Created by Whynot_vish - Monday, September 16, 2019 3:46 PM | Last reply by Mike Ubezzi (Azure) - Wednesday, September 18, 2019 11:02 PM -
0 Votes
How to move PROD SQL Azure Singleton database from one subscription to another
We have our production database (Azure Singleton) up and running in Azure. Due to a few security vulnerabilities found, we were asked to move that into a new subscription. The size of the database is ...Proposed | 3 Replies | 144 Views | Created by HeliosRex - Monday, September 16, 2019 4:22 PM | Last reply by HeliosRex - Wednesday, September 18, 2019 5:55 PM -
0 Votes
powershell write-sqltabledata error
I'm trying to import a csv file into a sql table on an azure database. The error is "Write-SqlTableData : Cannot access destination table ...Proposed | 7 Replies | 1623 Views | Created by oh_good_grief - Wednesday, April 18, 2018 6:02 AM | Last reply by NavtejSaini-MSFT - Wednesday, September 18, 2019 5:52 PM -
0 Votes
Fastest way to SELECT or INSERT a record and returning an ID
I'm trying to figure out what is the fastest way to select or insert a row in a table by returning the corresponding ID in a scenario where multiple threads run on the same table. In other words, each ... -
0 Votes
Azure SQL Server showing disabled
As title, when we want to access our SQL server showing disabled.Unanswered | 1 Replies | 53 Views | Created by Blue Ocean -Eileen Tang - Wednesday, September 18, 2019 10:20 AM | Last reply by Uri Dimant - Wednesday, September 18, 2019 10:27 AM -
0 Votes
using Azure AD on a different subscription to authenticate against Azure SQL database hosted by me
understand we can use Azure AD authentication for Azure SQL DB but they need to be on the same subscription, is there any way we can use Azure AD on a totally different subscription to authenticate ...Proposed | 3 Replies | 200 Views | Created by AzEzPz - Friday, September 13, 2019 2:21 AM | Last reply by Rohan Islam - Wednesday, September 18, 2019 10:13 AM -
0 Votes
Monitor or log Max Concurrent Requests?
I have an Azure SQL DB that I use exclusively with a set of Microsoft PowerApps apps. Suddenly about a week ago we blew through the 60 max requests on my Standard/S0 plan. I upped to the Standard/S2 ...Proposed | 2 Replies | 271 Views | Created by HoytB - Saturday, September 14, 2019 10:22 PM | Last reply by Kalyan Chanumolu-MSFT - Wednesday, September 18, 2019 9:35 AM -
0 Votes
Found more than one file to deploy with search pattern D:\a\r1\a\**\*.sql. There can be only one while using deply using sql query agent in azure devops release pipeline
Hi Team, Found more than one file to deploy with search pattern D:\a\r1\a\**\*.sql. There can be only one while using deploy using sql query agent in azure devops release ...Discussion | 7 Replies | 301 Views | Created by Sridhar Allada - Monday, September 9, 2019 8:40 AM | Last reply by Sridhar Allada - Wednesday, September 18, 2019 6:13 AM -
0 Votes
Query Performance Insight - Matching SQL with Corresponding LINQ
Hi, We are using Azure Query Performance Insight feature to spot the most problematic queries in terms of CPU and physical read consumption. Our project leverages EF (not Core) and ...Unanswered | 1 Replies | 82 Views | Created by DmitryVorobyev - Tuesday, September 17, 2019 8:37 PM | Last reply by Uri Dimant - Wednesday, September 18, 2019 3:50 AM - Items 1 to 20 of 10269 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
