I was thinking of doing certification from Microsoft. I was first intending to write exam 70-229 which is :
Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition.
The Microsoft site http://www.microsoft.com/traincert/exams/70-229.asp#TOOLS has a list of topics that I need to be familiar with in order to pass the exam, but it does not have the detailed information.
Can someone guide me to a place where I can go to get the detailed information about these topics so that I can prepare better for the certification exam?
thanks
Aslam
I have a question in one of the interviews relates to MS Certification.
Is it require to have the MCDBA in SQL Server 2000 certification or required 2005 version certification?
If so, What is the main difference in having that over 2000 version.
Then it went like What the difference it makes having certification and what are the general comments about it.
I know 2005 definetely have the edge over the 2000 certification but I didnt understand what the major advantage in having and have not such certification.
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 ?
I am interested in doing SQL server certification. I don't know any information abt this. It would be gr8 if u ppl could give some details as to how many levels of certification are there, how much is the cost of certification, is there any pre-requiste for the same and so on...
Hello everyone. This is my first post on this board. I've been working for an investment bank in London (via an IT services company) as a DBA for a year now. It's pretty much my first real job since graduating from university. I did a bit of SAP before this job but it didn't really work out.
The work has been almost entirely on SQL Server 2000. I've done a bit of 2005 such as installs, backing up/restoring databases, setting up security.
I was thinking of doing an MCITP course in SQL 2005 in India early next year (my company will not pay for training - cheapos). The bank has recently been taken over by another bank and I don't know what the future holds beyond February, it's probably likely that the DBA's from the other bank will take over.
Do you think certification is needed? Would it be hard for me to get another job with the experience I currently have?
I find it difficult to study at home and the idea of going to India and getting the certification in 2 weeks appeals to me. Has anyone else ever been to a boot camp in India or elsewhere? Just how important is certification?
If you could provide me with some advice I would be most grateful.
I am reading Administering SQL Server, a study guide for 70-228on page 27, it says:"INSTEAD OF triggers are useful when a DML operation is unsuccessful."I think this is nonsense. Any comments?
I have planned to take up the exam 70-229 "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition" as a select exam for MCAD".
Any links to sure shot Dumps avialable for the above exams OR any good E books.
I know this is not the forum for this question however i dont know where else to post it.
I am about to write my MCITP DBA Admin for Sql server 2005, however now that 2008 is being released this year i was thinking about maybe waiting and just writing 2008.
But i have had little luck finding out how the certifications will work.
Does anyone know if it will still be MCITP DBA Admin and Dev certifications but for 2008. Or will it be a whole new kind of certification path ?
Bottom Line is it worth while to do 2005 MCITP right now ? Perhaps 2008 certifications will only be available in 2009 ?
My employer has recently offered to pay for my certification exam (70-229) so I am about to start preparing/revising. Having visited numerous sites to get an idea of what is needed, I am now overwhelmed with info.
Has anyone out there successfully completed the exam and if so can you recommend any sites/resources that you found useful (or any to avoid).
I am about to start revising for exam 70-229 as part of my MS certification and was wondering if anyone has any advice/tips etc on revision material.
Having visited a number of sites I am now overwhelmed with the amount of study material. There are hundreds of sites offering exam training, others offering braindumps and others selling practice tests.
Does anyone know the best place to start and what material will get me up to speed the quickest. (Time is of the essence and I cannot afford to pay for training)
I'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 !!
I see that part of SP2 is the new CC certification -- can anyone give me some more details. What level is it at? EAL4? I can't seem to find the certificate on the CC Web site but it could be because it's not SP2 yet.
Hi all, Is it any Microsoft certification is there for Sql Reporting service ,If is there means please send me the related link to me!!! Regards, P.Veera Vinod.
I have successfully finish Oracle OCA Exam. Currently I am Microsoft Certified Database administrator(MCDBA) I would like to know there is any way I could use OCA Credit to any Microsoft Exam. If any advice will be helpful.
Thanks Faiz Farazi www.databasetimes.net Best learning center for Microsoft http://www.lascomp.com
hi guys, I am joining IT industry in august,my main intrest is in database(readed some stuff of warehousing oracle 9i and sql). However to move my career in that direction i need certification. So here is the point,should i get MCTS(in sql server 2005) or OCP(oracle associate 10g). My main goal is to become DBA. which of the above is more benificial. I mean more oppurtunites.
I used SqlConnection/SqlDataReader to read data from SQL Server 2000 in my ASP.NET project, but I found that the CPU usage is too high, and I used SQL Query Analyzer to run the same SQL statement, The CPU usage is the half of the previous, is there anyone can tell me why? Thank you!
Hi everyone!Being new the SQL, I wanted to ask everyone if there are good resources out there that they use? I could use all the help I can get! Books, links, websites, etc.Recently my friend sent me this, I found it informative and best of all, free! https://store.pentontech.com/index.cfm?s=9&promocode=qe2165f7 Thanks in advance for your help!- Lizzy
Sometimes logging in to SQL 7 I get 'Memory resources not available...' and log in process terminates. Do I need to up number of locks ! If so, how ! Pls. suggest any other ideas !
This proc will show you what is using SQL system resources right now. If a process is not currently using any resources, it will not show up on the list. Also, a dump of the input buffer is printed so you can see just what is going on.
I use this code whenever somebody whines that "The server is slow!".
The magic is ::fn_get_sql which came with service pack 3 for sql 2000.
use master IF (object_id('sp_Now')) is not null BEGIN PRINT 'Dropping: sp_Now' DROP PROCEDURE sp_Now END PRINT 'Creating: sp_Now' GO CREATE PROCEDURE sp_Now as -- FULL DETAILS OF WHAT IS RUNNING set nocount on declare @handle binary(20), @spid smallint, @rowcnt smallint, @output varchar(500)
DECLARE TEST CURSOR FOR select sql_handle, spid from sysprocesses where sql_handle <> 0x0000000000000000000000000000000000000000 -- and spid <> @@SPID --> Uncomment to stop seeing your own process order by cpu desc
OPEN TEST FETCH NEXT FROM TEST INTO @handle, @spid
select convert(char(15), loginame) as 'loginame', convert(char(10),hostname) as 'hostname', convert(char(20),db_name(dbid)) 'database', str(spid,4,0) 'spid', str(blocked,5,0) 'block', -- str(waittime,9,0) 'wait_time', str(physical_io,8,0) 'phys_io', -- str((cpu),10,0) 'cpu(ms)', -- str((cpu/60000.0),9,3) 'cpu(mins)', str((cpu/1000/60),6) + ':' + case when left((str(((cpu/1000) % 60),2)),1) = ' ' then stuff(str(((cpu/1000) % 60),2),1,1,'0') else str(((cpu/1000) % 60),2) END as 'cpu(mm:ss)', str((convert(float,memusage) * 8192.0 / 1024.0 / 1024.0),8,2) 'mem(MB)', convert(char(30),program_name) as 'program_name', cmd, convert(char(15),lastwaittype) 'lastwaittype', convert(char(20),login_time,120) 'login_time', convert(char(19),last_batch,120) 'last_batch', convert(char(10),status) as 'status', convert(char(15),nt_username) as 'nt_username' from master..sysprocesses where spid = @spid print ' ' print ' ' dbcc inputbuffer(@spid) print ' ' print ' ' select * from ::fn_get_sql(@handle) FETCH NEXT FROM TEST INTO @handle, @spid END close TEST deallocate TEST GO IF (object_id('sp_Now')) is not null PRINT 'Procedure created.' ELSE PRINT 'Procedure NOT created.' GO
Hi, Im just looking for someone that has a demonstration Visual Basic database script. Something that makes a database, ad / removes rows and information, does all basic database stuff, just as an example of how a SQL database is supposed to be handled.
I know that a query inside a called UDF does not show up when displaying theestimated query plan, but are the resources (CPU, DiskIO) used by a UDF thatis call from within an SProc or embedded in a SQL statement included insp_who2 and Profiler BatchCompleted?Also how performance draining is it to do something like the following. Iassume for every row returned the udf will be called causing 8000 tablescans on DateTable?Create Functionu udf_GetCountDates (@StartDate datetime, @EndDate datetime)Returns IntbeginReturn(select count(*) from DateTablewhere ColDate > @TestDate and Col1Date <)end--DateTable has 5,000 rowsCreate proc Test@TestDate datetimeAsselect Col1, Col2, udf_GetCountDates(@TestDate, Col2)From OTable--OTable has 8,000 rowsGoThanks,Ray
I have a question...say I have an asp app that works as a front end toan sql server 2000 database. Would it be better, performance wise, toseperate the webserver from the sqlserver or to have them on the samemachine?-Jim
I have a sql job(that runs several stored procs) that is run to fix a problem, it is set to run every few minutes (no, this is not my idea). What would be the best way to identify how much this specific job/and it's sp's are using in resources, such as cpu and memory?
