Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

new to DBA an dtechnology Expand / Collapse
Author
Message
Posted Sunday, September 16, 2012 4:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 3, 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
Posted Monday, September 17, 2012 2:10 AM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Friday, June 27, 2014 7:41 AM
Points: 739, Visits: 518
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.


"Be brave. Take risks. Nothing can substitute experience."
Post #1360021
Posted Monday, September 17, 2012 4:06 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:27 PM
Points: 13,776, Visits: 28,178
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
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
Posted Tuesday, September 25, 2012 9:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 3, 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
Posted Wednesday, September 26, 2012 3:26 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 9:27 PM
Points: 13,776, Visits: 28,178
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
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
Posted Wednesday, September 26, 2012 8:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 3, 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
Posted Wednesday, September 26, 2012 9:45 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, September 22, 2014 12:30 PM
Points: 93, Visits: 587
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
Posted Thursday, September 27, 2012 1:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 3, 2012 10:25 PM
Points: 5, Visits: 23
thanks a ton
Post #1365056
Posted Thursday, September 27, 2012 4:41 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Friday, April 4, 2014 5:29 AM
Points: 965, Visits: 396
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
Posted Thursday, September 27, 2012 10:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 3, 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 »

Add to briefcase 12»»

Permissions Expand / Collapse