From: "Roger Abell [MVP]" <[email protected]>
Newsgroups: microsoft.public.cert.exam.mcse
Sent: Friday, June 28, 2002 4:16 PM
Subject: Re: Required Memory for SQL
"LOCUTUSSS" <[email protected]> wrote in message
news:eVhpA7wGCHA.2596@tkmsftngp10...
Hi,
I have a question about can any one help and answer it.
I have an SQL server that when querys are sent to it alot, most of them will
time out.
I need to find out how much (exactly) memory I need for the machine to keep
SQL running with no time outs on the Queries.
Thanxs
I believe you have the wrong question for solving your problem.
IOW throwing memory at it is not always the solution.
User Query Analyzer to analyze your query (doh!), and then
optimize the query itself and/or the indexing on the tables involved.
If you still have issues, look at size/placement of tempdb and ram.
Run the profiler to give you a view over aggregate runtime behavior
when under a load from the optimized queries.
--
Roger Abell
MS MVP (Windows Platform), MCSE, MCDBA
Associate Expert - Windows XP ExpertZone
http://www.microsoft.com/windowsxp/expertzone

From: "Jtyc" <[email protected]>
Newsgroups: microsoft.public.cert.exam.mcse
Sent: Tuesday, June 18, 2002 3:56 AM
Subject: Re: For 70-215
For the Server exam that I have in 2 weeks, I am doing the Transcender
tests. Plus I have the Sybex books. Is that enough? Or are there any
websites or books I should check out before going for the exam?
I am just feeling nervous, thats why I asked.
If you have a lab, that will greatly help.  Practical application is my
favorite way to learn.

From: "Ben Smith [MS]" <[email protected]>
Newsgroups: microsoft.public.cert.exam.mcse
Sent: Saturday, June 15, 2002 8:34 AM
Subject: Re: Windows 2000 Update Notification-----Newbie Question
In article <u3Z3QP9ECHA.2564@tkmsftngp04>, David Brown (the__3
@hotmail.com) writes...
I have a Windows 2000 pro machine that the Windows Update Notifications is
turned on.  Is there a way that I can turn it off?
Thanks in advance
Dave Brown
You can:
Remove it through Add/Remove Programs
Disable it through the Scheduled Tasks manager
Customize it through the "personalize" option on Windows
Update.
HTH
--
Ben Smith
Microsoft Training and Certification
Are you secure? http://www.microsoft.com/security
This posting is provided 밃S IS?with no warranties, and confers no rights.

From: "William King" <[email protected]>
Newsgroups: microsoft.public.cert.exam.mcse
Sent: Tuesday, June 11, 2002 4:40 PM
Subject: Re: VPN Connections
Ben, I think you have your wires crossed?!!??
Im trying to create a phone book address list with PBA (on the 2000 server
CD) and I need to know how to make it either ask for a password or for me to
enter one (for the ISP).
I have no problem connecting to the remote network with VPN once I have
established a connection to the internet, but I would like to log onto the
network having ticked the 'Log on with Dial-Up networking' box before I log on.
When I do this, CMAK tries to dial my ISP (using it's phonebook) but then it
fails because the ISP requires username&Password and CMAK tries to use my
network credentials.
William
"Ben Smith [MS]" <[email protected]> wrote in message
news:[email protected]...
In article <[email protected]>, William
King ([email protected]) writes...
I know this isn't stricklty in the MCSE content....
I am using CMAK (Connection Manager Admin Kit) to provide VPN access to
users. I want to add phonebook entries to the Connectiod so that the user
can use that entry to automatically dial-up and sign on to the internet.
The problem I have run up against is that when you use PBA (Phone Book
Administrator) to create the published address, there is nowhere to enter
the Username/password to authenticate to the ISP.
Has anyone here ever got this working?
You might want to ping the RRAS groups.
--
Ben Smith
Microsoft Training and Certification
Are you secure? http://www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no
rights.

From: "Roger Abell" <[email protected]>
Newsgroups: microsoft.public.cert.exam.mcse
Sent: Saturday, June 08, 2002 3:57 PM
Subject: Re: AD Design
A comment on the second of your observations.
There is a difference between there being no DNS servers
located at a remote site and there being no DNS resolution
available to clients of the remote site.
DNS resolution is an absolute requirement for healthful
operations.  From where the resolution services are obtained
is flexible based on available resources, etc..
--
Roger Abell
MVP (Windows Platform)  Associate Expert
The Expert Zone - www.microsoft.com/windowsxp/expertzone
"Mister Sandman" <[email protected]> wrote in message
news:e3t10JgDCHA.1108@tkmsftngp04...
I have a couple of questions about this post.  (Every time I argue it's in
the form of a question.)  See below:
You should have a DC at each site (for each domain represented at that
site) -- two for resilience.  Given that you're almost certainly going
to be multi-domain, you should have a GC server at each site -- two
for resilience
......
......
Given the WAN link between the 2 London offices they could share a
(pair of) DHCP server(s), assuming the routers connecting the sites
are DHCP-relay-enabled.
Is it common to do what some of the books say, which is to have a server
at each remote site, with a 20% exclusion, and then have the scopes also on
the server at the main site, with an 80% exclusion, and turn relay on at the
routers?  That way you are backed up a little in case one fails (unless
the VPN is down too).  Do people really do this, commonly?
You don't need DNS or WINS servers at each site.  (You don't need WINS
at all if you have no NT4 nor w9x boxen.)
I'm studying for my last test, 220, right now.  And I discovered something
interesting.  In a multiple domain situation, if logging on from a remote
site, the logon process uses DNS to find the Global Catalog server.  So if
there is no DNS, the GC is not found, and the logon will take place with
cached credentials, or not at all.  So what's the point of having a GC at
each location except to maybe improve performance?
I'm more of an NT 4.0 expert, retooling myself for Win2k, but I don't really
like the idea of no DNS at remote sites, seeing how Win2k is so dependent
and chatty with DNS.  I guess if the VPN links can't handle the replication
traffic (but then can they handle all the lookup traffic?  Probably, with so
few users at each remote location.), or there is a need for centralized
management, it makes sense, but it also makes me nervous knowing the logon
process isn't fully fault tolerant.
Sandman

From: Paul Adare <[email protected]>
Newsgroups: microsoft.public.cert.exam.mcse
Sent: Wednesday, June 05, 2002 8:40 PM
Subject: Re: Evil Countries. Was: Microsoft stop all it's exams in the
Middle East. Is this true?
In article <[email protected]>,
[email protected] says...
>Why can't you book Microsoft exams through VUE in Iran, Iraq or North Korea?
Because it is illegal to export Microsoft products to those countries as
per the US laws.
--
Paul Adare
A fine is a tax for doing wrong. A tax is a fine for doing well.

From: <Consultant? <[email protected]>>
Newsgroups: microsoft.public.cert.exam.mcse
Sent: Wednesday, June 05, 2002 7:16 AM
Subject: Re: Who's with me?
i say make it 800 or 850
"Mister Sandman" <[email protected]> wrote in message
news:u7fCZUBDCHA.1576@tkmsftngp04...
I think they should raise passing score on every test to 700.
Anyone agree?
All comments, flames, welcome.
Sandman

From: Sir Big Mac <[email protected]>
Newsgroups: microsoft.public.cert.exam.mcse
Sent: Tuesday, June 04, 2002 9:22 AM
Subject: Re: Where do I start? I
What are you interested in doing? If LAN is what you're into (since you said
your a network administrator already), then the MCSA/CCNA is not a bad
choice.  If you're into multiple location deployments, then the MCSE and a
CCNP would be the way to go.
Or, you can ditch Microsoft and Cisco both and go vendor neutral with
CompTIA.  Most places will still ask for MS or Cisco certs however.
srb
"FS" <[email protected]> wrote in message
news:[email protected]...
http://www.microsoft.com/mcp/
<[email protected]> wrote in message news:[email protected]...
Hello Everyone,
I appreciate you taking the time to read my post.
I am considering getting certified.
I'm a Network Administrator and have been at it for about 8 years
I have never looked into doing this before.
My questions are:
Where the hell do I start.
How do I decide what areas to get certified in?
Do I get a MCSE or a MCSA?
What's the best way to learn the information to pass the test.
Again, thanks for taking the time and the helpful info.
CP

From: _Mike_ <[email protected]>
Newsgroups: microsoft.public.cert.exam.mcse
Sent: Tuesday, June 04, 2002 7:42 AM
Subject: Re: NNTP Service Question
"Christopher" <[email protected]> wrote in message
news:e0IHu1xCCHA.2712@tkmsftngp04...
>Hello,
>I'm playing with NNTP and I'm curious if it's possible to delete a message
>from the news server once it has been posted publically (no moderation) and
>anonymously?
Some news servers support it, some don't, it depends how far it has
propagated by the time you delete it, I would not bank on it working.
Cheers
Mike

From: <Consultant? <[email protected]>>
Newsgroups: microsoft.public.cert.exam.mcse
Sent: Tuesday, June 04, 2002 1:46 AM
Subject: Re: DNS Registration
you can use whatever name you want
"Vampidor" <[email protected]> wrote in message
news:[email protected]...
Is it necessary to register a DNS name to be able to study for the exams?
Let's say, when I am installin AD and DNS, or can I just use any name? My
2 networked pc's are behind a firewall -Linksys router using DSL. I am not
thinking on host any web site or manage email, I just want to learn AD.
Thank you

From: Darkmere72 <[email protected]>
Newsgroups: microsoft.public.cert.exam.mcse
Sent: Sunday, June 02, 2002 10:18 PM
Subject: Re: MCP Exams
I agree - I tend to use Sybex and MS Press.  There's nothing better than MS to
give you an insight into how the people who write the exams think!  (OK, apart
from braindumps, but most people take a dim view of using them).
There are also lots of free resources that can broaden your knowledge so you
can feel confident you've covered everything.
Free practice exams:
www.prometric.com
Free W2K vids/study guides:
www.freemcse.com
CIDR:
www.learntosubnet.com
Study guides:
www.cramsession.com
Live server practice over the net (demo is free):
www.propoint.com
Also check out SunBelt Software; in addition to tons of network admin tools,
they have free newsgroup lists, newsletter and often free utilities for download.
You're welcome to join our study group - if interested, please mail me.

From: Glenn D. Crosse <[email protected]>
Newsgroups: microsoft.public.cert.exam.mcse
Sent: Saturday, June 01, 2002 3:11 AM
Subject: Re: 215
I passed the 215 yesterday with a 860.
Transcender and Beachfront software really helped in the prep for the exam.
The examcram book and tests were confusing and misleading.
Glenn
"gf" <[email protected]> wrote in message
news:#$2BWN9vBHA.2152@tkmsftngp02...
I think you may be confusing 215 with 218.
I don't recall anyone saying 215 was RRAS or GPO, though both figure
prominantly on 218.
216 is the one where you need to know RRAS better than you know your own
name, though....
Anyway, congrats!