Archive for the ‘Professional Development’ Category

T-SQLTuesday #42: The New Adventure!

Tuesday, May 14th, 2013

It’s time for T-SQL Tuesday the forty-second, Wendy Pastrick asked that we talk

T-SQL Tuesday!

T-SQL Tuesday!

about our experiences with change in our work lives. I’d like to share some exciting news about myself and the new adventure I am taking.  Earlier this month I started a new journey with Dell as an Database Administrator Sr. Advisor. I also am happy to share why I decided to go down this path. Some of the reasons include new technology, career planning, exciting challenges with a great team.

New Technology!

I love being around new technology. Personally, I like to find new innovative technologies that can be used to improve business processes while save money and time. During the interview process I learned that the SQL team at Dell fits the bill. In fact, I heard about so many great projects including some under NDA all I can say is I feel like a kid in the candy store!

Career Planning!

Not every employeer makes it a priority to have you map your aspirations and goals. Very few companies help you do a fit gap assessment and tries to find business opportunities to fill them.  Dell goes out of its ways to help you with your career planning. This might be the greatest perk of the job.

Exciting Challenges with  a Great Team!

Not many people get excited about the opportunity to work with chained transactional replication where a subscriber is a publisher in another publication but I do.  That’s right, I love to be challenged and I am excited to work with some talented people. I am going to get to do both in my new role. I will be working with multiple DBA’s who have been working with SQL Server for over ten years. I look forward to sharing my knowledge and soaking up everything I can from them.

My First White Paper – Top 10 Tips for Optimizing SQL Server Performance

Tuesday, April 30th, 2013

Earlier this year I had the chance to collaborate on my first ever white paper “Top 10 Tips for Optimizing SQL Server Performance” with Patrick O’Keeffe who is Director of Software Development at Dell Software Group. I must say, it was a really interesting experience.

Writing a blog post is one thing, but to have a team of people critiquing everything you write is something else entirely. It really helps you to focus a lot more about the core message that you are trying to convey.

Things you might normally write in a blog have to be curtailed and thought of far more carefully for a more discerning audience. For example, one anecdote I wrote would have made perfect sense to a UK audience, but had to be removed as it may have confused a wider international audience.

The marketing process itself is really interesting too as there are various brand guidelines that you have to adhere to, you can think of it as a very manual Policy Based Management system. Rereading a document with track changes on with multiple edits from multiple editors is a skill that I am going to have to brush up on.

One thing that stuck in my mind from the various review sessions was when you were allowed to write a number in numerals and when you couldn’t. It seems such a small thing but a lot of attention was paid to it. Choosing callouts was a lot of fun too, so expect to see those cropping up in a blog post soon.

The white paper

We realise that you are all busy people and SQL Server is a vastly comprehensive piece of software that gets larger and more complex with each release. With this in mind there is no way that any single technical paper can tell you everything that you need to know. So in this white paper we have chosen to use the Pareto principle, that’s the 80/20 rule. By following these ten tips you will see the greatest percentage gain for the smallest amount of work.

The ten tips

10. The Baselining and Benchmarking methodology helps you spot problems.
9. Performance counters give you quick and useful information about currently running operations.
8. Changing server settings can provide a more stable environment.
7. Find rogue queries in the plan cache.
6. SQL Profiler is your friend.
5. Configure SANs for SQL Server performance.
4. Prevent cursors and other bad T-SQL from returning to haunt applications.
3. Maximize plan reuse for better SQL Server caching.
2. Learn how to read the SQL Server buffer cache and minimize cache thrashing.
1. Understand how indexes are used and find bad indexes.

You can download “Top 10 Tips for Optimizing SQL Server Performance” here.

How to provide a better customer service

Monday, April 29th, 2013

Thomas La Rock (Blog | Twitter) recently wrote a blog post about misplacing a  device he has called a FitBit One which is a pretty cool piece of kit, it’s entitled “How to find a missing FitBit”.  For those of you who don’t know what they are, think of it as a pedometer meets social media device (and much much more). Without it sounding like an advert it really is addictive as you gain badges the more steps you do, you can also share your stats with friends and have a league table to see who is doing best. This may sound a bit manual, but it’s not it can sync up to your laptop via a USB dongle and it uploads the information for you. I used this very product as a demonstration of the use of the cloud in a conference in Barcelona I presented at last year.

