Category Archives: Professional Development

Aside

The 2013 SQLPass Summit is being held in Charlotte, NC next week and I’m excited to say that I will be there. The SQLPass Summit is an annual SQL Server geek-fest of learning that attracts over 4000 SQL Server professionals. … Continue reading

90 days to MCSA – Building a plan for the Challenge

In the first post in this 90 days to MCSA series, I laid out the idea that we should all work together to target achieving the MCSA certification in SQL Server 2012 and/or Windows Server 2012.

Join the Challenge
Now, it is a very good idea to set a goal and to start working towards attaining that goal. However, if you do not have a plan on how to achieve that goal, you will never get there. Let’s say you set out to climb Mount Everest. That is all very well and fine, but first, you will need a few things before you can just go off and climb the highest peak on Earth. You will need oxygen tanks. Cold weather clothing and camping equipment. An idea on exactly where Mount Everest is. You will need training on how to climb large outcrops of rock. You may even need the services of an experienced mountaineer. The point is that there will be a number of steps that will need to be followed in order to even attempt the climb.

What I will, hopefully, lay out here is a basic plan of action that we can follow to be much better prepared to pass the exams that are required for the MCSA certification. I will lay out two separate plans, one for the SQL Server 2012 certification and one for the Windows Server 2012 certification. You will need to pick one of these to follow (or both, if you’re crazy in the head, just like me !).

First of all, let’s go over some basic rules of certification and test-taking.

1. You need hands-on experience !!! The whole point of the certification is the knowledge, not the piece of paper it’s written on. A wise old lady once told me “Knowledge is a burden easily carried!” To know something is definitely not the worst thing in the world. You can never know everything, but to continue learning new things every day is the way to go through life. In order to make sure that you know the material, you will need to build a home lab and play with the software. Break it. Fix it again. Break it again. Etc.

2. You can’t possibly know everything so rely on your strengths and focus on your weaknesses. That brings me to the next rule. You can’t possibly know everything about the product, especially when there is a time crunch like we have here. Make sure you shore up your knowledge in areas where you are strong and then develop a strategy on how you will attack some of the areas where you may not understand as much.

3. You will be tested on stuff you may never have, and may never use. We are a variegated bunch and work and play in a wide variety of environments. Some DBA’s may have never worked with SQL replication in their careers (like me), while others have no idea on how to set up database mirroring (who needs disaster recovery, anyway?). Some sysadmins have never actually created an Active Directory forest from scratch (Don’t blame me. It was like this when I got here) while others have no idea how to administer DNS (the network guys do that, right ?). If you want to walk on water, you have to get out of the boat first …

4. Carve out time every day to study & practice, if your work/home life will allow One thing I will advocate for you to do, RIGHT NOW, is to go and have a talk with your family, SO, spouse, dog, friends, etc. about the fact that you will need about 10 hours a week for the next 10 – 12 weeks in order to achieve this goal. I’m not kidding. If you’re serious about furthering your life, you will need the support of those who love you. If you skip this step, there will come a time when you’re sitting in the exam room thinking “Damnit, I should have spent an extra 2 hours going over this thing …”. Fact.

5. Develop a solid test-taking strategy. I have not taken a lot of certification tests in my career. I have been skating along on good-looks & charm all my life . However, there are a LOT of good resources out there that detail how to go about the task of sitting a Microsoft exam. Here are a few that I found:
Certification Magazine
Computer Performance LTD
Pearson IT Certification

6. Reward yourself when you hit your goals. Sitting at home, on the shelf in my office, I have this LEGO set. It’s not built. It’s still sealed in the box. When I finish this challenge, I am going to spend an entire Saturday with my 6 yr old son and we are going to open it and build it and it will be GLORIOUS !! Go find something similar for yourself. We can all share our triumphs together.

7. Take time off when you need it. “All work and no play makes Jack a dull boy” You are not a robot. You will go mad if you do not take a break. Go outside every now and then. Go and replenish your bacon supplies, at least.

90 days to MCSA – SQL Server 2012

Week 1 (this week):
     Build your Plan. Following this blog post series and visiting the Microsoft 90 days to MCSA web site will help you to do that.
     Build your Lab. Here is a great article from the fine folks at Microsoft learning on how to set up a lab to prep for exam 70-461: Lab Setup Guide to Prep for Exam 70-461 Querying SQL Server 2012.
     Sign up for the Microsoft Learning 90 Days to MCSA e-newsletter. This can be found on this page.

