October 24, 2018 at 1:54 pm
Okay. I had my annual review yesterday, and it was good. Also had a discussion about changes in the group that I am currently in. The gist of the discussion came down to what do I want to do, become a tester basically and leave SQL Server behind or do they start looking to see if they can find me a new home in the company. Our corporate IT uses SQL Server extensively and they don't have a dedicated DBA (the last one got fired and not replaced).
This also means I shouldn't just sit back and see what happens here, so it looks like I am going to have to start opening up an active job search as well. The only hard part is that I am not in a position to move. I am the only family my dad has and he is dependent (not a dependent) on me especially since he can no longer driver. One, his drivers license expired while he was in the hospital/long term care facility when his femur broke last November. And two, he gave me his car to give to my daughter in Virginia.
With his health the way it is I need to stay here.
Too bad there aren't too many jobs for remote workers (especially that pay what I currently make) as that would be a great alternative.
October 24, 2018 at 2:04 pm
Lynn Pettis - Wednesday, October 24, 2018 1:54 PMOkay. I had my annual review yesterday, and it was good. Also had a discussion about changes in the group that I am currently in. The gist of the discussion came down to what do I want to do, become a tester basically and leave SQL Server behind or do they start looking to see if they can find me a new home in the company. Our corporate IT uses SQL Server extensively and they don't have a dedicated DBA (the last one got fired and not replaced).This also means I shouldn't just sit back and see what happens here, so it looks like I am going to have to start opening up an active job search as well. The only hard part is that I am not in a position to move. I am the only family my dad has and he is dependent (not a dependent) on me especially since he can no longer driver. One, his drivers license expired while he was in the hospital/long term care facility when his femur broke last November. And two, he gave me his car to give to my daughter in Virginia.
With his health the way it is I need to stay here.
Too bad there aren't too many jobs for remote workers (especially that pay what I currently make) as that would be a great alternative.
Good luck finding something, Lynn. I don't know what the job situation is where you live, but I saw that Colorado Springs recently announced their SQL Saturday. You may be able to get some contacts from the PASS chapter meetings, which I've heard you know something about. 😉
To make sure I have it straight, corporate uses SQL Server and no longer has DBA. Is that something that interests you? At least ask if it's a possibility and remember that "the answer is always no unless you ask".
October 24, 2018 at 2:16 pm
Ed Wagner - Wednesday, October 24, 2018 2:04 PMLynn Pettis - Wednesday, October 24, 2018 1:54 PMOkay. I had my annual review yesterday, and it was good. Also had a discussion about changes in the group that I am currently in. The gist of the discussion came down to what do I want to do, become a tester basically and leave SQL Server behind or do they start looking to see if they can find me a new home in the company. Our corporate IT uses SQL Server extensively and they don't have a dedicated DBA (the last one got fired and not replaced).This also means I shouldn't just sit back and see what happens here, so it looks like I am going to have to start opening up an active job search as well. The only hard part is that I am not in a position to move. I am the only family my dad has and he is dependent (not a dependent) on me especially since he can no longer driver. One, his drivers license expired while he was in the hospital/long term care facility when his femur broke last November. And two, he gave me his car to give to my daughter in Virginia.
With his health the way it is I need to stay here.
Too bad there aren't too many jobs for remote workers (especially that pay what I currently make) as that would be a great alternative.
Good luck finding something, Lynn. I don't know what the job situation is where you live, but I saw that Colorado Springs recently announced their SQL Saturday. You may be able to get some contacts from the PASS chapter meetings, which I've heard you know something about. 😉
To make sure I have it straight, corporate uses SQL Server and no longer has DBA. Is that something that interests you? At least ask if it's a possibility and remember that "the answer is always no unless you ask".
That is something they are going to look at and is an option I am open to taking as I would like to stay with my current company. I just don't want to wait until I find out there is no "new home" to start looking else where. Especially since it has been a while (several months if not longer) that the other DBA was let go. They may not be interested in another DBA at this time. Of course I did help save them money when an errant update erroneously updated 39000+ rows (over a 11 years of data) of data back in July. The system administrator did come up with a solution, just couldn't execute it due to a very limited knowledge of SQL Server and T-SQL.
October 24, 2018 at 2:17 pm
Lynn Pettis - Wednesday, October 24, 2018 2:16 PMEd Wagner - Wednesday, October 24, 2018 2:04 PMLynn Pettis - Wednesday, October 24, 2018 1:54 PMOkay. I had my annual review yesterday, and it was good. Also had a discussion about changes in the group that I am currently in. The gist of the discussion came down to what do I want to do, become a tester basically and leave SQL Server behind or do they start looking to see if they can find me a new home in the company. Our corporate IT uses SQL Server extensively and they don't have a dedicated DBA (the last one got fired and not replaced).This also means I shouldn't just sit back and see what happens here, so it looks like I am going to have to start opening up an active job search as well. The only hard part is that I am not in a position to move. I am the only family my dad has and he is dependent (not a dependent) on me especially since he can no longer driver. One, his drivers license expired while he was in the hospital/long term care facility when his femur broke last November. And two, he gave me his car to give to my daughter in Virginia.
With his health the way it is I need to stay here.
Too bad there aren't too many jobs for remote workers (especially that pay what I currently make) as that would be a great alternative.
Good luck finding something, Lynn. I don't know what the job situation is where you live, but I saw that Colorado Springs recently announced their SQL Saturday. You may be able to get some contacts from the PASS chapter meetings, which I've heard you know something about. 😉
To make sure I have it straight, corporate uses SQL Server and no longer has DBA. Is that something that interests you? At least ask if it's a possibility and remember that "the answer is always no unless you ask".
That is something they are going to look at and is an option I am open to taking as I would like to stay with my current company. I just don't want to wait until I find out there is no "new home" to start looking else where. Especially since it has been a while (several months if not longer) that the other DBA was let go. They may not be interested in another DBA at this time. Of course I did help save them money when an errant update erroneously updated 39000+ rows (over a 11 years of data) of data back in July. The system administrator did come up with a solution, just couldn't execute it due to a very limited knowledge of SQL Server and T-SQL.
Looks like I will be doing a deep dive to finally get my Security+ certification.
October 24, 2018 at 3:56 pm
Lynn Pettis - Wednesday, October 24, 2018 2:17 PMLooks like I will be doing a deep dive to finally get my Security+ certification.
Ugh. When you get it, don't forget to also fork over the $150 (spread over 3 years or all at once) "Continuing Education" fees AND keep track of everything that can be counted towards the required 50 "Continuing Education Units" or you'll have to re-take the exam...
Yeah. Basically every 3 years you're paying the equivalent of the cost of the exam...
I really don't like that the Sec+ is required for me...
Also, good hunting on the job search!
October 24, 2018 at 4:02 pm
Ah the fun of finding a problem that a Dev says is the SQL Server...
And it's not.
Dev cloned an existing query to use a read-only account and the query was failing with an access denied.
He figured it was on my end, I figured it might be something with the query, maybe trying to hit a table the account didn't have access to...
Well, we were both kind of right. He *was* trying to hit tables that the account didn't have access to, because said tables had the same NAMES but not the same SCHEMA as some views the account has access to...
So, simple change on his end and we're both happy and I took off for lunch.
(and, if you thought I came back from lunch to a problem still? Nope.)
October 25, 2018 at 1:07 am
Some really bad advice:pinch:
😎
October 25, 2018 at 1:14 am
Eirikur Eiriksson - Thursday, October 25, 2018 1:07 AM
Are you trying to tell us that REPAIR_ALLOW_DATA_LOSS doesn't fix every problem? Well, I learned something new...
October 25, 2018 at 1:28 am
BrainDonor - Thursday, October 25, 2018 1:14 AMEirikur Eiriksson - Thursday, October 25, 2018 1:07 AMAre you trying to tell us that REPAIR_ALLOW_DATA_LOSS doesn't fix every problem? Well, I learned something new...
REPAIR_ALLOW_DATA_LOSS is only applicable if one is standing in high heals, on one foot, on the top of a lamp post, with a champagne in one hand and a faulty backup tape in the other.
😎
October 25, 2018 at 1:31 am
And he is at it again.
😎
Someone really needs to "repair" this poster.
October 25, 2018 at 2:25 am
Michael L John - Wednesday, October 24, 2018 10:27 AMWe let a new employee go today.
He was hired as a middle level person. He did very well on the "personality" scale during the interviews with 6 different people. He did excellent on the technical interview that I did with him. The technical interview was simple, yet contained enough grey areas to determine if he "thought correctly".From day one, everything he did was incorrect and had to be re-done.
On his second day, he performed a refresh to dev from production. This process was explained, and he was shown the documentation of the process. He proceeded to run the process with the defaults, and overwrote 21 databases on dev from production.We coached him, and made it clear that we would rather have him say he didn't know how to do something as opposed to doing something that was a guess on his part. We followed through, he seemed to understand.
Bam! Next morning, he did exactly the same thing we asked him not to do because he did not understand the process and the potential ramifications.He never tried to learn what to do, how it worked, or what the ramifications may have been. He simply did a google search, and whatever he found, he did. At one point, his supervisor told him to stop googling and go ask Mike because I have the answers. He never came to me for anything. I had to seek him out daily.
His entire set of work was trial and error. He was above asking folks who were at a lower level than he was.It seems like there are far too many posts these days that fit this same pattern. And far too many people who can be given resources, who never seem to use them.
Nuts. That's rough. Sorry you went through that. I remember a person who aced the technical interview we gave them. Then, we put them in front of a computer and they had no idea how to operate it. They had read a book and memorized enough of it to answer questions, but they didn't actually know what they were doing at all. It was the weirdest thing.
"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
October 25, 2018 at 4:38 am
Lynn Pettis - Wednesday, October 24, 2018 1:54 PMOkay. I had my annual review yesterday, and it was good. Also had a discussion about changes in the group that I am currently in. The gist of the discussion came down to what do I want to do, become a tester basically and leave SQL Server behind or do they start looking to see if they can find me a new home in the company. Our corporate IT uses SQL Server extensively and they don't have a dedicated DBA (the last one got fired and not replaced).This also means I shouldn't just sit back and see what happens here, so it looks like I am going to have to start opening up an active job search as well. The only hard part is that I am not in a position to move. I am the only family my dad has and he is dependent (not a dependent) on me especially since he can no longer driver. One, his drivers license expired while he was in the hospital/long term care facility when his femur broke last November. And two, he gave me his car to give to my daughter in Virginia.
With his health the way it is I need to stay here.
Too bad there aren't too many jobs for remote workers (especially that pay what I currently make) as that would be a great alternative.
Allstate allows its IT people to work from home. You may need to occasionally travel to the home office, but you can work remote.
https://www.allstate.com/careers.aspx and https://jobsearch.allstate.com
October 25, 2018 at 4:40 am
Lynn Pettis - Wednesday, October 24, 2018 2:17 PMLooks like I will be doing a deep dive to finally get my Security+ certification.
Is that the same or different from CISSP?
October 25, 2018 at 7:56 am
Brandie Tarvin - Thursday, October 25, 2018 4:40 AMLynn Pettis - Wednesday, October 24, 2018 2:17 PMLooks like I will be doing a deep dive to finally get my Security+ certification.Is that the same or different from CISSP?
Not as intense as the CISSP. Most government positions I am looking at require the Security+ for DBA and is really a DOD requirement. If I were a System Administrator getting the CISSP would be extremely desired, and depending on what needs to be done on the government networks.
My employer has said I should get the Security+ certification but wasn't required.
October 25, 2018 at 10:03 am
Wow, just wow, I just got a notice about Microsoft has finally improved the error "Binary or string data would be truncated"
This feature is shipped in SQLServer 2017 CU12, SQL Server 2019 CTPand upcoming SQL Server 2016 CP2 CU. Read more at https://blogs.msdn.microsoft.com/sql_server_team/string-or-binary-data-would-be-truncated-replacing-the-infamous-error-8152/
Viewing 15 posts - 62,746 through 62,760 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply