Are there any books/article/forum posts out there that document the
best practices for SQL Server security?
For example, what account should create the database?
What account should create the schema?
In a given database should there be a login that is solely responsible
for DDL and a seperate account that only does DML and Queries?
What conventions are people using?
I'm kind of clueless about this and trying to figure out where to
start.
-ThxWhat version of SQL Server are you using? Best practices for SQLS 2000
do not necessarily apply to 2005, where there are expanded options not
available in earlier versions. A good starting point is always SQLS
Books Online, supplemented with a good searh engine :)
-mary
On Wed, 22 Aug 2007 05:58:08 -0700, kilik3000@.gmail.com wrote:
>Are there any books/article/forum posts out there that document the
>best practices for SQL Server security?
>For example, what account should create the database?
>What account should create the schema?
>In a given database should there be a login that is solely responsible
>for DDL and a seperate account that only does DML and Queries?
>What conventions are people using?
>I'm kind of clueless about this and trying to figure out where to
>start.
>-Thx|||On Aug 23, 1:45 pm, "Mary Chipman [MSFT]" <mc...@.online.microsoft.com>
wrote:
> What version of SQL Server are you using? Best practices for SQLS 2000
> do not necessarily apply to 2005, where there are expanded options not
> available in earlier versions. A good starting point is always SQLS
> Books Online, supplemented with a good searh engine :)
> -mary
> On Wed, 22 Aug 2007 05:58:08 -0700, kilik3...@.gmail.com wrote:
> >Are there any books/article/forum posts out there that document the
> >best practices for SQL Server security?
> >For example, what account should create the database?
> >What account should create the schema?
> >In a given database should there be a login that is solely responsible
> >for DDL and a seperate account that only does DML and Queries?
> >What conventions are people using?
> >I'm kind of clueless about this and trying to figure out where to
> >start.
> >-Thx
SQL 2005.
-Thx|||That's a tough one. Basic information is in SQLS Books Online
(http://msdn2.microsoft.com/en-us/library/ms161948.aspx) but it
doesn't directly answer your questions, you have to infer the answers.
Also, your security architecture depends on your needs. DDL has gotten
a lot easier with user-schema separation in 2005 once you understand
it. Erland Sommarskog's web site has some good resources - see Giving
Permissions through Stored Procedures
(http://www.sommarskog.se/grantperm.html).
-mary
On Tue, 28 Aug 2007 20:01:27 -0000, kilik3000@.gmail.com wrote:
>On Aug 23, 1:45 pm, "Mary Chipman [MSFT]" <mc...@.online.microsoft.com>
>wrote:
>> What version of SQL Server are you using? Best practices for SQLS 2000
>> do not necessarily apply to 2005, where there are expanded options not
>> available in earlier versions. A good starting point is always SQLS
>> Books Online, supplemented with a good searh engine :)
>> -mary
>> On Wed, 22 Aug 2007 05:58:08 -0700, kilik3...@.gmail.com wrote:
>> >Are there any books/article/forum posts out there that document the
>> >best practices for SQL Server security?
>> >For example, what account should create the database?
>> >What account should create the schema?
>> >In a given database should there be a login that is solely responsible
>> >for DDL and a seperate account that only does DML and Queries?
>> >What conventions are people using?
>> >I'm kind of clueless about this and trying to figure out where to
>> >start.
>> >-Thx
>SQL 2005.
>-Thx
Showing posts with label books. Show all posts
Showing posts with label books. Show all posts
Sunday, March 25, 2012
Sunday, February 19, 2012
ABout SELECT Syntax?
Hi,everyone.
Today I met with a interesting problem. According to Microsoft SQL SERVER 2005 BOOKS ONLINE, there is following SELECT Syntax:
(1) SELECT @.local_variable (Transact-SQL)
For example:
DECLARE @.i int
SELECt @.i=100
(2) SELECt QUERY statement:
SELECT [ ALL | DISTINCT ]
[ TOP expression [ PERCENT ] [ WITH TIES ] ]
<select_list>
<select_list> ::=
....
For example,
[AdventureWorks]
SELECT * FROM DatabaseLog
To my surprise, in the given project, I met this kind of SELECT statement,
DECLARE @.w_type varchar(10), @.i varchar(30)
SELECT @.i='3'
SELECT @.w_type='OLTPNORMAL' WHERE @.i IN ('0','1','2','3','4','5','9',)
SELECT @.w_type
The result is:
OLTPNORMAL
However, I have not met with the kind of SELECT statement before. Please give me some advice. Thank you in advance.DECLARE @.w_type varchar(10), @.i varchar(30)
SELECT @.i='3'
SELECT @.w_type='OLTPNORMAL' WHERE @.i IN ('0','1','2','3','4','5','9')
SELECT @.w_type
The result is:
OLTPNORMAL
Thats absolutely okay,
SELECT @.i='3' -- assigning value '3' to @.i
SELECT @.w_type='OLTPNORMAL' WHERE @.i IN ('0','1','2','3','4','5','9') -- Assigning @.w_type='OLTPMORMAL' if where clause satisfies,here it is satisfying bcoz @.i='3'
SELECT @.w_type -displaying @.w_type|||Thank you,Rudra.
Here I have gotten the same result as yours. However, the kind of SQL Synax "SELECT...@.local_variable ...WHERE..." is not introduced in SQL SERVER 2005 in Microsoft SQL SERVER 2005 BOOKS ONLINE. So when I found this statement I felt surprised. Can you give me some advice to look for some introductions about the kind of SQL Synax ?
Thank you very much!|||Read this ...LINK (http://msdn2.microsoft.com/en-us/library/ms189484.aspx)
And please read the whole topic( you must scroll down) and then everything will be clear to you.
Today I met with a interesting problem. According to Microsoft SQL SERVER 2005 BOOKS ONLINE, there is following SELECT Syntax:
(1) SELECT @.local_variable (Transact-SQL)
For example:
DECLARE @.i int
SELECt @.i=100
(2) SELECt QUERY statement:
SELECT [ ALL | DISTINCT ]
[ TOP expression [ PERCENT ] [ WITH TIES ] ]
<select_list>
<select_list> ::=
....
For example,
[AdventureWorks]
SELECT * FROM DatabaseLog
To my surprise, in the given project, I met this kind of SELECT statement,
DECLARE @.w_type varchar(10), @.i varchar(30)
SELECT @.i='3'
SELECT @.w_type='OLTPNORMAL' WHERE @.i IN ('0','1','2','3','4','5','9',)
SELECT @.w_type
The result is:
OLTPNORMAL
However, I have not met with the kind of SELECT statement before. Please give me some advice. Thank you in advance.DECLARE @.w_type varchar(10), @.i varchar(30)
SELECT @.i='3'
SELECT @.w_type='OLTPNORMAL' WHERE @.i IN ('0','1','2','3','4','5','9')
SELECT @.w_type
The result is:
OLTPNORMAL
Thats absolutely okay,
SELECT @.i='3' -- assigning value '3' to @.i
SELECT @.w_type='OLTPNORMAL' WHERE @.i IN ('0','1','2','3','4','5','9') -- Assigning @.w_type='OLTPMORMAL' if where clause satisfies,here it is satisfying bcoz @.i='3'
SELECT @.w_type -displaying @.w_type|||Thank you,Rudra.
Here I have gotten the same result as yours. However, the kind of SQL Synax "SELECT...@.local_variable ...WHERE..." is not introduced in SQL SERVER 2005 in Microsoft SQL SERVER 2005 BOOKS ONLINE. So when I found this statement I felt surprised. Can you give me some advice to look for some introductions about the kind of SQL Synax ?
Thank you very much!|||Read this ...LINK (http://msdn2.microsoft.com/en-us/library/ms189484.aspx)
And please read the whole topic( you must scroll down) and then everything will be clear to you.
Thursday, February 16, 2012
About MCDBA
Hi,
I knew the MCDBA contains 3 required exams and 1 elective
exam.
1) Can someone tell me, if I am not go to the training
classes, just buy books such as MCSE Training Kit:
Microsoft SQL Server 2000 System Administration, Database
Design and Implementation, etc. is possible to pass exams?
2) Those MCSE Training Kit books contain self-test? If
they don't contain self-test, where I can find them?
Thanks,
Jennyhttp://www.transcender.com/
Best self-test stuff out there back when I was taking certification exams
Kevin Hill, MCSE
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Jenny" <anonymous@.discussions.microsoft.com> wrote in message
news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
for passing MCDBA.
The Books are rather scetchy, some are really good, some
are so bad they are not worth the paper they are printed
on. I would sugest you had a look at amazon before buying
them.
The best reference resource however is BOL (which are
suprisingly good.
J
certification exams
message
I used a combination of experience (almost 3 years), books (Inside SQL
Server 2000 is excellent), & training videos (cbt nuggets were pretty good).
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||Hands on training is the best preparation, period. :-)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:OCggor23DHA.1428@.TK2MSFTNGP12.phx.gbl...
I am not sure how much experience you aquired as a DBA but
I have done some R & D on websites In the process of
preparing for Certification.
To get certified you MUST have MS Press Books and Sybex
Books read & practiced thoroughly ( both includes Test
Simulations also). Apart from the above, there are lot of
sites offering Test Simulation product samples.(some are
downloadable and some are online). practiceing these tests
will make you more comfortable while attempting the Real
Exam. Ensure that you are not going to accept any shortcut
methods of passing the exam. A bit of hardwork and
sincerity , we can pass the exams in flying colors.
Also Look at the article wrote by by Brad M. McGehee.
Self Taught DBA
http://www.sql-server-performance.c..._taught_dba.asp
HTH
Best Wishes
THIRUMAL REDDY MARAM
Sys Admin / SQL Server DBA
books (Inside SQL
were pretty good).
you are good to go.
Steven S. Warren
MCSA, MCSE, MCDBA, CCA, CIW-SA, CIW-MA, NETWORK+, i-NET+
http:\\www.swtechworks.net
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23aRknh33DHA.1804@.TK2MSFTNGP12.phx.gbl...
I knew the MCDBA contains 3 required exams and 1 elective
exam.
1) Can someone tell me, if I am not go to the training
classes, just buy books such as MCSE Training Kit:
Microsoft SQL Server 2000 System Administration, Database
Design and Implementation, etc. is possible to pass exams?
2) Those MCSE Training Kit books contain self-test? If
they don't contain self-test, where I can find them?
Thanks,
Jennyhttp://www.transcender.com/
Best self-test stuff out there back when I was taking certification exams
Kevin Hill, MCSE
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Jenny" <anonymous@.discussions.microsoft.com> wrote in message
news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
quote:|||I agree that the Trancender is the bust resource out there
> Hi,
> I knew the MCDBA contains 3 required exams and 1 elective
> exam.
> 1) Can someone tell me, if I am not go to the training
> classes, just buy books such as MCSE Training Kit:
> Microsoft SQL Server 2000 System Administration, Database
> Design and Implementation, etc. is possible to pass exams?
> 2) Those MCSE Training Kit books contain self-test? If
> they don't contain self-test, where I can find them?
> Thanks,
> Jenny
>
for passing MCDBA.
The Books are rather scetchy, some are really good, some
are so bad they are not worth the paper they are printed
on. I would sugest you had a look at amazon before buying
them.
The best reference resource however is BOL (which are
suprisingly good.
J
quote:
>--Original Message--
>http://www.transcender.com/
>Best self-test stuff out there back when I was taking
certification exams
quote:
>--
>Kevin Hill, MCSE
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>"Jenny" <anonymous@.discussions.microsoft.com> wrote in
message
quote:|||Yes you can pass them without any classroom teaching.
>news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
elective[QUOTE]
Database[QUOTE]
exams?[QUOTE]
>
>.
>
I used a combination of experience (almost 3 years), books (Inside SQL
Server 2000 is excellent), & training videos (cbt nuggets were pretty good).
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||Hands on training is the best preparation, period. :-)
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:OCggor23DHA.1428@.TK2MSFTNGP12.phx.gbl...
quote:|||Hi Jenny,
> http://www.transcender.com/
> Best self-test stuff out there back when I was taking certification exams
> --
> Kevin Hill, MCSE
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> "Jenny" <anonymous@.discussions.microsoft.com> wrote in message
> news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
>
I am not sure how much experience you aquired as a DBA but
I have done some R & D on websites In the process of
preparing for Certification.
To get certified you MUST have MS Press Books and Sybex
Books read & practiced thoroughly ( both includes Test
Simulations also). Apart from the above, there are lot of
sites offering Test Simulation product samples.(some are
downloadable and some are online). practiceing these tests
will make you more comfortable while attempting the Real
Exam. Ensure that you are not going to accept any shortcut
methods of passing the exam. A bit of hardwork and
sincerity , we can pass the exams in flying colors.
Also Look at the article wrote by by Brad M. McGehee.
Self Taught DBA
http://www.sql-server-performance.c..._taught_dba.asp
HTH
Best Wishes
THIRUMAL REDDY MARAM
Sys Admin / SQL Server DBA
quote:
>--Original Message--
>Yes you can pass them without any classroom teaching.
>I used a combination of experience (almost 3 years),
books (Inside SQL
quote:
>Server 2000 is excellent), & training videos (cbt nuggets
were pretty good).
quote:|||I use BOL and and the MOC Press books combined w/ VMWARE and Transcender and
>
>--
>Cheers,
>
>James Goodman MCSE, MCDBA
>http://www.angelfire.com/sports/f1pictures
>
>.
>
you are good to go.
Steven S. Warren
MCSA, MCSE, MCDBA, CCA, CIW-SA, CIW-MA, NETWORK+, i-NET+
http:\\www.swtechworks.net
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23aRknh33DHA.1804@.TK2MSFTNGP12.phx.gbl...
quote:
> Hands on training is the best preparation, period. :-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:OCggor23DHA.1428@.TK2MSFTNGP12.phx.gbl...
exams[QUOTE]
>
Monday, February 13, 2012
About MCDBA
Hi,
I knew the MCDBA contains 3 required exams and 1 elective
exam.
1) Can someone tell me, if I am not go to the training
classes, just buy books such as MCSE Training Kit:
Microsoft SQL Server 2000 System Administration, Database
Design and Implementation, etc. is possible to pass exams?
2) Those MCSE Training Kit books contain self-test? If
they don't contain self-test, where I can find them?
Thanks,
Jennyhttp://www.transcender.com/
Best self-test stuff out there back when I was taking certification exams
--
Kevin Hill, MCSE
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Jenny" <anonymous@.discussions.microsoft.com> wrote in message
news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
> Hi,
> I knew the MCDBA contains 3 required exams and 1 elective
> exam.
> 1) Can someone tell me, if I am not go to the training
> classes, just buy books such as MCSE Training Kit:
> Microsoft SQL Server 2000 System Administration, Database
> Design and Implementation, etc. is possible to pass exams?
> 2) Those MCSE Training Kit books contain self-test? If
> they don't contain self-test, where I can find them?
> Thanks,
> Jenny
>|||I agree that the Trancender is the bust resource out there
for passing MCDBA.
The Books are rather scetchy, some are really good, some
are so bad they are not worth the paper they are printed
on. I would sugest you had a look at amazon before buying
them.
The best reference resource however is BOL (which are
suprisingly good.
J
>--Original Message--
>http://www.transcender.com/
>Best self-test stuff out there back when I was taking
certification exams
>--
>Kevin Hill, MCSE
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>"Jenny" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
>> Hi,
>> I knew the MCDBA contains 3 required exams and 1
elective
>> exam.
>> 1) Can someone tell me, if I am not go to the training
>> classes, just buy books such as MCSE Training Kit:
>> Microsoft SQL Server 2000 System Administration,
Database
>> Design and Implementation, etc. is possible to pass
exams?
>> 2) Those MCSE Training Kit books contain self-test? If
>> they don't contain self-test, where I can find them?
>> Thanks,
>> Jenny
>
>.
>|||Yes you can pass them without any classroom teaching.
I used a combination of experience (almost 3 years), books (Inside SQL
Server 2000 is excellent), & training videos (cbt nuggets were pretty good).
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||Hands on training is the best preparation, period. :-)
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:OCggor23DHA.1428@.TK2MSFTNGP12.phx.gbl...
> http://www.transcender.com/
> Best self-test stuff out there back when I was taking certification exams
> --
> Kevin Hill, MCSE
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> "Jenny" <anonymous@.discussions.microsoft.com> wrote in message
> news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
> > Hi,
> >
> > I knew the MCDBA contains 3 required exams and 1 elective
> > exam.
> >
> > 1) Can someone tell me, if I am not go to the training
> > classes, just buy books such as MCSE Training Kit:
> > Microsoft SQL Server 2000 System Administration, Database
> > Design and Implementation, etc. is possible to pass exams?
> >
> > 2) Those MCSE Training Kit books contain self-test? If
> > they don't contain self-test, where I can find them?
> >
> > Thanks,
> > Jenny
> >
>|||Hi Jenny,
I am not sure how much experience you aquired as a DBA but
I have done some R & D on websites In the process of
preparing for Certification.
To get certified you MUST have MS Press Books and Sybex
Books read & practiced thoroughly ( both includes Test
Simulations also). Apart from the above, there are lot of
sites offering Test Simulation product samples.(some are
downloadable and some are online). practiceing these tests
will make you more comfortable while attempting the Real
Exam. Ensure that you are not going to accept any shortcut
methods of passing the exam. A bit of hardwork and
sincerity , we can pass the exams in flying colors.
Also Look at the article wrote by by Brad M. McGehee.
Self Taught DBA
http://www.sql-server-performance.com/self_taught_dba.asp
HTH
Best Wishes
THIRUMAL REDDY MARAM
Sys Admin / SQL Server DBA
>--Original Message--
>Yes you can pass them without any classroom teaching.
>I used a combination of experience (almost 3 years),
books (Inside SQL
>Server 2000 is excellent), & training videos (cbt nuggets
were pretty good).
>
>--
>Cheers,
>
>James Goodman MCSE, MCDBA
>http://www.angelfire.com/sports/f1pictures
>
>.
>|||I use BOL and and the MOC Press books combined w/ VMWARE and Transcender and
you are good to go.
--
Steven S. Warren
MCSA, MCSE, MCDBA, CCA, CIW-SA, CIW-MA, NETWORK+, i-NET+
http:\\www.swtechworks.net
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23aRknh33DHA.1804@.TK2MSFTNGP12.phx.gbl...
> Hands on training is the best preparation, period. :-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:OCggor23DHA.1428@.TK2MSFTNGP12.phx.gbl...
> > http://www.transcender.com/
> >
> > Best self-test stuff out there back when I was taking certification
exams
> >
> > --
> > Kevin Hill, MCSE
> > President
> > 3NF Consulting
> >
> > www.3nf-inc.com/NewsGroups.htm
> >
> > "Jenny" <anonymous@.discussions.microsoft.com> wrote in message
> > news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
> > > Hi,
> > >
> > > I knew the MCDBA contains 3 required exams and 1 elective
> > > exam.
> > >
> > > 1) Can someone tell me, if I am not go to the training
> > > classes, just buy books such as MCSE Training Kit:
> > > Microsoft SQL Server 2000 System Administration, Database
> > > Design and Implementation, etc. is possible to pass exams?
> > >
> > > 2) Those MCSE Training Kit books contain self-test? If
> > > they don't contain self-test, where I can find them?
> > >
> > > Thanks,
> > > Jenny
> > >
> >
> >
>
I knew the MCDBA contains 3 required exams and 1 elective
exam.
1) Can someone tell me, if I am not go to the training
classes, just buy books such as MCSE Training Kit:
Microsoft SQL Server 2000 System Administration, Database
Design and Implementation, etc. is possible to pass exams?
2) Those MCSE Training Kit books contain self-test? If
they don't contain self-test, where I can find them?
Thanks,
Jennyhttp://www.transcender.com/
Best self-test stuff out there back when I was taking certification exams
--
Kevin Hill, MCSE
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Jenny" <anonymous@.discussions.microsoft.com> wrote in message
news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
> Hi,
> I knew the MCDBA contains 3 required exams and 1 elective
> exam.
> 1) Can someone tell me, if I am not go to the training
> classes, just buy books such as MCSE Training Kit:
> Microsoft SQL Server 2000 System Administration, Database
> Design and Implementation, etc. is possible to pass exams?
> 2) Those MCSE Training Kit books contain self-test? If
> they don't contain self-test, where I can find them?
> Thanks,
> Jenny
>|||I agree that the Trancender is the bust resource out there
for passing MCDBA.
The Books are rather scetchy, some are really good, some
are so bad they are not worth the paper they are printed
on. I would sugest you had a look at amazon before buying
them.
The best reference resource however is BOL (which are
suprisingly good.
J
>--Original Message--
>http://www.transcender.com/
>Best self-test stuff out there back when I was taking
certification exams
>--
>Kevin Hill, MCSE
>President
>3NF Consulting
>www.3nf-inc.com/NewsGroups.htm
>"Jenny" <anonymous@.discussions.microsoft.com> wrote in
message
>news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
>> Hi,
>> I knew the MCDBA contains 3 required exams and 1
elective
>> exam.
>> 1) Can someone tell me, if I am not go to the training
>> classes, just buy books such as MCSE Training Kit:
>> Microsoft SQL Server 2000 System Administration,
Database
>> Design and Implementation, etc. is possible to pass
exams?
>> 2) Those MCSE Training Kit books contain self-test? If
>> they don't contain self-test, where I can find them?
>> Thanks,
>> Jenny
>
>.
>|||Yes you can pass them without any classroom teaching.
I used a combination of experience (almost 3 years), books (Inside SQL
Server 2000 is excellent), & training videos (cbt nuggets were pretty good).
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||Hands on training is the best preparation, period. :-)
--
Kevin Hill
President
3NF Consulting
www.3nf-inc.com/NewsGroups.htm
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:OCggor23DHA.1428@.TK2MSFTNGP12.phx.gbl...
> http://www.transcender.com/
> Best self-test stuff out there back when I was taking certification exams
> --
> Kevin Hill, MCSE
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> "Jenny" <anonymous@.discussions.microsoft.com> wrote in message
> news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
> > Hi,
> >
> > I knew the MCDBA contains 3 required exams and 1 elective
> > exam.
> >
> > 1) Can someone tell me, if I am not go to the training
> > classes, just buy books such as MCSE Training Kit:
> > Microsoft SQL Server 2000 System Administration, Database
> > Design and Implementation, etc. is possible to pass exams?
> >
> > 2) Those MCSE Training Kit books contain self-test? If
> > they don't contain self-test, where I can find them?
> >
> > Thanks,
> > Jenny
> >
>|||Hi Jenny,
I am not sure how much experience you aquired as a DBA but
I have done some R & D on websites In the process of
preparing for Certification.
To get certified you MUST have MS Press Books and Sybex
Books read & practiced thoroughly ( both includes Test
Simulations also). Apart from the above, there are lot of
sites offering Test Simulation product samples.(some are
downloadable and some are online). practiceing these tests
will make you more comfortable while attempting the Real
Exam. Ensure that you are not going to accept any shortcut
methods of passing the exam. A bit of hardwork and
sincerity , we can pass the exams in flying colors.
Also Look at the article wrote by by Brad M. McGehee.
Self Taught DBA
http://www.sql-server-performance.com/self_taught_dba.asp
HTH
Best Wishes
THIRUMAL REDDY MARAM
Sys Admin / SQL Server DBA
>--Original Message--
>Yes you can pass them without any classroom teaching.
>I used a combination of experience (almost 3 years),
books (Inside SQL
>Server 2000 is excellent), & training videos (cbt nuggets
were pretty good).
>
>--
>Cheers,
>
>James Goodman MCSE, MCDBA
>http://www.angelfire.com/sports/f1pictures
>
>.
>|||I use BOL and and the MOC Press books combined w/ VMWARE and Transcender and
you are good to go.
--
Steven S. Warren
MCSA, MCSE, MCDBA, CCA, CIW-SA, CIW-MA, NETWORK+, i-NET+
http:\\www.swtechworks.net
"Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
news:%23aRknh33DHA.1804@.TK2MSFTNGP12.phx.gbl...
> Hands on training is the best preparation, period. :-)
> --
> Kevin Hill
> President
> 3NF Consulting
> www.3nf-inc.com/NewsGroups.htm
> "Kevin3NF" <KHill@.NopeIDontNeedNoSPAM3NF-inc.com> wrote in message
> news:OCggor23DHA.1428@.TK2MSFTNGP12.phx.gbl...
> > http://www.transcender.com/
> >
> > Best self-test stuff out there back when I was taking certification
exams
> >
> > --
> > Kevin Hill, MCSE
> > President
> > 3NF Consulting
> >
> > www.3nf-inc.com/NewsGroups.htm
> >
> > "Jenny" <anonymous@.discussions.microsoft.com> wrote in message
> > news:0a7701c3df65$34b84b90$a101280a@.phx.gbl...
> > > Hi,
> > >
> > > I knew the MCDBA contains 3 required exams and 1 elective
> > > exam.
> > >
> > > 1) Can someone tell me, if I am not go to the training
> > > classes, just buy books such as MCSE Training Kit:
> > > Microsoft SQL Server 2000 System Administration, Database
> > > Design and Implementation, etc. is possible to pass exams?
> > >
> > > 2) Those MCSE Training Kit books contain self-test? If
> > > they don't contain self-test, where I can find them?
> > >
> > > Thanks,
> > > Jenny
> > >
> >
> >
>
Subscribe to:
Posts (Atom)