Passed 70-462

Tawaz

Hey Friends

I passed my exam today with a 820 score!! I am now a qualified SQL 2012 with only two exams because i have MCSA server 2012.I feel to do 463 though.

N2IT

Nicely done!

Tawaz

Thanks man, i also must thank everybody on this forum for their support.

nster

I am going to start studying this today How long did it take you? Did you use a book?

burghard82

Congrats Tawaz and great score!

Learned

Congrats Tawaz! Best of luck to you.

zaleonardz

Right now,

You are my frikken hero, 70-462 definitely has more content/things to remember than 461

ccnpninja

Well done!

Tawaz

Thank you,yeh 462 its the main core.Though i am Mcsa sql 2012 with two exams i feel its not enough without 463.whats your opinion?

MohauMoorosi

70-461 is more for database developers whose job role is to primarily write TSQL code. The 70-462 is for Database Administators, more often than not, these are the guys responsible for the SQL Server Engine, both from Server requirements against SQL, and for the actual administration of all instance wide activities. With 70-463 being for Business Intelligence where you're either working as an ETL developer, a Report Developer, MDS or DQS administrator etc.

It is beneficial to pass all the exams, i think it shows how dynamic you are but in actual reality, you are less likely to use all the certs in one job position. If you're looking to get paid the big bucks then get the 70-463 and delve into the BI Sphere either as an SSAS or an SSIS specialist, these guys get all the big bucks.

Tawaz

thanks for information,i will go for 463 in few weeks to come.Howz Jozi?

zaleonardz

Oh wow,

Yet another South African

I have to make the following comment.

I was working on an Oracle box that I have been querying against for years.

The enterprise manager crashed, and with google I was able to sort it out, it was a fun afternoon, actually enjoy it, and I have a far better understanding of the Oracle Enterprise manager which is web based, SQL Management studio is by far superior.

The comment I would like to make is how many of the skills learnt on 461 and 462 and transferable to oracle.

Using their version of DMV's, I was actually able to scrub out about 5gb of garbage in terms of bad indexing, poor table structures ect out of it, using the exact same theory as what we learnt above...

I have a question though, by rebuilding a primary key on a highly fragmented index (or non clustered if you will), as we learnt the primary key is actually the way the data is physically written to disc in order.

So if you alter index Reorganize its essentially going to re-organize or defrag the table for you.

In oracle, obviously the same applies, due to all of my "half empty" pages equating to my 5gb of data saving, but I still feel there is a table or two that is consuming more space then it should.

In oracle, is there a way to further defragment a table, without looking at row compression. I dont want to go that route because the ERP is old, (BAAN IV)