Azure SQL Limitations compared with a SQL Server Enterprise

  • Daniel Calbimonte

    SSCarpal Tunnel

    Points: 4702

    Comments posted to this topic are about the item Azure SQL Limitations compared with a SQL Server Enterprise

  • piotrka

    SSCrazy

    Points: 2023

    Azure Database is a database not a server. Imagine you create a database on your on premises SQL Server and give access to your developers. Your programmers will have as much control over the newly created database as on Azure DB.

    If you need full control of all the services then Azure DB may not be your best solution. However, if you want inexpensive way to store your data and access it from anywhere then it may work.

    I know it is a very simplistic way but don't compare Azure DB to SQL Server Enterprise. Think of Azure DB more like 1 database on your local server.

  • Alan Burstein

    SSC Guru

    Points: 61026

    Nice read, well done Daniel.

    -- Alan Burstein


    Helpful links:Best practices for getting help on SQLServerCentral -- Jeff ModenHow to Post Performance Problems -- Gail ShawNasty fast set-based string manipulation functions:For splitting strings try DelimitedSplit8K or DelimitedSplit8K_LEAD (SQL Server 2012+)To split strings based on patterns try PatternSplitCMNeed to clean or transform a string? try NGrams, PatExclude8K, PatReplace8K, DigitsOnlyEE, or Translate8KI cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code.  -- Itzik Ben-Gan 2001

  • Daniel Calbimonte

    SSCarpal Tunnel

    Points: 4702

    I believe that Azure SQL will replace the Traditional SQL Servers in the long run. I just wanted to point in this article that having an Azure SQL requires some extra effort to learn the new technology and that some automations scripts and other stuff used in Traditional SQL Servers may not work in Azure SQL. I have some customers who wanted to migrate everything to Azure SQL, but they were not aware of the differences.

  • piotrka

    SSCrazy

    Points: 2023

    I totally agree with you on Azure DB taking over transactional SQL servers. We already use number of web apps connected to Azure DB. However, we still keep a copy of SQL Server enterprise edition to do more advanced work.

  • Andrew..Peterson

    SSCertifiable

    Points: 6657

    calbimonte.daniel (7/26/2016)


    I believe that Azure SQL will replace the Traditional SQL Servers in the long run. I just wanted to point in this article that having an Azure SQL requires some extra effort to learn the new technology and that some automations scripts and other stuff used in Traditional SQL Servers may not work in Azure SQL. I have some customers who wanted to migrate everything to Azure SQL, but they were not aware of the differences.

    Thanks Daniel, and agree with the your long run expectation for cloud db's. In the past, when I was more involved with daily operations, SQL Server Agent and the MSDB database were key parts of the process. It will be interesting to see how that all plays out over time.

    The more you are prepared, the less you need it.

  • Revenant

    SSC-Forever

    Points: 42467

    There is no SSIS . . . You can also have a Virtual Machine in Azure with SQL Server that can have a traditional SQL Server and SSIS included.

    There is no SSIS in Azure because this functionality is handled by Azure Data Factory. You do not need a VM.

  • John_B

    SSC Enthusiast

    Points: 155

    Also, Azure SQL doesn't support linked servers (due to the lack of MSDTC support).

  • neerajstar

    Old Hand

    Points: 300

    Thanks Daniel,
    it was very informative and gives good insight about the Azure Database.

    One small update. I tried creating the Global temp table in SQL Azure, Table got created and accessible in another session as well.

    May the support for creating the global temp table added to azure db services recently.

    Regards,
    Neeraj Kumar

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply