This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
Microsoft Logo
Gray Pipe
Developer Network Developer Network Developer
:CreateViewProfileText: Sign in

Subscriber portal

Get tools
  • Downloads
    • Visual Studio
    • SDKs
    • Trial software
      • Free downloads
      • Office resources
  • Programs
    • Subscriptions
      • Overview
      • Administrators
    • Students
      • Microsoft Imagine
      • Microsoft Student Partners
    • ISV
    • Startups
    • Events
  • Community
    • Magazine
    • Forums
    • Blogs
    • Channel 9
  • Documentation
    • APIs and reference
    • Dev centers
    • Samples
    • Retired content
search clear
We’re sorry. The content you requested has been removed. You’ll be auto redirected in 1 second.
Ask a question
Quick access
  • Forums home
  • Browse forums users
  • FAQ
Announcement: 2

Azure SQL Database announcement

  • Link
    New service update available for SQL Data Sync!
    Shirley Wang [ADF] Thursday, May 28, 2015 2:58 PM

    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:

    1. 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.
    2. 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
    Understand Azure SQL Database and SQL Server in Azure VM
    Vinod Ramakrishna Friday, October 3, 2014 6:35 PM

    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!

    http://azure.microsoft.com/en-us/documentation/articles/data-management-azure-sql-database-and-sql-server-iaas/


    Selcin Turkarslan

  • Remove From My Forums

Forums [ view all ]

Selected forums

Clear
Azure SQL Database
x
Filter : All threads
All threads
Answered
Unanswered
Proposed answers
General discussion

No replies
Helpful
Has code

All languages
Sort : Most recent post
  • Most recent post
  • Most recent thread
  • Total votes
  • Total replies
  • large check mark
    0 Votes

    Announcements & News

    Microsoft Azure
     > 
    Azure SQL Database
    Good day all, It is highly recommended to follow the relevant Announcements & News. You are welcome to follow the following blogs: Azure SQL ...
    Sticky | 0 Replies | 427 Views | Created by pituach - Thursday, January 3, 2019 7:57 PM
  • large check mark
    0 Votes

    Download DTU Max Metrics Last 30 days

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    1 Votes

    Getting Azure SQL Database Disabled frequently

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    0 Votes

    Migrate TDE enabled database using HSM device to Managed instance

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    0 Votes

    Please enter a valid agent key to proceed. The key must be generated from SQL Data Sync web portal.

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    2 Votes

    Azure SQL Managed Instance Service Broker External Activator Support

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    0 Votes

    Azure Data Tracking

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    0 Votes

    Need more clarity with SQL server Managed Instance - General Purpose storage...

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    0 Votes

    Send email using Store Procedure in Azure SQL Database

    Microsoft Azure
     > 
    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
  • large check mark
    0 Votes

    Unable to connect to the destination mentioned in the KeyVault URL- Azure SQL

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    1 Votes

    Azure Monitor - "metric" source not available for SQL Database, SQL Servers, SQL Elastic Pools

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    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.

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    1 Votes

    Hyperscale with 0 read replicas deletes all tables/views/users?

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    0 Votes

    Additional charge on monthly subscription in azure sql server

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    1 Votes

    Importing a BACPAC gives an empty database

    Microsoft Azure
     > 
    Azure SQL 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
  • large check mark
    0 Votes

    Multiple Copies of SQL Database appearing in my DB list

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    0 Votes

    How to connect to Azure SQL DB using Active Directory Password Authentication through SSIS

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    0 Votes

    Microsoft SQL Data Sync Agent 2.0 keeping old Configuration and not using new one

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    0 Votes

    Azure DMS connectivity with IBM DB2(LUW) version - V9.7.0.11

    Microsoft Azure
     > 
    Azure SQL Database
    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 ...
    Unanswered | 0 Replies | 38 Views | Created by Archana06 - Wednesday, February 20, 2019 6:04 PM
  • large check mark
    0 Votes

    sql server create is hanging in Cloud Shell

    Microsoft Azure
     > 
    Azure SQL Database
    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
  • large check mark
    0 Votes

    Bandwidth requirement for SQL availability group copy

    Microsoft Azure
     > 
    Azure SQL Database
    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 ›
Announcement: 2

Azure SQL Database announcement

  • Link
    New service update available for SQL Data Sync!
    Shirley Wang [ADF] Thursday, May 28, 2015 2:58 PM

    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:

    1. 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.
    2. 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
    Understand Azure SQL Database and SQL Server in Azure VM
    Vinod Ramakrishna Friday, October 3, 2014 6:35 PM

    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!

    http://azure.microsoft.com/en-us/documentation/articles/data-management-azure-sql-database-and-sql-server-iaas/


    Selcin Turkarslan

Help us improve MSDN.
Visit our UserVoice Page to submit and vote on ideas!
Make a suggestion

Dev centers

  • Windows
  • Office
  • Visual Studio
  • Microsoft Azure
  • More...

Learning resources

  • Microsoft Virtual Academy
  • Channel 9
  • MSDN Magazine

Community

  • Forums
  • Blogs
  • Codeplex

Support

  • Self support

Programs

  • BizSpark (for startups)
  • Microsoft Imagine (for students)
United States (English)
  • Newsletter
  • Privacy & cookies
  • Terms of use
  • Trademarks
logo © 2019 Microsoft