What did I do when I lost my FitBit?

Well to be honest, the first thing I did was hit a search engine. After a while I decided that taking my anger out on an inanimate object wasn’t the way to go, so clicked on search instead. The guys over at FitBit have a pretty good FAQ section and provided a list of things for you to do in this scenario. One of the tasks was to email support which I duly did, I wasn’t expecting anything to come of this, but I received an email that contained this:

FitBit response

To say I was shocked was an understatement. This is probably the best customer service response I have ever had!

The SQL Server related bit

In Thomas’s post he lists a number of steps that you should cover in a “production down” outage. I’m not going to list them in this post. If you want to read them you should read his post.

The reason I am writing this is primarily not to inform you of the great customer service I received, but to make you think of the business owners that you are providing a service to when a disaster strikes.

How do you engage with your “customers”?

I’m going to go out on a limb here and say most of you just think about the technical aspect of disaster recovery. There are of course other things that need to be considered, that’s the state of mind of those people whose data you are trying to save. These people are scared, they may not know you (or maybe they do and now they’re really scared). They potentially don’t know how skilled you are and that you have a disaster recovery procedure in place – you do have one right?

Many of them may never have been in this situation before. Remember this, they are scared they will be thinking things like; “What if I can’t get my data back?”, “Can my department recover from this”, “Will my project / business be shut down?”

It is the responsibility of someone on the team to ensure that people in your business are up to date with proceedings and are made aware of any problems as soon as possible so alternative plans can be put into action.

In order to help you with this task I have come up with five ways to help you communicate more effectively.

5 Customer service tips

1) Understand that time is of the essence.

There are a number of processes that you can put in place prior to a disaster occurring that will save you time when dealing with your customers during a disaster whilst making them feel valued at the same time.
Consider adopting some of the following strategies:

  • Assigning a member of the team for being point of contact for all customers.
  • Create an internal distribution list for this scenario.
  • Create a document that can be used as a template for an auto-response. This autoreply should apologize for the disruption and point people to using the email distribution list rather than contact a team member directly by email or phone where their enquiry can be dealt with in a more timely manner.
  • Consider setting a new voicemail message giving the number of the point of contact.

Implementing these suggestions will only take a few moments and could repay you tenfold in the time saved from dealing with worried customers whilst still providing a level of service.

2) Be empathetic

I have already touched on this point before, but as it is so important I will re-iterate it again. Your customers are scared they are looking to someone to make them feel better about the situation. You are that person. Being empathetic is easier if you take on board the rest of the top 5 hints and utilize them.

3) Be honest

If you are the person doing the work be honest to your representative, they won’t thank you for it if you’re not. Likewise, if you are the representative and you have just been told that you have more chance of winning the lottery than hitting your RTO (Recovery Time Objective) then tell them that. By this I mean you will miss the target not that the best chance they have of supporting their family is to play the lottery!

The level of honesty will be up to the most senior person working at that point. There might be some details that for business reasons you should not disclose.

4) Take responsibility

This is the time where you earn your salary as a DBA. Apportioning blame to someone else is energy wasted on something other than the task in hand. You should have a single focus to recover as much data as quickly as possible. Anything else is a distraction. Focus on those tasks that will allow you to achieve your goal more quickly.

Of course if you are the one taking the blame then accept it, make a note, vow to yourself that it will never happen again. Learn from the pain and become a better SQL Server professional.

If you are the department representative and have a difficult call to make to senior management then make it. It might be they need to make some kind of company release or put an alternative procedure in place. It won’t look good if you were the one who delayed that decision which cost the company more money.

5) Keep focused on the positive

Be confident in your abilities, you will have practiced this scenario before and if you haven’t then from this point on you will! If you aren’t sure what to do take advice there is a whole community out there just waiting to give a helping hand to those in need, take comfort from that.

Tell your business users that they have seasoned professionals working for them on their behalf and that this problem will be resolved for them as quickly as possible.