Week 2 (next week):
     Build your Knowledge. Sign up for the Free Video Training from TrainSignal.com: trainsignal.com/blog/90-day
     Sign up for the first exam. Microsoft is offering free second shot retake vouchers for a limited time. Go and grab 15% or more savings on certification packs here.
     Share with us in the Google+ community. Let us know how you’re doing, if you have any questions or if you just generally need to talk. We’re here for you.

Week 3:
     Build your Knowledge. Watch the Microsoft Learning Exam Prep video for the first exam that will be attempted – 70-461
     Join the Microsoft Learning Study Group. There are some great resources available in these Study Groups including discussion forums and exam prep wikis. Go and join the Database Certification Study Group.

Week 4:
     Build your Knowledge. You should be consuming the content of an exam training kit like the one offered by Microsoft Press which can be found, amongst other places, on Amazon: Training Kit (Exam 70-461): Querying Microsoft® SQL Server 2012. Also available and recommended is the Study notes and review questions book: MCSA SQL Server 2012 Exam 70-461 & 462 ExamFOCUS Study Notes & Review Questions.
     Take the 70-461 exam. By this point, you should be in a position to exert your effort into actually putting knowledge to paper. Well, digital bits of paper. You will go and attempt to pass the exam. Let us know how it goes !

Week 5 and beyond:
     The process is more-or-less repeated with the 70-462 and 70-463 certification exams. I will be updating this post with specific links that cover those exams. Keep an eye out for that.

90 days to MCSA – Windows Server 2012

Week 1 (this week):
     Build your Plan. Following this blog post series and visiting the Microsoft 90 days to MCSA web site will help you to do that.
     Build your Lab. One of the tricky things about studying Windows Server 2012 is that you need to delve into the guts of Windows Hyper-V as it is a very integral part of the OS. You will need 1-2 Windows 2012 instances and that is not including the DC. Remember, Hyper-V does not support nested Hyper-V virtual machines so you will need a physical installation of Hyper-V or the use of anopther company’s virtualisation software (VMWare or Oracle VirtualBox – What I use). Details on how I am building my virtual environment will be coming in another blog post.
     Sign up for the Microsoft Learning 90 Days to MCSA e-newsletter. This can be found on this page.

Week 2 (next week):
     Build your Knowledge. Sign up for the Free Video Training from TrainSignal.com: trainsignal.com/blog/90-day
     Sign up for the first exam. Microsoft is offering free second shot retake vouchers for a limited time. Go and grab 15% or more savings on certification packs here.
     Share with us in the Google+ community. Let us know how you’re doing, if you have any questions or if you just generally need to talk. We’re here for you.

Week 3:
     Build your Knowledge. Watch the Microsoft Learning Exam Prep video for the first exam that will be attempted – 70-410
     Join the Microsoft Learning Study Group. There are some great resources available in these Study Groups including discussion forums and exam prep wikis. Go and join the Server Certification Study Group.

Week 4:
     Build your Knowledge. You should be consuming the content of the exam training guide offered by Microsoft Press which can be found, amongst other places, on Amazon: Training Guide: Installing and Configuring Windows Server 2012. Also available and recommended is the Exam reference book: Exam Ref 70-410: Installing and Configuring Windows Server 2012.
     Take the 70-410 exam. By this point, you should be in a position to exert your effort into actually putting knowledge to paper, well digital bits of paper. You will go and attempt to pass the exam. Let us know how it goes !

Week 5 and beyond:
     The process is more-or-less repeated with the 70-411 and 70-412 certification exams. I will be updating this post with specific links that cover those exams. Keep an eye out for that.

And that’s it. Stick to your plan and you will, successfully, achieve your goal of a brand new MCSA certification that you can take to your boss as your bargaining chip for a raise or promotion (hopefully).

I hope to see everybody that I know achieve their MCSA certification in SQL Server 2012 or Windows Server 2012.

90 days to MCSA

I saw a very cool post from Microsoft Learning on Facebook yesterday that intriged me. Microsoft Learning has put together a very nice set of training materials, videos, wikis, discussion forums and the like to help candidates prepare for the set of exams that make up the SQL Server 2012 or Windows Server 2012 MCSA certifications.

Join the Challenge

90 Days to MCSA blog post series:
1. Introduction – This post
2. Building a plan for the Challenge – 90 days to MCSA – Building a plan for the Challenge

Now, let’s break down the two certifications:

The SQL Server 2012 MCSA consists of 3 exams that need to be passed. They are 70-461: Querying Microsoft SQL Server 2012, 70-462: Administering Microsoft SQL Server 2012 Databases and 70-463: Implementing Data Warehouses with Microsoft SQL Server 2012.

