Re: More about 70-228?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: kat (eternalbliss_at_NOSPAM.techie.com)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 09:35:56 -0800

I passed 228 a few weeks ago (January, I think) and I also used the
sybex guide, and a trial version on SQL. I didn't use VMware, just the
plain, standard sql server.

I don't think you've mentioned your experience/history with
microsoft?I'm asking because I'd say I got 15-20 questions that
overlapped with 210/215. I.E. There were several questions on raid,
backups, which drive to store the log/db files on. And file permissions.
It's a lot easier if yu already understand GPO and inheritance (if sally
is a member of a group that has denied read permissions, but she has
read permissions, can se view the DB?)

As for the programming, know your SQL Transaction statements. Select,
obviously, and there were a few others. I didn't get anything on XML, at
all. Must be 229. I don't even remmeber reading it, but I already know
XML, so I may hae skipped it. GO to the microsoft website, read the exam
objectives. Read the book, and practice, practice, practice.

Good luck.

CoolHandSid wrote:

> Thanks Paul and Neil for your answers!!
> I have the Sybex study guide and some general MS SQL books.
> I'm just curious, Do they ask anything about T-SQL or programming in
> 70-228?
>
> Sid.
> "Paul Lynch" <paul.lynch@nospam.com> wrote in message
> news:gltl609pg4nrd2e9njqkcjco05aimmjpr9@4ax.com...
> 

-- 
Kat FORMER MCNGP #29
/* Get the facts first. You can distort them later. */

Relevant Pages

  • Re: More about 70-228?
    ... This is my first ever microsoft certification, ... and a trial version on SQL. ... And file permissions. ... Read the book, and practice, practice, practice. ...
    (microsoft.public.cert.exam.mcse)
  • Re: More about 70-228?
    ... This was fairly more difficult than the 2000 professional exams, ... probably since I don't work with SQL as much. ... >>is a member of a group that has denied read permissions, ... Read the book, and practice, practice, practice. ...
    (microsoft.public.cert.exam.mcse)
  • Re: SQL CE Synching Problems
    ... Have you granted IUSER_ServerName access to your publication within SQL ... It looks like the permissions problem is getting access to the publication. ... so the issue has to be between the server tools and the publisher. ... > A request to send data to the computer running IIS has failed. ...
    (microsoft.public.sqlserver.ce)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging in irrespective of database access
    ... Sysadmin role members have full permissions, ... SQL Server MVP ... > My problem is that in the Login section of Enterprise Manger I have to> specify that each login has the System Admin ticked under Server Roles> because in SQL 2000 there doesn't seem to a Grant All permissions option> like there used to be in SQL 6.5. ... > What's the point in having the Database Access section if the System Admin> under Server Roles allows you to get into anything?. ...
    (microsoft.public.sqlserver.server)