The importance of feedback

After the disaster is over and things are back to normal it’s important to hold a debriefing to see where you as a team could have done better. It’s important that you can take onboard any criticism that can be put your way, don’t be afraid about this as it’s about the situation and the process, not you as an individual.

What’s great about this scenario is that you too can have your say, make a list of everything that would have made your life easier if you would have been able to use availability feature x. Ask them if there is anyway that they could put aside some budget in future for this kind of thing. Talk to them about the importance of maintenance windows and how you can help reduce the risk of this kind of thing from happening again.

A wise IT professional once told me “It’s important that they feel the pain they have created, otherwise change is difficult to influence”.

Now is the perfect time to ask for that faster piece of kit, upgraded licence, extra member of staff or training.

How do you handle this scenario?

I’d love to hear how you have handled this scenario in the past. I hope for those of you who haven’t thought about this aspect of DR before that it’s been beneficial to you.

How Not To Hire Someone

Thursday, April 4th, 2013

This sign may not help you to hire someoneIt’s the end of the college basketball season here in the US. At this time of year I get a little nostalgic for my former life as a basketball coach. I always enjoyed playing in March as that meant our team was doing well and advancing through the playoffs.

I recall one year while in graduate school at Washington State University when our basketball team was struggling. A couple of starters were hurt, another player suspended. We were relying on our backup players towards the end of the season. When asked about why the team was not performing well the coach said “we didn’t recruit these guys to be starters.”

Ouch.

That coach moved on soon afterwards, as most coaches tend to do for one reason or another. But that comment always stuck with me. As a coach myself I knew it was my role to find the best talent and assemble the best possible team. It was my job to not only find talent but to develop their skills. I would never walk into the athletic directors office and say “sorry we aren’t performing well, but I can’t seem to find any good talent out there, and the guys we have just aren’t developing fast enough.”

I can’t imagine I’d leave that meeting with my coaching job still intact.

Fast forward a few years (OK, decades) later and I see people comment frequently about how they can’t find talent to fulfill an IT role. DBA, server engineer, network admin. The list goes on but the feedback is the same: there seems to be a dearth of talent. “We can’t find any good DBAs” you will hear people say, and they will list out all the deficiencies for the candidates.

Most companies look to hire someone by employing recruiters, both internal and external, to work through their human resources department. These are your coaches. If they aren’t getting you the talent, then you need to go find the people that can attract and recruit talent. You can’t allow a coach or recruiter to keep telling you that the talent doesn’t exist. It does exist, it’s all around us.

Here are the three reasons I see as to why you hear someone claim they can’t find talent:

1. Expectations are too high

They are looking for the top 1%. If you want to only hire the top tier then you need to go after and recruit the top tier. If you expect to put up a HELP WANTED sign and have the top 1% of all applicants send in a resume then you are doing it wrong. As a coach I can’t hold out for a seven foot tall player, I need to go find someone that is shorter but can still rebound.

2. Silly requirements

I’ve written before about bad job requirements. If you list out four different roles in a job description (or have those expectations, see above) then you are likely not going to be able to find anyone. As a coach I can’t think of trying to recruit someone and say “OK, after practice I need you to take care of the team’s laundry, make their dinner, and then help them with their homework. Oh, and on game days you’ll be driving the team bus, too.”

3. Inability to coach or train

Let’s say you find someone but they aren’t quite in the 1%. You may hesitate to bring them on board because you don’t have anyone around that can help them develop into the role you need. As a coach I made certain I put players into places on the floor where they would be the most successful right away. Then over time I would work on developing their skills so that they could contribute in more ways. If you don’t have someone that can help coach or properly train, then you likely won’t take a chance on hiring someone outside of the top 1%.

It’s also possible that you are told that no good candidates exist because the people doing the interviewing don’t want to bring someone on board that is better than they are. Most good basketball teams are focused on winning, not playing time. Be mindful about the folks you have doing the interviewing and make certain they aren’t afraid of “hiring up” when possible.

