June 9, 2016 at 6:19 am
Brandie Tarvin (6/9/2016)
Ed Wagner (6/8/2016)
Lynn Pettis (6/8/2016)
Mention Dynamic SQL and suddenly that is THE solution for the immediate problem, but what problems may it cause down the road?Won't be surprised if we hear from that OP again later.
Not only is it THE solution to the immediate problem, but probably all future problems. Everyone's looking for the silver bullet that solves everything. They don't look at it as one tool in a toolbox. One tool to rule them all...
Dynamic SQL with NOLOCK!
Fixes all problems, even your clogged kitchen sink. @=)
I thought the kitchen sink had a blocking problem, not a locking problem. Locks don't cause this type of block...or do they? 😛
June 9, 2016 at 8:10 am
So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?
I realize that there are good use cases for both NoSQL and traditional RDBMS but when your whole knowledge base is in one area, it kind of feels like a gut punch. Oh well, I guess I ought to spin up a Linux instance on Azure and start playing (learning).
June 9, 2016 at 8:25 am
Y.B. (6/9/2016)
So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?I realize that there are good use cases for both NoSQL and traditional RDBMS but when your whole knowledge base is in one area, it kind of feels like a gut punch. Oh well, I guess I ought to spin up a Linux instance on Azure and start playing (learning).
That is a good question. Where does one even start to look into NoSQL?
Again, seriously. Because I've pretty much ignored all the NoSQL stuff on account of not currently using it at work.
June 9, 2016 at 8:28 am
Y.B. (6/9/2016)
So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?I realize that there are good use cases for both NoSQL and traditional RDBMS but when your whole knowledge base is in one area, it kind of feels like a gut punch. Oh well, I guess I ought to spin up a Linux instance on Azure and start playing (learning).
Ask why and explain that NoSQL is not a magic technology that will make things run faster.
June 9, 2016 at 8:32 am
Y.B. (6/9/2016)
So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?I realize that there are good use cases for both NoSQL and traditional RDBMS but when your whole knowledge base is in one area, it kind of feels like a gut punch. Oh well, I guess I ought to spin up a Linux instance on Azure and start playing (learning).
That you're curious - why?
Never bad to look at alternatives to see what they offer.
We always did some of this, if nothing else to see what was out there and validate the whole stack we were using was the best bang for the buck.
Converting a system is not a trivial task, and there is cost and risk involved.
Then maybe suggest a small test project to have a look.
June 9, 2016 at 9:15 am
Greg Edwards-268690 (6/9/2016)
Y.B. (6/9/2016)
So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?I realize that there are good use cases for both NoSQL and traditional RDBMS but when your whole knowledge base is in one area, it kind of feels like a gut punch. Oh well, I guess I ought to spin up a Linux instance on Azure and start playing (learning).
That you're curious - why?
Never bad to look at alternatives to see what they offer.
We always did some of this, if nothing else to see what was out there and validate the whole stack we were using was the best bang for the buck.
Converting a system is not a trivial task, and there is cost and risk involved.
Then maybe suggest a small test project to have a look.
What you said is pretty much what is happening. It's only an exercise right now to explore our options. That being said there is a strong case for it for our needs. Does that mean it will replace all of our DB's? No, I don't see that happening but it could become a strong focus. I guess I just shouldn't hit the panic button right now and look at it from a positive note. Having more skills on my resume isn't a bad thing. In fact I had a talk with my manager about my concerns after my initial post. He assured me that I'm not going anywhere regardless of the underlying technology. He's also willing to pay for training and certification.
June 9, 2016 at 9:16 am
Greg Edwards-268690 (6/9/2016)
Y.B. (6/9/2016)
So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?I realize that there are good use cases for both NoSQL and traditional RDBMS but when your whole knowledge base is in one area, it kind of feels like a gut punch. Oh well, I guess I ought to spin up a Linux instance on Azure and start playing (learning).
That you're curious - why?
Never bad to look at alternatives to see what they offer.
We always did some of this, if nothing else to see what was out there and validate the whole stack we were using was the best bang for the buck.
Converting a system is not a trivial task, and there is cost and risk involved.
Then maybe suggest a small test project to have a look.
In addition to needing to learn PostgreSQL in the near future (1 to 2 years) I shuld also look at learning MongoDB since both are being used in the next version of our lead product. Only problem I am deeply involved in supporting our current product running on SQL Server.
June 9, 2016 at 9:37 am
Y.B. (6/9/2016)
Greg Edwards-268690 (6/9/2016)
Y.B. (6/9/2016)
So what do you say when your boss announces in a meeting that 'we' should look into NoSQL? No really...what do you say?I realize that there are good use cases for both NoSQL and traditional RDBMS but when your whole knowledge base is in one area, it kind of feels like a gut punch. Oh well, I guess I ought to spin up a Linux instance on Azure and start playing (learning).
That you're curious - why?
Never bad to look at alternatives to see what they offer.
We always did some of this, if nothing else to see what was out there and validate the whole stack we were using was the best bang for the buck.
Converting a system is not a trivial task, and there is cost and risk involved.
Then maybe suggest a small test project to have a look.
What you said is pretty much what is happening. It's only an exercise right now to explore our options. That being said there is a strong case for it for our needs. Does that mean it will replace all of our DB's? No, I don't see that happening but it could become a strong focus. I guess I just shouldn't hit the panic button right now and look at it from a positive note. Having more skills on my resume isn't a bad thing. In fact I had a talk with my manager about my concerns after my initial post. He assured me that I'm not going anywhere regardless of the underlying technology. He's also willing to pay for training and certification.
I forgot to mention that. It's a good sign that your boss asks you to get involved with a new technology. It means that the intention is to keep current talent instead of hiring someone else.
With the good reasons to implement NoSQL, it could be a great opportunity.
June 9, 2016 at 11:10 am
< rant >
Geez people. Try answering the question we ask instead of just expecting us to answer your question with no effort on your part.
< /rant >
June 9, 2016 at 11:13 am
< different rant >
Repeating what you posted and providing NO explanation does not help with clarity.
< /different rant >
June 9, 2016 at 12:26 pm
Lynn Pettis (6/9/2016)
< different rant >Repeating what you posted and providing NO explanation does not help with clarity.
< /different rant >
Looks like Sean does have the crystal ball today.
June 9, 2016 at 12:35 pm
Lynn Pettis (6/9/2016)
< different rant >Repeating what you posted and providing NO explanation does not help with clarity.
< /different rant >
Don't worry, Lynn. If you ask again, they'll post the same thing again in the hopes that it makes it clear. 😉
June 9, 2016 at 12:38 pm
Lynn Pettis (6/9/2016)
Lynn Pettis (6/9/2016)
< different rant >Repeating what you posted and providing NO explanation does not help with clarity.
< /different rant >
Looks like Sean does have the crystal ball today.
Not anymore. I used its magical powers. It is now in somebody else's unsuspecting hands to be determined when it is least expected.
_______________________________________________________________
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/
June 9, 2016 at 1:09 pm
Lynn Pettis (6/9/2016)
< different rant >Repeating what you posted and providing NO explanation does not help with clarity.
< /different rant >
Perfectly valid (it seems) exercise in politics 😀
😎
Viewing 15 posts - 54,526 through 54,540 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply