Skip to main content

Posts

Showing posts from December, 2015

MCSA 70-461 - Final Chapter 17 - Further Optimization Aspects

This is it....the final chapter 17 of the 70-461 Query Microsoft SQL Server.  Pumping it today to finish strong and begin practicing for the exam.  Hopefully in a week of practice I'll go and take the real 70-461 test.  Wish me luck.

MCSA 70-461 - Chapter 16 - Cursors, Sets and Temp Tables

Closing in on the end.  Chapter 16.

Gloria Jean Signature Iced Coffee

Taking a break...Gloria Jeans Signature Iced Coffee.

MCSA -- 70-461 - Chap 15 - Index & Statistics

Stuff is deep and taking while to read and understand.  Hitting Chapter 15 -- Indexes & Statistics.  Maybe I'll make it to 17 by Sunday, if not by Christmas?  Still a good pace and almost done.

Making good pace...Book 70-461

I'm making a good pace in the 70-461 book.  Although I took two weeks worth of breaks, I've managed to finish 75% of the book and should finish the whole book within a month of starting (11/22 - 12/22).  I'm thinking I can finish each MCSA exam portion (read the book , practice exams) In about 6-7 weeks total, so I can wrap this whole MCSA thing in about 18-21 weeks and leave me time to tackle the MCSE!  Now I've already accumulated five years of practical experience and the exams are just a way to test my aptitude and expose me to things I don't normally have an opportunity to use much at work.  In any case, MCSE sounds like a good goal, after the MCSA of course.  After that?  Hmm...more dev stuff, which might not be covered in any formal exam or go back to school and snag a Math Degree.  Ha. Goals March 2016 -- MCSA certification June 2016 -- MCSE certification Rest of 2016 -- study code!

MCSA -- 70-461 -Chapter 14 -- Query Performance Tools

Getting closer to the final stretch.  Chapter 14 -- Query Performance Tools.

MCSA -- 70-461 -Chap 13 -- T-SQL Routines

Took a break, but back in the game.  Chapter 13 - T-SQL routines

MCSA - 70-461 - Chapter 12 - Transactions, Error Handling, Dynamic SQL

Behind schedule, but still going.  Now Chapter 12.

MCSA - 70-461 - Chap 11 - Other Data Modification

Moving to Chap 11.

MCSA - 70-461 - Chapter 8 - Tables

Took Friday off to catch up.  I'm halfway through Chapter 8 and pushing to finish Chapter 9 tonight... If lucky maybe punch through or at least hit part of Chapter 10.  Then rest of weekend to try clear out the last 7 chapters.  Let's do this.

MCSA 70-461 - Chapter 7 XML

Not quite where I want to be.  I'm only in Chapter 7 as of 12/2.  Taking longer than expected.  Hope to speed up as Chapter 8 -- Tables and 9 -- Views should be easier.