This site uses cookies for analytics, personalized content and ads. By continuing to browse this site, you agree to this use. Learn more
  • TechNet
  • Products
  • IT Resources
  • Downloads
  • Training
  • Support
Products
  • Windows
  • Windows Server
  • System Center
  • Microsoft Edge
 
  • Office
  • Office 365
  • Exchange Server
 
  • SQL Server
  • SharePoint Products
  • Skype for Business
  • See all products »
Resources
  • Channel 9 Video
  • Evaluation Center
  • Learning Resources
  • Microsoft Tech Companion App
  • Microsoft Technical Communities
  • Microsoft Virtual Academy
  • Script Center
  • Server and Tools Blogs
  • TechNet Blogs
 
  • TechNet Flash Newsletter
  • TechNet Gallery
  • TechNet Library
  • TechNet Magazine
  • TechNet Wiki
  • Windows Sysinternals
  • Virtual Labs
Solutions
  • Networking
  • Cloud and Datacenter
  • Security
  • Virtualization
Updates
  • Service Packs
  • Security Bulletins
  • Windows Update
Trials
  • Windows Server 2016
  • System Center 2016
  • Windows 10 Enterprise
  • SQL Server 2016
  • See all trials »
Related Sites
  • Microsoft Download Center
  • Microsoft Evaluation Center
  • Drivers
  • Windows Sysinternals
  • TechNet Gallery
Training
  • Expert-led, virtual classes
  • Training Catalog
  • Class Locator
  • Microsoft Virtual Academy
  • Free Windows Server 2012 courses
  • Free Windows 8 courses
  • SQL Server training
  • Microsoft Official Courses On-Demand
Certifications
  • Certification overview
  • Special offers
  • MCSE Cloud Platform and Infrastructure
  • MCSE: Mobility
  • MCSE: Data Management and Analytics
  • MCSE Productivity
Other resources
  • Microsoft Events
  • Exam Replay
  • Born To Learn blog
  • Find technical communities in your area
  • Azure training
  • Official Practice Tests
Support options
  • For business
  • For developers
  • For IT professionals
  • For technical support
  • Support offerings
More support
  • Microsoft Premier Online
  • TechNet Forums
  • MSDN Forums
  • Security Bulletins & Advisories
Not an IT pro?
  • Microsoft Customer Support
  • Microsoft Community Forums
Windows Client
 
