This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
SALES: 1-800-867-1380
MY ACCOUNT
PORTAL
Sign in
  • Features
    • Features
      • Infrastructure
      • Web
      • Mobile
      • Dev & Test
      • Media
      • Integration
      • Big Data
      • Big Compute
      • Data Management
      • Identity & Access Management
      • Storage, Backup & Recovery
    • Discover
      • What is Azure
      • Enterprise IT
      • Application Hosting
      • Azure vs. Amazon Web Services
      • Azure in China
    • Services
      COMPUTE
      • Virtual Machines
      • Web Sites
      • Mobile Services
      • Cloud Services
      DATA SERVICES
      • Storage
      • SQL Database
      • HDInsight
      • Cache
      • Backup
      • Recovery Manager
      APP SERVICES
      • Media Services
      • Services Bus
      • Notification Hubs
      • Scheduler
      • BizTalk Services
      • Visual Studio Online
      • Active Directory
      • Multi-Factor Authentication
      • Automation
      • CDN
      NETWORK SERVICES
      • ExpressRoute
      • Virtual Network
      • Traffic Manager
    • Case Studies
  • Pricing
    • Overview
    • Pricing Details
      COMPUTE
      • Virtual Machines
      • Web Sites
      • Mobile Services
      • Cloud Services
      DATA SERVICES
      • Storage
      • SQL Database
      • HDInsight
      • Cache
      • Backup
      • Site Recovery
      APP SERVICES
      • Media Services
      • Service Bus
      • Notification Hubs
      • Scheduler
      • Automation
      • BizTalk Services
      • Visual Studio Online
      • Active Directory
      • Multi-Factor Authentication
      • CDN
      NETWORK SERVICES
      • ExpressRoute
      • Virtual Network
      • Traffic Manager
      • Data Transfers
    • Calculator
    • Purchase Options
    • Member Offers
      • MSDN
      • BizSpark Startups
      • Microsoft Partner Network
    • Regions
    • Support Plans
    • FAQ
  • Documentation
  • Downloads
  • Add-ons
  • Community
    • Blog
    • Service Updates
    • Events
    • Partners
    • Education
    • Newsletter
  • Support
    • Support Options
    • Support Plans
    • Forums
    • Service Dashboard
    • Trust Center
      • Overview
      • Security
      • Privacy
      • Compliance
    • Legal
    • FAQ
