Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

MCJ - The Missing Link Expand / Collapse
Author
Message
Posted Monday, April 5, 2010 3:43 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:46 PM
Points: 21,187, Visits: 14,880
If you haven't seen it yet, there is a pretty good discussion on the Missing Certification based on an Editorial by Steve Jones. You can check out that discussion here.

The discussion had once upon been summarized into some talking points, and it is time once again to do that. This time we will summarize here, and try to direct the conversation from this new location. If you want to see the first summary, check out the blog on it here.

At this point we are discussing each of the bulleted items from that blog and determining how best to handle them.

Current items of discussion are a) Time in Service, b) Review Board, c) a new requirement to be added which is recertification / renewal.

A) Time in service is pretty close to being tabled. The idea is currently that the requirement be somewhat relaxed and that each candidate have 1.5 yr Database related experience. This topic could be discussed at greater length, depending on how the discussion goes with it. There is a vote currently on this topic based on the following criteria.

The candidate attests to a minimum of 18 months hands-on experience in SQL Server. Willfully misrepresenting (lying) about this is subject to a permanent revocation of this certification.

This does NOT mean an equivalent of 18 months of 8 hr days with hands-on experience; this means 18 months of any hands-on experience. This can be as a developer, DBA, or in BI (SSAS/SSIS/SSRS).



B) The Review Board discussion has just gotten under way. We hope to find a lot of input on this topic.

C) Recertification has come up during our discussions on the TIS. This has been discussed to some point. We will discuss further if need to in order to reach a consensus. Right now the gist revolves around an interview or exam to renew the certification. The certification should expire after some time, and people need to demonstrate continuing effort in this field to maintain current certification. However, if the cert lapses, the certification isn't necessarily revoked.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #897076
Posted Monday, April 5, 2010 3:45 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:46 PM
Points: 21,187, Visits: 14,880
Something from the old thread that should be ported over.


WayneS (4/5/2010)
CirquedeSQLeil (4/5/2010)
How about we move on to a new topic?

I think the next viable topic would be to hash out how the review board should be handled.

So, how will we propose this particular requirement?


Well, to start off, there are several distinct areas to cover:
1. Who qualifies to be sit on the board?
2. Where will the board convene?
3. How often will the board convene?
4. What topics will be covered by the board?
5. How large should the board be?

I suggest that we actually tackle these individually. However, it might be best to just throw things out that can cover all of these for a little bit, to get the conversation going.

It has been mentioned that it would be good to have boards at events / conventions (i.e. PASS, SQL Saturday, etc.). I agree with this, but we need to ensure that there are enough different people there to run multiple boards so that we don't end up with one group of people where all they do is do boards... they probably want to see what all is going on at the event also. (Unless they are being paid to be there for the purpose of conducting a board...)

It has also been mentioned that the board should be local. And in cases where it becomes a hardship to attend a board, that provisions to conduct the board via web-cam be available. I like both of these suggestions, but recognize that in order to have quality people sit on the board, we may need for some of them to actually be there virtually via web-cam also.

My initial thought as to who should sit on the board was to use MVPs. However, I immediately shot this down... because MVP does NOT mean that they are knowledgeable of the product to that depth, but instead this is a recognition of their evangalism of the product. This isn't to say that we should exclude MVPs; but that depth of knowledge is more important. I'm certain that MVPs will be on this board, but that should not be the criteria. I think that every attempt should be made to get at least two board members physically at the board, with the board consisting of 4-5 persons.

Does someone that has earned this certification automatically qualify to sit on a board? After all, they have demonstrated a deeper knowledge of sql.

What should be covered?
Index structures.
Indexing.
Clustering.
Mirroring.
Log shipping.
Replication.
Performance tuning (how to read execution plans / statistics).
Server configuration.

Time to let other people in with their thoughts...




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #897080
Posted Monday, April 5, 2010 3:48 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:46 PM
Points: 21,187, Visits: 14,880
I think another important thing that needs to be done with this information is to disseminate it.

dma-669038 has taken the idea to her UG. I think following that example would help to increase more information flow and get a broader sense of what should be involved with this certification.


It should also be important to note, this is not yet a certification. This is merely an attempt to propose a change and offer a solution as we see fit.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #897085
Posted Monday, April 5, 2010 4:32 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:06 AM
Points: 36,711, Visits: 31,161
I'd rather see the discussion continue on the thread which started it all rather than essentially double posting. Sorry Jason.

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #897109
Posted Monday, April 5, 2010 4:36 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:46 PM
Points: 21,187, Visits: 14,880
Jeff Moden (4/5/2010)
I'd rather see the discussion continue on the thread which started it all rather than essentially double posting. Sorry Jason.


I know. There are reasons to move it from there to here though. I agree with the reasons. Some of it is that there is a lot to wade through over there. Having this info here, may make it easier for other people to follow the thread and provide good feedback.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #897113
Posted Monday, April 5, 2010 5:32 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:06 AM
Points: 36,711, Visits: 31,161
CirquedeSQLeil (4/5/2010)
Jeff Moden (4/5/2010)
I'd rather see the discussion continue on the thread which started it all rather than essentially double posting. Sorry Jason.


I know. There are reasons to move it from there to here though. I agree with the reasons. Some of it is that there is a lot to wade through over there. Having this info here, may make it easier for other people to follow the thread and provide good feedback.


I guess that's reasonable. Thanks for the feedback, Jason.


--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #897144
Posted Monday, April 5, 2010 5:38 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:46 PM
Points: 21,187, Visits: 14,880
Jeff Moden (4/5/2010)


I guess that's reasonable. Thanks for the feedback, Jason.



NP.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #897147
Posted Monday, April 5, 2010 7:41 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:07 AM
Points: 22,993, Visits: 31,473
I know the discussion right now is the review board, but I thought I'd interject one other aspect so it doesn't get lost. Should there be one MCJ or should it be broken down similiar to the MCITP (DBA, Developer, BI) or as I had suggested earlier DBA/Developer, BI? Should all versions have a common core and then a specialization. This will be important as we discuss the review board as it could easily change the complexion of the who makes up the board.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #897197
Posted Monday, April 5, 2010 7:49 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 9:46 PM
Points: 21,187, Visits: 14,880
Lynn Pettis (4/5/2010)
I know the discussion right now is the review board, but I thought I'd interject one other aspect so it doesn't get lost. Should there be one MCJ or should it be broken down similiar to the MCITP (DBA, Developer, BI) or as I had suggested earlier DBA/Developer, BI? Should all versions have a common core and then a specialization. This will be important as we discuss the review board as it could easily change the complexion of the who makes up the board.


Let's backtrack then and refocus the discussion on that topic.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #897206
Posted Monday, April 5, 2010 8:04 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:07 AM
Points: 22,993, Visits: 31,473
Since we are refocusing, I'll begin.

I think that the MCJ should be broken down into to certifications; MCJ DBA/Developer and MCJ BI. As you progress in your career field there will be a merging of specific skills across specific boundries. This is particularly true between DBA and Developer as both will begin to learn to write better performing code, creating better indexes, reading and understanding execution plans, etc. The BI world, however, I don't necessarily see as much cross over with DBA/Developers. Especially since MDX queries are your fathers SQL queries.

Both should require a core understanding of the SQL Server Engine, T-SQL, Indexing, but not necessarily to the level of a DBA/Developer.




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #897222
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse