MCDBA (SQL Server 2000) Exams Still Available ?
May 31, 2007Can anybody answer :
Are MCDBA (SQL Server 2000) exams still available today ?
Is it worth going for this exam today, in spite of the fact SQL Server 2005 has been released ?
ADVERTISEMENT
MCDBA Exams
Feb 24, 2000Does anyone know of a self test area for the MCDBA exams?
View 1 Replies View RelatedAbout MS Exams In SQL Server 2000
May 4, 2007Hi all,
I am new to SQL Server 2000 and i want to take MCP exams in SQL,
can any one suggest me what exams i have to write.
Thank's & Regard's
Peter
SQL SERVER 7.0 Exams
Nov 21, 2000I'm just looking for some SQL SERVER 7.0 ADMIN/DESIGN exams, regarding my preparation for the MCP exams.
Thanks
When Might The SQL Server 2005 Exams Come Out?
Aug 14, 2004I know SQL Server 2005 isn't out yet untill next year, but I am wondering if anyone knows about when the MCP exams might come out for it?
I am an MCSD and MCAD, and I am thinking about getting MCDBA soon, and I am wondering if it would be better for me to wait for the SQL Server 2005 exams.
SQL Server And SQL Exams And Brainbench
Mar 28, 2004Can anyone tell me where to find a site with Braindumps specifically for Brainbench exams SQL ANSI and SQL Server 2000? Even though they are "open book", they are more challenging than I previously thought. Or if not, can anyone suggest some VERY useful books/materials to pass exams with Intermediate-Expert level knowledge of SQL and SQL Server?
Responses can be directed to stevengara@hotmail.com
Thanks,
Steve G.
MS Exams 70-445 And 70-446.
Aug 9, 2006Does anyone know when these will be available?
TIA, cfr
Cert Exams
Jun 21, 2008how good are certmagic.com to prepare
for ccna and mcse exams . i have a long
learning ahead to do and will realy like
some practice questions to practice
myself . anyone have any idea about certmagic
exams , plz let me know
Important Information About Microsoft Exams
Jun 2, 2008There are twelve more exams will retire on March 31st, 2009. Microsoft has announced this information. These exams focus on technologies will be no longer included in Microsoft mainstream support. The exams are currently required to achieve Microsoft Certified Application Developer (MCAD), Microsoft Certified Solution Developer (MCSD), and Microsoft Certified Database Administrator (MCDBA) certifications.
Details:
Developer exams that retire on March 31, 2009
€¢ Exam 70-300: Analyzing Requirements and Defining Microsoft .NET Solution Architectures
€¢ Exam 70-301: Managing, Organizing, and Delivering IT Projects by Using Microsoft Solutions Framework 3.0
€¢ Exam 70-305: Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
€¢ Exam 70-306: Developing and Implementing Windows-based Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET
€¢ Exam 70-310: Developing XML Web Services and Server Components with Microsoft Visual Basic .NET and the Microsoft .NET Framework
€¢ Exam 70-315: Developing and Implementing Web Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
€¢ Exam 70-316: Developing and Implementing Windows-based Applications with Microsoft Visual C# .NET and Microsoft Visual Studio .NET
€¢ Exam 70-320: Developing XML Web Services and Server Components with Microsoft Visual C# and the Microsoft .NET Framework
€¢ Exam 70-330: Implementing Security for Applications with Microsoft Visual Basic .NET
€¢ Exam 70-340: Implementing Security for Applications with Microsoft Visual C# .NET
Microsoft SQL Server exams that retire on March 31, 2009
€¢ Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
€¢ Exam 70-229: Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
This article is quoted from microsoft.com.
MCDBA Hot Or Not?
Sep 24, 2004I've been working with SQL for close to a year now and I'm wondering if its worth the time and money to become certified. Are DBA's still on the up and rising or another job that will be outsourced to India?
View 3 Replies View RelatedMcdba
Oct 26, 2004Hi
I am wanting to take the 70-228 and 70-229 exams. Does anyone who has already passed them have any recommendations for the best / most complete books for studying them? Opinions seem so varied on Amazon...
Thx
Des
Mcdba
Feb 26, 2008Hi,
I have been a DBA for about 5 years now but I have never considered getting MCDBA certification until now..
Is it worth doing?
Whats the best way to revise for the exam? i.e are there any free online tests ect?
MCDBA - UK
Jul 20, 2005Is it worth studying towards an MCDBA (hopefully going to get myemployer to pay for it) ... has anyone completed it in the UK? if sowhat learning methods did you use(ie Boot Camp, elearning etc)? Andwho do you recommend for the training course?ThanksChris Longstaff
View 1 Replies View RelatedMCDBA Is Good For DBA?
Jan 21, 2001Hi All
I am planning to do MCDBA, whether it'd good for DBA's, is't worth of doing or not, Please send me your comments.
Thanks
Regards
Ram
MCDBA - Is It Worthwhile?
Jul 7, 2000Anyone take (and pass) the MCDBA exams? If so, do you feel the experience
was worth it? I'm most interested in what I can learn. Do you feel that
it's a respected certification (like an MCSE)?
Thanks.
Is MCDBA Worth It?
Sep 23, 2005Is MCDBA worth of the time and money one has to put into to acheive it?
I am talking in terms of getting a job.
Do you think after getting MCDBA you have gained sustantial knowledge about the subject?
I havent appeared for any of the MS exams as yet
but would like to start with 70 228 and 70 229.
I like reading BOL, but i guess for certfn exams you have to have a diff approach...
MCDBA Notes
Mar 4, 2004Hello chapies,
Does anyone know where I can download notes for taking the MCDBA exam?
Cheers
MCDBA Or MCTS
Feb 7, 2007For my last 3 years I have work with the SQL 2000 as a database analysis. Now I want to get a certification to prepare me to look for a better job. Which certification is more valuable in today job marker MCTS or MCDBA.
View 13 Replies View RelatedMCDBA Certification: Exam 70-228
Feb 6, 2004I'll be taking this test and was hoping for some input, please.
1. How long is it ?
2. Anything in particular I should look out for ?
3. Should you only spend a certain amount of time on each question ?
4. Any place I can find any coupons for the heavy $125 fee ?
5. What company did you sign up through ?
6. Any other input, would greatly be appreciated !!
Thank you
What Is Best Training Software For Mcdba?
Sep 17, 2004Hey guys,
Im wanted to know what was the best training software to pass the mcdba cert or better yet, what is best software for exam 70-228 which is the first exam to take. Classes are just too expensive right now for me=( I am open for suggestions. Thank Guys
MCDBA - Study Materials Needed
Feb 27, 2002Hi,
Does anyone have a copy of the MS SQL2000 Administrator exam...??
Book Suggestions For Studying For MCDBA
Jul 20, 2005Hi All,I'm about to begin studying for the MCDBA certification and I'mwondering what books people would recommend?The following gets a good review, so I'm planning on purchasing it:MCSA/MCSE/MCDBA Self-Paced Training Kit: Microsoft SQL Server 2000System Administration, 70-228, Second EditionHowever, I'd like to also go through a second book as well, just tomake sure my coverage is as complete as possible, and I'm wondering ifanyone has any suggestions?Many thanks in advance,Murray
View 2 Replies View RelatedExchange MCDBA/MCSD Self Test Software And Material With OCP And MCSE STS
Jan 4, 2002Dear Sir/Madam
I am certified Oracle DBA/Developer/Internet Developer. Now, I am interested in Microsoft Certificated DBA (MCDBA/MCSD).
By the way, I don't want to waste money to purchase the Microsoft exam software (Self Test Software) and training material. So, I want to exchange the MCDBA exam software and training material with you by using Oracle OCP 8i, Developer 2000 Rel 2.0 and MCSE 2000 Self Test Software.
I can use Oracle 8iDBA, Oracle Developer and MCSE 2000 self test software listed below to exchange 70-228,70-229,70-215,70-216,70-175 or other MCDBA 2000 and MCSE 2000 self test software and training materials.
<Oracle 8i DBA>
1Z0-001 Introduction to Oracle: SQL and PL/SQL
1Z0-023 Oracle8i: Architecture and Administration
1Z0-024 Oracle8i: Performance Tuning
1Z0-025 Oracle8i: Backup and Recovery
1Z0-026 Oracle8i: Network Administration
<Oracle Developer>
1Z0-101 Develop PL/SQL Program Units
1Z0-121 Developer/2000: Build Forms I
1Z0-122 Developer/2000: Build Forms II
1Z0-123 Developer/2000: Build Reports
<MCSE 2000>
70-210 Installing, Configuring and Administering Microsoft Windows 2000 Professional
70-215 Installing, Configuring, and Administering Microsoft Windows 2000 Server
70-216 Implementing and Administering a Microsoft Windows 2000 Network Infrastructure
70-217 Implementing and Administering a Microsoft Windows 2000 Directory Services Infrastructure
70-219 Designing a Windows 2000 Directory Services Infrastructure - (Includes 4 Case Studies)
By the way, if you have any one of 70-228,70-229,70-175,70-176,70-100, I can use whole set of Self test software to exchange yours.
Please provide email accounts with at least 5MB space for exchanging Self Test Software.
Thanks and Regards,
Jack
OCP DBA/Developer/Internet Developer
jacklam@tom.com
Can I Keep Sql Server 2000 If Upgrade Win 2000 To Win 2003 (was Sql Server 2000)
Feb 24, 2005Hello, i have a question that the sql server 2000 is install in window 2000 server. If i want to update to window 2003. Is that any problem in sql server 2000. I am worry about whether we will have problem after update. What i need to do? Many thanks.
View 5 Replies View RelatedSQL SERVER 2000: In Which Format The Datetime Will Be Stored In Sql Server 2000?
Feb 28, 2008Hi All,
I would like to know, how the datetime will be stored in the sqlserver datetime column.
Because some time i am giving the date in dd/mm/yyyy and sometime mm/dd/yyyy.
while give the date in mm/dd/yyyy works fine but not in the another case. and also while i execute a query on query analyser it shows the datetime in
yyyy/mm/dd format.
So anyone can please tell me how the dates will be stored in the datetime column of sqlserver database?
Thanks in Advance.
Regards,
Dhanasekaran. G
Upgrading SQL Server 2000 Standard To SQL Server 2000 Enterprise
Sep 14, 2004I am currently running SQL Server 2000 Standard on my production system, and I am looking to upgrade the system to Windows 2000 Adv. Server. I would also like to upgrade SQL Server 2000 Standard to SQL Server 2000 Enterprise to utilize more than 2GB of memory. Can anyone tell me what is the best way to upgrade the system, and please provide some feedback on your experiences with the upgrade. Thanks in advance.
View 2 Replies View RelatedSql Server 2000 Linked Server To Access 97/2000 Incompatability
Jul 20, 2005We are experiencing a problem with Sql Server 2000 linking to anAccess 97 file. We have two machines that link to this .mdb file, andwe recently upgraded one to newer hardware, SP3a, MDAC 2.8, etc. Thelink on this upgraded machine no longer works, giving this message:Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.[OLE/DB provider returned message: Cannot open a database created witha previous version of your application.]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'IDBInitialize::Initialize returned 0x80004005: ].The link on the older machine still works. We decided to tryconverting a copy of the file to Access 2000 to see if the newerpatches/drivers/whatever no longer supported 97. We set up a link onboth machines to this file, and they both work. However, on theupgraded machine, the following error is receievedServer: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.[OLE/DB provider returned message: System resource exceeded.]OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'ICommandText::Execute returned 0x80004005: ].when making 1-3 connections to the the linked server, while the oldermachine supports at least 7 simultaneous queries connecting to thelinked server and still hasn't produced that error.Does anyone have any idea if there is a known issue with linking toAccess 97/2000 files under MDAC 2.8, Jet 4.0, etc? Any light anyonecan shine on this subject would be greatly appreciated.
View 1 Replies View RelatedSQL Server 2000 Standard On Windows 2000 Advanced Server
Jul 20, 2005What is the limitation of memory that SQL Server 2000 Standard can usewhen running on a Windows 2000 Advanced Server platform?
View 1 Replies View RelatedUpgrate Sql Server 2000 Standard To Sql Server 2000 Enterprise
Sep 15, 2006Hi, I need to know if somebody knows like making the update of Standard SQL 2000 to Enterprise. Greetings.
View 3 Replies View RelatedDB File Size Limit With SQLServer 2000 In Small Business Server 2000
Mar 15, 2006Thanks in advance. What is maximum SQL Server database (*.mdf) file size with SQL Server 2000 as part of Microsoft Small Business Server 2000? (Database files were limited to 10 GB in SBS 4.5 with SQLServer 7.0... has this changed?).
View 1 Replies View RelatedSql Server 2000 Developer Edition W/MSDE 2000 Release A Install
May 21, 2005Can you install Sql Server 2000 Developer Edition with MSDE 2000 release A already installed?
View 2 Replies View RelatedMicrosoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A
Feb 17, 2004My objective is to use Enterprise Manager to move (copy) my SQL db from the server to my windows desktop computer.
I downloaded MSDE and am having trouble installing it, no doubt because I do not understand the documentaion (ReadMeMSDE2000A.htm).
When I try to run setup, I get that message that says:
"A strong SA password is required for security reasons. Please use SAPWD switch to supply the same."
Considering my purpose, do I need a "strong" SA password? If not, how do I get around it? If yes, how do I set it up?
I am a Mac user so I have poor windows skills, please make it as painless as possible for me, thanks!
Ron
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release
Feb 16, 2006venu writes "Hi,
Am very new to MS SQL adminstration
Can anybody help me out how to work on Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A just for the practice.
The activity which am going to workout on MSDE is below.
How to install SQL(on XP)
How the layout will be(like if i insall MSDE what are all Application will be and how they depends on each other)
How to create/delete tables if so, how can we do it either by GUI or CUI
just i need a clarifications reg same
Thank you,
venu"