SSIS: MCP Certification
Dec 5, 2006Is there a mcp certification exam for SSIS? I have been using google to find information about SSIS exam but with out success.
Please help.
ADVERTISEMENT
SQL 7 Certification
May 14, 1999Does anyone know where to get practice tests for the new SQL 7.0 Admin exam?
TIA
Certification
Jan 12, 1999Where can I find information on the MCSDBA certification, when the exam is coming
out, is it for SQL 7.0, etc.
Certification !!!!!!!!!!!!
Feb 11, 2008Hi Experts,
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.
Thanks in advance.
About Microsoft Certification
Jun 26, 2007hi.
iam learing Ms server 2005 i want is there any MicrosoftSoft certification for Microsoft Sql server 2005 alone
Resources For MS Certification
Jun 19, 2002I 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
Certification: Looking For Advise
Oct 1, 2004Hi All
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 ?
Any advice in this regards really appreciated.
SQL Server Certification
Feb 17, 2006Hi,
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...
Thanks,
Vatsan
Pre-certification Tests
Apr 23, 2007Anyone know of a site or company that provide good pre-tests for certification?
I don't mind paying for downloadable test either.
Peter Larsson
Helsingborg, Sweden
SQL 2005 Certification
Nov 9, 2007Hello 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.
Certification Question
Aug 23, 2005I 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?
View 5 Replies View RelatedCertification Question
Jan 17, 2007Hi all,
I am new to Sql Server 2005
I planning to take exam MCTP exam 70-445
is the cert 70-431 a pre-requisite for certs 70-445 and 70-446?
Thanks and regards
Sql Server Certification 70-229
Mar 18, 2008Hi All,
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.
Please Help....
Thanks
2008 Certification ?
Feb 13, 2008Hi There
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 ?
If anyone has info onthis please let me know.
Appreciated, Thanx
SQL Server Certification Exam
Aug 3, 2004Hello,
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).
Regards
Simon
SQL Server Certification (MCAD)
Nov 1, 2004Hello,
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)
Any advice would be appreciated.
Simon
MCDBA 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
SQL Server 2005 Certification
May 14, 2007Hi has anyone taken the SQL Server 2005 Certification test yet???
View 5 Replies View RelatedMicrosoft Certification Test 70-229
Jul 20, 2005Pls Help if somebody has taken this test...70-229(MS SQL Server 2000)I want to pass this desperately.Pls suggest some good question banks.
View 1 Replies View RelatedCommon Criteria Certification
Dec 18, 2006I 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.
View 3 Replies View RelatedAny Certification In Ssrs 2000
Jul 2, 2007Hi 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.
SQL Server 2005 Certification
Oct 6, 2007I am new to SQL Server 2005. What is the best certification to start with? What training resources should I use?
View 3 Replies View RelatedAbout Microsoft SQL Server Certification Exam
Jun 24, 2006Hi all,
Is there any On-line Resource available to prepare for Microsoft SQL server Certification Exam . Or from which site i can get the Dump?
Regards
Magesh
OCA Credit Count Any Certification For Microsoft
Mar 20, 2007I 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
Sql Server 2005 Versus Oracle 10g Certification
Mar 21, 2008hi 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.
please reply.
How To Login In Sql Server With Certification Login
Jun 8, 2007hi all,
i have created a login account using certificate.
-----CREATE A CERTIFICATE--------
CREATE CERTIFICATE TEST_CERTIFICATE123
WITH SUBJECT = 'CERTIFICATE IN TEST DATABASE',
START_DATE='06/04/2007',
EXPIRY_DATE = '02/02/2009';
GO
--CREATE LOGIN FRON THE CERTIFICATE---
CREATE LOGIN LALIT12301 FROM CERTIFICATE TEST_CERTIFICATE123;
GO
How can i use this login credential to login to microsoft sql server management studio.It is askin only for sql/windows authentication.There is no option for the certificate based login.
if i m passing this login id as sql server authentication then i m getting following error.
Login failed for user 'LALIT123'. (Microsoft SQL Server, Error: 18456)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476
please do help me.....
Running Ssis Package With Ssis Run Time Compoenents And Sql Server 2000...
Jan 22, 2007running ssis package with ssis run time compoenents and sql server 2000...
Is it possible to run ssis packages that point to servers on sql server 2000
without installing sql server 2005 ?
Can we just install runtime for ssis and run the packages ?
Please explian with links if possible
thanks a lot
Integration Services :: Executing Child SSIS Package In Parent SSIS
Oct 9, 2015I want to achieve the following in (SSIS/SSDT for SQL 2012) -Â
I have a generic SSIS package which simply sends out email notifications using SMTP email task (this package is within its own project, and has project level input parameters).
I need to be able to call this package in the Event handler section of every package (numbering in about less than 60) that we have. These packages are within their own respective projects.
I thought I could use the "execute package task", but it turns out , using this, I cannot call a package that is part of some other project. I also cannot call a package that is stored in the CATALOG. Is there any way I can do this ?
When I call the child package , I should be able to send in parameters like - error information and package name of the Parent package.
SSIS Called From Agent Job Not Calling New Child SSIS Package Addition
Oct 29, 2007I have an SSIS package (TransAgentMaster) that I recently modified to include a call to a child package via the file system. The child package creates a text file. When I run the package in dev studio then the child package/text file is produced.
I then imported the TransAgentMaster as a stored packagesfilesystem package into SQL SSIS and executed the package. The child package produced the text file.
I then ran the SQL Server Agent to see if the child package would work and it did not generate the text file. Thus after updating a SSIS package importing the package into SSIS the job that calls the package will not call the child package. Please not that the TransAgentMaster package calls 7 children packages €¦ just not my new one.
Any thoughts why the agent will not run the child newly crated childe package?
Could Not Serialize The SSIS Runtime Objects When Attempting To Copy Tasks Created By SSIS Wizard
Jul 11, 2007Run the SSIS import/export wizard.
(xls -> sql table)
Select the tasks created.
Copy.
Here is the error that occurs.
p.s. Does anyone have any needles I can borrow? I think sticking them in my eyes would be nicer than working with SSIS.
===================================
An error occurred while objects were being copied. SSIS Designer could not serialize the SSIS runtime objects. (Microsoft Visual Studio)
===================================
Could not copy object 'Preparation SQL Task' to the clipboard.
(Microsoft.DataTransformationServices.Design)
------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.762&EvtSrc=Microsoft.DataTransformationServices.Design.SR&EvtID=SerializeComponentsFailed&LinkId=20476
------------------------------
Program Location:
at Microsoft.DataTransformationServices.Design.DtsClipboardCommandHelper.SerializeRuntimeObjects(ICollection logicalObjects)
at Microsoft.DataTransformationServices.Design.ControlFlowClipboardCommandHelper.InternalMenuCopy(MenuCommand sender, CommandHandlingArgs args)
===================================
Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.PersistImpl.SaveToXML(XmlDocument& doc, XmlNode node, IDTSEvents events)
at Microsoft.SqlServer.Dts.Runtime.DtsContainer.SaveToXML(XmlDocument& doc, XmlNode node, IDTSEvents events)
at Microsoft.DataTransformationServices.Design.DtsClipboardCommandHelper.SerializeRuntimeObjects(ICollection logicalObjects)
SSIS: Excel Import: SSIS Not Reading Dates
Apr 26, 2008Hi. I need to import excel file in database. i first need to do an unpivot task. the column names are dates and SSIS seems to be unable to pick up the column name as it is replaced by F2 F3 F4etc Can you advise of a solution. thanks ken
View 1 Replies View RelatedSource Code For The Standard SSIS Components That Come With SSIS?
Jun 2, 2006Hi,
I'm finding that the standard components often just don't quite meet my
needs, but would only need some fairly minor changes to save me and my team a lot of
work (and produce more elegant solutions). So I was just wondering whether the source code was available for the standard components that come with SSIS, or if there is anyway to extend their functionality?
Or do you just have to start form scratch?
Thanks,
Lawrie
Use Of SSIS In Reading And XSL File. Should I Use SSIS Or Just Straight C#
Aug 1, 2007I need to build an asp.net/C# application to read values from an Excel spreadsheet. Once the values are read from the spreadsheet, the C# code will do some elementary statistics on the values read. Then the values read and their computations will be written to a sql server database.
My manager suggested that SSIS might be a good candidate technology for doing this type of work. Does that sound correct? My only hesitation with using SSIS is that I want to keep the application as simple as possible, so that the code can be more portable. Maybe might argument is not a good one, but maybe someone can help me out here.
Ralph