Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


No R2


No R2

Author
Message
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17569 Visits: 32254
Gary Varga (6/11/2013)
chrisn-585491 (6/11/2013)
I can see a scenario where organizations turn to cloud based services to host their e-commerce database or quickly spin up some one-off analytical solution requested by management.


That's about what I see. But the daily bread, the data, the crown jewels will more than likely be in-house for a long, long, while.


I disagree. Of course it is one of those "only time will tell" discussion but do feel free to tell me "I told you so" in a post to this forum...

...but not for 5 years Crazy


Yeah, I'm in the 3-5 years crowd. Let's just see if there's still a Microsoft as we know it at that point.

----------------------------------------------------
The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood...
Theodore Roosevelt

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36042 Visits: 18736
chrisn-585491 (6/11/2013)
I can see a scenario where organizations turn to cloud based services to host their e-commerce database or quickly spin up some one-off analytical solution requested by management.


That's about what I see. But the daily bread, the data, the crown jewels will more than likely be in-house for a long, long, while.


I'm not so sure. I can see a single point of reference for many apps, but I suspect there may be interfaces or proxies built that push some of this stuff to a cloud environment. Why not use a cloud if you can firewall access to it from the corporate network only and save on the need to manage your own machines. Why not use it in places for non financial/PII/medical information? I could see lots of small departmental apps moving. For that matter, I could see all kinds of quick analysis stuff moving because it's easier or quicker to throw something up in a cloud environment if your IT group isn't responsive.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8260 Visits: 6129
Suddenly the whole VPN access to locally hosted apps almost, almost, disappears.

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Revenant
Revenant
SSCertifiable
SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)

Group: General Forum Members
Points: 5771 Visits: 4706
Steve Jones - SSC Editor (6/11/2013)
[quote]. . . I could see all kinds of quick analysis stuff moving because it's easier or quicker to throw something up in a cloud environment if your IT group isn't responsive.

It takes IT several months to get and set up a server, even if the budget is approved. It takes literally five minutes to provision a new Azure SQL server. Bonus: if you have several, setting up load balancing takes say two minutes.

My client uses Azure for a system that tracks and reports on disposal of compostable waste at supermarkets; confidentiality is not the number one consideration.
chrisn-585491
chrisn-585491
SSC Eights!
SSC Eights! (944 reputation)SSC Eights! (944 reputation)SSC Eights! (944 reputation)SSC Eights! (944 reputation)SSC Eights! (944 reputation)SSC Eights! (944 reputation)SSC Eights! (944 reputation)SSC Eights! (944 reputation)

Group: General Forum Members
Points: 944 Visits: 2311
It takes IT several months to get and set up a server, even if the budget is approved.


Really? Depending on the server it takes us days, at most, once approved.
Revenant
Revenant
SSCertifiable
SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)

Group: General Forum Members
Points: 5771 Visits: 4706
chrisn-585491 (6/11/2013)
It takes IT several months to get and set up a server, even if the budget is approved.


Really? Depending on the server it takes us days, at most, once approved.

Wow - you do a much better job than the IT of my big clients.
chrisn-585491
chrisn-585491
SSC Eights!
SSC Eights! (944 reputation)SSC Eights! (944 reputation)SSC Eights! (944 reputation)SSC Eights! (944 reputation)SSC Eights! (944 reputation)SSC Eights! (944 reputation)SSC Eights! (944 reputation)SSC Eights! (944 reputation)

Group: General Forum Members
Points: 944 Visits: 2311
Why not use it in places for non financial/PII/medical information?


Confidential info is my day job. No cloud there!

But I crunch data on the side for a some non profits and it's easier to set up quick and dirty data analysis in Linux than deal with MS licenses and such. Different set of tools too. Interesting contrast, almost night and day... :-P
Eric M Russell
Eric M Russell
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4578 Visits: 9502
Revenant (6/11/2013)
Steve Jones - SSC Editor (6/11/2013)
[quote]. . . I could see all kinds of quick analysis stuff moving because it's easier or quicker to throw something up in a cloud environment if your IT group isn't responsive.

It takes IT several months to get and set up a server, even if the budget is approved. It takes literally five minutes to provision a new Azure SQL server. Bonus: if you have several, setting up load balancing takes say two minutes.

My client uses Azure for a system that tracks and reports on disposal of compostable waste at supermarkets; confidentiality is not the number one consideration.

It takes days to provision and install the server, but it can take weeks for management and accounting to approve the purchase order. It can take a single afternoon to provision, if they decide on a VM, which most of our SQL Server stances are.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
Revenant
Revenant
SSCertifiable
SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)SSCertifiable (5.8K reputation)

Group: General Forum Members
Points: 5771 Visits: 4706
Eric M Russell (6/11/2013)
Revenant (6/11/2013)
Steve Jones - SSC Editor (6/11/2013)
[quote]. . . I could see all kinds of quick analysis stuff moving because it's easier or quicker to throw something up in a cloud environment if your IT group isn't responsive.

It takes IT several months to get and set up a server, even if the budget is approved. It takes literally five minutes to provision a new Azure SQL server. Bonus: if you have several, setting up load balancing takes say two minutes.

My client uses Azure for a system that tracks and reports on disposal of compostable waste at supermarkets; confidentiality is not the number one consideration.

It takes days to provision and install the server, but it can take weeks for management and accounting to approve the purchase order. It can take a single afternoon to provision, if they decide on a VM, which most of our SQL Server stances are.

That is true; however, setting up a new VM does not increase your resources or computing power, it only allocates available resources and power.

I was trying to point out that my small, start-up clients greatly appreciate that they can change the class of the server from Dev to Biz, allocate more memory, and get more disk space by literally just a few clicks. Yes, Azure bill will go up but that's the cost of doing business.

In other words, I have more and more clients who specifically ask for Azure and I get the gig because I have Azure SQL on my resume.
Steve Jones
Steve Jones
SSC-Dedicated
SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)SSC-Dedicated (36K reputation)

Group: Administrators
Points: 36042 Visits: 18736
chrisn-585491 (6/11/2013)
It takes IT several months to get and set up a server, even if the budget is approved.


Really? Depending on the server it takes us days, at most, once approved.


What size company? What environment? I know that come large companies that have a mostly virtualized infrastructure put up servers in days, but only for a certain size. Anything that needs more than 4-8 cores (4 sockets) tends to take weeks if not months.

Follow me on Twitter: @way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
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