MCDBA or MCTS

For 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.

That would be easy. MCTS - SQL Server, MCITP - Database Administrator, or MCITP - Database Developer. Why? MCDBA is a SQL Server 2000 certification. MCTS - SQL Server is the Microsoft Certfied Technical Specialist - SQL Server which is for SQL Server 2005. After attaining your MCTS in SQL Server (70-431), you can take two exams to get the MCITP (Microsoft Certified IT Professional) Database Administrator (70-443 and 70-444) or you can take two exams (70-441 and 70-442) to get your MCITP - Database Developer.

The MCDBA is the old cert and the MCTS/MCITP is the new certification.

|||

Indeed, you don't gain any benefits when doing MCDBA. The only benefit you could have is to gain some extra knowledge when studying for the exam but since you allready have some experience this will be limited.

There is an upgrade track from MCDBA to MCITP Administrator but this is only for the administrator track and not for the Development or Business Intelligence track.

You can check the multiple possibilities at http://www.microsoft.com/certification

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

So do I, but I am preparing required resources such as Books, SQL Server Kit, and so on.

On of the problems that I faced is my friend’s suggestion which was reading as much as I can in TestKing Examples for MCITP course because it give similar questions with description of best questions.

If anyone has softcopy of TestKing Examples for MCITP I shall be more than happy if he or she send it to me at Essam.Computer@.yahoo.com

Thanks a lot

Your Sincerely,

Server Programmer

|||

I VERY strongly discourage using a source such as TestKing. That company is in the business of ripping off certification exams and then selling answers to whomever is dumb enough to buy them. The person then passes the exams and gets a piece of paper that is truly worthless, because they have no clue how to actually work with a SQL Server. Copying off someone else's paper is cheating. It was cheating when you were 6 and it is still cheating no matter how old you get. What people need to realize is that this is a VERY small industry. I run across people at customer sites that I had worked with 15 years before. It's also not uncommon for me to be involved in interview processes at various customers and see the resumes for the same people at multiple companies spanning numerous states. I remember every single person that I've ever come across who had certifications and obtained those certifications by cheating their way through the exams. Those people will NEVER get hired at any company that I deal with and when I encounter them already working at a customer of mine, I also let the management know that I am aware of them having cheated their way to a certification.

The certification is intended to offer a base level of proof that you have achieved a basic level of knowledge in a subject, just like a diploma or a degree. A DBA is placed is a position requiring a very high level of trust. Does anyone really think that a company is going to keep someone around with access to their most sensitive data when they find out that person is a known cheat?

Take the time to learn SQL Server. Pick up books, ask questions, and USE the product. If you know SQL Server, you will have no problem passing the exam. Thousands of other people before you have already passed the exams. If you have to resort to cheating your way through, I would strongly suggest that you find another career, because if you don't have enough respect for yourself to do something honestly, this industry does not want you.

|||

Hello mr.Michael Hotek

i would like to clarify my last post,

i am working as a programmer SQL Server since 5 years, but i modified my specialization to focus only on the Server side;

because i did not earn any exam before and i was not plan to do it, i did not care about the methodical way to start earn this certification,

when i visited Microsoft website, i saw various kind of exams and prerequisites to earn MCITP certificate and in fact i was confused,

that is way i asked this question

any way thanks again for your valued response and have a great day

MCDBA or MCTS

For 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.

That would be easy. MCTS - SQL Server, MCITP - Database Administrator, or MCITP - Database Developer. Why? MCDBA is a SQL Server 2000 certification. MCTS - SQL Server is the Microsoft Certfied Technical Specialist - SQL Server which is for SQL Server 2005. After attaining your MCTS in SQL Server (70-431), you can take two exams to get the MCITP (Microsoft Certified IT Professional) Database Administrator (70-443 and 70-444) or you can take two exams (70-441 and 70-442) to get your MCITP - Database Developer.

The MCDBA is the old cert and the MCTS/MCITP is the new certification.

|||

Indeed, you don't gain any benefits when doing MCDBA. The only benefit you could have is to gain some extra knowledge when studying for the exam but since you allready have some experience this will be limited.

There is an upgrade track from MCDBA to MCITP Administrator but this is only for the administrator track and not for the Development or Business Intelligence track.

You can check the multiple possibilities at http://www.microsoft.com/certification

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

So do I, but I am preparing required resources such as Books, SQL Server Kit, and so on.

On of the problems that I faced is my friend’s suggestion which was reading as much as I can in TestKing Examples for MCITP course because it give similar questions with description of best questions.

If anyone has softcopy of TestKing Examples for MCITP I shall be more than happy if he or she send it to me at Essam.Computer@.yahoo.com

Thanks a lot

Your Sincerely,

Server Programmer

|||

I VERY strongly discourage using a source such as TestKing. That company is in the business of ripping off certification exams and then selling answers to whomever is dumb enough to buy them. The person then passes the exams and gets a piece of paper that is truly worthless, because they have no clue how to actually work with a SQL Server. Copying off someone else's paper is cheating. It was cheating when you were 6 and it is still cheating no matter how old you get. What people need to realize is that this is a VERY small industry. I run across people at customer sites that I had worked with 15 years before. It's also not uncommon for me to be involved in interview processes at various customers and see the resumes for the same people at multiple companies spanning numerous states. I remember every single person that I've ever come across who had certifications and obtained those certifications by cheating their way through the exams. Those people will NEVER get hired at any company that I deal with and when I encounter them already working at a customer of mine, I also let the management know that I am aware of them having cheated their way to a certification.

The certification is intended to offer a base level of proof that you have achieved a basic level of knowledge in a subject, just like a diploma or a degree. A DBA is placed is a position requiring a very high level of trust. Does anyone really think that a company is going to keep someone around with access to their most sensitive data when they find out that person is a known cheat?

Take the time to learn SQL Server. Pick up books, ask questions, and USE the product. If you know SQL Server, you will have no problem passing the exam. Thousands of other people before you have already passed the exams. If you have to resort to cheating your way through, I would strongly suggest that you find another career, because if you don't have enough respect for yourself to do something honestly, this industry does not want you.

|||

Hello mr.Michael Hotek

i would like to clarify my last post,

i am working as a programmer SQL Server since 5 years, but i modified my specialization to focus only on the Server side;

because i did not earn any exam before and i was not plan to do it, i did not care about the methodical way to start earn this certification,

when i visited Microsoft website, i saw various kind of exams and prerequisites to earn MCITP certificate and in fact i was confused,

that is way i asked this question

any way thanks again for your valued response and have a great day

MCDBA or MCTS

For 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.

That would be easy. MCTS - SQL Server, MCITP - Database Administrator, or MCITP - Database Developer. Why? MCDBA is a SQL Server 2000 certification. MCTS - SQL Server is the Microsoft Certfied Technical Specialist - SQL Server which is for SQL Server 2005. After attaining your MCTS in SQL Server (70-431), you can take two exams to get the MCITP (Microsoft Certified IT Professional) Database Administrator (70-443 and 70-444) or you can take two exams (70-441 and 70-442) to get your MCITP - Database Developer.

The MCDBA is the old cert and the MCTS/MCITP is the new certification.

|||

Indeed, you don't gain any benefits when doing MCDBA. The only benefit you could have is to gain some extra knowledge when studying for the exam but since you allready have some experience this will be limited.

There is an upgrade track from MCDBA to MCITP Administrator but this is only for the administrator track and not for the Development or Business Intelligence track.

You can check the multiple possibilities at http://www.microsoft.com/certification

Greetz,

Geert

Geert Verhoeven
Consultant @. Ausy Belgium

My Personal Blog

|||

So do I, but I am preparing required resources such as Books, SQL Server Kit, and so on.

On of the problems that I faced is my friend’s suggestion which was reading as much as I can in TestKing Examples for MCITP course because it give similar questions with description of best questions.

If anyone has softcopy of TestKing Examples for MCITP I shall be more than happy if he or she send it to me at Essam.Computer@.yahoo.com

Thanks a lot

Your Sincerely,

Server Programmer

|||

I VERY strongly discourage using a source such as TestKing. That company is in the business of ripping off certification exams and then selling answers to whomever is dumb enough to buy them. The person then passes the exams and gets a piece of paper that is truly worthless, because they have no clue how to actually work with a SQL Server. Copying off someone else's paper is cheating. It was cheating when you were 6 and it is still cheating no matter how old you get. What people need to realize is that this is a VERY small industry. I run across people at customer sites that I had worked with 15 years before. It's also not uncommon for me to be involved in interview processes at various customers and see the resumes for the same people at multiple companies spanning numerous states. I remember every single person that I've ever come across who had certifications and obtained those certifications by cheating their way through the exams. Those people will NEVER get hired at any company that I deal with and when I encounter them already working at a customer of mine, I also let the management know that I am aware of them having cheated their way to a certification.

The certification is intended to offer a base level of proof that you have achieved a basic level of knowledge in a subject, just like a diploma or a degree. A DBA is placed is a position requiring a very high level of trust. Does anyone really think that a company is going to keep someone around with access to their most sensitive data when they find out that person is a known cheat?

Take the time to learn SQL Server. Pick up books, ask questions, and USE the product. If you know SQL Server, you will have no problem passing the exam. Thousands of other people before you have already passed the exams. If you have to resort to cheating your way through, I would strongly suggest that you find another career, because if you don't have enough respect for yourself to do something honestly, this industry does not want you.

Maximum Memory Settings for Analysis 2005

Dear Anyone,

We have a live machine with an Analysis Services 2005 (32 bit) installed. The machine has been running for a couple of months. They recently upgraded to 8GB (formerly 4GB). It seems that the 32 bit version of MSAS 2005 does not support 8GB or memory. Can anyone please suggest memory settings to maximize the use of the 8GB of memory in the server? Or does anyone know of the maximum memory setup that we can give Analysis Services 2005?

Thanks,

Joseph

