Blog Archives
70-457 and 70-458 Game Plan Part Uno
Being methodical and logical as I am, I have set forth a plan to achieve my Microsoft Certified Solutions Associate as noted earlier in my goals for 2013. Having not found much in the way of preparation material as noted in this post , I decided to rent the 70-462 Training Kit from Amazon and transpose some of the objectives there to fit the 70-457 and 70-458 since I am taking the upgrade exams the materials for the regular exams should suffice in preparation.
Now I have outlined a calendar below and the hard dates to hold me accountable to the task especially since the book has to be returned in June. Let the journey begin!
| 70-462 Training Kit – 70-457 Objectives | |||
| Objective | Chapter | Lesson | Date |
| Install and Configure | |||
| Plan Installation | 1 | 1 | 1/20/2013 |
| Install SQL Server & related services | 1 | 2 | 1/20/2013 |
| Implement a migration strategy | 4 | 1 | 1/27/2013 |
| Configure additional SQL server components | 3 | 1 | 1/27/2013 |
| Manage SQL Server agent | 11 | 1 | 2/3/2013 |
| Maintain Instances and Databases | |||
| Manage and configure databases | 3 | 3 | 2/10/2013 |
| Configure SQL Server Instances | 2 | 1 | 2/17/2013 |
| Implement a SQL Server clustered instance | 8 | 1 | 2/24/2013 |
| Manage SQL Server instances | 2 | 2 | 3/3/2013 |
| Optimize and Troubleshoot | |||
| Identify and resolve concurrency problems | 10 | 2 | 3/10/2013 |
| Collect and analyze troubleshooting data | 9 | 1-6 | 3/17/2013 |
| Audit SQL Server instances | 6 | 3 | 3/24/2013 |
| 70-462 Training Kit – 70-458 Objectives | |||
| Manage Data | |||
| Configure and maintain a backup strategy | 11 | 2 | 3/31/2013 |
|
Restore databases
|
11 | 3 | 4/7/2013 |
|
Implement and maintain indexes
|
10 | 1 | 4/14/2013 |
| Import and Export Data | 4 | 2 | 4/21/2013 |
| Implement Security | |||
| Manage logins and server roles | 5 | 1 | 4/28/2013 |
| Manage database permissions | 6 | 1 | 5/5/2013 |
| Manage users and database roles | 5 | 2 | 5/12/2013 |
| Troubleshoot security | 6 | 2 | 5/19/2013 |
| Implement High Availability | |||
| Implement AlwaysOn | 8 | 2 | 5/26/2013 |
| Implement database mirroring | 7 | 1 | 6/2/2013 |
| Implement replication | 7 | 2 | 6/9/2013 |
T-SQL Tuesday #38: Speaking of Resolve
This month’s topic for T-SQL Tuesday #38 hosted by Jason Brimhall (b|t) is an aptly themed variation on the word resolution. I personally chose the word resolve.
In 2012, I made a resolution to begin presenting at the local level. That sounds like a normal enough resolution for most, however being an introvert standing in front of people is quite terrifying. After attending many user group meetings and SQL Saturdays, I decided that since I have met many of these speakers and they are not much different from me, I should be able to stand up and do that too!
In the past, when called upon to speak in public or in front of a group my fight or flight instinct would kick in and generally I would want to run with every fiber of my being. Sometimes, I did run shamefully. Interviews are no different in many cases therefore it is safe to assume that I do not interview well. In the past, I have probably missed out on some good job opportunities simply because they thought I was an idiot based solely upon my presentation skills. It is because of this that I resolved to improve upon the skill.
Sounds good, huh? Make a resolution and then you do it, right? Easy as pie.
Not so fast, my friend. I still wanted to run Forrest run! Karla Landrum (b|t), the SQL Community Evangelist for SQL PASS, realized what was going on and she gently nudged me along to speak at the Pensacola SQL Saturday last summer. This is not unusual as historically I have been talked into doing stuff by women (and I probably should not have put that out there, so now you know).
That day in Pensacola, my fight or flight instinct kicked in again all morning long, but now I was on the hook and I did not want to disappoint Karla. Plus many of my colleagues knew I was speaking. Quite honestly this held me accountable for I did not want to ruin my reputation in the SQL community before I really even had one. My resolve that day held firm and I spoke quite nervously. But I did not run. I climbed the proverbial mountain and planted my flag upon its peak.
Since that time I have spoken at SQL Saturday Orlando and a user group meeting. It is getting easier with each event, but I still need to resolve myself to get better each time. Maybe one day I can speak at the PASS Summit? I will resolve myself to accomplish that goal and now you can hold me accountable. Enjoy!
Personal Development Plan for 2013
After yesterday’s review of 2012, it is time to set the bar a little higher for 2013. Let’s soar to new heights!
Community
- I will post daily during the work week to this blog in order to give back to the SQL community. Last year I had planned to blog 365 days of the year, but there were many days when the content was subpar because I was on vacation, holiday, or simply having fun with my family. I think this year if I limit it to the days that I am actually working on SQL Server then the content should stay consistent.
- I will spend time daily helping people on twitter, SQL blogs, and various SQL-related websites such as SQL Server Central. This was hard to do last year but it is still a noble goal and thus should be listed.
- I am setting a goal of 600 followers on Twitter which would increase my existing followers 33%.
- I will attend at least ten of the twelve Tampa Bay SQL Server User Group meetings.
- I will attend three to five other User group meetings, such as the Tampa BI group, Orlando’s MagicPASS, or the Tampa VMUG.
- I will attend at least one other event that interfaces with SQL Server such as the Orlando IT Pro Camp.
SQL Conferences & Training Events
- I will attend at least one formal Microsoft SQL training course this year.
- I will attend every SQL Saturday offered in the Orlando, Tampa, and Jacksonville areas. I would also like to attend some others, if possible, within driving distance.
- I will volunteer to help with at least one SQL Saturday this year.
- I will attend the SQL PASS Summit in Charlotte.
- I will submit to at least two different SQL Saturday events in addition to SQL PASS. Hopefully, I will get the opportunity to present somewhere in 2013.
Health
- I will be in better physical shape in time for Summit 2013.
- I will lose 100 pounds by the end of the year.
Five Year Goals
- I will continue to take at least one to two classes a semester online in order to complete my degree in Business Administration from the University of Florida. All those Engineering and Computer Science classes I took 20 years ago are not relevant today and I would like to possibly return to consulting in five or ten years and that degree would be more beneficial in that long-term goal.
- I would like to become a Microsoft Certified Master within five years.
Personal Development Plan, End of 2012 Review
With today being the first day of 2013, I thought it would be good to review my goals for the year and see where I finished. I will italicize the updates at the end of each of the original items.
- I will post daily to this blog in order to give back to the SQL community that has helped me so much over the years. I published 364 blog posts for the year! It was difficult on holidays and weekends, but I am glad that I persevered through it. It became a habit and I think my writing improved because of the effort.
- I will spend time daily helping people on twitter, SQL blogs, and various SQL-related websites such as SQL Server Central. I have tried to do this regularly, but it is harder than blogging daily. I thought this one would have been easier. I simply did not have enough hours in the day.
- I am setting a goal of 300 followers on Twitter which would double my existing followers for 2011. I am at 465 followers today, thanks everyone!
- I will attend at least ten of the twelve Tampa Bay SQL Server User Group meetings. In the end I only missed one and it was due to illness, goal accomplished!
- I will attend three to five other SQL User group meetings, such as the Tampa BI group or Orlando’s MagicPASS. There is a new Hillsborough SQL Users Group that I have attended every session. However, I did not get the chance to attend MagicPASS or the BI group this year!
- I will attend every Tampa VMWare User Group meetings which occur quarterly. I am 100 percent on this one (mainly because there hasn’t been a meeting since December of 2011! There is hope as I believe there will be a meeting in February.
- I will attend other events that interface with SQL Server or VMWare such as the Orlando IT Pro Camp scheduled for January 21, 2012. I missed the IT Pro Camp.
- I will attend one Microsoft SQL training course this year, but I cannot say at this time what that course will be as that will depend upon my employer
. I would like to attend Course 2778a (Writing Queries Using Microsoft SQL Server 2008 Transact-SQL) and Course 6234 (Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services. I did even better than that, I attended a SQLskills.com class and I am also attended the PASS Summit in November. - I will attend every SQL Saturday offered in the Orlando, Tampa, and Jacksonville areas. I would also like to attend some others, if possible, within driving distance. I am already registered forSQL Saturday #110 in Tampa on March 10, 2012. I missed the Jacksonville SQL Saturday but made up for it with Pensacola. I attended the March one in Tampa, the one in Orlando in September, but missed the BI one in Tampa in November due to the flu.
- I will volunteer to help with at least one SQL Saturday this year. I volunteered in March and spoke in June and September.
- I would like to attend SQL Rally in Dallas this year and I would definitely like to attend the SQL PASS Summit, but with one child in college this year and two more entering over the next two years, I may have to pass on this one for a couple of years until they are situated and my bank account returns to normal. I did not get to go to Rally, but I was able to attend the Summit and I cannot imagine myself ever missing that event in the future no matter what the cost! The friendships made were priceless.
- I will continue to take at least one to two classes a semester online in order to complete my degree in Business Administration. All those Engineering and Computer Science classes I took 20 years ago are not relevant today and I would like to possibly return to consulting in five or ten years and that degree would be more beneficial in that long-term goal. I am still on track here and was accepted to return to the University of Florida for the Summer of 2013.
- I will continue SQLAndy’s recommendation to meet at least three people at every SQL event. This is a great recommendation for networking. It is hard sometimes to break out of our introverted ways. I have been working hard to do this every time and it pays off so much so that when I went to the Summit I had no trouble walking up to strangers and introducing myself.
- I will attain my VMWare Certified Professional 4 certificate this year for VMWare. This did not happen as VMWare came out with a new version before my window closed to take the exam. Now I will have to take a version 5 class in order to take the exam. Personally, I am not that interested in pursuing this certification anymore choosing instead focusing primarily on SQL Server.
- I would like to speak somewhere this year, my local SSUG, VMUG, or even a training session at work. I need to get over my fear of public speaking. 2012 is the year to step it up and take it to another level. I have spoken at my user group and SQL Saturday and it is addictive.
This has been a great year for me, and I hope it has been for you too. Enjoy.
Great News for my Goals
Today I received word, after a lengthy four-month process, that my petition to return to the University of Florida after 23 years has been approved. This was one of the major goals that I set for myself last year and this year and now it has been accomplished. I have always felt a gaping hole inside having never completed my degree, not because I really needed it, but because it has always burned inside of me as a personal failure. At this stage in my career it is probably not necessary, but it is something I set out to do and never accomplished. It will be completed, I will not leave this world willingly without accomplishing this goal.
Moving On Up, To the Eastside
Yesterday was a good day, I was officially promoted to Senior Administrator late in the afternoon. Same job, a little more pay, but mainly recognition by my employer that they appreciate my performance. That is always a great feeling and a great way to start the weekend.
How will that change my day-to-day routine? It will not, except maybe that I will walk a little taller and have a bounce in my step. It is interesting to note that there have been rumblings of creating additional pay grades so that technical people like myself can advance further without going into management. However, if that does not happen then I have reached the proverbial glass ceiling as I prefer to be a DBA instead of a manager, to be honest.
I truly cannot see myself at the same pay grade for the rest of my career. Money isn’t everything, but raises on a regular basis say that you appreciate me and my work and that you value my performance. Always the optimist, I think everything will work out for the best, so no worries.
Enjoy your weekend!
Roll of the Dice
My wife and I are confronted within the next year with an interesting quandary. Come August, we will be empty-nesters at a young age. Our children will be either on their own or in college. This puts us in a unique position to move onto the next stage of our life. We still have around twenty years left in our professional careers, but where do we want to spend that? Do we stay in our beloved small town?
At this point, it does not look like our children will stick around to start families here so there is really nothing other than a lifetime of friends holding us to this town. We will however, keep our house and possibly move back here for retirement. Do we take the plunge and move somewhere totally outside of our comfort zones and reap the rewards. Do we live the life of nomads moving every couple of years to a new town just for the sake of new and exciting opportunities? We almost feel like high school seniors trying to pick the right college. What do you think?
Milestones, Keeping Them in Perspective
Today is my daughter’s last high school marching band competition. Being my youngest daughter, her senior year has been filled with “lasts” and she has been nostalgic to say the least, probably more so than my other children because she is the youngest. For me this is bittersweet as we will never experience these moments again in our lives but we also know that next year will bring many new “firsts” for her.
In life we have to keep milestones in perspective. I am more excited about her “firsts” than her “lasts” but cannot help but be a little sad at the same time because I know she will leave the nest in a few months and our nest will be empty for the first time in over twenty years. That will be a new “first” for us. A challenge to be sure. Enjoy!
Talk the Talk? Then, Walk the Walk!
If you follow my blog regularly, you will no doubt have seen many messages like this one. The clichés sound great and motivational, but there comes a time when you have to put or shut up.
Part of the reason that I blog about these subjects is to hold myself accountable. I find it quite easy to crawl back into my introverted shell and stay in my comfort zone. But as more and more people read the blog and follow me on twitter, I find it harder to procrastinate and avoid taking chances. I have spent years cultivating a plan of caution and self-conservation. This year I have broken those chains, have you? Why not?
Enjoy!
Step Outside Your Comfort Zone
“Life begins at the end of your Comfort Zone.” ~ Neale Walsh
For years people told me to get outside of my comfort zone, to which I replied no thanks. Besides, I like it in here, they all know my name. For years I did not venture outside of the zone. At the same time I was bored and found little excitement in life. That all changed in 1998 when I was 27. I had no intentions of traveling outside of the United States for fear of the unknown. I rarely did new things because the change may be uncomfortable.
The company I was working for at the time sent me to Italy for a month to finish off and deliver our software and ensure that it was implemented properly for our client when it went into production. I was skeptical and scared to leave the country but thought at least they have a vested interest in my safety and ensuring that I return home. I had a prime opportunity to explore Italy being there for a month and I rarely ventured out more than a couple of blocks from my hotel. Looking back, I wasted an opportunity of a lifetime staying in my comfort zone.
A year later I was a consultant traveling around North America. Having realized the opportunity that I missed in Italy, I ventured out a little more but not nearly as much as I should have. Two golden opportunities to see the world down the drain. Over the last couple of years, I have stepped further outside the zone to begin networking and meeting new people as well as traveling. In that time frame, my life has been more fulfilled, so much so that I look for new opportunities to step out of the circle. Don’t get me wrong, I am not all the way there yet. I still have to coax myself away from my iPad and force myself to talk to people and step away from the introversion. But I can see with each step brings new opportunities and new adventures and my life has been forever changed. Enjoy!
