Azure SQL Limitations compared with a SQL Server Enterprise

Question

Azure SQL Limitations compared with a SQL Server Enterprise

Daniel Calbimonte

SSCertifiable

Points: 6200
More actions
July 25, 2016 at 10:34 pm

#400465

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

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

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

piotrka SSCrazy Points: 2031 More actions · Answer 1

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: 61141 More actions · Answer 2

Nice read, well done Daniel.

"I 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 SSCertifiable Points: 6200 More actions · Answer 3

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: 2031 More actions · Answer 4

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: 6838 More actions · Answer 5

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 More actions · Answer 6

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: 156 More actions · Answer 7

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

neerajstar Old Hand Points: 330 More actions · Answer 8

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