I'm coming from a developer role for the pass 12 years. I've created
everything from, components, web app, windows apps, mobile device
applications, etc. Now I'm getting ready to take over work on our databases,
Our DBA has left and I'm kind of stepping in to take on that role. So my
question is, coming from developer background, what do I need to know beyond
creating stored procedures and select statements to be a successful DBA? I
know from in the pass in working with DBA's that they do more then just
create stored procedures and database, what do I need to know such as,
replication, mirroring, security, performance, etc. where do I begin, is
there anything out there to help me get an understanding of a DBA role, or
should I just 'fly by the seam of my pants' on this one? (probably not a
good idea, but willing to try it)
thanks for any help and or suggestions you may have to offer, (good or bad
are accepted)just to add I know how to create users in the database, SSIS packages, I
guess its more on triggers, indexes, performance issues, replication,
mirroring, etc, suff like that I guess is what i'm looking for.
and other things a DBA does within this role.
"Mike" <Mike@.community.nospam.com> wrote in message
news:%23G$Syd3rHHA.1168@.TK2MSFTNGP03.phx.gbl...
> This is probably a wide open question but:
> I'm coming from a developer role for the pass 12 years. I've created
> everything from, components, web app, windows apps, mobile device
> applications, etc. Now I'm getting ready to take over work on our
> databases, Our DBA has left and I'm kind of stepping in to take on that
> role. So my question is, coming from developer background, what do I need
> to know beyond creating stored procedures and select statements to be a
> successful DBA? I know from in the pass in working with DBA's that they do
> more then just create stored procedures and database, what do I need to
> know such as, replication, mirroring, security, performance, etc. where do
> I begin, is there anything out there to help me get an understanding of a
> DBA role, or should I just 'fly by the seam of my pants' on this one?
> (probably not a good idea, but willing to try it)
>
> thanks for any help and or suggestions you may have to offer, (good or
> bad are accepted)
>
>|||Thanks, I'm now second guessing myself for taken this task on and learn
something new.
> First and most importantly, you need to be able to put the system back the
> way it was yesterday, data and all. Fully document the system and make
> sure your recovery strategy is in place and tested.
I can say I was successful in restoring all the databases when the
server actually crashed. I learned that process hands on. The only thing
though I had to add all of the logins again manually. Is there a way to back
up the 'Security' folder so I can all Login ID and Privilages or no?
> Second, all developers are now your natural enemy. They write code to
> destroy the data and performance. It is your job to limit the damage they
> can do. See requirement #1.
Coming from development, I admit I either brought down a DB or locked a db
in my development days.
> Security just became your problem. You don't want to be the next headline
> on data lost or hacked.
this part I like because I handled alot of the security for the
applications I developed. Though this is a different level of security.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OtZbfu3rHHA.1476@.TK2MSFTNGP06.phx.gbl...
> First and most importantly, you need to be able to put the system back the
> way it was yesterday, data and all. Fully document the system and make
> sure your recovery strategy is in place and tested.
> Second, all developers are now your natural enemy. They write code to
> destroy the data and performance. It is your job to limit the damage they
> can do. See requirement #1.
> Performance monitoring and tuning must now be regular parts of your
> routine.
> Security just became your problem. You don't want to be the next headline
> on data lost or hacked.
> There are lots more, but this should keep you up nights for the next few
> months.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
>
> "Mike" <Mike@.community.nospam.com> wrote in message
> news:OinW2i3rHHA.632@.TK2MSFTNGP03.phx.gbl...
>|||Thanks, I'm going to be looking online this weekend for classes in my area.
"Pawn" <TheRealPawn@.gmail.com> wrote in message
news:1181932262.511711.220810@.q66g2000hsg.googlegroups.com...
>I was in the same boat. Microsoft has some really good training
> classes and I'd highly recommend getting into one of those as soon as
> you can. They'll cover a broad range of your day to day operations
> like backups and security. Also, get familiar with some networking
> knowledge as well. You're going to be walking the line between
> hardware and software. But, the first thing is with only SQL Dev
> experience I'd see what, if any, training classes you can get into. If
> anything the book can be used for reference for TSQL statements.
>|||what about replication, mirroring, or clustering? Or should I not worry
about that until the time comes? According to the mgr none of the above are
used Just backups of the db's on a nightly basis.
"Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
news:OtZbfu3rHHA.1476@.TK2MSFTNGP06.phx.gbl...
> First and most importantly, you need to be able to put the system back the
> way it was yesterday, data and all. Fully document the system and make
> sure your recovery strategy is in place and tested.
> Second, all developers are now your natural enemy. They write code to
> destroy the data and performance. It is your job to limit the damage they
> can do. See requirement #1.
> Performance monitoring and tuning must now be regular parts of your
> routine.
> Security just became your problem. You don't want to be the next headline
> on data lost or hacked.
> There are lots more, but this should keep you up nights for the next few
> months.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
>
> "Mike" <Mike@.community.nospam.com> wrote in message
> news:OinW2i3rHHA.632@.TK2MSFTNGP03.phx.gbl...
>|||Hey, not ALL developers are bad. Just the great majority. Coming out
of the trenches yourself you probably get along well with them so when
you see a performance problem they will most likely be very receptive
to your suggestions on how to fix it. SQL Profiler and Performance
Monitor have just become some of your best friends. Though they do add
overhead to the server so use them sparingly.
This site may help you figure out some more details about performance
monitors:
http://www.sql-server-performance.com/
Here's a link on what your day-to-day's may include:
http://www.databasedesign-resource...server-dba.html
On Jun 15, 2:33 pm, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:[vbcol=seagreen]
> First and most importantly, you need to be able to put the system back the
> way it was yesterday, data and all. Fully document the system and make su
re
> your recovery strategy is in place and tested.
> Second, all developers are now your natural enemy. They write code to
> destroy the data and performance. It is your job to limit the damage they
> can do. See requirement #1.
> Performance monitoring and tuning must now be regular parts of your routin
e.
> Security just became your problem. You don't want to be the next headline
> on data lost or hacked.
> There are lots more, but this should keep you up nights for the next few
> months.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> "Mike" <M...@.community.nospam.com> wrote in message
> news:OinW2i3rHHA.632@.TK2MSFTNGP03.phx.gbl...
>
>
>
>|||thanks I greatly appreciate the information.
This Database stuff is a whole new world to me (from a true dba perspective)
and I was willing to give it a shot.
"Pawn" <TheRealPawn@.gmail.com> wrote in message
news:1181933280.917354.9000@.p77g2000hsh.googlegroups.com...
> Hey, not ALL developers are bad. Just the great majority. Coming out
> of the trenches yourself you probably get along well with them so when
> you see a performance problem they will most likely be very receptive
> to your suggestions on how to fix it. SQL Profiler and Performance
> Monitor have just become some of your best friends. Though they do add
> overhead to the server so use them sparingly.
> This site may help you figure out some more details about performance
> monitors:
> http://www.sql-server-performance.com/
> Here's a link on what your day-to-day's may include:
> http://www.databasedesign-resource...server-dba.html
> On Jun 15, 2:33 pm, "Geoff N. Hiten" <SQLCrafts...@.gmail.com> wrote:
>
>|||Unless you are currently using or expect to use a technology, I would not
worry about it on day one. Getting a handle on managing, recovering, and
operating the server AS IS should be your top priority. Learn about what
new technologies can and cannot do so you can make intelligent
recommendations, but unless they are part of your current environment, they
are not part of your current problem set.
As for the developer comments, I have worked as a developer, a system admin,
and as a DBA over the course of my career. Each has a different perspective
on the system and different goals. Sometimes those goals are in wildly
different directions.
Don't rely on luck to restore a system. Have a plan and practice it. Test
your backups regularly. Training classes will help give you the knowledge
to build an effective operations and recovery plan, but you have to do the
heavy lifting. Remember, management does not care about backups, they care
about restores.
Good luck. I figure we will see you around here quite a bit in the months
to come.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Mike" <Mike@.community.nospam.com> wrote in message
news:O70I913rHHA.4548@.TK2MSFTNGP03.phx.gbl...
> what about replication, mirroring, or clustering? Or should I not worry
> about that until the time comes? According to the mgr none of the above
> are used Just backups of the db's on a nightly basis.
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:OtZbfu3rHHA.1476@.TK2MSFTNGP06.phx.gbl...
>|||> Is there a way to back up the 'Security' folder so I can all Login ID and
Privilages or no?
You need to "get" the architecture of SQL Server. Logins are in the master d
atabase, so with proper
backup of master, you have your logins. Having said that, Google for sp_help
_revlogin.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Mike" <Mike@.community.nospam.com> wrote in message news:eeD1Sz3rHHA.5032@.TK2MSFTNGP02.phx.g
bl...
> Thanks, I'm now second guessing myself for taken this task on and learn so
mething new.
>
> I can say I was successful in restoring all the databases when the serv
er actually crashed. I
> learned that process hands on. The only thing though I had to add all of t
he logins again
> manually. Is there a way to back up the 'Security' folder so I can all Log
in ID and Privilages or
> no?
>
> Coming from development, I admit I either brought down a DB or locked a d
b in my development
> days.
>
> this part I like because I handled alot of the security for the applica
tions I developed.
> Though this is a different level of security.
>
> "Geoff N. Hiten" <SQLCraftsman@.gmail.com> wrote in message
> news:OtZbfu3rHHA.1476@.TK2MSFTNGP06.phx.gbl...
>|||As a trainer, I know the (MS) SQL Server courses inside out. Here's my recom
mendation:
2780, which is an admin class. Sure, you might know bits here and there alre
ady, but if you are
about to shift position, they (your managers) would want to invest a bit. Ma
ke sure you get the 5
days revision of the course (B rev), and preferably from a reputable instruc
tor. Added value differs
a lot. I have difficulties managing to teach this class for the specified ti
me, while other say
there is way too much time allocated.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Mike" <Mike@.community.nospam.com> wrote in message news:OziQgz3rHHA.3500@.TK2MSFTNGP04.phx.g
bl...
> Thanks, I'm going to be looking online this weekend for classes in my area
.
>
> "Pawn" <TheRealPawn@.gmail.com> wrote in message
> news:1181932262.511711.220810@.q66g2000hsg.googlegroups.com...
>
No comments:
Post a Comment