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 VotesWho will be announced as the next Azure SQL Database Guru? Read more about May 2019 competition!!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. This is ...Sticky | 1 Replies | 323 Views | Created by RajeeshMenoth - Thursday, May 2, 2019 4:17 AM | Last reply by pituach - Thursday, May 9, 2019 3:26 AM
-
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
Two-Way Synchronization between Azure SQL and wpf/uwp clients
I have a Azure SQL database, and then clients (UWP and WPF) running SQLite that gets data from the database. The clients can change the data and it updates the ...Unanswered | 1 Replies | 38 Views | Created by Kasper mathiesen - 14 hours 41 minutes ago | Last reply by Mike Ubezzi (Azure) - 1 hour 9 minutes ago -
0 Votes
SQL2008 => SQL-Svr2017
Upgraded to SQL Server 2017... Added to Query: OPTION (USE HINT('QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_100')) I assume this tells the optimizer ...Unanswered | 1 Replies | 71 Views | Created by VikingExplorer - Wednesday, May 22, 2019 8:34 PM | Last reply by Mike Ubezzi (Azure) - 1 hour 23 minutes ago -
0 Votes
Contained database users spontaneously disabled
'The SELECT permission was denied on the object 'tbl_xxx', database 'xxx', schema 'xxx'.' or I getan access denied message -> 'Login failed for user ...Unanswered | 1 Replies | 66 Views | Created by grauwolf - Wednesday, May 22, 2019 7:30 AM | Last reply by Mike Ubezzi (Azure) - 1 hour 33 minutes ago -
0 Votes
How to sync the database table with userdefined datatype
Anyone know how to sync the userdefined datatype (grayout unable to select) to Azure database? The Azure database sync function is works fine but it is unable to select and ...Unanswered | 1 Replies | 44 Views | Created by Chin_Tan - 12 hours 3 minutes ago | Last reply by pituach - 5 hours 8 minutes ago -
0 Votes
Using Reporting Services (rdl) reports in Azure
Hi, First of all, thanks in advance to everyone :) I have a web site running against an SQL Database that is working fine in Azure. We have the IIS and the site ...Proposed | 4 Replies | 175 Views | Created by David Varo - Tuesday, May 21, 2019 8:59 AM | Last reply by Kalyan Chanumolu-MSFT - 5 hours 41 minutes ago -
0 Votes
SQL server reporting services on Azure VM
Hi, I want to install only SQL reporting services on Azure VM. Just want to know what will be the best method to deploy it and which latest operating system and ...Proposed | 2 Replies | 105 Views | Created by Prafull Wavhal - Wednesday, May 22, 2019 3:34 PM | Last reply by Prafull Wavhal - 7 hours 5 minutes ago -
0 Votes
Failed to sync after modified the database structure
I was trying to delete some unnecessary tables, The sync couldn't start and throw an exception : Failed to perform data sync operation: Exception of type ...Proposed | 2 Replies | 66 Views | Created by CZAupup - Wednesday, May 22, 2019 2:39 PM | Last reply by angoyal-msft - 11 hours 50 minutes ago -
0 Votes
Failure - Migrating from SQL Server to Azure DB
Hi Team, We're performing an export data-tier application on AWS's RDS to a local disk for creating a ,BACPAC file & it fails. We ... -
0 Votes
SSRS report connection
Hello Team, I have seen that it is possible to map an SSRS datasource to Azure SQL database based on SQL authentication. Is it possible to provide the connection ...Unanswered | 2 Replies | 93 Views | Created by Nandan Hegde - Wednesday, May 22, 2019 4:25 AM | Last reply by Nandan Hegde - 13 hours 0 minutes ago -
0 Votes
Attempts to authenticate against Azure SQL are failing with cloud-only (non-federated) Azure Active Directory
Hello everyone, We have a cloud-only environment that consists of the following: - VM joined to Azure AD (using Domain Services) running IIS ...Unanswered | 4 Replies | 404 Views | Created by Alex1088 - Friday, May 10, 2019 3:23 PM | Last reply by Mike Ubezzi (Azure) - 23 hours 42 minutes ago -
1 Votes
Migration of On-Premise SQL database fails because of encrypted Stored Procedures, Functions, etc.
Hi, I'm in the process of migrating an in-house SQL database into Azure SQL and the process fails because of encrypted Stored Procedures, Functions, etc. The database is ...Proposed | 10 Replies | 385 Views | Created by Moe Gholami - Friday, May 17, 2019 3:46 PM | Last reply by Moe Gholami - Wednesday, May 22, 2019 8:45 PM -
0 Votes
Has anyone used Azure Site Recovery to create a BCDR from on Prem Dynamics Servers
Are there any issues , particularly around GUID's when migrating a Dynamics environment from on prem to Azure using Azure Site Recovery ? I've ...Discussion | 1 Replies | 60 Views | Created by jkeith.dickson_gmail - Wednesday, May 22, 2019 5:09 PM | Last reply by pituach - Wednesday, May 22, 2019 6:33 PM -
1 Votes
Can't connect from MS PowerApps to Azure SQL Database
From PowerApps - create connection, I get: Credentials are missing or not valid. inner exception: The credentials provided for the SQL source are invalid. 1) Created azure trial ...Answered | 2 Replies | 146 Views | Created by bradadams100 - Tuesday, May 21, 2019 9:15 PM | Last reply by bradadams100 - Wednesday, May 22, 2019 5:33 PM -
0 Votes
SQL Server in Azure VM recovery vault backups
Hi Experts we have 3 node AG Configuration in one of our prod SQL Server in azure VM. database has been added in AG. we are configured backups in Azure recovery service vault., but ...Unanswered | 1 Replies | 105 Views | Created by raghu3085 - Wednesday, May 22, 2019 5:31 AM | Last reply by Kalyan Chanumolu-MSFT - Wednesday, May 22, 2019 11:10 AM -
0 Votes
Http request failed as there is an error: 'Cannot write more bytes to the buffer than the configured maximum buffer size: 104857600.'.
Export Huge Table from Azure SQL Database to CSV using Logic Apps, I have a table with 70 columns and 1 million rows. I use Logic Apps to export data and upload to FTP. I get ...Unanswered | 1 Replies | 84 Views | Created by Sagar Gulati - Wednesday, May 22, 2019 5:50 AM | Last reply by Kalyan Chanumolu-MSFT - Wednesday, May 22, 2019 11:08 AM -
0 Votes
ssis package executed successfully but nothing happens From azure ssisdb where as same package is working fine in local in VS
Dear techies, I have created one ssis package which moves csv file from my local drive to azure blob which is working well in VS. When a deployed it in Azure SSISDB package ... -
1 Votes
Error: "Database 'dbname' on server '' is not currently available." persists
Hi, I have a database that I can no longer connect to. Attempting to connect generates the same error: Database 'dbname' on server '' is not currently ...Unanswered | 4 Replies | 238 Views | Created by Sam - Kiandra - Monday, May 20, 2019 5:25 AM | Last reply by Sam - Kiandra - Wednesday, May 22, 2019 7:50 AM -
1 Votes
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. - MSI ( managed identity )
I have followed this tutorial to secure Azure SQL Database connection from App Service using a managed identity. Everything is working as ...Answered | 2 Replies | 118 Views | Created by Hemant.Shelar - Tuesday, May 21, 2019 1:39 PM | Last reply by Hemant.Shelar - Wednesday, May 22, 2019 4:24 AM -
0 Votes
Set Server Firewall
Hi all together, i have a database mostly used with SQLMobileClient and Xamarin. SqlMobileClient didn't work with WPF..... Now i would like to ...Answered | 5 Replies | 332 Views | Created by PeterForstmeier - Thursday, May 9, 2019 6:23 PM | Last reply by Kalyan Chanumolu-MSFT - Wednesday, May 22, 2019 3:34 AM -
0 Votes
Datasync anormaly slow (or stucked)
Hello, I'm experimenting problems with Datasync, the syncronization takes a lot of time or is stucked, i wait and when i click the update button to see if some log message shows... ...Unanswered | 1 Replies | 120 Views | Created by ThibautMdC - Tuesday, May 21, 2019 10:21 AM | Last reply by Mike Ubezzi (Azure) - Tuesday, May 21, 2019 5:36 PM - Items 1 to 20 of 9917 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
