January 27, 2016 at 7:49 am
Just expanding on this discussion a little: if there are people here who know both AWS and Azure, it would be nice to hear their views on pros and cons of the two.
--Edit: fixed typo
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 27, 2016 at 8:10 am
Michael L John (1/27/2016)
I haven't come up with a good idea on that yet. Our Azure initiative is in it's infancy. There are a couple very small "one-off" systems that are in production. The devs run reindexing/statistics scripts manually about once a week.
Cool beans. As you work with it, if you want to share stuff with me, I'd really love to hear it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 27, 2016 at 8:18 am
Grant Fritchey (1/27/2016)
Michael L John (1/27/2016)
I haven't come up with a good idea on that yet. Our Azure initiative is in it's infancy. There are a couple very small "one-off" systems that are in production. The devs run reindexing/statistics scripts manually about once a week.Cool beans. As you work with it, if you want to share stuff with me, I'd really love to hear it.
Me too, Mike. I'm incredibly interested. The two key points I read were: 1) developers; and 2) manually. :w00t:
January 27, 2016 at 8:25 am
Ed Wagner (1/27/2016)
Grant Fritchey (1/27/2016)
Michael L John (1/27/2016)
I haven't come up with a good idea on that yet. Our Azure initiative is in it's infancy. There are a couple very small "one-off" systems that are in production. The devs run reindexing/statistics scripts manually about once a week.Cool beans. As you work with it, if you want to share stuff with me, I'd really love to hear it.
Me too, Mike. I'm incredibly interested. The two key points I read were: 1) developers; and 2) manually. :w00t:
There are ways to automate stuff within Azure. Actually, there are too many ways to automate things within Azure. Picking and choosing is actually kind of hard.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 27, 2016 at 8:50 am
Phil Parkin (1/27/2016)
Just expanding on this discussion a little: if there are people here who know both AWS and Azure, it would be nice to hear their views on pros and cons of the two.--Edit: fixed typo
You know, a thorough article on the differences, with the pros/cons explained, would make a very nice article.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 28, 2016 at 2:55 am
I've just discovered Redgate's 'Tab History' button.
Where was that at my last place of work? That little gem could have saved me hours of agony.
Hunting through tabs, closing tabs that I wished I hadn't, trying to remember code I had opened from a day or more back. It's wonderful.
I hope that whoever wrote that tool is feeling suitably smug.
Anyway, back to what I was doing....
January 28, 2016 at 8:44 am
BrainDonor (1/28/2016)
I've just discovered Redgate's 'Tab History' button.Where was that at my last place of work? That little gem could have saved me hours of agony.
Hunting through tabs, closing tabs that I wished I hadn't, trying to remember code I had opened from a day or more back. It's wonderful.
I hope that whoever wrote that tool is feeling suitably smug.
Anyway, back to what I was doing....
This saves me regularly, as I've had some instability with laptops and W10. It is nice
January 28, 2016 at 8:45 am
Articles on Azure, and/or AWS, are very welcome. I'm looking for people, but having a hard time.
Plus Grant seems to avoid writing on it here 😛
January 28, 2016 at 8:54 am
Phil Parkin (1/27/2016)
Just expanding on this discussion a little: if there are people here who know both AWS and Azure, it would be nice to hear their views on pros and cons of the two.--Edit: fixed typo
Relatively short answer:
If you're looking at IaaS, then AWS and Azure both offer you a virtual machine, into which you can install SQL Server. I haven't done this with AWS in some time, but Azure makes this easy with images and templates.
Con: Note that if you use some (maybe all) of the Azure templates, it's more expensive as they're supplying you with the SQL license.
Pro: In either case, you can use your own licenses and do the install for a "normal" SQL Server. They help you set up networking, firewalls, etc. Note that when I say help, I mean there are GUIs or PoSh ways to do this. They aren't holding your hand, but there are docs and articles in some places on this.
If you want PaaS, then in Azure, you get Azure SQL Database. This is both a superset and subset of current on premise SQL Server functionality at the database level. You have to think of this as a database, not a server or instance. You get access to the database, and only manage the database. There is no agent, no server role, nothing outside of the database. As Grant mentioned, this means you automate, and try to understand how to do this. Easy way, have a box on your premise that connects and runs maintenance. Hard(er) way, pick some Azure Automation and learn to go that.
If you go AWS, they have a version of SQL that is really the on premise version, but it's locked down. You don't really have the ability to do much at the server level. They (Amazon) manage the instance, you get the database. When I played with it before, I'm not sure I saw a lot of benefit over using an on premise SQL instance. I believe you can get cross database stuff working, but I'm not sure, and apparently, AMZN doesn't know how to limit searches for RDS for SQL Server from RDS for other platforms.
January 28, 2016 at 9:07 am
Steve Jones - SSC Editor (1/28/2016)
Articles on Azure, and/or AWS, are very welcome. I'm looking for people, but having a hard time.Plus Grant seems to avoid writing on it here 😛
HA!
Well it's not like I've been writing on it elsewhere...
They asked!
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 28, 2016 at 9:23 am
Grant Fritchey (1/28/2016)
Steve Jones - SSC Editor (1/28/2016)
Articles on Azure, and/or AWS, are very welcome. I'm looking for people, but having a hard time.Plus Grant seems to avoid writing on it here 😛
HA!
Well it's not like I've been writing on it elsewhere...
They asked!
Okay...
Grant, would you please write an article series of articles on AWS / Azure for SSC?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
January 28, 2016 at 10:39 am
WayneS (1/28/2016)
Grant Fritchey (1/28/2016)
Steve Jones - SSC Editor (1/28/2016)
Articles on Azure, and/or AWS, are very welcome. I'm looking for people, but having a hard time.Plus Grant seems to avoid writing on it here 😛
HA!
Well it's not like I've been writing on it elsewhere...
They asked!
Okay...
Grant, would you please write an
articleseries of articles on AWS / Azure for SSC?
No.
But only because I don't know AWS very well. I'm spending all my time in Azure.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 28, 2016 at 10:43 am
Grant to follow the theme about poorly named products in your article about estimated execution plans. (http://www.cnet.com/pictures/25-worst-named-tech-products-pictures/24/[/url]). That has to be one of the worst webpage designs ever. It has a picture in the middle that looks like it needs to have vertical scrolling but the only actual scrolling is in the text that accompanies the picture. The upside is the text that explains the picture is cleverly hidden over on the right side where most site stick ads so that most of us just blindly ignore that section of website. Well done c/net. Oh wait...they make fun of all the other names that have strange punctuation in them yet strangely avoid their own name. Bah!!!
Ok back to my regularly scheduled work avoidance.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
January 28, 2016 at 10:54 am
Sean Lange (1/28/2016)
Grant to follow the theme about poorly named products in your article about estimated execution plans. (http://www.cnet.com/pictures/25-worst-named-tech-products-pictures/24/[/url]). That has to be one of the worst webpage designs ever. It has a picture in the middle that looks like it needs to have vertical scrolling but the only actual scrolling is in the text that accompanies the picture. The upside is the text that explains the picture is cleverly hidden over on the right side where most site stick ads so that most of us just blindly ignore that section of website. Well done c/net. Oh wait...they make fun of all the other names that have strange punctuation in them yet strangely avoid their own name. Bah!!!Ok back to my regularly scheduled work avoidance.
Okay, I clicked on it and I have agree that it's pretty horrid. It kind-of reminded me of the early days of <frameset> where people started putting everything in its own frame. I hated that almost as much as the <blink> HTML tag.
January 28, 2016 at 10:57 am
Ed Wagner (1/28/2016)
Sean Lange (1/28/2016)
Grant to follow the theme about poorly named products in your article about estimated execution plans. (http://www.cnet.com/pictures/25-worst-named-tech-products-pictures/24/[/url]). That has to be one of the worst webpage designs ever. It has a picture in the middle that looks like it needs to have vertical scrolling but the only actual scrolling is in the text that accompanies the picture. The upside is the text that explains the picture is cleverly hidden over on the right side where most site stick ads so that most of us just blindly ignore that section of website. Well done c/net. Oh wait...they make fun of all the other names that have strange punctuation in them yet strangely avoid their own name. Bah!!!Ok back to my regularly scheduled work avoidance.
Okay, I clicked on it and I have agree that it's pretty horrid. It kind-of reminded me of the early days of <frameset> where people started putting everything in its own frame. I hated that almost as much as the <blink> HTML tag.
Which was only made better when putting it in the scrolling marquee. 😀
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 15 posts - 52,411 through 52,425 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply