Certification: Looking for advise

Hi All

I have been working with Ms access Database the last four years and have gained a lot of experience which help me to have extensive knowledge of Jet, Dao and Ado. Since The Begining of this year i hv been migrating to SQL server server and for that i bought two books :Programming Access project file with Microsoft Sql server and Access Developers Guide to Ms sql server : Chipman & Baron ( this oner is simply a great achievement ). They help me out in the very near past to complety migrate a two database approch Jet Application to a reliable (Adp/ SQL Server client server ) where major parts of the code business logic has been transfered to run on the server as stored procedures and all forms re-built as unbound. these merely leads to a great enhancement of the applications.

My goal now is register to MCDBA and get the certification. I am not interested by classroom training from Microsoft Parterns or online training. I am looking for books that can help to get well prepared for the exams.

Have found this two books in Amazon:

1 - MCAD/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 Database Design and Implementation, Exam 70-229, Second Edition

2- MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000 System Administration, 70-228, Second Edition

However their rating didn't encourage me to place directly my orders.

Does someone have any experience with them ?

Do you think they will considerably help me to add value to my knowledge of SQL Server and get ready for the exam ?

Do you know some others books you woul rather encourage me to buy ?

Any advice in this regards really appreciated.Transcender

www.transcender.com

Regards,

hmscott|||The MS Press books are not the best for learning. Try the Que or Sybex books for learning the material while preparing for certification. Make sure you get hands-on experience with all the examples and labs as you read the books. Use Transcender after reading the books to assess your readiness to take the test. Good luck!

Certification training?

I hope this is the right place to ask this. Does anyone know places
that offer SQL Server 2005 certification training and testing (MCTS,
MCITP) in South Florida (Palm Beach County and surrounding area)?

I've tried searching around on the web, and it's hard to find what I'm
looking for mixed in with all the junk. I found a couple of places that
have the training I want, but I'm sure I didn't find all of them. So
far, I'm not overly impressed, so more options would be a good thing.

Also, about how much do those types of classes usually cost? How about
the tests? I might just go the self study route, instead of a class,
but I still need to know how much to expect to pay for testing.

Thanks in advance,

--Richardblueghost73@.yahoo.com (blueghost73@.yahoo.com) writes:

Quote:

Originally Posted by

I hope this is the right place to ask this. Does anyone know places
that offer SQL Server 2005 certification training and testing (MCTS,
MCITP) in South Florida (Palm Beach County and surrounding area)?
>
I've tried searching around on the web, and it's hard to find what I'm
looking for mixed in with all the junk. I found a couple of places that
have the training I want, but I'm sure I didn't find all of them. So
far, I'm not overly impressed, so more options would be a good thing.
>
Also, about how much do those types of classes usually cost? How about
the tests? I might just go the self study route, instead of a class,
but I still need to know how much to expect to pay for testing.

I entered "SQL Server 2005 certification training" and "Palm Beach" in
the search field at Google, and ended up at
http://www.mcse-training-classes.co...lm-Beach-FL.htm
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Certification Signature

I already have MCP status. Assuming I earn MCTS credential, what is the
appropriate signature?
1) John Doe, MCTS, MCP
Or
2) John Doe, MCTS
While reading user posts, I can't seem to find a consistant useage regarding
signatures.
My question is general in nature, as I plan on also getting MCSA/MCSE.
Thanks!please just put one...whichever you want noticed...:)
None is better.
--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"labsRcool@.community.nospan"
<labsRcoolcommunitynospan@.discussions.microsoft.com> wrote in message
news:750ACE96-469F-4023-9D4B-8125698DB310@.microsoft.com...
>I already have MCP status. Assuming I earn MCTS credential, what is the
> appropriate signature?
> 1) John Doe, MCTS, MCP
> Or
> 2) John Doe, MCTS
> While reading user posts, I can't seem to find a consistant useage
> regarding
> signatures.
> My question is general in nature, as I plan on also getting MCSA/MCSE.
> Thanks!

certification question

I am reading Administering SQL Server, a study guide for 70-228
on page 27, it says:
"INSTEAD OF triggers are useful when a DML operation is unsuccessful."
I think this is nonsense. Any comments?Ford Desperado (ford_desperado@.yahoo.com) writes:
> I am reading Administering SQL Server, a study guide for 70-228
> on page 27, it says:
> "INSTEAD OF triggers are useful when a DML operation is unsuccessful."
> I think this is nonsense. Any comments?

Without any context at all, the sentence certainly looks funny. It reminds
of what I once read in a manual from DEC: "Frequently, unexpected errors are
entirely unpredictable."

I guess what they are trying to say is that when you cannot insert, update
or delete directly on a view, because the view does not live up to the
rules, then you can achieve this with an INSTEAD OF trigger.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||>Without any context at all, the sentence certainly looks funny.

well there isn't any more context.
Thanks Erland|||It's certainly a strange comment in the absence of any context, as
Erland says. Another possible explanation might be that if you have to
INSERT data into a table where you know that some data will violate
constraints, an INSTEAD OF trigger could be used to INSERT only the
good data, and flag or log the bad data; if you did a single INSERT,
then it would all be rolled back.

Simon|||One more nonsense:

the book claims that db_denydatawriter " Can deny the write permissions
on any object"

According to BOL, db_denydatawriter Cannot modify any data in any user
table in the database, and BOL seems to be correct

I think the author, Joyjit Mukherjee, screwed it up|||It sounds like he took a guess based on the group name, rather than
look it up in BOL, which would make me wonder about the quality of the
rest of the book. I've seen the official MS Press MCDBA study guides,
and they seem to be quite good, but then I suppose they should be.

Incidentally, sp_dbfixedrolepermission gives quite a detailed (and
accurate) list of each role's permissions - it's a bit clearer than the
comments in BOL.

Simon

Certification Question

Hi all,

I am new to Sql Server 2005

I planning to take exam MCTP exam 70-445

is the cert 70-431 a pre-requisite for certs 70-445 and 70-446?

Thanks and regards

Currently, according to the 'official' Microsoft websites, 431 is NOT required for SQL BI certification.

See:

http://www.microsoft.com/learning/mcp/mcts/bi/default.mspx
http://www.microsoft.com/learning/mcp/mcitp/bid/default.mspx

Certification Exam on reporting service