The Windows Server 2012 MCSA consists of the following 3 exams that will need to be passed. They are 70-410: Installing and Configuring Windows Server 2012, 70-411: Administering Windows Server 2012 and 70-412: Configuring Advanced Windows Server 2012 Services.

More information can be found on each of the links above and by visiting the Microsoft Learning web pages for SQL Server and for Windows Server.

There are many , many different excellent resources available and the main landing page for all that great content can be found at 90daystoMCSA.com.

Now, I’m sure that I will be able to put together a good basic rundown of the various information available on the 90 Days to MCSA website, but the team at Microsoft Learning is much better at that than me. Here is the link to 90 Days to MCSA: SQL Server 2012 Edition and 90 Days to MCSA: Windows Server 2012 Edition articles that will explain eveything is great detail for you.

What *I* will be doing is moderating a study group and email list of people who have indicated to me that they’d like to achieve this certification within 90 days. I have created a Google+ community here that will be used as a discussion forum / study group and I’ll be sending out regular (every week or 2) newsletters that will contain updates, tips & tricks, etc. Please contact me if you’d like to be included in the Google+ communit or on the email list. I will also be posting various blog posts about the 90 Days to MCSA Challenge. Keep your eyes open for those. I will be adding updates to this page as I add blog posts.

Now, one thing I’d like to mention is that I will be trying to achieve BOTH certifications. I am currently a DBA consultant but my background is in systems administration. I have been tasked by the company to achieve these certifications as part of our company relationship with Microsoft. BUT, I know that these certification are very beneficial even if I didn’t *need* to do them for work, hehehe.

I hope to see everybody that I know achieve their MCSA certification in SQL Server or Windows Server.

SQL Server 2012 for the DBA

This past Wednesday night, the 18th Jan, I had the privilege to speak at the local SQL Server user group – JaxSSUG.

I was asked by Tom Brenneman to co-present on some of the new SQL Server 2012 hotness. I am currently working on SQL Server 2012 content that will be the basis of an upcoming 4-day class so I was able to put together a quick overview presentation. It was called Delta Force: SQL Server 2012 for the DBA.

JaxSSUG presentation

It was a great evening with approximately 60 people attending. I was definitely the supporting act while Adam Jorgensen (blog | twitter) headlined with his presentation on the BI Tabular Model and PowerView in SQL Server 2012.

Thanks to Scott Gleason, Tom Brenneman and JaxSSUG for putting on a great event.

You may download the slide deck for my presentation here.

SQL Server 2012 for the DBA (virtual class)

A new skill for a New Year
Pragmatic Works Training has a full and varied schedule of classes coming up. You can find the list here.
I will be teaching the SQL Server 2012 for the DBA virtual class on 19th – 22nd March. Registration is now open for this class.

Overview

SQL Server 2012 is the newest version of SQL Server available from Microsoft. This four day (half-day) course is designed to introduce SQL Server DBA’s to the new and exciting features available in that version. We use a variety of lab exercises to ensure lecture sessions are backed up by hands-on experience. With the hands-on labs, you will experience how the new features can be utilized in your everyday DBA work. This course will cover topics such as AlwaysOn, ColumnStore indexes, SQL Server Data Tools, the FileTable feature, Azure and administering the BI platform within the context of SQL Server 2012.

Prerequisites

The target of this class is SQL Server DBA’s, developers, architects or IT professionals who have average to good T-SQL skills already. This class assumes that you have a good understanding of SQL Server fundamentals. For example, you should know and use the SQL Server Management Studio (SSMS) interface and associated toolbox items before attending this class. It is not mandatory but some experience using the Business Intelligence Design Studio (BIDS) interface will be an advantage to you.

Day 1 – Administration and Performance:

Module 1: Deprecated and Discontinued Features
Module 2: ColumnStore Indexes
Module 3: DMV’s & Extended Events
Module 4: Security
Module 5: SQLOS
Module 6: Central Management and DRU

Day 2 – AlwaysOn and Disaster Recovery:

Module 7: Availability Groups
Module 8: Using Availability Groups
Module 9: Clustering Enhancements
Module 10: Disaster Recovery Enhancements

Day 3 – Programmability & Azure:

Module 11: SQL Server Data Tools (SSDT)
Module 12: Data-tier Applications (DAC Pac’s)
Module 13: T-SQL Enhancements
Module 14: FileTable and Full-text Semantic Search
Module 15: Introduction to Azure

