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 April 2019 competition!!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. ...
-
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
Out of Sync with Server Error
In my environment I’m trying to run a web application on “mnwebserver” and its trying to connect to the MySQL resource called “anotherdbserver” I can run the application ...Unanswered | 4 Replies | 72 Views | Created by bvukas - 10 hours 37 minutes ago | Last reply by Mike Ubezzi (Azure) - 5 hours 40 minutes ago -
0 Votes
How to use both Auto and Manual sync option with Bi-direction Azure sync data?
My company currently set up the database on the Azure cloud. I've also set the Data Sync feature, which will allow us having the local database backup with every 5m sync ...Unanswered | 1 Replies | 52 Views | Created by Vinh Loc - 19 hours 15 minutes ago | Last reply by Mike Ubezzi (Azure) - 8 hours 23 minutes ago -
0 Votes
Azure SQL Database - auto-failover groups
As per Use auto-failover groups to enable transparent and coordinated failover of multiple databases : If you add a database that already has a ...Proposed | 1 Replies | 45 Views | Created by Taiob Ali - 11 hours 3 minutes ago | Last reply by Mike Ubezzi (Azure) - 8 hours 46 minutes ago -
0 Votes
Performance issue In Azure SQL server database 2012
Hi Gurus, I have share point SQL server database 2012 hosted in Azure.last couple of weeks, users are reporting that there is some slowness issue but we are not sure whether its ...Proposed | 3 Replies | 1697 Views | Created by Manisha K S - Thursday, April 18, 2019 5:18 AM | Last reply by Matt Bradley Mcr - 11 hours 35 minutes ago -
0 Votes
Create External Data Source in Visual Studio Database project
So in Visual Studio 2017 I have a SQL Server Database Project, I am creating schema, tables and procedures - fine. My project properties "Target Platform" is Microsoft Azure SQL ...Answered | 7 Replies | 3958 Views | Created by Bill Blakey FA - Friday, April 19, 2019 12:22 AM | Last reply by pituach - Saturday, April 20, 2019 12:16 AM -
0 Votes
HTTP Connections
Hi All, Is there any way to connect MS Azure SQL databases using HTTPs encrypted method not using default 1433 port, like HTTP endpoint connection or some thing ...Unanswered | 5 Replies | 1708 Views | Created by KRevolution - Wednesday, April 17, 2019 9:09 PM | Last reply by pituach - Friday, April 19, 2019 5:16 PM -
0 Votes
Unable To Create SQL Managed Instance
Hello, I tried creating Azure SQL managed instance using the REST API from the docs https://docs.microsoft.com/en-us/rest/api/sql/managedinstances/createorupdate. I ...Answered | 4 Replies | 1632 Views | Created by Deji19 - Thursday, April 18, 2019 10:11 AM | Last reply by Danimir Ljepava - Thursday, April 18, 2019 4:50 PM -
0 Votes
Cant Connect to Azure from Work network, what are the options to connect?
Hi guys! I have been trying to connect to Azure SQL Database, but the problem is that I am in Work network, I need to connect to that database for an activity I ...Proposed | 2 Replies | 1419 Views | Created by andrsGutirrz - Wednesday, April 17, 2019 4:28 PM | Last reply by andrsGutirrz - Wednesday, April 17, 2019 9:51 PM -
0 Votes
Azure Key Vault and Insert into Azure DB
I set up an Azure Key Vault and I have an Azure DB where there is a table with a column set up use encryption. CREATE TABLE [dbo].[TestUserApplication]( [SSN] ...Unanswered | 2 Replies | 1714 Views | Created by brianmrush1 - Friday, August 18, 2017 4:47 PM | Last reply by Abinash Tumulu - Wednesday, April 17, 2019 4:40 PM -
0 Votes
Problem using cert in Azure Key Vault for Always Encrypted fields.
I have Web App in Azure that works just fine with Sql Azure with no encrypted fields. The Web App and SSMS can access the DB just fine. But when I encrypt a field with AE, I can ...Unanswered | 10 Replies | 3337 Views | Created by chiefley2 - Tuesday, November 21, 2017 6:53 PM | Last reply by Abinash Tumulu - Wednesday, April 17, 2019 4:36 PM -
0 Votes
Azure Database Sync to other database and Sync Agent problem
Hello, I have two Databases in Azure. One is Production database(name XXX here) and other is same kind of database for testing (name XXXTest). I have made ...Unanswered | 3 Replies | 1396 Views | Created by Michael_laanti - Wednesday, April 17, 2019 6:43 AM | Last reply by pituach - Wednesday, April 17, 2019 3:09 PM -
0 Votes
Managed Identity and SQL connection
{ options.Events.RaiseErrorEvents = true; options.Events.RaiseInformationEvents = true; options.Events.RaiseFailureEvents = ...Proposed | 1 Replies | 1350 Views | Created by RiccardoBecker - Wednesday, April 17, 2019 7:35 AM | Last reply by Alberto Morillo - Wednesday, April 17, 2019 2:26 PM -
2 Votes
Starter Here!! Help me to Learn Microsoft Azure
I am a newbie. Just started learning Microsoft Azure. Already did some search in internet, got some important information but not all. I want to learn Microsoft ...Proposed | 14 Replies | 1606 Views | Created by Khaled Syfullah - Sunday, April 14, 2019 5:18 PM | Last reply by Kapil.Kumawat - Wednesday, April 17, 2019 1:52 PM -
0 Votes
Understanding In-Memory Limits and Technology
there is theoritically no limit cause SQL Server only holds the data which is currently used in the memory and therefore it can exceed the limit. best ...Proposed | 3 Replies | 1418 Views | Created by [Yavuz B.] - Tuesday, April 16, 2019 8:49 AM | Last reply by pituach - Wednesday, April 17, 2019 10:45 AM -
0 Votes
Unable to change or remove Sync Metadata Database
Hi, Whilst trying to set up a database sync, I accidentally chose an existing database to act as the Sync Metadata Database (which is obviously not recommended). I managed to ...Answered | 5 Replies | 2546 Views | Created by firstdanr - Thursday, September 28, 2017 7:34 PM | Last reply by Jon Perkins - Wednesday, April 17, 2019 10:09 AM -
0 Votes
MDAC ODBC Driver Support
Hi - was hoping I could get an answer on whether connecting to Azure SQL Database is supported with the legacy MDAC ODBC Driver (pre Native Client) such as the old 2.8 SP1 ODBC Driver. ...Proposed | 3 Replies | 1117 Views | Created by S Harder - Tuesday, April 16, 2019 4:39 PM | Last reply by Alberto Morillo - Tuesday, April 16, 2019 10:07 PM -
0 Votes
Long running UPDATE query completed with errors and caused 30gb of bloat
I have a few tables storing files data. Each table has a VARBINARY(MAX) column. Weeks ago I had downloaded those files to an FTP server. And redesigned the front end application to ...Answered | 4 Replies | 1487 Views | Created by Acquire Logic - Monday, April 15, 2019 4:38 PM | Last reply by Acquire Logic - Tuesday, April 16, 2019 7:12 PM -
0 Votes
Azure SQL Monitoring resource
So as fate would have it, our DBA is out sick today and we are having issues with our Azure SQL Database. Are there any free applications that exist to monitor Azure SQL Databases? ...Proposed | 1 Replies | 1395 Views | Created by ITBobbyP - Tuesday, April 16, 2019 1:38 PM | Last reply by Matt Bradley Mcr - Tuesday, April 16, 2019 2:57 PM -
0 Votes
Need some help please
I am trying to set a new name variable here and I am new to this, not sure what im doing wrong. I want it to set the variable as the GivenName attribute and then add our domain on Here is what I ...Discussion | 1 Replies | 1370 Views | Created by ProMode - Tuesday, April 16, 2019 2:24 PM | Last reply by Marcin Policht - Tuesday, April 16, 2019 2:54 PM -
0 Votes
Loading Multiple files from Azure Blob Storage into Azure SQL Database
I am able to Load single from Azure blob storage into azure SQL dB using below script. BULK INSERT ...Unanswered | 4 Replies | 2358 Views | Created by Mohan Badra - Monday, February 27, 2017 8:05 AM | Last reply by MeghaGupta1 - Tuesday, April 16, 2019 2:10 PM - Items 1 to 20 of 9824 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
