Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AlexP
Starting Member
34 Posts |
 Posted - 2005-08-11 : 14:22:27
|
| Initially I got hired as a .NET developer with SQL2000 experience. As time went on I was officially moved into the position where all database architecture and design considerations rest on me. Now I am not a DBA by any means in my opinion but I have alot of experience designing and maintaining sql databases. Whether it is good experience is yet to be seen!Anyway, please post your top suggestions for a person in my position. This is a serious inquiry so please....you know what I mean. ;) |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2005-08-11 : 15:11:14
|
| Well, Alex, it depends on what your actual responsibilities are. Are you responsible for performance issues as well as design issues? How large is your system (# DBs, # Users, etc., etc.)? Your situation is fairly common in small to medium sized businesses. I think you'll learn a lot just by browsing SQLTeam on a regular basis. There are also a ton of good books recommended in our store. If you've got the time and inclination, you might pursue certification, not so much for the piece of paper as for the learning it forces you to do. But of course, books and SQLTeam are less expensive.---------------------------EmeraldCityDomains.com |
 |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2005-08-11 : 15:55:46
|
| Same here AlexP except I was hired as a Parametric modeller.Company has 400 folks, about 10 Gigs of Data.Performance,Design,Application build and support and Hardware.Just me. I don't call myself a DBA either and often wish for an identity and focus.I wish someone would start an Official XML Rant Thread. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-08-11 : 17:07:00
|
| www.sql-server-performance.comHas lot of DBA - related info, and good faq + howto's. I recommend You give it a browse.Coming from a programming background and going to DBA, at least You will have excellentcommunication skills with the code crunchers.rockmoose |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2005-08-11 : 18:50:06
|
| What it the scope of your responsibility? Are you responsible for “DBA things” like backups, restores, installing SQL Server, setting up jobs, data replication, and granting access? Database architecture and design is not done by a DBA in many organizations. Many companies separate the responsibility of administration from database architecture.I personally think that a real database guru has to understand both, because the database stands at the intersection of the worlds of network administration, server administration, hardware, application development, application performance, data architecture, the database engine, and the data itselfIf you do have responsibility for “DBA things”, I would make backups the first thing you get under control and develop a good plan for. They are boring, easy to put off straightening out, and a drag to watch over, but sooner than you think, like 5 minutes from now, you will absolutely, desperately need one. People here can help you with a lot of things, but they can’t get your data back when it’s gone. This includes those development databases too; they are the developer’s production databases, so don’t leave them out of your backup plans.CODO ERGO SUM |
|
|
|
|
|
|
|
|
***Being a DBA***