Day 4 – Administering the BI platform:

Module 16: SSIS Administration
Module 17: SSAS Administration
Module 18: SharePoint Administration
Module 19: Azure Reporting

On sale: $495

Twitter – #Meme15

Logo for Meme15
It’s the middle of January already and most people are curled up under a blanket by the fire, trying to keep warm. I, however, live in Florida where it’s (relatively) warm and I’m putting together this #Meme15 post. #Meme15 is a blog series thought up by Jason Strate (blog | twitter) that gives us a place to discuss a common topic and how that topic affects us personally.

This month, we have been tasked with answering one, or both, of these two questions:

1. Why should average Jane or Joe professional consider using twitter?
2. What benefit have you seen in your career because of twitter?

Well, I joined Twitter back in 2009 and was basically using it to follow people that I thought were interesting (@SteveWoz, @LanceArmstrong, etc). You know – the way the rest of the world uses Twitter. I was looking to get more and more involved in the SQL community and Brent Ozar (blog | twitter) told me to look at connecting with SQL people on Twitter. I was sceptical at first because I wasn’t sure what SQL people tweeted about apart from how big their database was and how many times they had to shrink it per week. Boy, was I wrong. I quickly got connected with some very smart people who were friendly and helpful. I attended many SQL Saturdays and started meeting these people in real life and built up some great friendships within the community.

In 2011 I was fortunate to be able to go on the second SQL Cruise (blog | twitter) and had an absolute blast. If ever anyone feels like taking a great learning vacation, SQL Cruise is the way to go. I feel that the experience was enhanced due to the Twitter friends that I had made.

I returned from the cruise refreshed and a little bit smarter. Not long after that, I received a job offer from Pragmatic Works Consulting. I’d been discussing the opportunity with them for a few months by then and the time had come for me to take the next step in my career. I am currently involved in authoring the upcoming Professional SQL Server 2012 Administration book. I am also currently putting together a 4-day SQL Server 2012 training class and will be recording the class for SSWUG in the near future. I will also be presenting the material at SQL events around the country. The success that I enjoy is due, in part, to the help and support I have found from the SQL people I interact with on Twitter. Thank you to all those people from the bottom of my heart.

To some people, Twitter may just be a place where they can find out when and where celebrities are having lunch. To me, it is a network of like-minded individuals that interact with each other for the greater good of the community. Even if it’s mostly about bacon.

Spouting tripe! or, Why do I blog? #meme15

A great man once said “If nobody said anything unless he knew what he was talking about, a ghastly hush would descend upon the earth.”
That great man was Sir Alan Patrick Herbert and he CERTAINLY knew what he was talking about.

There are many, many, many, many brilliant blogs out there and I don’t want to just add to the “noise”. One of the things that I hope to accomplish, in general, is to be more of a Producer than a Consumer.
The Western way of life is all about product consumption – information, food, money, oil, goods. Mostly food, though. I mean money. I mean information, mostly information … Definitely information.

It’s not surprising that THE most important product (in my opinion) of recent times is the i – the Internet. The i has 2 things going for it: It’s BIG and it’s TOO big. You can find just about anything on the i. Well, actually, you CAN find anything and everything on the i. That is good and bad. On one hand, the i is good for finding help when you are at a loss. However, you can get lost down a rabbit hole of time-suck if you’re not careful. There are also some very, very, bad corners of the i that you should never, ever go. But, the basis of the i is the information.

It's starting to feel a lot like Christmas ...

It's starting to feel a lot like Christmas ...



One of the main reasons I blog is to share information that is different. One of the key characteristics that I want to foster for my blog is that of uniqueness. I don’t just want to rehash the same old thing that everybody else is saying. I hope to be fresh, new, exotic and exciting. Like a good toothpaste.

I have always considered myself a warm and friendly person. (I hope others do too, or I’m in trouble). Another reason I blog is to help people in a hospitable, yet fun way. I know that I have searched for help when I have been stuck on something and I hope that my blog will help somebody (maybe only many, many years down the road).

One of the most amazing things about Pragmatic Works is the commitment to the SQL Community. This is not just a cursory “Oh, Hai. How r U? Have a doughnut …”. This is a deep rooted commitment that is entrenched in the very culture of our workplace. It is actually in our job description to blog, speak and be involved in the community as much as possible (without interfering with our normal consulting duties). I count it a privilege to be a part of that.

So, let’s be careful out there in the unpredictable world of the i.
The main thing to remember is to “Believe none of what you hear and only half of what you see.” – Benjamin Franklin.