SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Clouds Are In our Future


Clouds Are In our Future

Author
Message
Revenant
Revenant
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12179 Visits: 5010
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.
Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (204K reputation)SSC Guru (204K reputation)SSC Guru (204K reputation)SSC Guru (204K reputation)SSC Guru (204K reputation)SSC Guru (204K reputation)SSC Guru (204K reputation)SSC Guru (204K reputation)

Group: General Forum Members
Points: 204116 Visits: 41949
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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
BSavoie
BSavoie
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1131 Visits: 795
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]

.
Jeremiah Peschka
Jeremiah Peschka
SSC-Enthusiastic
SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)SSC-Enthusiastic (138 reputation)

Group: General Forum Members
Points: 138 Visits: 178
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search