Sunday, March 25, 2012

Advice needed - how to build skills as a MS database administrator

Would appreciate some advice for a small/mid company IT MCSE that is now
required to pick up MCDBA skills (with a training budget that limits me to
Barnes&Noble).
Our environment has an SQL 2000 on our ERP server; both will be upgraded in
November, where we will have SQL 2005.
I've scanned over free technet documentation, and subscribed to newsletters
- but could use a bit more direction.
I'd be interested in an SQL guru's advice on how I could ramp up my skill
quickly - to at least maintain an existing SQL database with an app server.
High quality books (they don't need to start at ground zero, I am a
proficient SQL writer already), and quality websites, would be greatly
appreciated. I'm looking for materials that will show me how to provide
proper maintenace and optimize performance of an SQL server.
Thanks in advance,
--
pbrill1You might find something useful here.
http://msdn2.microsoft.com/en-us/virtuallabs/aa740409.aspx
http://www.microsoft.com/learning/assessment/ind/windowsserver/default.mspx#EWD
Regards,
Dave Patrick ...Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
"pbrill1" wrote:
> Would appreciate some advice for a small/mid company IT MCSE that is now
> required to pick up MCDBA skills (with a training budget that limits me to
> Barnes&Noble).
> Our environment has an SQL 2000 on our ERP server; both will be upgraded
> in
> November, where we will have SQL 2005.
> I've scanned over free technet documentation, and subscribed to
> newsletters
> - but could use a bit more direction.
> I'd be interested in an SQL guru's advice on how I could ramp up my skill
> quickly - to at least maintain an existing SQL database with an app
> server.
> High quality books (they don't need to start at ground zero, I am a
> proficient SQL writer already), and quality websites, would be greatly
> appreciated. I'm looking for materials that will show me how to provide
> proper maintenace and optimize performance of an SQL server.
> Thanks in advance,
> --
> pbrill1|||Hello!
There are self-training kits you can buy. They are very good.
MCDBA certificate is for SQL Server 2000. There is a new certification path
for SQL Server 2005.
First you need to achieve MCTS: SQL Server 2005 certificate by sitting for
70-431 exam.
http://www.microsoft.com/learning/mcp/mcts/sql/default.mspx
And then you need to achieve MCITP: DBA certificate by sitting for 70-443
and 70-444 exams.
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/default.mspx
You can find recommended sources by Microsoft from the links above to study
on these exams.
Ekrem Ã?nsoy
"pbrill1" <pbrill1@.discussions.microsoft.com> wrote in message
news:36FADB02-C067-42FC-84DD-9A36425B9997@.microsoft.com...
> Would appreciate some advice for a small/mid company IT MCSE that is now
> required to pick up MCDBA skills (with a training budget that limits me to
> Barnes&Noble).
> Our environment has an SQL 2000 on our ERP server; both will be upgraded
> in
> November, where we will have SQL 2005.
> I've scanned over free technet documentation, and subscribed to
> newsletters
> - but could use a bit more direction.
> I'd be interested in an SQL guru's advice on how I could ramp up my skill
> quickly - to at least maintain an existing SQL database with an app
> server.
> High quality books (they don't need to start at ground zero, I am a
> proficient SQL writer already), and quality websites, would be greatly
> appreciated. I'm looking for materials that will show me how to provide
> proper maintenace and optimize performance of an SQL server.
> Thanks in advance,
> --
> pbrill1|||Thank you for the information.
At present, I won't be looking to certify as an SQL DBA (on a personal note
- no training funding until well into 2008) - so I need to run up the
learning curve on a budget of $50 or less.
Microsoft books (hardcover or online) or good how-to websites/blogs that can
show me how to 1) set up a maintenance schedule for SQL 2005 (what to
maintain/how often), and 2) tips/tricks to provide overall performance
improvements (i.e., I don't intend to dive into complex coding to seek
performance improvements) - would be the type of resource that I'm looking
for. A Microsoft SQL 2005 "DBA Secrets" type reference, maybe?
Any advice on inexpensive (again $50 range) resources would be greatly
appreciated.
--
pbrill1
"Dave Patrick" wrote:
> You might find something useful here.
> http://msdn2.microsoft.com/en-us/virtuallabs/aa740409.aspx
> http://www.microsoft.com/learning/assessment/ind/windowsserver/default.mspx#EWD
>
> --
> Regards,
> Dave Patrick ...Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
> "pbrill1" wrote:
> > Would appreciate some advice for a small/mid company IT MCSE that is now
> > required to pick up MCDBA skills (with a training budget that limits me to
> > Barnes&Noble).
> >
> > Our environment has an SQL 2000 on our ERP server; both will be upgraded
> > in
> > November, where we will have SQL 2005.
> >
> > I've scanned over free technet documentation, and subscribed to
> > newsletters
> > - but could use a bit more direction.
> >
> > I'd be interested in an SQL guru's advice on how I could ramp up my skill
> > quickly - to at least maintain an existing SQL database with an app
> > server.
> > High quality books (they don't need to start at ground zero, I am a
> > proficient SQL writer already), and quality websites, would be greatly
> > appreciated. I'm looking for materials that will show me how to provide
> > proper maintenace and optimize performance of an SQL server.
> >
> > Thanks in advance,
> > --
> > pbrill1
>

No comments:

Post a Comment