This weekend I will be branching out and presenting a business intelligence (BI) session at SQL Saturday Louisville. By profession, I was a programmer turned DBA turned SQL Server consultant. As a consultant, I have done a lot of BI learning and a lot more SQL Server development than previously as a database administrator. In essence, I have broadened my skill set taking advantage of my previous skill set. Therefore, it is only natural that I present a learning session on BI, or in this case Introduction to SQL Server Integration Services. This session is great for the beginner to SSIS. I have presented this at a user group in Atlanta earlier this year, but this will be my first BI session at a SQL Saturday. Come on out to Louisville and learn about some SSIS with me! Register here.
Recently, I was humbled to be selected to speak at SQL Saturday Nashville over the Martin Luther King, Jr weekend. I will be presenting “Backup Strategies Are For Losers” at 10:30AM. This will be my first presentation in Nashville, and I am excited to expand my geographic range. In addition, I was excited to see some of the big names coming into town. Don’t believe me? Check out the schedule for yourself.
Do not forget that there are some excellent pre-cons that start on Friday, January 17th by Denny Cherry, who is presenting “SQL Server Performance Tuning and Optimization” and David Klee is presenting “Virtualization for SQL Server DBAs.” Please check those out as soon as you can while space is still available.
If you haven’t registered yet, please do so now! See you there!
Today I was thinking about the SQL PASS Summit which begins next Tuesday and I just realized that I have yet to announce that I was chosen to speak for the very first time at the Summit. I am so humbled and excited at this opportunity. I cannot begin to thank the program committee, PASS headquarters, and the SQL community enough for everything they have done for me in the past few years. At this point in my career, I truly feel that my career has exploded thanks to my involvement with SQL PASS.
Rob Volk (b|t) and I had this idea to do a humorous session where we play Laurel and Hardy depicting the interactions between junior and senior DBAs. It should be a good time for all. Our session is Wednesday at 3pm, come by and say hi. Enjoy!
This Saturday, I will be presenting “Backup Strategies Are For Losers” at 7:30AM in Orlando. It should be noted that my first ever SQL Saturday that I attended was in Orlando, so I have a special place in my heart for this event. In addition, I have never presented a session this early in the morning so hopefully there is a Starbucks close by to the campus of Seminole State College. Do not forget that there are some excellent pre-cons that start on Wednesday (tomorrow) so please check those out as soon as you can while space is still available.
If you haven’t registered yet, please do so now! See you there!
I am humbled and honored to have been selected to present my “Backup Strategies are for Losers” presentation at the inaugural SQL Saturday for Cocoa Beach, Florida. This is SQL Saturday #231 as well as being the first for the Space Coast SQL Users Group, so please make your way to the chocolate beach on July 27th for a great day of SQL Learning.
You can register here, come on you know you want to hit the beach for the weekend. There is also a group rate code for the Hilton (SQLP), where the event is being held, that expires tomorrow (June 28th). You can reserve your room here. However, I will be staying just down the road at the Courtyard where my wife and I stayed on our wedding night before our honeymoon cruise to the Bahamas. I look forward to seeing you there. Enjoy!
This past weekend was SQL Saturday 192 in Tampa. Being my home user group event always makes this event special, however this was the first time I spoke at my home SQL Saturday and that made it an event that I will always cherish. In addition, this year, I took in a full day pre-con training on Friday with Buck Woody (b | t) and quite frankly it changed my life. How many times can you say that about a SQL training, let alone a $99 training?
I know what you’re thinking, believe me I do. How can a one day training change your life? I have spoken at two SQL Saturdays prior to this event and a couple of times at a couple of user group meetings so to say that I was a speaking novice would be an accurate term in my eyes anyway. In addition, I have had no formal training in public speaking except for the semester speech class that I nervously tried to avoid and almost vomited every time I stood up in front of the class.
This journey began in 2011 as I resolved myself in Andy Warren’s Professional Development Plan session at the Tampa BI SQL Saturday. I wanted to conquer this fear of public speaking and give back to the community. It seemed pretty simple. I had no idea how hard it would be and with my fight or flight instincts many times I wanted to just run away, but I did not want to embarrass myself in this community and that held me accountable.
After taking Buck’s class entitled “Creating Your Best Technical Presentation: A Speaker Workshop,” I now feel that I have the skills necessary to put together a decent presentation and deliver it without embarrassing myself. The presentation this past Saturday went well considering that I did not rewrite it, I also did not want to run or vomit and those are great things in my book. Now I have to go back and rewrite my presentation with the skills that I have learned. If you ever get the opportunity to take this class at a local SQL Saturday near you, do it!
It is an honor and privilege to be selected to present at SQL Saturday Tampa on March 2, 2013. We will be at a new location this year, Hillsborough Community College in beautiful Ybor City, due to our growth over the last couple of years. In addition, we have three pre-cons this year and I will be attending the “Creating Your Best Technical Presentation: A Speaker Workshop” by Buck Woody (b|t). Hopefully, after this session, my presentation skills will continue to improve before my session on that Saturday. If the winter blues got you down then head down to beautiful Tampa for a warm weekend of SQL learning and register for SQL Saturday #192.
This year I will finally get to attend two other SQL Saturdays that are in the relative vicinities. In the past there was always something going on during those two weekends. As it stands, I am planning on submitting my newest session, Backups: Getting the Most Out of Your Storage, to both of those events. Curious as to what they are?
SQL Saturday Jacksonville (#SQLSat215) will be April 27th and SQL Saturday Atlanta is tentatively scheduled for May 18th. Come on out and join me at all three of those events and maybe one of them will have some SQLKaraoke for the after event! Enjoy!
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|
|Install and Configure|
|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|
|Configure and maintain a backup strategy||11||2||3/31/2013|
Implement and maintain indexes
|Import and Export Data||4||2||4/21/2013|
|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|
|Implement High Availability|
|Implement database mirroring||7||1||6/2/2013|
Today I thought I would set forth a course of action in order to accomplish my goal of passing the 70-457 (and eventually 70-458) in order to achieve the Microsoft Certified Solutions Architect (how hard is it not to say Systems Administrator). I know what you are thinking, experience is the best trainer, but I like to be well prepared before I spend money to take an exam.
Sadly, Microsoft’s page for this exam has no content as far as a book, training, or even practice tests available for either exam. I understand that I could use the limited materials for exams 70-461, 462 and 463, but those are all assuming that you do not have an MCTS. I would like to limit my preparation to only what I need to pass the exam. I was able to find one book on Amazon, but I am not sure of the series. I have never used one of these books before. I think I will rent the 70-462 book from Amazon and that will force me to finish it by June.
Now in order to accomplish this goal I need to set aside at least four hours a week in preparation with book learning and using my 2012 Developer license at home. That will be tough, but now I have told you so I am now accountable. Please let me know if you have any tips for studying for this exam, I would appreciate your input. Enjoy!
Yesterday I posted my personal development plan for 2013. After reading a few other similar blogs by colleagues yesterday, one haunting thought stayed with me all night that I couldn’t quite put my finger on until this morning. My goals were lofty, but they were no more so than last year. That would not be stepping out of my comfort zone. There was really no challenge in the list when compared to 2012, where there were some serious steps on the ledge for me.
How do I resolve this? Not sure at this point, but I have some ideas so this may evolve over the next week. The first idea I had would be to upgrade my SQL Server 2008 MCTS to the new MCSA 2012 (Microsoft Certified Solutions Associate). This would consist of two exams, 70-457 and 70-458, both aptly titled ‘Transition Your MCTS on SQL Server 2008 to MCSA SQL Server 2012, Part 1 and 2.’ I waited for all of the dust to settle with the new certifications before I pursued moving forward in my personal growth as it does not appear that I am anywhere ready to tackle the MCM, thus I have made it a five-year goal. This would put me on that path and force me to commit to the preparation needed to pass these exams. Now that I have talked this out with you here I think I will add these to the list! Enjoy!