October 1, 2015 at 6:17 pm
I am brand new to the world of DBAs and I have found myself thrown in the ring with a new installation of SQL Server 2014 at my new job. Does anyone have any ideas where I should start as far as learning, tutorial, resources to tackle this beast. I have start from the ground floor and build up.
Thank you
Art Lorenzini
Warm Regards,
Art Lorenzini
Sioux Falls, SD
October 1, 2015 at 7:51 pm
Searching for "accidental DBA" on Google provides a wealth of information and resources. Here are a couple of good ones.
http://www.johnsansom.com/how-to-become-a-sql-server-dba/
http://www.brentozar.com/archive/2013/07/announcing-our-free-accidental-dba-6-month-training-plan/
http://www.sqlservercentral.com/Books/
--Jeff Moden
Change is inevitable... Change for the better is not.
October 2, 2015 at 4:18 am
Don't forget about all the "Stairways" series of articles listing over on the left of this screen.
"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 2, 2015 at 9:10 am
Thank you for these resources I will start looking at them right away.
Warm Regards,
Art Lorenzini
Sioux Falls, SD
October 2, 2015 at 9:17 am
Hi Art,
Just out of curiosity, is there no one else in your organization who knows a thing about SQL Server, or did the previous DBA pack up and leave? In addition to assuming the administration role, are you also installing SQL Server from scratch and building the database too, or did a vendor show up and drop off a shiny new server box with everything ready to go? I know this situation happens all the time, but I'm just wondering how someone suddenly get's themselves into this position. 🙂
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 2, 2015 at 9:50 am
The previous DBA left in not so good of terms and took his knowledge base with him. Since I had some Access experience management put two and two together and said I was a natural fit. We are a small organization that runs a Housing Authority on the Cheyenne River Sioux Tribe Reservation in South Dakota USA.
He left us with a mixture of different tables in which we were using to track our unit information. After doing some research (Google) I told them there were a number of 3rd party property management and housing application out there but they want there own in-house developed application. The SQL Server also houses our Financial package which is Microsoft Dynamics (now that is a beast).
Like I was reading in one the links from earlier in the thread.. and accidental DBA.
So yeah! Ground up... :):w00t:
Warm Regards,
Art Lorenzini
Sioux Falls, SD
October 2, 2015 at 9:54 am
If you have questions or hit snags along the way, you know where to go.
Best of luck.
"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 2, 2015 at 10:00 am
Thank you. I have a feeling you will get sick of me before too long.
Warm Regards,
Art Lorenzini
Sioux Falls, SD
October 2, 2015 at 10:08 am
alorenzini 26244 (10/2/2015)
Thank you. I have a feeling you will get sick of me before too long.
Believe or not, there are a lot of folks here who actually enjoy answering questions. It's intellectually stimulating to work through a problem unrelated to our own day job, and we love hearing from someone that our suggestions worked.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 8, 2015 at 1:26 pm
If you are THAT green look into the 5 day SQL Server DBA class from a Microsoft certified training facility. On youtube there are some good step by step videos of installing SQL Server as well by some professionals.
October 8, 2015 at 1:49 pm
Markus (10/8/2015)
If you are THAT green look into the 5 day SQL Server DBA class from a Microsoft certified training facility. On youtube there are some good step by step videos of installing SQL Server as well by some professionals.
Ha! The other day someone asked me what special degree or training you need to get a job working as a database administrator. I told them all it takes to get the job is to be standing next to the server room when the DBA quits or gets pushed in front of a bus.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho
October 8, 2015 at 2:47 pm
http://www.red-gate.com/community/books/accidental-dba
It was written for 2008, so a little out of date, but still very good.
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
October 12, 2015 at 1:29 pm
I would say to definitely ask here first if you have any doubts. In my opinion you should prioritise learning about backup and restore, particularly checking that you actually have SQL backups and server backups available. Check the recovery model of the databases, any that are in full will need transaction log backups and any in simple will need to be questioned as to whether simple is good enough?
Sorry if I've raised more questions than I've answered but this would be my priority initially, I'm happy to go in to more detail on any of the above if required?
Andrew Mansell
sqlmansell.com Useful everyday hints and tips for SQL Server
Twitter: @sqlmansell
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply