September 16, 2012 at 4:17 am
Hi all,
I am new to technology world, been in customer support, planing to move to technology, been thinking of doing a course in dba, sql dba,
I want to know the essentials , background technical knowledge required for a dba,
am i supposed to be good in
operating systems, troubleshooting etc
windows administration etc
please advice
thanks in advance
September 17, 2012 at 2:10 am
All of the above and more - don't forget people skills as you'll be liaising with business owners, budget holders, developers, data protection individuals and other database professionals.
I'm not sure the role of a DBA is so cut and dried as it used to but that will also depend on the organisation you work for.
:exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:
September 17, 2012 at 4:06 am
DBA is a huge job covering lots of different aspects of technology. For a good general description of the position, I'd suggest Craig Mullins book, Database Administration. It's a little old, but still shows the breadth of knowledge and the potential different positions very well. It's system agnostic and, as I said, old, so don't count on it as a mechanism for starting to learn the actual position. It just teaches about the discipline itself.
"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
September 25, 2012 at 9:37 pm
Okay, I have a couple of questions now, that have been confusing me,
what is the difference between a Sql developer or a programmer and a DBA, ( I often here terms like Index, cluster as part of the responsibility of both a Developer and a DBA , why does 2 people handle same issues? what the difference?, If any exists)
and In this age or future of Cloud computing , is it anywise to learn DBA at this juncture from the scratch? what does future hold for SQL DBA
Finally are there any online resources, websites where I can get a feel and hang of DBA, that can teach me the ABCs of sql dba
Please guide me
Thanks in advance.
September 26, 2012 at 3:26 am
Creating a clustered index is generally considered to be part of the work of designing a database. Who designs a database? There's no absolute, hard and fast rule on that. I started work as a developer and then moved into database administration. As a developer, I designed databases and built clustered indexes on the tables on those databases. As a DBA, with a lot more knowledge and experience, I designed databases and built clustered indexes on the tables on those databases. Both are right depending on the environment you're working in.
I don't know a single web site devoted to teaching DBA skills. There are the Stairway series here on SSC[/url]. They will teach you about SQL Server, but not so much about the job of DBA. I strongly recommend getting a copy of Craig Mullins book. To learn about the role of a DBA, I haven't seen a better resource.
"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
September 26, 2012 at 8:38 pm
So, it depends on the employer as to what irresponsibility he assigns to a dba, and a developer?
and whats the future of DBA with cloud computing and VM Ware soon emerging
September 26, 2012 at 9:45 pm
There are a lot of great free sources of information. This website is one of my favorites. Sign up for their daily newsletter and read it every day. Look for free webinars on SQL Server. Red Gate and Idera both have some really wonderful free webinars. Look for a SQL Saturday in your area - it's a fabulous free event, happening all over the world, bringing in SQL Server experts.
Here are a few of my favorite websites:
http://blog.sqlauthority.com/author/pinaldave/ - He's got a lot of great tips
http://www.sqlskills.com/blogs/kimberly/ - This site is well written and they cover many topics in depth - they have a lot of great people on their team.
http://www.brentozar.com/sql/ - this guy is a riot! He is funny and gives great information too!
Good luck and happy learning!
September 27, 2012 at 1:07 am
thanks a ton
September 27, 2012 at 4:41 am
Some other good sources:
Red-Gate's bookstore - lots of free PDFs full of useful stuff.
Microsoft has a few free e-books too at their %20SQL%20Server]TechNet E-Book Gallery
Thomas Rushton
blog: https://thelonedba.wordpress.com
September 27, 2012 at 10:12 am
Great , thank you all for being so helpful, but I would like to re iterate, that I am new to technology, though I know a bit of SQL..I'd therefore request that any such book recommendations be from a beginners point of view.
I still haven't found an answer to what would be the future of DbA, given VM ware is catching up.
September 27, 2012 at 11:16 am
I'd look on Amazon for SQL Server 2008 beginners. Here's one series that I've heard great things about. I met him at a SQL Saturday and he's knowledgable and easy to understand.
September 27, 2012 at 10:41 pm
latebloomerdba (9/26/2012)
So, it depends on the employer as to what irresponsibility he assigns to a dba, and a developer?and whats the future of DBA with cloud computing and VM Ware soon emerging
I'm one of those that believes that cloud computing makes a DBA even more necessary. Although the DBA may not have to do things like service packs and may not even need to do backups, a DBA can really cut costs by controlling what gets indexed, optimizing performance and resource usage of code using both indexes and by changing the code, and by controlling "waste reads" where people are simply asking for unnecessary data to be returned to do a job.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply