Clouds Are In our Future

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Editorials » Clouds Are In our Future

14 posts, Page 2 of 2

««1 2

Clouds Are In our Future

Rate Topic

Display Mode

Topic Options

Author

Message

Revenant

Posted Monday, January 03, 2011 10:10 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 4:25 PM
Points: 3,511, Visits: 2,593

One issue I never see mentioned are leagl requirements for auditability. There are many types of database-centric applications that are legally required to keep data on premises; for example, pharmacies. The first thing pharmacy auditors do is that they lock the door and then they disconnect the computer. Brokerage systems must keep their databases within the jurisdiction that licensed them.

Like or not, for tyhese apps you would have to change the law before you would even consider security.

Post #1041937

Jeff Moden

Posted Monday, January 03, 2011 6:13 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112, Visits: 27,038

Steve Jones - SSC Editor (1/3/2011)

Jeff Moden (1/3/2011)

If someone doesn't already have enough reasons to avoid the cloud, here is a recent post that may contain some additional reasons you may not have been aware of...
http://www.sqlservercentral.com/Forums/Topic1041653-392-1.aspx

Rumor also has it that you can't do a SELECT/INTO on a Temp Table in Azure. Does anyone happen to have a convenient list of all the things you can't do in Azure that you can do in a real instance of SQL Server?

The cloud fits in places, but there are limitations right now. The SQL Azure team is enhancing it quickly, and I believe that all future tools, i.e. SSMS, will work seemlessly with Azure and non-cloud databases.

Here's a list of some limitations: http://msdn.microsoft.com/en-us/library/ee336245.aspx

Good link. Thanks, Steve.

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1042111

BSavoie

Posted Monday, January 03, 2011 8:13 PM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 11:32 AM
Points: 309, Visits: 720

Below is the official Microsoft doc on limitations. It seems like every which way I turn, I bump up against SOME limitation. Then there's the lack of tooling. R2 FINALLY adds object browser support to SSMS for Azure DBs, but with MANY limitations. Moving db's around between Azure and production/qa servers is very frustrating as well. Although, I came across the SQLAzureMigrationWizard, which is a wonderful (free) tool. I'm trying to talk my company down. SQL Azure feels like a "toy". Personally, I think MS rushed SQL Azure out the door before it was ready. I think SQL Server "as a service" is proving much more difficult than MS thought.

And to Steve's point, my company was wondering why we are getting $1000.00 bills for Azure. Very simple all our developers/testers are using the cloud db as if it was local... jeez. $1000.00 per month buys some pretty nice REAL SQL Server space somewhere!

[url=http://msdn.microsoft.com/en-us/library/ee336245.aspx][/url]

.

Post #1042130

Jeremiah Peschka

Posted Monday, January 10, 2011 6:51 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 4:06 PM
Points: 30, Visits: 174

BSavoie (1/3/2011)And to Steve's point, my company was wondering why we are getting $1000.00 bills for Azure. Very simple all our developers/testers are using the cloud db as if it was local... jeez. $1000.00 per month buys some pretty nice REAL SQL Server space somewhere!

When you change the way you host and deploy applications, you need to change the way that you develop them. There are a number of tools that your developers can use to mimic an Azure environment on their local machines instead of burning through company money in production. There are going to be some growing pains, it stinks that yours ended up costing money.

Jeremiah Peschka
Microsoft SQL Server MVP
Managing Director - Brent Ozar PLF, LLC

Post #1045658

« Prev Topic | Next Topic »

14 posts, Page 2 of 2

««1 2

Permissions