The next time you hear someone say they can’t find qualified people to hire I want you to think about the real reason why. Chances are if you make a few adjustments in your hiring process, as well as your internal training, you may find that there are plenty of candidates that would be wonderful additions to your team.

How Not To Hire Someone is a post from: SQLRockstar - Thomas LaRock

The post How Not To Hire Someone appeared first on SQLRockstar - Thomas LaRock.

How To Be An Expert At What You Do

Wednesday, March 20th, 2013

Every successful company has them. They’re the lifeblood of their organisations. Linchpins essential to getting things done and doing them extremely well. More commonly we know them as experts.

Experts are always in popular demand and they come in all manner of different flavours.

Of course they are just everyday people, regular folks, like you and me. Regular folks that is, who one day decided that they want to be outstanding at what they do!

What’s So Great About Being An Expert Anyway?How To Be An Expert

There are many common as well as individually unique reasons why you might want to be outstanding at what you do, to be an expert.

Some of the benefits to being an expert include:

Career Enrichment

  • Establishing yourself as the go-to-guy (or girl)
  • Being at the forefront of your customers and managers minds (particularly come review time)
  • Recognition as an authority of your subject
  • Increased opportunity
  • Investment in you professionally

Knowledge & Skill

Influence

  • People trust and value your opinion
  • Your decisions can shape the world around you

Challenge

  • Be the first in line for the difficult, demanding and interesting projects, work and opportunities.

These are some of the more general motivations however being the expert that you want to be is an individual choice.

What might an expert look like in your role/company?

What opportunities and challenging projects could open up to you as an expert?

Become The Expert “You” Want To Be

Being an expert is not about being the very best at something. It is about being the best that YOU can be.

Here are some of things you will might wish to consider on the journey to becoming the expert that you want to be:

Skills Development

  • Strengths – What are you good at? How can you excel at these even more?
  • Weaknesses - What might you need to learn in order to progress? Are there any particular obstacles holding you back?
  • Continued Investment – Make a commitment to continually invest in your skills development. (Here’s how)

Professional Positioning

  • Customer Focus 
  • You and Your Manager
    • What are your goals and are you on target to achieving them? (what is the purpose of your role)
    • Is you manager aware of your expertise and how you can contribute?
    • What would need to happen/change in order for you to be your manager’s go-to-person?

These are just some of the things you will want to consider when determining how to become the expert that you want to be. What does being an expert mean for you?

The rewards of being an expert are clear. Make the decision to be outstanding and to become the expert that you want to be.

SQL Saturday #194 Exeter – A presenters review

Monday, March 11th, 2013

This weekend was full of a range of emotions for me. Grab a beverage and I’ll tell you all about it….

The Journey

On the Friday I had arranged to take my 70-451 exam at lunchtime at a test center just outside Birmingham which would provide me with a nice jaunt down the M5, or so I thought.

Drove to the test center, took and passed the exam and all was well with the world. I was pretty happy. Unfortunately there were quite a lot of roadworks on the M5 and driving down to Devon with a bad back on a Friday afternoon probably wasn’t the wisest decision I could have made.

As it tuns out my journey faired a lot better than some of the other presenters who decided to travel down later in the day.

 

The arrival / venue

