February 22, 2016 at 5:17 pm
Jeff Moden (2/22/2016)
No need to pile on but here's another example of a "DBA" like the ones I've been interviewing. I wonder if he knows how to get the current date and time in T-SQL? Certainly, there's near zero intellectual curiosity on this person's part.http://www.sqlservercentral.com/Forums/FindPost1762990.aspx
Like I said, no need to pile on. Just be silently amazed that people like this feel slighted if you don't offer them a job as a DBA making 6 figures.
I have been doing DBA work for nearly 20 years and I have just recently reached where I make 6 figures, barely. Add in the cost of benefits I don't pay and it goes up a bit more.
Do I think I am worth more, of course. I also know that there are parts of SQL Server I don't know because I am not in an environment that uses these parts of SQL Server. Yes, I have created POC or sandbox environments on occasion, but that doesn't mean I know them as well as someone who is working with them on a daily basis. Difference is that I can learn these areas.
February 22, 2016 at 7:55 pm
Jeff Moden (2/22/2016)
No need to pile on but here's another example of a "DBA" like the ones I've been interviewing. I wonder if he knows how to get the current date and time in T-SQL? Certainly, there's near zero intellectual curiosity on this person's part.http://www.sqlservercentral.com/Forums/FindPost1762990.aspx
Like I said, no need to pile on. Just be silently amazed that people like this feel slighted if you don't offer them a job as a DBA making 6 figures.
All they need is right there, and they still need someone to hand them a script.
I envision a frozen pork chop launched at excessive speed.
Question is - does it impact heavily charred, or completely vaporizes before impact?
February 22, 2016 at 9:11 pm
Greg Edwards-268690 (2/22/2016)
Jeff Moden (2/22/2016)
No need to pile on but here's another example of a "DBA" like the ones I've been interviewing. I wonder if he knows how to get the current date and time in T-SQL? Certainly, there's near zero intellectual curiosity on this person's part.http://www.sqlservercentral.com/Forums/FindPost1762990.aspx
Like I said, no need to pile on. Just be silently amazed that people like this feel slighted if you don't offer them a job as a DBA making 6 figures.
All they need is right there, and they still need someone to hand them a script.
I envision a frozen pork chop launched at excessive speed.
Question is - does it impact heavily charred, or completely vaporizes before impact?
People like that aren't even worth the effort to cock the launcher never mind waste a perfectly good pork chop. I just don't understand how people can take their livelihood so lightly. It's just not that difficult. People want a "Work/Life Balance"... I'm thinking a whole lot of people out there need to adjust the fulcrum a bit.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 23, 2016 at 5:30 am
^ It goes back to the old proverb I threw out in another thread... Give a man a fish, he eats for a day. Teach a man how to fish, he eats for a lifetime. You gave him a fishing rod and pointed to the lake. He needs to figure out the rest.
Seems like too many people want others to create a solution for them.
February 23, 2016 at 5:36 am
Jeff Moden (2/22/2016)
Like I said, no need to pile on. Just be silently amazed that people like this feel slighted if you don't offer them a job as a DBA making 6 figures.
I agree with Lynn. Been doing this for a while now and still do not make a lot. I know there are many things I have yet to learn, and with my poor memory, I need to use something many times before I remember it. 🙂
But if someone suggested I look at a couple of tables and even tells me what to join on, at a minimum I would come back with T-SQL code to ask what I did wrong.
February 23, 2016 at 5:38 am
Jeff Moden (2/22/2016)
Greg Edwards-268690 (2/22/2016)
Jeff Moden (2/22/2016)
No need to pile on but here's another example of a "DBA" like the ones I've been interviewing. I wonder if he knows how to get the current date and time in T-SQL? Certainly, there's near zero intellectual curiosity on this person's part.http://www.sqlservercentral.com/Forums/FindPost1762990.aspx
Like I said, no need to pile on. Just be silently amazed that people like this feel slighted if you don't offer them a job as a DBA making 6 figures.
All they need is right there, and they still need someone to hand them a script.
I envision a frozen pork chop launched at excessive speed.
Question is - does it impact heavily charred, or completely vaporizes before impact?
People like that aren't even worth the effort to cock the launcher never mind waste a perfectly good pork chop. I just don't understand how people can take their livelihood so lightly. It's just not that difficult. People want a "Work/Life Balance"... I'm thinking a whole lot of people out there need to adjust the fulcrum a bit.
I absolutely want a work/life balance. My balance, however, is not "do nothing" or "skate by doing as little as possible" in any area of life. If I do that, why participate at all? If something's worth doing, it's worth doing well.
"Do or do not...there is no try." -Yoda
February 23, 2016 at 5:40 am
Grumpy DBA (2/23/2016)
^ It goes back to the old proverb I threw out in another thread... Give a man a fish, he eats for a day. Teach a man how to fish, he eats for a lifetime. You gave him a fishing rod and pointed to the lake. He needs to figure out the rest.Seems like too many people want others to create a solution for them.
Some people have reinterpreted a part of the proverb to be "Teach a man to fish and he'll sit in a boat and drink beer all day." It's sad, but it looks like there's a lot of people in boats.
February 23, 2016 at 5:48 am
djj (2/23/2016)
Jeff Moden (2/22/2016)
Like I said, no need to pile on. Just be silently amazed that people like this feel slighted if you don't offer them a job as a DBA making 6 figures.I agree with Lynn. Been doing this for a while now and still do not make a lot. I know there are many things I have yet to learn, and with my poor memory, I need to use something many times before I remember it. 🙂
But if someone suggested I look at a couple of tables and even tells me what to join on, at a minimum I would come back with T-SQL code to ask what I did wrong.
I glanced at that topic and *so* wanted to jump in. Frankly, if the fellow had indicated that he got thrown into the spot, had no clue, their DBA had just walked out the door, and the bosses were demanding this information now, I might be more inclined to help.
But this read as Jeff indicated, "I'm not interested in knowing how to do this myself, give me the answer."
Fie on that, figure it out yourself or get canned, it's not my circus, not my monkeys...
As for the pay thing, from the general tone it sounds like I'm in the zone for a well-paid DBA (upper end of 5 figures,) which to be honest *I* don't feel I'm that good (but my employer apparently does, so there's that.) I *know* there are plenty of things I don't know in SQL (I'm more of a "keep the servers running" DBA, not a developer, and *don't* ask me to whip up an SSIS package or SSRS report (yet)).
February 23, 2016 at 5:50 am
Grumpy DBA (2/23/2016)
^ It goes back to the old proverb I threw out in another thread... Give a man a fish, he eats for a day. Teach a man how to fish, he eats for a lifetime. You gave him a fishing rod and pointed to the lake. He needs to figure out the rest.Seems like too many people want others to create a solution for them.
Yeah but teach 'em how to fish and then they need a rod, a reel, lures & bait, a beer cooler, a boat, a SUV to pull the boat around...
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden
February 23, 2016 at 5:56 am
Anyone? http://www.sqlservercentral.com/Forums/Topic1763388-2799-1.aspx
It's not SQL Server (the UNIQUE gives that away at the least). I don't know what it is, and the OP keeps posting questions here that turn out to be MS Access or Informix or other.
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
February 23, 2016 at 6:08 am
Jeff Moden (2/22/2016)
No need to pile on but here's another example of a "DBA" like the ones I've been interviewing. I wonder if he knows how to get the current date and time in T-SQL? Certainly, there's near zero intellectual curiosity on this person's part.http://www.sqlservercentral.com/Forums/FindPost1762990.aspx
Like I said, no need to pile on. Just be silently amazed that people like this feel slighted if you don't offer them a job as a DBA making 6 figures.
I once had a C++ programmer with very little knowledge of SQL and certainly no experence at all as a DBA or database developer who, when he was faced with exactly that problem, asked for help and was told "Use books online. Look at system tables to do with jobs" and had working T-SQL about 20 minutes later. And he wasn't payed anything near 6 figures.
The thing about people who won't put in the effort to learn to do what their job needs is that they are often pretty good at toadying up to technically unaware management so it's extremely important to avoid hiring them.
Tom
February 23, 2016 at 6:21 am
GilaMonster (2/23/2016)
Anyone? http://www.sqlservercentral.com/Forums/Topic1763388-2799-1.aspxIt's not SQL Server (the UNIQUE gives that away at the least). I don't know what it is, and the OP keeps posting questions here that turn out to be MS Access or Informix or other.
I'll give it a go. The thing that threw me was the archive: in the FROM clause. I've never seen that before, but my Oracle knowledge is a bit out of date.
February 23, 2016 at 8:12 am
Any XML gurus out there who would like to help?
http://www.sqlservercentral.com/Forums/Topic1763386-3412-1.aspx
--Edit: fixed garbage English!
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
February 23, 2016 at 8:22 am
GilaMonster (2/23/2016)
Anyone? http://www.sqlservercentral.com/Forums/Topic1763388-2799-1.aspxIt's not SQL Server (the UNIQUE gives that away at the least). I don't know what it is, and the OP keeps posting questions here that turn out to be MS Access or Informix or other.
It's aggravating he can't answer a simple question like what platform he's using but regardless the HAVING clause isn't valid SQL on any platform that I can think of.
February 23, 2016 at 8:22 am
Phil Parkin (2/23/2016)
Any XML gurus out there who would like to help?http://www.sqlservercentral.com/Forums/Topic1763386-3412-1.aspx
--Edit: fixed garbage English!
Heh... good grief. 1500 nodes. And it's not flat. It does contain a hierarchy. I've got some old code somewhere that will at least tell you what the hierarchy of the nodes is and produce some code to parse it but it's buggy on complex stuff because the reason why I wrote it is I hate XML and didn't want to learn much about it. 😉
I don't know where the code is but I'll take a look for it tonight. No guarantees, though. It's been a couple of years since I've even opened the code, never mind used it.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 15 posts - 52,846 through 52,860 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply