MCDBA Roadmap

Hey Guys,
Does any 1 have the roadmap to MCDBA? If you have the document, please send
me a link where I can download or please email the document to
seelanr@.hotmail.com
Thanks"Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
> Hey Guys,
> Does any 1 have the roadmap to MCDBA? If you have the document, please
> send
> me a link where I can download or please email the document to
> seelanr@.hotmail.com
> Thanks
>
http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
Rick Sawtell
MCT, MCSD, MCDBA|||Thanks Rick
But that web page only has the requirements and NOT the ROADMAP.
"Rick Sawtell" <Quickening@.msn.com> wrote in message
news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
> "Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
> news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
> http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>|||What are you talking about if not the MCDBA requirements? The roadmap
is simply do the 3 core exams (SQL design, SQL admin & one of the Win
Server exams) and 1 of the electives (mostly dev/design exams). Or do
you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCDBA (SQL 2005) -> ?
etc.? If so then this may (or may not) be helpful:
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
*mike hodgson*
http://sqlnerd.blogspot.com
Seelan Raja wrote:

>Thanks Rick
>But that web page only has the requirements and NOT the ROADMAP.
>"Rick Sawtell" <Quickening@.msn.com> wrote in message
>news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
>
>
>|||Hey Guys,
Thanks for the replies but What I am looking for is the steps/the order in w
hich I take the courses/ exam.
-Seelan
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:OJgWJBoNGHA.3936@.
TK2MSFTNGP10.phx.gbl...
What are you talking about if not the MCDBA requirements? The roadmap is simply do the
3 core exams (SQL design, SQL admin & one of the Win Server exams) and 1 of the electi
ves (mostly dev/design exams). Or do you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCD
BA (SQL 2005) -> ? etc.? If so then this may (or may not) be helpful: http://ww
w.microsoft.com/le.../mcitp/dbadmin/
mike hodgson
http://sqlnerd.blogspot.com
Seelan Raja wrote:
Thanks Rick
But that web page only has the requirements and NOT the ROADMAP.
"Rick Sawtell" <Quickening@.msn.com> wrote in message
news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
"Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
Hey Guys,
Does any 1 have the roadmap to MCDBA? If you have the document, please
send
me a link where I can download or please email the document to
seelanr@.hotmail.com
Thanks
http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
Rick Sawtell
MCT, MCSD, MCDBA|||There are no steps. Order is unimportant. You can take them in any
order you feel like. Each exam is independent in it's own right. Many
people like to do the ones they are most comfortably with first (ie. the
ones they think they are most likely to pass) to give them a confidence
boost for the harder ones but it's all just personal preference.
*mike hodgson*
http://sqlnerd.blogspot.com
Seelan Raja wrote:
[vbcol=seagreen]
> Hey Guys,
> Thanks for the replies but What I am looking for is the steps/the
> order in which I take the courses/ exam.
> -Seelan
> "Mike Hodgson" <e1minst3r@.gmail.com <mailto:e1minst3r@.gmail.com>>
> wrote in message news:OJgWJBoNGHA.3936@.TK2MSFTNGP10.phx.gbl...
> What are you talking about if not the MCDBA requirements? The
> roadmap is simply do the 3 core exams (SQL design, SQL admin & one
> of the Win Server exams) and 1 of the electives (mostly dev/design
> exams). Or do you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCDBA
> (SQL 2005) -> ? etc.? If so then this may (or may not) be
> helpful: http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
> Seelan Raja wrote:
>

MCDBA Roadmap

Hey Guys,
Does any 1 have the roadmap to MCDBA? If you have the document, please send
me a link where I can download or please email the document to
seelanr@.hotmail.com
Thanks
"Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
> Hey Guys,
> Does any 1 have the roadmap to MCDBA? If you have the document, please
> send
> me a link where I can download or please email the document to
> seelanr@.hotmail.com
> Thanks
>
http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
Rick Sawtell
MCT, MCSD, MCDBA
|||Thanks Rick
But that web page only has the requirements and NOT the ROADMAP.
"Rick Sawtell" <Quickening@.msn.com> wrote in message
news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
> "Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
> news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
> http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
>
> Rick Sawtell
> MCT, MCSD, MCDBA
>
>
|||What are you talking about if not the MCDBA requirements? The roadmap
is simply do the 3 core exams (SQL design, SQL admin & one of the Win
Server exams) and 1 of the electives (mostly dev/design exams). Or do
you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCDBA (SQL 2005) -> ?
etc.? If so then this may (or may not) be helpful:
http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
*mike hodgson*
http://sqlnerd.blogspot.com
Seelan Raja wrote:

>Thanks Rick
>But that web page only has the requirements and NOT the ROADMAP.
>"Rick Sawtell" <Quickening@.msn.com> wrote in message
>news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
>
>
>
|||Hey Guys,
Thanks for the replies but What I am looking for is the steps/the order in which I take the courses/ exam.
-Seelan
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message news:OJgWJBoNGHA.3936@.TK2MSFTNGP10.phx.gbl...
What are you talking about if not the MCDBA requirements? The roadmap is simply do the 3 core exams (SQL design, SQL admin & one of the Win Server exams) and 1 of the electives (mostly dev/design exams). Or do you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCDBA (SQL 2005) -> ? etc.? If so then this may (or may not) be helpful: http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
mike hodgson
http://sqlnerd.blogspot.com
Seelan Raja wrote:
Thanks Rick
But that web page only has the requirements and NOT the ROADMAP.
"Rick Sawtell" <Quickening@.msn.com> wrote in message
news:uACCW9kNGHA.2624@.TK2MSFTNGP12.phx.gbl...
"Seelan Raja" <seelan_rd@.NOSPAMyahoo.com> wrote in message
news:%234iLarkNGHA.1716@.TK2MSFTNGP10.phx.gbl...
Hey Guys,
Does any 1 have the roadmap to MCDBA? If you have the document, please
send
me a link where I can download or please email the document to
seelanr@.hotmail.com
Thanks
http://www.microsoft.com/learning/mcp/mcdba/mcdba.asp
Rick Sawtell
MCT, MCSD, MCDBA
|||There are no steps. Order is unimportant. You can take them in any
order you feel like. Each exam is independent in it's own right. Many
people like to do the ones they are most comfortably with first (ie. the
ones they think they are most likely to pass) to give them a confidence
boost for the harder ones but it's all just personal preference.
*mike hodgson*
http://sqlnerd.blogspot.com
Seelan Raja wrote:
[vbcol=seagreen]
> Hey Guys,
> Thanks for the replies but What I am looking for is the steps/the
> order in which I take the courses/ exam.
> -Seelan
> "Mike Hodgson" <e1minst3r@.gmail.com <mailto:e1minst3r@.gmail.com>>
> wrote in message news:OJgWJBoNGHA.3936@.TK2MSFTNGP10.phx.gbl...
> What are you talking about if not the MCDBA requirements? The
> roadmap is simply do the 3 core exams (SQL design, SQL admin & one
> of the Win Server exams) and 1 of the electives (mostly dev/design
> exams). Or do you mean MCDBA (SQL 7) -> MCDBA (SQL 2000) -> MCDBA
> (SQL 2005) -> ? etc.? If so then this may (or may not) be
> helpful: http://www.microsoft.com/learning/mcp/mcitp/dbadmin/
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
> Seelan Raja wrote:
sql

Maximum SQL 2005 Database Size

Hello! I'm trying to figure out what the ultimate size limitation for a SQL 2005 Enterprise server is. This document is helpful but I'm a bit confused:

http://msdn2.microsoft.com/en-us/library/ms143432.aspx

In the document, it says that the maximum database size is 524,258 terabytes; however, it also says that the maximum data file size--which I assume is the .MDF file--is 16 terabytes. My question is, how can you create a 524,258 TB database if the maximum file size 16 TB?

Dumb question, I'm sure...please enlighten me!

Norm

A database have minimum a data file and a log file so

(I quote from that document)

File size (data)

16 terabytes

16 terabytes

File size (log)

2 terabytes

2 terabytes

mean that you can have (528,258-2):16=33016 data files (id est 1 mdf file and 33015 ndf files) and 1 log file.

Or other combination of data and log files that totalize 528,258 terabytes.

|||I still don't understand. If I create a database, call it NewJack, the system automatically creates an .MDF file named newjack.mdf. If that file is limited to 16TB, then my NewJack database can only be 16TB...right?|||

In Management Studio right click on your database go to properties then go to files and file groups, these two properties let you add and remove MDF, LDF and NDF as needed. That is you can place a set of tables in a file group and the indexes in separate file groups try the link below for how you can use the file groups to separate fast growing databases into smaller manageable file groups.

http://msdn2.microsoft.com/en-us/library/ms179316.aspx

Maximum memory and processor support for sql server 2000 and 2005

Hi,
I am trying to search a document that would let me know the maximum
processor and memory for SQL Server 2000 and SQL Server 2005 for the
following Opearating Systems -
Windows 2000 Server
Windows 2000 Advanced Server
Windows 2003 Standard Server
Windows 2003 Enterprise Server
Windows 2003 DataCenter Server
Windows 2003 Web Server
I'll appreciate if someone can point me to the right direction. Thanks.Hi,
Here are some links for SQL 2000 + 2005 :
http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx
http://technet.microsoft.com/en-us/library/ms143760.aspx
http://technet.microsoft.com/en-us/library/ms143685.aspx
Ayad Shammout
"sharman" <sharman@.discussions.microsoft.com> wrote in message
news:8CCA4208-9AF2-4E23-9DD6-69E062A32EAD@.microsoft.com...
> Hi,
> I am trying to search a document that would let me know the maximum
> processor and memory for SQL Server 2000 and SQL Server 2005 for the
> following Opearating Systems -
> Windows 2000 Server
> Windows 2000 Advanced Server
> Windows 2003 Standard Server
> Windows 2003 Enterprise Server
> Windows 2003 DataCenter Server
> Windows 2003 Web Server
> I'll appreciate if someone can point me to the right direction. Thanks.|||Thanks for the info. Is there any article which gives info on Max Memory and
Max Processor for SQL Server 2000 running on Winodws Server 2003?
"Ayad Shammout" wrote:
> Hi,
> Here are some links for SQL 2000 + 2005 :
> http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx
> http://technet.microsoft.com/en-us/library/ms143760.aspx
> http://technet.microsoft.com/en-us/library/ms143685.aspx
> Ayad Shammout
> "sharman" <sharman@.discussions.microsoft.com> wrote in message
> news:8CCA4208-9AF2-4E23-9DD6-69E062A32EAD@.microsoft.com...
> > Hi,
> >
> > I am trying to search a document that would let me know the maximum
> > processor and memory for SQL Server 2000 and SQL Server 2005 for the
> > following Opearating Systems -
> >
> > Windows 2000 Server
> > Windows 2000 Advanced Server
> > Windows 2003 Standard Server
> > Windows 2003 Enterprise Server
> > Windows 2003 DataCenter Server
> > Windows 2003 Web Server
> >
> > I'll appreciate if someone can point me to the right direction. Thanks.
>
>|||Look at http://support.microsoft.com/kb/274750 and
http://www.sql-server-performance.com/articles/per/awe_memory_sql2000_p1.aspx .
Regards,
Viatcheslav V. Vassiliev
"sharman" <sharman@.discussions.microsoft.com> Ñ?ообÑ?ил/Ñ?ообÑ?ила в новоÑ?Ñ?Ñ?Ñ?
Ñ?ледÑ?Ñ?Ñ?ее: news:DEDA7AA4-E34E-4386-B191-96D79947087C@.microsoft.com...
> Thanks for the info. Is there any article which gives info on Max Memory
> and
> Max Processor for SQL Server 2000 running on Winodws Server 2003?
> "Ayad Shammout" wrote:
>> Hi,
>> Here are some links for SQL 2000 + 2005 :
>> http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx
>> http://technet.microsoft.com/en-us/library/ms143760.aspx
>> http://technet.microsoft.com/en-us/library/ms143685.aspx
>> Ayad Shammout
>> "sharman" <sharman@.discussions.microsoft.com> wrote in message
>> news:8CCA4208-9AF2-4E23-9DD6-69E062A32EAD@.microsoft.com...
>> > Hi,
>> >
>> > I am trying to search a document that would let me know the maximum
>> > processor and memory for SQL Server 2000 and SQL Server 2005 for the
>> > following Opearating Systems -
>> >
>> > Windows 2000 Server
>> > Windows 2000 Advanced Server
>> > Windows 2003 Standard Server
>> > Windows 2003 Enterprise Server
>> > Windows 2003 DataCenter Server
>> > Windows 2003 Web Server
>> >
>> > I'll appreciate if someone can point me to the right direction. Thanks.
>>