Does anybody have any idea if there is certification exam yet?
--
SincerelyThere is course 2030
(http://www.microsoft.com/traincert/syllabi/2030AFINAL.ASP) but it is not
part of any certification track yet.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"Frank RS" <FrankRS@.discussions.microsoft.com> wrote in message
news:AD66A6C8-22D8-4388-86BE-3060C84013F1@.microsoft.com...
> Does anybody have any idea if there is certification exam yet?
> --
> Sincerely
>

Certification

Hi All,
This post isn't particularly directly related to the Group but I
thought I would get some opinions.
I use SQL Server 2000 on a daily basis - both administering &
programming, coupled with VB6 client applications. I am currently
learning VB .NET
I am thinking about getting some kind of certification as I learn VB
.NET. I have been looking at the MCAD track on the Microsoft site. At
my current programming level this seems to be a good starting point. I
passed Exam 70-229 last year, which counts as an elective exam towards
the MCAD certification.
Does anyone have any advice/opinions for my current situation.
I am aware that there is the MCSD certification, however, I was
planning to tackle that one a bit later - see how I get on with the
MCAD first?
Thanks in advance for any comments.
BarryMicrosoft is in the process of rolling out new exams and certifications:
http://www.microsoft.com/learning/mcp/newgen/
"Barry" <barry.oconnor@.singers.co.im> wrote in message
news:1139511623.548378.271810@.g44g2000cwa.googlegroups.com...
> Hi All,
> This post isn't particularly directly related to the Group but I
> thought I would get some opinions.
> I use SQL Server 2000 on a daily basis - both administering &
> programming, coupled with VB6 client applications. I am currently
> learning VB .NET
> I am thinking about getting some kind of certification as I learn VB
> .NET. I have been looking at the MCAD track on the Microsoft site. At
> my current programming level this seems to be a good starting point. I
> passed Exam 70-229 last year, which counts as an elective exam towards
> the MCAD certification.
> Does anyone have any advice/opinions for my current situation.
> I am aware that there is the MCSD certification, however, I was
> planning to tackle that one a bit later - see how I get on with the
> MCAD first?
> Thanks in advance for any comments.
> Barry
>

Certification

Can anyone guide me on how to prepare for exam 229. There is just ton of
information out there. What is a good begining point? I'll appreciate if
someone can send me a link for good mock exams.Personally, I would get a copy of _Inside SQL Server 2000_ by Kalen Delaney.
Read (and understand) it cover-to-cover and you'll be all set.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"docsql" <docsql@.noemail.nospam> wrote in message
news:eUBHBdccFHA.3244@.TK2MSFTNGP10.phx.gbl...
> Can anyone guide me on how to prepare for exam 229. There is just ton of
> information out there. What is a good begining point? I'll appreciate if
> someone can send me a link for good mock exams.
>|||ACK
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> schrieb im
Newsbeitrag news:eHnn$tccFHA.4028@.TK2MSFTNGP10.phx.gbl...
> Personally, I would get a copy of _Inside SQL Server 2000_ by Kalen
> Delaney.
> Read (and understand) it cover-to-cover and you'll be all set.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "docsql" <docsql@.noemail.nospam> wrote in message
> news:eUBHBdccFHA.3244@.TK2MSFTNGP10.phx.gbl...
>|||agreed.
also try to get the Transcender Exams.
Greg Jackson
PDX, Oregon

Certification

Can anyone guide me on how to prepare for exam 229. There is just ton of
information out there. What is a good begining point? I'll appreciate if
someone can send me a link for good mock exams.
Personally, I would get a copy of _Inside SQL Server 2000_ by Kalen Delaney.
Read (and understand) it cover-to-cover and you'll be all set.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
"docsql" <docsql@.noemail.nospam> wrote in message
news:eUBHBdccFHA.3244@.TK2MSFTNGP10.phx.gbl...
> Can anyone guide me on how to prepare for exam 229. There is just ton of
> information out there. What is a good begining point? I'll appreciate if
> someone can send me a link for good mock exams.
>
|||ACK
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> schrieb im
Newsbeitrag news:eHnn$tccFHA.4028@.TK2MSFTNGP10.phx.gbl...
> Personally, I would get a copy of _Inside SQL Server 2000_ by Kalen
> Delaney.
> Read (and understand) it cover-to-cover and you'll be all set.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "docsql" <docsql@.noemail.nospam> wrote in message
> news:eUBHBdccFHA.3244@.TK2MSFTNGP10.phx.gbl...
>
|||agreed.
also try to get the Transcender Exams.
Greg Jackson
PDX, Oregon

Certification

I am just wondering if I wanna upgrade my MCDBA 2000 certification to MCDBA
2005 then which exam I have to clear ?
Thanks
Hi,
google should be your friend allthe time before asking in the groups:
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/default.mspx
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||That means only one exam (Exam 70-447 to upgrade from 2000 to 2005 ?
Please advice.
"Jens" <Jens@.sqlserver2005.de> wrote in message
news:1169066687.258676.201810@.a75g2000cwd.googlegr oups.com...
> Hi,
> google should be your friend allthe time before asking in the groups:
> http://www.microsoft.com/learning/mcp/mcitp/dbadmin/default.mspx
>
> HTH, Jens K. Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
>
|||Hi,
and 70-431 in addition.
HTH, jens K. Suessmeyer.
http://www.sqlserver2005.de

Certification

Can anyone guide me on how to prepare for exam 229. There is just ton of
information out there. What is a good begining point? I'll appreciate if
someone can send me a link for good mock exams.Personally, I would get a copy of _Inside SQL Server 2000_ by Kalen Delaney.
Read (and understand) it cover-to-cover and you'll be all set.
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--
"docsql" <docsql@.noemail.nospam> wrote in message
news:eUBHBdccFHA.3244@.TK2MSFTNGP10.phx.gbl...
> Can anyone guide me on how to prepare for exam 229. There is just ton of
> information out there. What is a good begining point? I'll appreciate if
> someone can send me a link for good mock exams.
>|||ACK
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> schrieb im
Newsbeitrag news:eHnn$tccFHA.4028@.TK2MSFTNGP10.phx.gbl...
> Personally, I would get a copy of _Inside SQL Server 2000_ by Kalen
> Delaney.
> Read (and understand) it cover-to-cover and you'll be all set.
>
> --
> Adam Machanic
> SQL Server MVP
> http://www.datamanipulation.net
> --
>
> "docsql" <docsql@.noemail.nospam> wrote in message
> news:eUBHBdccFHA.3244@.TK2MSFTNGP10.phx.gbl...
>> Can anyone guide me on how to prepare for exam 229. There is just ton of
>> information out there. What is a good begining point? I'll appreciate
>> if
>> someone can send me a link for good mock exams.
>>
>|||agreed.
also try to get the Transcender Exams.
Greg Jackson
PDX, Oregon

CASS Certification and Postal Discounts

My organization is moving to a SQL based CRM solution that is customized for
our industry. As a part of this move we are converting all our documents
over to SQL Reports. We have also been contemplating using a CASS certified
product to help us get some substantial postal discounts for our mailings.
Is anyone aware of a product that can take the data being fed into a
reporting server and queue the reports, sort and certify, and then print to
allow postal discounts?
I realize that I am simplifing the process some but I am trying to find out
if there are any vendors servicing this market yet.
--
"Okay, I signed in this box. How do I wipe the ink off my screen now?"I don't know of a product that will do what you want...
However, you might think of this in two parts..
Certifying the addresses in the database,
sorting/printing/printing the CASS Cert documents
The first will be much easier than the second...
In order to get the lowest rate you must print the documents in the same
group together... Docs will print in the order that they complete, so you'd
probably have to buy/write something to group reports into a single printing
batch..
Another thing you might try is to print each group of reports one at a time,
don't start the second group until the first has completed...
In any case - you'll probably have to work very hard if each report is
specific to the address, instead of printing the same report and delivering
it to many people.
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Julian I. Spring" wrote:
> My organization is moving to a SQL based CRM solution that is customized for
> our industry. As a part of this move we are converting all our documents
> over to SQL Reports. We have also been contemplating using a CASS certified
> product to help us get some substantial postal discounts for our mailings.
> Is anyone aware of a product that can take the data being fed into a
> reporting server and queue the reports, sort and certify, and then print to
> allow postal discounts?
> I realize that I am simplifing the process some but I am trying to find out
> if there are any vendors servicing this market yet.
> --
> "Okay, I signed in this box. How do I wipe the ink off my screen now?"