SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


new to DBA an dtechnology


new to DBA an dtechnology

Author
Message
latebloomerdba
latebloomerdba
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 23
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
Robin Sasson
Robin Sasson
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1117 Visits: 530
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
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)

Group: General Forum Members
Points: 96049 Visits: 33013
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

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
latebloomerdba
latebloomerdba
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 23
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.
Grant Fritchey
Grant Fritchey
SSC Guru
SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)SSC Guru (96K reputation)

Group: General Forum Members
Points: 96049 Visits: 33013
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. 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

The Scary DBA
Author of: SQL Server Query Performance Tuning and SQL Server Execution Plans
Product Evangelist for Red Gate Software
latebloomerdba
latebloomerdba
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 23
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
Elizabeth.Block
Elizabeth.Block
Say Hey Kid
Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)

Group: General Forum Members
Points: 712 Visits: 702
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://www.mssqltips.com/
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!
latebloomerdba
latebloomerdba
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 23
thanks a ton
Thomas Rushton
Thomas Rushton
SSCertifiable
SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)SSCertifiable (6.1K reputation)

Group: Moderators
Points: 6098 Visits: 4133
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
latebloomerdba
latebloomerdba
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 23
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search