I never told anyone this at the event, but I managed to get lost :( oops oh well! Eventually found the hotal and parked across the road which was really convenient. At this point I’m sore but glad to be here.

The hotel itself was OK, the staff were pleasant and courteous – you can’t ask for much more than that and it was in a pretty good location for those travelling in being not too far from the bus and train stations.

I’m going to skip ahead a bit here and then double back later in a Tarrantino style edit so stick with me. After the speaker meal (stick with me) I mentioned I didn’t have my pass so was ushered downstairs to where the event was taking place. Jonathan, Annette and the team had managed to attain 4 fair sized rooms plus two other rooms for use as a speaker room and an exhibition hall for the event itself. It was a hive of activity these volunteers, organisers and sponsors put in a lot more hours than regular attendees would realise.

 

The social bit

It’s become a bit of a tradition to have a speakers meal before events now and we all headed down to a Spannish tapas establishment where I spent a very pleasant meal sat between Denny Cherry (Blog|Twitter) and Mark Broadbent (Blog|Twitter) with Mr and Mrs (to be) Dave Morrison opposite. I should point out that Dave’s fiance isn’t going to take his first name as well – that would be too confusing!

It was great to catch up with so many of the #SQLFamily, I’ve ended up committing to speaking at a few more events as well as pulling in a few favours and booking others to speak at my user group.

There were a full range of conversations with various people from bewildered looking first timers unsure of what to expect from a community event to a really deep chat with Thomas Kejser (Blog | Twitter) on the future of SSD and how it could change our whole perception of performance tuning with SQL Server.

 

The sessions

I made a conscious decision not go to many of the sessions during the day because I was getting quite a bit of pain from my back and didn’t think it would be fair on people if I needed to stand up and walk around whilst someone else was trying to present! I really do regret this decision as there are so many talented people in the UK and Jonathan, Annette and the team made a great job of creating an interesting and varied programme.

There was one session that I did sit in on and that was Thomas’s session on compression – for those that missed it he has blogged about it and you can read it here – http://blog.kejser.org/2013/03/11/quantifying-the-cost-of-compression/

 

Thank you’s – Sponsors

Due to syndication rules, I can’t really speak about the companies which were there as it’s similar to product placement. Suffice to say there were companies there providing blazingly fast IO subsystems, training providers, more traditional software vendors and a few consultancy firms.

Your support was appreciated as without your sponsorship events like this would not be possible.

 

Thank you’s – Organisers

A big thank you has to go out to the organising team headed up by “Mr and Mrs Father Jack” aka Jonathan and Annette Allen who run the SQL SouthWest user group. Jonathan, Annette and the team really put a lot of effort into organising this event, which is especially impressive when you consider that they are also working on other projects such as SQL Relay.

You can gain a little bit of insight into their lives with the “New Year Aspirations” interviews I conducted with them back in January: Jonathan, Annette

 

Thank you’s – Volunteers

Being a volunteer is a very selfless task and can be very hard work, so I’d like to thank all the volunteers and let them know that we all really appreciated their part in the days proceedings. Especially my room monitor who didn’t seem to mind that I went a few minutes over!

That brings me on neatly to my session…

 

My session – “Natural Born Killers, performance issues to avoid”

I was very humbled to be billed alongside several MVP’s, MCM’s, MCA’s and authors. As this was my first ever SQL Saturday I was a little unsure exactly what to expect.

My session was billed last, whether this was because they saved the best till last (doubtful – see my comments about the highly esteemed counterparts above) or they though everyone would have gone home by then (much more plausible).

I was actually very pleasently surprised by the turnout. As this session is a summary of a number of core performance issue topics and I knew that some of these topics were being covered in other sessions throughout the day I thought there would be me and the room monitor watching the rugby on the big screen. The reality was very different with just a couple of empty seats at the front.

From my perspective things seemed to go pretty well, I haven’t recived the feedback yet, so whether that feeling was reciproated is under dispute.

What I can say that I did manage to get some audience participation going and there seemed to be some genuine enthusiasm and I could see a few lightbulbs going off. Add in some random sweet throwing to people who answered questions correctly and I was very happy.

 

The end?

Unfortunately I wasn’t able to stick around for the raffle and wrap up and had to shoot off atraight after my session, but not before I was asked to pose for a photo which was a little strange! If I ever receive a copy I’ll update the post with a picture.

It was a really enjoyable time and I would recommend that everyone does try to support the community by goingto these kinds of events. You may even want to try your hand at presenting…

 

Presenting Tips

If you’re interested in speaking or have just started speaking why not check out the indepth interview I did with Kevin Kline (Blog | Twitter) on presenting.

 

Upcoming events

If this has whet your appetite for finding out more about community events, this post of mine lists all the events based in the UK for March 2013.

If you are living elsewhere in the world why not check out http://www.sqlsaturday.com/events.aspx to see if there is a SQL Saturday event taking place near you.

SQares

Tuesday, March 5th, 2013

give, gain and growLast weekend some friends of mine (Jason Strate (blog | @stratesql), Tracy McKibben (blog | @RealSQLGuy)) jumped into a lake as part of a charity fundraiser. They even gave the event a hashtag: #SQLPlunge

But that’s not why I am writing this today.

Throughout the year I will see members of the SQL Community give. They give their time. They give money. They give themselves. They just give. Our community seems to have that common thread, we are givers.

But that’s not why I am writing this today.

This morning I woke up and realized that when I have left this world I want to be remembered for how much I was able to help others. I don’t want to be remembered as the person who treated, or spoiled, himself first. The word ‘Ubuntu’ comes to mind here. It’s a concept that essentially says ‘I am because we are”.

That’s what I want to write about: Our community of data professionals. Ubuntu. I am because we are.

Archbishop Desmond Tutu offered a definition in the 1999 book No Future Without Forgiveness:

A person with Ubuntu is open and available to others, affirming of others, does not feel threatened that others are able and good, based from a proper self-assurance that comes from knowing that he or she belongs in a greater whole and is diminished when others are humiliated or diminished, when others are tortured or oppressed.

Tutu has been credited with offering additional context on Ubuntu in 2008:

Ubuntu speaks particularly about the fact that you can’t exist as a human being in isolation. It speaks about our interconnectedness. You can’t be human all by yourself, and when you have this quality – Ubuntu – you are known for your generosity. We think of ourselves far too frequently as just individuals, separated from one another, whereas you are connected and what you do affects the whole World. When you do well, it spreads out; it is for the whole of humanity.

When people tell me how successful I have been in my life I need to stop and understand it is because of the success of others. I am not drinking from a well that I dug for myself. The well was dug for me so that I may drink.

That is why I feel the need to dig, too.

And that is why I want you to start digging.

I was sent an email recently from Lara Rubbelke (@SQLGal). In that email she mentioned the idea of “SQares”. Similar to how “Sqoop” got it’s name (“SQL” + “Hadoop”), SQares is the result of “SQL” + “Cares” = “SQares”.

We already use the #SQLFamily hashtag to describe our sense of Community. I think Lara is on to something with SQares. I’d like to see folks use the #SQares hashtag for events similar to the Polar Plunge.

I recognize that not everyone likes to go out of their way to talk about their charitable donations. That’s fine. I would ask that when you see others being charitable feel free to promote that hashtag a bit. I’d like to raise awareness for the amount of giving that we see throughout the year. And charity doesn’t mean donations or fundraisers, it can be as simple as volunteering your time at a SQL Saturday, or the PASS Summit, or even a local school helping kids learn about computers and data.

Maybe after we spend some time pointing it out then the idea of giving back to others won’t be so uncommon.

To me this is what #SQLFamily is all about. I think some folks feel it means just folks that touch SQL Server. To me it means a group of data professionals that help one another whenever possible.

I am honored to be a part of this group. I am honored to serve this group.

I am because we are.

SQares is a post from: SQLRockstar - Thomas LaRock

The post SQares appeared first on SQLRockstar - Thomas LaRock.

Career Growth and How You Can Achieve Explosive Results

Tuesday, March 5th, 2013

Continued investment in your professional development for career growth is hard. It’s also essential to being a successful Data Professional.

You’ve got a lot of competing priorities, we all do, it goes with the territory of being good at what you do. Managing the demands and responsibilities of your job can consume a great amount of time, leaving little for everything else that’s important to you. Professional development and career growth can all too easily become a luxurious afterthought.

So when you do get time to focus on your professional development it’s vital that you maximize the return on your investment.

Let’s Hit The Gym

Career growth - Push Past Your Limits - Bench press

Push Past Your Limits

Keeping fit is a hobby of mine and I enjoy training several times a week. It’s quite common knowledge that regularly working out is good for your health, much like regular investment in professional development is good for your career.

Anyone who has ever worked out will tell you that when you start a new fitness programme you will often see quick and dramatic results.

This happens because the new stimulus to the body is a shock to the norm. It’s something that you are not used to doing and so the body has to adapt to cope with the new stress.

The more significant the shock to the system, the greater the reaction to adapt.

Unfortunately this dramatic growth period is often short lived. The body is very efficient at adapting and so as many a gym goer will attest to, results and ultimately progress can quickly plateau.

If you continue to just show up to the gym and go through the motions, you’re not going to make much progress.

The same is true of your professional development. Sticking to your preferred subject, reading the next chapter in that book or taking the next logical step, is comfortable. It may well be a small step in the right direction but you’re not really challenging yourself and the growth you experience will reflect this.

In order to break free from a plateau and promote new growth, the body needs to be challenged.

Breaking Out of Your Comfort Zone for Career Growth

You need to step outside of your comfort zone, to challenge yourself, in order to really grow.

By stepping outside of your comfort zone you:

  • Accelerate your growth
  • Amplify your growth
  • Broaden your experience
  • Increase your versatility
  • Challenge yourself

Taking on Your Own Challenge

What could you do to step outside of your comfort zone to expose yourself to increased career growth potential?

I bet when you think about it there are opportunities right there for the taking close by.

  • Maybe the development team are working on a project that you can stretch yourself and get involved with.
  • Perhaps your manager has a requirement to deploy an inventory system for your SQL Server infrastructure and maybe you could use PowerShell for the job.
  • Fancy trying your hand at presenting? Why not start with a brown bag lunch session at your office or smaller slot at your local User Group.
  • Thinking about getting a SQL Certification? Why not really push yourself by shooting for the MCM.
  • Is your company looking into alternative Database Technology? Maybe you could volunteer to learn and evaluate them, become the company expert.
  • Who said anything about SQL Server? I bet brushing up on those project management skills could come in handy.
career growth mountain

Which mountain will you climb?

Once you start brain storming ideas, you’ll soon discover that you are spoilt for choice.

As Data Professionals we really do have an abundance of opportunity for career growth and development. In the words of Thomas LaRock, “It’s a wonderful time to be in technology”.

Should you find that when you’re considering your own development options, the thought of pursuing a particular path gives you a sense of apprehension or nerve’s, then you’ve found exactly the right choice for you!

Stepping outside of your comfort zone is NOT easy and that’s the point. By taking on a more challenging venture you will significantly increase the return on your growth and development.

What could you do to step outside of your comfort zone? Share your thoughts and ideas in the comments.

 

100th blog post

Friday, March 1st, 2013

Unless you’ve entered “100th blog post” into your favourite search engine and clicked on pot luck (or whatever it is) you’ll know that I pretty much always blog about SQL Server. Not this time!

Today, I thought I would share a little bit about me and my blogging experiences. I’ll probably do an update post at 200 and compare what has happened.

 

Why do I do it?

Why I blog is a very good question, I wrote something on it a little time back, you can read about it here if you’re interested.

 

What motivated me?

There seems to be something in me that wants to help others and give something back. For years I played the trumpet and wanted to be a brass teacher, I used to be in the cubs and then scouts and went on to become an assistant Scout leader for a while.

It seemed innevitable that once I was settled in a career in SQL Server that something like this would raise it’s head again.

 

How did I get started?

Blogging was becoming more and more popular and it started seeping though into search engine results for problems that I was experiencing. At that point I started to follow a couple of people including some chap called Brent Ozar.

 

Brent wrote a series of posts on How to start a blog. I mulled it over for a while, quite a while, and then some. Eventually I decided that I should give it a go. If you are thinking about blogging then do have a read. I found it a big help and probably wouldn’t have taken the plunge without it.

 

Has it proved popular?

To be honest I have no idea, what is good is people saying I really enjoyed that post on X or I didn’t know that about Y thanks. Feedback means a lot, not just to me but every blogger. It can be hard creating content and wondering if anybody is gaining anything from it.

If you find something useful, then please leave a comment and/or share it with others though social media. Far too many bloggers stop writing great content because they think that nobody cares!

 

Some metrics

Due to the fact I syndicate my blog in a few places I don’t have a complete picture of the number of people that read content that I create (another reason why comments are so important). What I can share with you are some of the metrics from my site via Google Analytics.

 

As you can see from the number of visits, things have picked up over time. Hopefully that’s some encouragement for people just starting out.

 

It’s hard to tell from the image above just how many visitors my blog has received. I included this just so you knew it wasn’t all me hitting F5 !

 

To my surprise, I seem to have had visits from readers all over the world.

 

You might be able to tell from the shading that the top 3 locations are the U.S., the U.K. and India.

The image below shows the top 10:

 

Well, that’s it for my 100th post. I hope you’ve enjoyed it!

I’d love to hear back from you on your experiences of blogging or if this has inspired you to start your own blog.

If you want to contact me about a SQL Server problem or blogging a little less publicly than leaving a comment,  you can always Contact  Me using the Menu at the top of my website, or the page list at the  bottom.

Here’s to another 100 blog posts!

 

Multitasking A Ridiculous Workload – How I Do It

Tuesday, February 19th, 2013

I don’t! There’s no such thing as multitasking. At least, not how most of us think about it……

Being successful as a Data Professional is hard. When you’re good at what you do, you are in demand.

If you’re like most data professionals then there’s always something else that needs doing. In fact, should you ever find yourself with nothing to do, then well, you’re doing it wrong.

There’s only so much time that you have available to work with and so you need to make sure you spend it wisely (See: The Best Database Administrators Automate Everything).

This means ensuring that you focus your time and energy on what is most important. For me personally, this is determined by the achievable value of completing a given task and it’s priority.

So You Think You’re Good at Multitasking

Well I’m sorry but you are not. In fact, none of us are. Ironically those of us that think we’re good at multitasking are apparently the worst at it (Beware Employees Who Boast About Multitasking).

StressHeads

Being a Data Professional is hard

Multitasking is a misnomer, people can’t actually do more than one task at a time. What most of us consider to be multitasking is in fact task-switching, the act of switching back and forth from one task to the next. Task-switching is expensive and you could be loosing as much as 40% of your productivity in the process.

I encourage you to stop believing the multitasking myth and to instead invest your energy in organising your task workflow so that you can dedicate uninterrupted time to focus on a single given task, preferably from start to finish (or at least up to the point where you personally cannot move it further forward).

If you can do this you will avoid the associated costs(time and focus) of task switching and increase your overall effectiveness.

Workload Management For The Data Professional

To ensure that you are investing your time and energy in the right place, you must use a system.

I don’t care how high your IQ is or how awesome that photographic memory is. One day, they will let you down. Use a system, it’s simple and more reliable.

It doesn’t really matter which system you decide to choose, so long as you do use one. Often it’s a matter of personal preference and in time you will identify which approaches work best for you, perhaps even a combination of several.

There are entire publications written on the subject of time/task management and productivity techniques, the most popular being Getting Things Done(GTD). Personally I find it to be a bit overkill and too restrictive for my tastes, which is why I like the more lightweight model put forward in Eat That Frog by Brian Tracy.

The Eat That Frog System

Book Eat That Frog

Eat That Frog – by Brian Tracy

The essential theme of the book (Eat That Frog) is that you should always eat your biggest and ugliest frog first. In other words complete the work that you want to do the least first, as the things that you procrastinate on and avoid doing are almost always your most important tasks.

Frogs aside, the book outlines a simple and effective task management system that I have adopted myself and tweaked to my specific needs. If you are not already using a system of your own, then I would highly recommend that you give this one a try.

Quite simply, it requires that you first split your tasks into categories. A through to D.

A – Must be completed today
B – Should be completed today
C – Nice to complete someday
D – Delegate

(You’re all smart folks and I’m sure you get the general idea so I’m not going to explain the detailed reasoning behind each of these categories, that’s what the book is for. If you have any specific questions though feel free to drop me an email.)

Within each category you then assign each task a numerical priority, with 1 being the most important.

Once completed, your system shows you exactly what you need to be working on right now, with A1 being your most important task.

Task Log Example

Task Log Example

Increase Your Effectiveness By Getting Organised

By using a task management system such as the one I described here, you can keep an accurate track of workload, prioritise and ensure that you spend more of your time delivering on what’s really important.

Do you have a task management system that you like to use or have some tips of your own? Share your thoughts in the Community Forum.

References