FREE TRIAL
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 [SQL] 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 03, 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
    2 Votes

    Migration from Azure SQL to Azure SQL performance issue

    Microsoft Azure
     > 
    Azure SQL Database
    Hi. I´m in process of migrating a Azure SQL Database from one subscription to another. Since they are not in the same tenant this requires a ...
    Unanswered | 5 Replies | 114 Views | Created by Tommy...h - Friday, September 29, 2017 8:48 AM | Last reply by JRStern - 2 hours 6 minutes ago
  • large check mark
    0 Votes

    PAGEIOLATCH_SH and PAGEIOLATCH_EX in Azure DB

    Microsoft Azure
     > 
    Azure SQL Database
    Hi,  I scaled (with difficulty, ...
    Answered | 5 Replies | 61 Views | Created by Asmine - 10 hours 17 minutes ago | Last reply by JRStern - 2 hours 11 minutes ago
  • large check mark
    0 Votes

    SQL Azure Data Sync Error No DataSync - Azure SQL DB provisioning failed

    Microsoft Azure
     > 
    Azure SQL Database
    I have set up a new sync on a PC Tables are OK, but no data is synced Does anyone have an ...
    Unanswered | 2 Replies | 126 Views | Created by Armin Ebner - Wednesday, September 27, 2017 3:24 PM | Last reply by Armin Ebner - 4 hours 23 minutes ago
  • large check mark
    1 Votes

    DB scaling take excessive time to complete

    Microsoft Azure
     > 
    Azure SQL Database
    Hi,  I have a 10Gb database, 5.77GB used. I started a scale up from S0 to S1 around 2pm today and it is still going now, 1h15min later. Is this ...
    Answered | 4 Replies | 110 Views | Created by Asmine - Tuesday, October 03, 2017 4:16 AM | Last reply by Asmine - 9 hours 30 minutes ago
  • large check mark
    0 Votes

    Cannot Verify Connection String when adding new Database

    Microsoft Azure
     > 
    Azure SQL Database
    I am following an online guide about setting up a mobile backend on Azure. I would post the link but it wont let me. I am at the part where I will be adding a SQL Database. I have ...
    Unanswered | 4 Replies | 130 Views | Created by jlovatt121 - 18 hours 28 minutes ago | Last reply by Alberto Morillo - 10 hours 7 minutes ago
  • large check mark
    2 Votes

    Primary key check when the field is updated

    Microsoft Azure
     > 
    Azure SQL Database
    How do I do to get the primary key check for doublettes when the field (or control ) is updated? I have very long forms and the primary key is the first in order, and a check for doublettes is ...
    Proposed | 4 Replies | 53 Views | Created by MR_ANDERSSON - 21 hours 42 minutes ago | Last reply by Alberto Morillo - 10 hours 43 minutes ago
  • large check mark
    0 Votes

    Connecting Azure SQL Database from Azure Data Factory

    Microsoft Azure
     > 
    Azure SQL Database
    <g class="gr_ gr_55 gr-alert gr_gramm gr_inline_cards gr_run_anim Punctuation only-ins replaceWithoutSep" data-gr-id="55" id="55">Hello</g> ...
    Unanswered | 1 Replies | 38 Views | Created by Karthi Kuppuraj - 20 hours 45 minutes ago | Last reply by Estienne Granet - 14 hours 13 minutes ago
  • large check mark
    0 Votes

    Azure Fail over Group connection Issue for secondary server database

    Microsoft Azure
     > 
    Azure SQL Database
    Hi, I am successfully created failover group for a production sql server , but i am facing issue to connect to the secondary server database through SQL Server Management studio.I ...
    Unanswered | 1 Replies | 35 Views | Created by Praveenm05 - 18 hours 9 minutes ago | Last reply by Estienne Granet - 14 hours 35 minutes ago
  • large check mark
    0 Votes

    About Migration to Cloud

    Microsoft Azure
     > 
    Azure SQL Database
    Team I have a Asp.net  web application that uses SQL server 2012 for dBASE since this is critical application a we are getting high amount of request to ...
    Unanswered | 1 Replies | 36 Views | Created by shreebharaath - 17 hours 32 minutes ago | Last reply by Estienne Granet - 14 hours 39 minutes ago
  • large check mark
    1 Votes

    Create Data Sync Group - "Sync Metadata Database" Option Grayed Out

    Microsoft Azure
     > 
    Azure SQL Database
    I was trying out the "Sync to other databases" option on the new Azure portal however, when I'm creating the Sync Group, the "Sync Metadata Database" option is ...
    Answered | 3 Replies | 209 Views | Created by Rick Su - Friday, August 11, 2017 1:02 AM | Last reply by Kruti D Mehta - 17 hours 51 minutes ago
  • large check mark
    2 Votes

    Bulk Insert from storage account 'files' not 'blobs'

    Microsoft Azure
     > 
    Azure SQL Database
    Hello I've successfully imported files using bulk insert where the file is in a 'blob' in a storage account. My question is can we bulk insert from 'files' in a storage account and ...
    Proposed | 4 Replies | 49 Views | Created by Brian Searle - 22 hours 12 minutes ago | Last reply by Brian Searle - 18 hours 24 minutes ago
  • large check mark
    0 Votes

    Migrating SQL database to Azure using SSMS fails with "login failed"

    Microsoft Azure
     > 
    Azure SQL Database
    In SSMS, I'm trying to use the "Deploy Database to SQL Azure Database" utility. I'm moving a small local database in SQL 12 to Azure for hosting. But after entering the ...
    Unanswered | 13 Replies | 1140 Views | Created by Karl K - Tuesday, September 06, 2016 5:02 AM | Last reply by GearWorld - 20 hours 20 minutes ago
  • large check mark
    1 Votes

    Using Microsoft Azure - MySQL In App to create database, php code cannot see it?

    Microsoft Azure
     > 
    Azure SQL Database
    Hi there, I'm relatively new to PHP but have set up an Azure web app with a MySQL In App database.  There is no db icon in the resources panel, although I assume that the in app function does not ...
    Proposed | 3 Replies | 74 Views | Created by Alex BPC - Tuesday, October 03, 2017 1:58 PM | Last reply by Alex BPC - Wednesday, October 04, 2017 8:04 AM
  • large check mark
    0 Votes

    Best way to control DTUs while inserting records in Azure SQL Table

    Microsoft Azure
     > 
    Azure SQL Database
    I have an Azure service that can be modeled as follow: N instances of a cloud service insert the IP of each visit coming on the HTTP interface in a queue (Azure Storage). A worker role, processes the ...
    Unanswered | 10 Replies | 123 Views | Created by dsmwb - Tuesday, October 03, 2017 4:36 PM | Last reply by JRStern - Wednesday, October 04, 2017 6:58 AM
  • large check mark
    0 Votes

    AZURE STACK ISSUE - CONFIGURING SQL AS A SERVICE FAILED: Use SQL databases on Microsoft Azure Stack

    Microsoft Azure
     > 
    Azure SQL Database
    Hi Team, When trying to add a Hosting Servers to Resource Providers after filling the server name, login, password etc. we're getting this ...
    Unanswered | 2 Replies | 76 Views | Created by Mayank Dhama - Tuesday, October 03, 2017 12:09 PM | Last reply by Mayank Dhama - Wednesday, October 04, 2017 4:50 AM
  • large check mark
    0 Votes

    Azure Data Sync messed up in Azure SQL DB

    Microsoft Azure
     > 
    Azure SQL Database
    I was trying to set up Azure Data Sync to sync a DB _from_ Azure SQL to a local db.  I had gone through a couple of false starts and had finally gotten to the point where I was asked what tables ...
    Unanswered | 11 Replies | 353 Views | Created by Peter A. Schott - Tuesday, August 01, 2017 4:26 PM | Last reply by Alberto Morillo - Wednesday, October 04, 2017 4:39 AM
  • large check mark
    0 Votes

    Azure Data Sync messed up in Azure SQL Data Base

    Microsoft Azure
     > 
    Azure SQL Database
    I was trying to set up Azure Data Sync to sync a Database from azure and a local Database, I have created a sync agent, and a sync group, but something happened and now i can't see or edit that data, ...
    Unanswered | 2 Replies | 83 Views | Created by Enrique Rubio - Tuesday, October 03, 2017 6:50 PM | Last reply by Alberto Morillo - Wednesday, October 04, 2017 4:36 AM
  • large check mark
    0 Votes

    Fatal error: Call to undefined function mysqli_connect()

    Microsoft Azure
     > 
    Azure SQL Database
    I am running a Linux Web App + mysql. I have a php app. My app works great on localhost. I use a MacBook Pro.  I was given this link by the CSR on twitter. ...
    Unanswered | 3 Replies | 105 Views | Created by stevenmaberry - Tuesday, October 03, 2017 2:50 AM | Last reply by Alberto Morillo - Wednesday, October 04, 2017 4:19 AM
  • large check mark
    1 Votes

    Azure SQL Server OData Service

    Microsoft Azure
     > 
    Azure SQL Database
    Hey guys, Some searching on SQL Azure OData provided me with some information that there was an OData overlay to SQL Azure at one point, that allowed a no code OData feed of a ...
    Proposed | 1 Replies | 76 Views | Created by andrewtobin - Tuesday, October 03, 2017 9:30 PM | Last reply by Alberto Morillo - Wednesday, October 04, 2017 3:34 AM
  • large check mark
    1 Votes

    Only a handful of my databases show up when I click SQL DATABASES in Azure Portal

    Microsoft Azure
     > 
    Azure SQL Database
    If I click SQL DATABASES I see a list of 5 databases. I have 10. If I click on SQL Servers and choose the proper database server I see all ...
    Answered | 2 Replies | 75 Views | Created by Jerrak - Tuesday, October 03, 2017 1:49 PM | Last reply by Kapil.Kumawat - Tuesday, October 03, 2017 8:19 PM
  • Items 1 to 20 of 8288 Next ›
Announcement: 2

Azure SQL Database announcement

  • Link
    New service update available for SQL Data Sync!
    Shirley Wang [SQL] 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 03, 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


Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.

Would you like to participate?

  
Privacy statement
Go Social
  • Facebook
  • Twitter
  • Rss
  • Newsletter
  • Microsoft Azure
  • Features
  • Services
  • Regions
  • Case Studies
  • Pricing
  • Calculator
  • Documentation
  • Downloads
  • Marketplace
  • Microsoft Azure in China
  • Community
  • Blogs
  • Forums
  • Events
  • Support
  • Forums
  • Service Dashboard
  • Support
  • Account
  • Subscriptions
  • Profile
  • Preview Features
  • Management Portal
  • Trust Center
  • Security
  • Privacy
  • Compliance
Hello from Seattle
English
English Dansk Deutsch Español
Français Italiano Nederlands Polski
Português Svenska Türkçe Pусский
日本語 한국어 简体中文 繁體中文
 
  • Contact Us
  • Trademarks
  • Privacy & Cookies
  • Feedback
© 2017 Microsoft