AS2K5 is not AWE-aware. As such, its capabilities are based on the underlying OS' virtural address space limitations. The general limits are (32-bit):

2GB -- with an OS that doesn't support the /3GB switch in boot.ini

3GB -- with /3GB enabled in the OS

4GB -- running on an x64 system under WOW

Otherwise, to go more, you need to run in native 64-bit using either x64 or ia64 hardware.

_-_-_ Dave

Maximum databases on SQL Server 2000

We have a Dell 2650 server with 3 GB of ram ( SQL Staandard edition )
This server is being used for heavy analysis by 10 heveyduty workstations.
We have more then 1000 databases on this server.
Should we limit the databases on this server ? we are having issues with
performance and SQL service stopping frequently..
Please advise
Probably. I'd be surprised you can keep all 1000 open and working at the
same time. Memory, disks, bus, etc... are all probably pretty upset with
their deplorable work conditions. :-)
Figure out which of your 1000 databases are most heavily used and move them
out first. Perfmon and Profiler are probably gonna be your new buddies if
they aren't already.
Btw, perf issues aside, 1000 databases in one instance is probably not much
fun to manage. Just expanding the object browser takes a while. What about
maintenance operations? Look up multi instance in BOL and give it some
serious thought. Life will probably be at least a little better that way.
joe.
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:37CBC0C7-C1FA-4FE5-9851-B101A5E8E88D@.microsoft.com...
> We have a Dell 2650 server with 3 GB of ram ( SQL Staandard edition )
> This server is being used for heavy analysis by 10 heveyduty
> workstations.
> We have more then 1000 databases on this server.
> Should we limit the databases on this server ? we are having issues with
> performance and SQL service stopping frequently..
> Please advise

Maximum databases on SQL Server 2000

We have a Dell 2650 server with 3 GB of ram ( SQL Staandard edition )
This server is being used for heavy analysis by 10 heveyduty workstations.
We have more then 1000 databases on this server.
Should we limit the databases on this server ? we are having issues with
performance and SQL service stopping frequently..
Please adviseProbably. I'd be surprised you can keep all 1000 open and working at the
same time. Memory, disks, bus, etc... are all probably pretty upset with
their deplorable work conditions. :-)
Figure out which of your 1000 databases are most heavily used and move them
out first. Perfmon and Profiler are probably gonna be your new buddies if
they aren't already.
Btw, perf issues aside, 1000 databases in one instance is probably not much
fun to manage. Just expanding the object browser takes a while. What about
maintenance operations? Look up multi instance in BOL and give it some
serious thought. Life will probably be at least a little better that way.
joe.
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:37CBC0C7-C1FA-4FE5-9851-B101A5E8E88D@.microsoft.com...
> We have a Dell 2650 server with 3 GB of ram ( SQL Staandard edition )
> This server is being used for heavy analysis by 10 heveyduty
> workstations.
> We have more then 1000 databases on this server.
> Should we limit the databases on this server ? we are having issues with
> performance and SQL service stopping frequently..
> Please advise

Maximum databases on SQL Server 2000

We have a Dell 2650 server with 3 GB of ram ( SQL Staandard edition )
This server is being used for heavy analysis by 10 heveyduty workstations.
We have more then 1000 databases on this server.
Should we limit the databases on this server ? we are having issues with
performance and SQL service stopping frequently..
Please adviseProbably. I'd be surprised you can keep all 1000 open and working at the
same time. Memory, disks, bus, etc... are all probably pretty upset with
their deplorable work conditions. :-)
Figure out which of your 1000 databases are most heavily used and move them
out first. Perfmon and Profiler are probably gonna be your new buddies if
they aren't already.
Btw, perf issues aside, 1000 databases in one instance is probably not much
fun to manage. Just expanding the object browser takes a while. What about
maintenance operations? Look up multi instance in BOL and give it some
serious thought. Life will probably be at least a little better that way.
joe.
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:37CBC0C7-C1FA-4FE5-9851-B101A5E8E88D@.microsoft.com...
> We have a Dell 2650 server with 3 GB of ram ( SQL Staandard edition )
> This server is being used for heavy analysis by 10 heveyduty
> workstations.
> We have more then 1000 databases on this server.
> Should we limit the databases on this server ? we are having issues with
> performance and SQL service stopping frequently..
> Please advise

Maximum allowed value for integer in Analysis Services

Is there a maximum number up to which Analysis Services will do a SUM up to.

The reason I ask is that I get a negative number when I run the following MDX ([Mesaure] is aggregated with SUM)

SELECT [Measures].[Measure] ON AXIS(0)
FROM [Cube]

However each row in my fact table has a positive (and quite large value) for its Measure.

Thanks in advance

Stephen

Yes. There a maximun value of integer, I believe its just over 2 billion or so. When you first built your cube, AS defaulted your measure to the datatype in your source. You will have to change the datatype to a bigint, then you won't see those negative values.

Van Dieu

|||Sweet. Bigint it is. Don't know why it never occured to me to change the datatype of the Measure in Analysis Services.

Oh well, the simple things.