Sign in
United States (English)Drop down arrow
Brasil (Português)Česká republika (Čeština)Deutschland (Deutsch)España (Español)France (Français)Indonesia (Bahasa)Italia (Italiano)România (Română)Türkiye (Türkçe)Россия (Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中国 (中文)台灣 (中文)日本 (日本語)
 
 
HomeWindows 10Windows 10 MobilePrevious versionsMDOPSurfaceSurface HubLibraryForums
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

RRS feed

  • 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

    SQL Server (Pre-release)
     > 
    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 | 4694 Views | Created by pituach - Thursday, January 3, 2019 7:57 PM
  • large check mark
    0 Votes

    How to limit DTU per job/task for SQL on Azure

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    Hello I am wondering if there is a way to set a limit on a per job or task basis that a job or task on a SQL DB that is hosted on Azure. So, something ...
    Proposed | 1 Replies | 91 Views | Created by Jason Johnson1834 - 8 hours 50 minutes ago | Last reply by Mike Ubezzi (Azure) - 9 minutes ago
  • large check mark
    0 Votes

    Hyperscale sql server hooks on insert

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    Hi,  I want to know if there is a way to define hooks on my hyperscale ms sql DB.  I want to manipulate all my insert events. Whats ...
    Unanswered | 4 Replies | 223 Views | Created by Elad IS - Wednesday, December 11, 2019 8:36 AM | Last reply by Mike Ubezzi (Azure) - 4 hours 50 minutes ago
  • large check mark
    0 Votes

    SSMS crashes when 'Object Explorer Details' is opened

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    When using SQL Server Management Studio 18.4 to access an Azure SQL server, I am able to login successfully and can expand the Databases list in Object Explorer. However, when I attempt to open Object ...
    Unanswered | 4 Replies | 173 Views | Created by stevetroughton - Thursday, December 12, 2019 10:11 AM | Last reply by Mike Ubezzi (Azure) - 5 hours 3 minutes ago
  • large check mark
    0 Votes

    Reading Extended Events Files from Blob Storage in Azure SQLDB and parsing to JSON with Spark/hadoop

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    Hi, We need to process the Event logs stored in blobs using Spark for the audit purpose. Is there any documentation about how to read the XEL file programatically ? or is there any ...
    Answered | 2 Replies | 161 Views | Created by shettyh - Thursday, December 12, 2019 10:16 AM | Last reply by Mike Ubezzi (Azure) - 5 hours 24 minutes ago
  • large check mark
    0 Votes

    Many unavailability issue over the past few days

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    Hello, We have many unavailability issue with our azure database located in france central over the past 3 ...
    Proposed | 3 Replies | 198 Views | Created by yousfi.youssef - Thursday, December 12, 2019 10:47 AM | Last reply by Mike Ubezzi (Azure) - 5 hours 33 minutes ago
  • large check mark
    0 Votes

    How can you alias connecting to a Managed Instance?

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    instead of  name.xxxxxxxxxxxxxxxx.database.windows.net Is there some way to add a dns entry where it will respond to  name.domain.com ...
    Proposed | 5 Replies | 237 Views | Created by Goofoff - Wednesday, December 11, 2019 5:29 PM | Last reply by Mike Ubezzi (Azure) - 8 hours 20 minutes ago
  • large check mark
    0 Votes

    Cant find sql version to match azure manged instance

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    Azure DB managed instance have updated the version to 15.00.2000.[8]? but cant find this version on onpremise version so backup from AZURE DB MANAGED INSTANCE to SQL ONPREMISES cant be restore because ...
    Proposed | 3 Replies | 202 Views | Created by aner santana - Thursday, December 12, 2019 8:58 PM | Last reply by Mike Ubezzi (Azure) - 8 hours 40 minutes ago
  • large check mark
    0 Votes

    CREATE STATISTICS on external table in same elastic pool

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    Is it not possible to create statistics on an external table located in the same elastic pool in Azure?  according ...
    Unanswered | 1 Replies | 102 Views | Created by WMP i no understand - 14 hours 41 minutes ago | Last reply by Gonzalo Bissio - 10 hours 56 minutes ago
  • large check mark
    0 Votes

    The Authorization header was not found - Azure Sql DB

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    The Authorization header was not found - Azure Sql DB I am using  Query editor (preview) in Azure portal and also trying to connect the sql server management studio ...
    Unanswered | 2 Replies | 106 Views | Created by shivanish2019 - 20 hours 0 minutes ago | Last reply by Kalyan Chanumolu-MSFT - 15 hours 49 minutes ago
  • large check mark
    0 Votes

    Geo-Replication works, but server isn't registered as a secondary

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    Hi, I've tried multiple variations and have geo-replication working using the docs. When I update data on my primary, the secondary database is also updated. No issue there. ...
    Answered | 5 Replies | 519 Views | Created by qnal - Tuesday, December 10, 2019 3:30 AM | Last reply by qnal - Friday, December 13, 2019 2:24 AM
  • large check mark
    1 Votes

    Identity seed is incorrect after restore of Azure SQL Database from bacpac

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    We have bacpac files for database backup retention for more than 35 days as part of our DRP, and for restoring into test environments. What we have found is that after restoring a ...
    Unanswered | 8 Replies | 608 Views | Created by Gerri M - Thursday, December 5, 2019 12:20 AM | Last reply by Gerri M - Thursday, December 12, 2019 10:38 PM
  • large check mark
    2 Votes

    SQL "USE" statement is not supported in azure sql database for selecting different databases in a single azure sql server

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    SQL "USE" statement is not supported in azure sql database for selecting different databases in a single azure sql server. I have to run different SQL queries on different ...
    Proposed | 12 Replies | 11175 Views | Created by Adeel Rehman Sheikh - Wednesday, December 13, 2017 5:28 AM | Last reply by robert-tonnessen - Thursday, December 12, 2019 11:50 AM
  • large check mark
    1 Votes

    database id gets changed

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    From @ahunjet via Twitter   I have an Azure website and app that checks database ID. For some reason database id gets changed. Can you tell me why? ...
    Answered | 5 Replies | 1654 Views | Created by Estela Virko Microsoft (MSFT CSG) - Tuesday, May 3, 2016 6:55 AM | Last reply by SeanDecker - Thursday, December 12, 2019 12:41 AM
  • large check mark
    0 Votes

    SQL 2008RT linked to Azure DB

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    Hi, this is the question, i have a SQL 2008rt databse getting continuesly data from a productive process, i want to make a copy and update it each 1 min in a azure db to acees it from app or ...
    Discussion | 3 Replies | 478 Views | Created by Julio.Laguardia - Monday, December 2, 2019 1:27 AM | Last reply by Kalyan Chanumolu-MSFT - Wednesday, December 11, 2019 10:53 AM
  • large check mark
    0 Votes

    How to copy google sheets data to azure data warehouse via azure data factory?

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    Proposed | 1 Replies | 137 Views | Created by Avi21 - Wednesday, December 11, 2019 7:07 AM | Last reply by Vaibhav-Chaudhari - Wednesday, December 11, 2019 7:12 AM
  • large check mark
    0 Votes

    Can I use Azure Lighthouse to provide delegated access to an Azure SQL DB?

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    This question is partly related to Azure SQL and partly to Azure Lighthouse. I'd like to use Azure AD Authentication with an Azure SQL database in my customers ...
    Unanswered | 2 Replies | 258 Views | Created by George Wieggers - Tuesday, December 10, 2019 8:29 AM | Last reply by Mike Ubezzi (Azure) - Wednesday, December 11, 2019 2:03 AM
  • large check mark
    0 Votes

    how to read and write to Azure SQL from MS Flow SharePoint Online

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    Hi All, I need to read and write in a azure sql table from SharePoint Online list. How to achieve this?
    Unanswered | 5 Replies | 802 Views | Created by SamDany - Tuesday, November 19, 2019 8:23 PM | Last reply by Mike Ubezzi (Azure) - Tuesday, December 10, 2019 7:09 PM
  • large check mark
    4 Votes

    SQL Managed Instance PITR Backup Costs September 1 2019 - Help me understand the architecture

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    Hi I am trying to forecast the costs of our PITR backups on Azure SQL Managed Instance (MI). As per MS documentation it states that as of September 1st 2019 customers will be ...
    Answered | 4 Replies | 1201 Views | Created by CloudMatt - Thursday, July 11, 2019 12:18 AM | Last reply by KehaDK - Tuesday, December 10, 2019 4:03 PM
  • large check mark
    1 Votes

    TDE (encryption at rest) with SSMS (management studio)

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    Hi, I'd like to enable TDE on my SQL database. My question is: Can I still use SQL Server management studio to do basic support tasks such as looking up user ...
    Answered | 2 Replies | 208 Views | Created by BTI1 - Tuesday, December 10, 2019 9:31 AM | Last reply by BTI1 - Tuesday, December 10, 2019 10:10 AM
  • large check mark
    0 Votes

    How can I see the actual problem/error from a logged exception?

    SQL Server (Pre-release)
     > 
    Azure SQL Database
    On my Azure SQL "Server" I have a few SQL Databases, on the "Server" I have enabled Server-level auditing.  On the SQL Database I click "Auditing" then "View ...
    Answered | 4 Replies | 648 Views | Created by Bill Blakey FA - Tuesday, December 3, 2019 12:43 AM | Last reply by Kalyan Chanumolu-MSFT - Tuesday, December 10, 2019 8:41 AM
  • Items 1 to 20 of 10480 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

 
© 2019 Microsoft. All rights reserved.
Newsletter|Contact Us|Privacy Statement|Terms of Use|Trademarks|Site Feedback