January 28, 2016 at 12:27 pm
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
I have worked with Azure SQL and AWS for a little more than a year now (AWS more than Azure).
What I like about Azure is, if you've worked with Microsoft SQL Server or other Microsoft Enterprise products, it's pretty easy to find your way around and do what you need to do. What I hate about Azure SQL & Azure SQL Data Warehouse is the limitations, specifically the T-SQL limitations.
On the AWS side I have worked with RDS/SQL Server and AWS Redshift. RDS with SQL Server runs great without the limitations you have in Azure SQL.
AWS Redshift is Amazing once you get it setup. It's a Postgresql/Columnstore-based data warehouse and it's nasty fast. For the ETL I used the AWS data pipeline which works nicely once setup but has a terribly clunky web-based interface. That's my only complaint with AWS: the web-based interface needs a lot of work IMHO. I frequently find myself saying, "That's how you <perform some simple task>?!?!? Really? C'mon!!!"
That's my $0.02.
-- Itzik Ben-Gan 2001
January 28, 2016 at 12:36 pm
Alan.B (1/28/2016)
What I hate about Azure SQL & Azure SQL Data Warehouse is the limitations, specifically the T-SQL limitations.
Which ones?
I ask because, for the Azure SQLDB side, most of the T-SQL limitations have gone away in the last few updates. DW still has plenty, but they're rooted in the distributed architecture and the earthed version of the Azure SQLDW has them too.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 28, 2016 at 3:30 pm
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....
I would have to say that is one the best add-ons out there. It has saved me many times due to SSMS instability.
I would rate tab history as THE #1 must have add-on from RedGate. That said, SQL Prompt rocks too.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 28, 2016 at 7:41 pm
SQLRNNR (1/28/2016)
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....
I would have to say that is one the best add-ons out there. It has saved me many times due to SSMS instability.
I would rate tab history as THE #1 must have add-on from RedGate. That said, SQL Prompt rocks too.
Thanks to the both of you for the recommendation. I'm not motivated to check it out.
I've checked out several different SSMS add-ins before and have been completely unimpressed. I've never tried any of the paid ones because the ones I've tried were lame. I genuinely hope this one changes my mind.
January 29, 2016 at 1:20 am
Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?
January 29, 2016 at 1:43 am
BL0B_EATER (1/29/2016)
Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?
Always for me. I guess I'm a bit unique from the others here who have worked specifically in one or two similar fields for a longer time than me. I've worked in software development (video game development specifically) for 7 years prior to my big switch into marketing, where I switched into a data specific role (career change and industry change for me).
My switch from video games to non-video games was because I was burnt out of video game development and publishing. I was tired of having to face layoffs after each project completion. This ignited the idea of switching careers year-after-year.
3 years into the new industry and career, I still think about other things all the time. Like starting my own business in something non-IT related. Maybe going more management/leadership role for a new startup and so forth.
I think these thoughts are pretty normal. I've met amazing IT people who seemed they will never change careers. The people who would likely be the last guys in the office who turn the lights out when everyone is gone. But, that's not everyone. Dreaming keeps you alive.
January 29, 2016 at 1:51 am
xsevensinzx (1/29/2016)
BL0B_EATER (1/29/2016)
Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?Always for me. I guess I'm a bit unique from the others here who have worked specifically in one or two similar fields for a longer time than me. I've worked in software development (video game development specifically) for 7 years prior to my big switch into marketing, where I switched into a data specific role (career change and industry change for me).
My switch from video games to non-video games was because I was burnt out of video game development and publishing. I was tired of having to face layoffs after each project completion. This ignited the idea of switching careers year-after-year.
3 years into the new industry and career, I still think about other things all the time. Like starting my own business in something non-IT related. Maybe going more management/leadership role for a new startup and so forth.
I think these thoughts are pretty normal. I've met amazing IT people who seemed they will never change careers. The people who would likely be the last guys in the office who turn the lights out when everyone is gone. But, that's not everyone. Dreaming keeps you alive.
That's interesting. I think I am starting to walk on a slippery path, you mentioned dreams / goals etc. Well I had 1 and 2 weeks ago it splattered with no real indication of why hence my question. I guess I need to find new goals to pursue to keep me going.
January 29, 2016 at 3:02 am
BrainDonor (1/29/2016)
SQLPass in Manchester (UK) have a meeting on Wednesday 3rd. Will anybody from this place be there?
I wont be. But I will be in London June for IE2. If anyone from here is going please say hello. You cant miss me. I look like a hybrid of satya nadella and jabba the hut....
January 29, 2016 at 4:00 am
The discussion about AWS/Azure - I've just had this link sent to me, which may interest UK people - free all-day AWS presentations.
January 29, 2016 at 5:03 am
BL0B_EATER (1/29/2016)
Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?
Why yes. That's why I write.
And why I dream of being an Academy Award / Oscar winning actress even though I haven't done professional work in over twenty years.
EDIT: I should also mention that I came to IT late. Only been in it for 12 years now. My previous career was in retail / customer service.
January 29, 2016 at 5:15 am
BrainDonor (1/29/2016)
SQLPass in Manchester (UK) have a meeting on Wednesday 3rd. Will anybody from this place be there?
No, but I will be about the Southampton UG that night - so I guess a virtual wave from one UG to another then!
Rodders...
January 29, 2016 at 5:16 am
BL0B_EATER (1/29/2016)
Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?
Definitely, I'd love to earn a living from food somehow. I've got a background in catering but I got fed up of working like a dog to make money for other people. I'd happily work every hour God sends to make the best bread or barbecue I could if I was seeing the results.
How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537
January 29, 2016 at 5:25 am
BWFC (1/29/2016)
BL0B_EATER (1/29/2016)
Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?Definitely, I'd love to earn a living from food somehow. I've got a background in catering but I got fed up of working like a dog to make money for other people. I'd happily work every hour God sends to make the best bread or barbecue I could if I was seeing the results.
If I had to pick an industry other than IT, food would have to be it for me as well. I enjoy cooking, coming up with new and cool recipes, experimenting and making people happy with food. The points you raise, BWFC, are completely valid. Chefs work loads of hours and other people make all the money. It isn't until you get to restaurant ownership where you get to make real money, and by that time it's about the business end instead of the food.
Honestly, I think I'm doing what I'm supposed to be doing. I actually enjoy what I do for a living. It's something I can continue to do as I get older and age isn't seen as a detriment - it's seen as valuable.
January 29, 2016 at 5:58 am
BL0B_EATER (1/29/2016)
Have you guys during your careers ever thought about doing something else in life.. as opposed to IT / SQL Server / Coding etc etc?
Absolutely. I had some rough on-call weeks that had me preaching to my kids (7th and 5th grade) to go into a field that does not have on-call responsibilities. Also had me thinking I'm too old for this shiz, after being in different IT roles over the past 25+ years and being on-call for 20 of those years. I volunteer at my sons' school and think teaching would be an option. I also coach youth baseball, wish I could make a career out of that. Dream job would be a professional snowboarder, but as a backup I want to move to Utah or Colorado and become a snowboard instructor.
Meanwhile, I am on-call this week at my new employer (started in early December) and have received just 2 calls over the past 2 nights. At my previous employer I would have received at least 15-20 calls over the past 2 nights. So maybe this is the one...
Viewing 15 posts - 52,426 through 52,440 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply