new to DBA an dtechnology

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » new to DBA an dtechnology

12 posts, Page 1 of 2

1 2 »»

new to DBA an dtechnology

Rate Topic

Display Mode

Topic Options

Author

Message

latebloomerdba

Posted Sunday, September 16, 2012 4:17 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 03, 2012 10:25 PM
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

Post #1359876

Robin Sasson

Posted Monday, September 17, 2012 2:10 AM

Say Hey Kid

Group: General Forum Members
Last Login: Monday, February 18, 2013 6:17 AM
Points: 674, Visits: 472

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

Post #1360021

Grant Fritchey

Posted Monday, September 17, 2012 4:06 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 2:58 PM
Points: 13,381, Visits: 25,172

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1360071

latebloomerdba

Posted Tuesday, September 25, 2012 9:37 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 03, 2012 10:25 PM
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.

Post #1364411

Grant Fritchey

Posted Wednesday, September 26, 2012 3:26 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 2:58 PM
Points: 13,381, Visits: 25,172

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1364518

latebloomerdba

Posted Wednesday, September 26, 2012 8:38 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 03, 2012 10:25 PM
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

Post #1365007

Elizabeth.Block

Posted Wednesday, September 26, 2012 9:45 PM

Valued Member

Group: General Forum Members
Last Login: Monday, May 13, 2013 9:43 AM
Points: 67, Visits: 426

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!

Post #1365019

latebloomerdba

Posted Thursday, September 27, 2012 1:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 03, 2012 10:25 PM
Points: 5, Visits: 23

thanks a ton

Post #1365056

ThomasRushton

Posted Thursday, September 27, 2012 4:41 AM

SSC Eights!

Group: General Forum Members
Last Login: Monday, May 20, 2013 8:40 AM
Points: 966, Visits: 373

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

Post #1365135

latebloomerdba

Posted Thursday, September 27, 2012 10:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, October 03, 2012 10:25 PM
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.

Post #1365370

« Prev Topic | Next Topic »

12 posts, Page 1 of 2

1 2 »»

Permissions