DevLINK, Music City’s Own Technical Conference

To many, August represents the lazy dog days of summer when it’s too hot to even think about going outside. To others, this time of year conjures up thoughts of going back to school, either for us or for our kids. Still others, think of bacon.

But for the technical crowd in Nashville, August is the time of year for one of the best values going in conferences: devLINK. This year, devLINK is August 5 – 7 at Lipscomb University, One University Park Drive Nashville, TN  37204. There are over 150 sessions scheduled. It costs only $100. That’s a great value.

I’m presenting a couple of sessions at this year’s devLINK. One is in the SQL Server track; the other is in the Professional Development realm.

Locking and Blocking Made Simple

A good working knowledge of how SQL Server makes use of locking and transaction isolation levels can go a long way toward improving an application’s performance. In this session, we will explore SQL Server’s locking methodology and discover techniques for enhancing query response times.

Conducting Effective Meetings

Ever been in a meeting that drones on and on? It starts late, runs long, and doesn’t really accomplish anything. It’s a complete waste of everyone’s time. Worse yet, since nothing was resolved you’ll have to have a follow up meeting. Argh! In this session you’ll learn some of the keys to conducting an effective meeting. You’ll gain practical tips for making your meetings more productive and dramatically improving one of the most inefficient parts of your day.

If you’re going to devLINK, look me up and perhaps we can chat during one of breaks.

So I Got Promoted, Now What? Stop Doing Your Old Job

[This is part two in a series of posts about how to effectively transition to your new role after being promoted.]

Series Outline

Your Hard Work Has Paid Off

You’ve work hard over the past few years, going the extra mile to make sure that everything in your charge has gone well. You’ve managed your individual and team projects well; you’ve organized your work and developed a personal discipline so that nothing has fallen through the cracks. And now your hard work has finally paid dividends. You’ ve been recognized with a promotion. So now what do you do?

This is a question that many highly skilled, highly technical people ask themselves once the euphoria of increased pay and acknowledgement has worn off.

Unfortunately, many don’t pursue the answer long enough to find it. Instead they get mired down into the daily routine of their new role and never explore how they could better prepare to succeed. Many languish in mediocrity at best, and fail at worst.

So what’s the first thing you need to do?

Stop Doing Your Old Job

Stop doing your old job. To many, this may sound too obvious to mention. If you are promoted to a new position, why would you want to continue doing your old job as well as the new one? Isn’t one job enough?

Unfortunately, in many cases it’s just not that discrete. Often the promotion is a “working promotion.” You’ve been promoted to Senior DBA, to Development Team Lead, to Manager of the Administration Team, or to Director of Operations. The promotion comes with a new title, an increase in pay, and some new responsibilities. However, you find that in addition to your new duties, you are still accountable for many of the same tasks you had before your promotion.

To be successful in your new role, you will need to approach it with the same fervor and dedication that led to your promotion. You won’t be able to do that if effectively if you are spending a significant amount of your time doing your old job. Something has to give and it had better be the old job.

“But, It’s Not My Job”

To be clear, I’m not advocating that you tell your boss “It’s not my job anymore.” when he asks you about something that was your direct responsibility prior to the promotion. They don’t want to hear that. And besides, unless your promotion has moved you to a completely new department, that task still falls under your purview. And it’ll remain your responsibility until you’re told specifically otherwise or your replacement can be found.

So, in order to stop doing your old job, you’ll need to identify people who can successfully step into the role you once occupied, or at least take on many of the responsibilities. This can be done through a series of progressively larger and more impacting steps: assign immediate tasks, delegate small projects, and create a growth plan for your team.

Assign Immediate Tasks

Many of us have daily, weekly, or even monthly tasks that require our time and attention. There are backups to verify, meetings to attend, status reports to create, numbers to run, and logs to review, to name but a few. None of these are particularly urgent. Many are not high profile. But all need to be done.

In your prior role, you probably handled each of these at part of your job. Those responsibilities were commiserate with your level. In your new role, however, many of those activities will drain one of the most precious resources you have: your time. If you can safely offload those discrete yet repetitive tasks to one or your team members, you’ll potential free several hours per week.

Delegate Small Projects

The next step is to begin delegating some of the projects for which you are responsible. Start small and work your way up. Don’t begin with a large, complex project with multiple moving parts requiring input from numerous colleagues. Start with a small, fairly self-contained project that can be accomplished without  much outside input. Expect to work closely with the team member to whom you’ve delegated the project.

Initially, delegating will not free up your time. On the contrary, it will likely consume more of your time in the short-term than if you just did it yourself. But the payoff is just around the corner, just a few months down the road. As you get better at delegating and your team learns how to run with the delegated projects, you’ll be able to do more and more. Delegation is a force multiplier once you pay the initial start up costs in time.

Create a Growth Plan for Your Team

The best people have a knack for bringing out the best in other people. They somehow get others to perform and exceed even their own expectations. You want those kind of people on your team. And if you want them on your team, you can bet that your boss wants them on his team, too.

One way to bring out the best in other people is to consciously and intentionally create a growth plan for each of them. Talk with them. Learn their aspirations. Discover their likes and dislikes. Create a plan to help  them grow professionally, technically, and interpersonally. In short, you’d eventually like for them to easily step into your shoes once you get promoted again.

Ifs, Ands, and Buts

But isn’t all this risky? Won’t one of your team members take your job? Or won’t they get promoted out from under you?

Fostering an environment where you can be more effective while growing your people is not “risky.” In fact, a good argument can be made for just the opposite. Not growing your team is risky. Creating an environment where personal growth is not evident, where the same old routine is done day in and day out, is far riskier to you than growing your team. The best people won’t want to stay in that environment. You’ll be left with the mediocre.

One of the best compliments you can be paid as a manager is to have one of your team members promoted to a new position. It’s speaks well of the environment you’ve created. And when that happens again and again, senior management will recognize your role in producing highly effective people.

And when you get promoted, you’re next transition will be easier because you’ll have already cultivated your replacement.


Literary Rocks, Atlas Shrugged, and Twitter

Most of the time, I live under a rock when it comes to pop culture. I’ve never seen a single episode of Survivor, 24, or House. I don’t know which megastar is getting married to what professional athlete. And I can’t name a single song from Lady Gaga. In fact, I didn’t even know that name until a few months ago.

It’s not that I feel above those things; it’s just that they hold exactly zero interest for me. And it doesn’t bother me that I don’t know these things. I’m used to being completely unaware when others bring up those topics. I’d much rather watch the History Channel, learn a new Dutch Oven recipe, or mend a fence in the pasture.

“Who is John Galt?”

So I wasn’t surprised when I’d never heard of a book that a friend recommended to me about a year ago. That happens with some regularity.

But since then I’ve slowly realized that I have apparently been living under a literary classics rock too when it comes to Atlas Shrugged by Ayn Rand.

It seems that most everyone I know has read it at least once. Most agree that it’s a good book and worth the sizable time commitment required to finish its 800-plus pages.

From what I understand through talking with others, the book is eerily similar to many of today’s political events and remarkably parallels our current economic challenges. All the more astonishing is that the book was written over 50 years ago!

The 140 Character Book Club

A couple of weeks ago I tweeted my intention to finally read Rand’s most famous prose. About a half dozen Twitter friends are going to read it as well. Some have read it before, others haven’t. Some I know personally; others I’ve just met.

Together we’re going commit to reading a couple of chapters per week and discussing it 140 characters at a time. We’ll use the Twitter hashtag #JohnGalt. Our first virtual, Twitter-based book club meeting is Monday, the 26th of July. There is no specific time. We’ll just tweet comments and questions throughout the day as we have time. In fact, I’d expect the asynchronous discussion to last a few days. If you’d like to join us, tune into the Twitter feed. We’d love to have you.

“So I Got Promoted, Now What?”

“In a hierarchy every employee tends to rise to his level of incompetence.” That’s the premise of Dr. Laurence Peter in his 1969 book, The Peter Principle: Why Things Always Go Wrong My first thought when I read a statement like that is: I wonder if Dr. Peter worked in a hierarchy and if so would his premise still apply?

Nevertheless. I think we’ve all seen instances where someone who is very good with technology is promoted and flounders. Horribly. And the worse they do, the more stress they feel. And they flounder even more. So what happens? The don’t make changes in their daily work required by the new position.

This is the first in an nine-part series on how to do your job better once you’ve been promoted. Hopefully the next eight posts in the series will help you to be aware of the new dynamics required by your new role so you adjust and excel.

Stop Doing Your Old Job

At first blush, this may sound too obvious to be worth mentioning. But there’s a reason it’s first on the list. This is far more prevalent than you may think.  If you don’t address this shortly after your promotion, it can set you up for failure down the road. [more...]

Employ the Same Successful Tactics

In your prior role, you approached your job, your responsibilities, and your preparation in a certain way, one that eventually led to your promotion. And while you don’t want to simply repeat the “what” you were doing before, you can most definitely leverage the “how” that got you the promotion. [more...]

Get to Know Your Peers

Far too often, IT professionals believe, mistakenly in my opinion, that they are paid to be good with technology. To be sure, that’s a part of it. In some jobs it may even be the majority of it. However, none us work in a vacuum and it’s important to know your colleagues before you need them. [more...]

Get a Trusted System

In your prior role, your may have had little difficulty managing your  workload and tasks. But now things are more complex. You are responsible for for work that you assign or delegate to others. You had better find a good system for managing that work.

Manage Your Email

Email is a great way to communicate, however when you receive scores or even hundreds of emails every day, it can quickly become unwieldy and detrimental to your productivity. A considerable portion of your day, or even night, can be consumed by email. You’ve got to find a good technique for managing your email inbox.

Manage Your Calendar

This could just as easily be called “Protect Your Time”. The collaborative world of shared calendars can be great for people who’s job it is to coordinate and plan meetings. However, for those of us who must attend meetings as well as doing work, shared calendars can be quite a disruption our days. You must take steps to ensure you have time to work.

Start Having Weekly One-on-Ones

As a new supervisor, team lead, manager, director, or even executive team member, it’s critical to build a trust with your team that can weather the storms that are sure to come. A great way to do this is to conduct a weekly, one-half hour, one-on-one meeting with each of member.

Recognize the Tendency to Revert

When push comes to shove and the pressure really begins to mount, many new managers tend revert back to their comfort zone, to their strengths, to what made them successful in their prior role. But that only makes matters worse. Being aware of this can help you to avoid it.

Questions:

  • What were some of the unforeseen challenges that you faced after your last promotion?
  • How did you cope with the new challenges?

Writing Better Queries in Steel City

T-SQL is a very forgiving language. As long as you have the basic syntax of the statement correct, SQL Server assumes you know what you’re doing and it will gladly do your bidding for you.

But anyone who has written queries for very long will tell you that not all queries are created equally. Some return with results in under a second; we like those almost as much as we like bacon. Almost. Some take a few minutes to mull over the data and get back to you; that’s like fake bacon. And alas, some queries will run for eternity minus one.

So what’s the difference? And how can we go for the bacon and avoid the fake bacon and eternity minus one queries?

That’s the topic of a presentation I’m delivering at the Steel City SQL Server User Group meeting next week. If you’re in the Central Alabama area, I hope you’ll come out and join me.

Update:
The meeting starts at 600pm on Tuesday, July 20th, 2010 at
601 Beacon Pkwy, West Suite 106
Birmingham AL 35209.

When you enter the office park, there’s an office building immediately on the right, follow the short curve past it to the next building, it is the New Horizons one.

PowerShell and Effective Meetings at PASS 2010

Last week, PASS announced this year’s program for the 2010 Summit in Seattle, Washington. The program session are available online. This year I had a couple of abstracts that were accepted for the Summit.

Conducting Effective Meetings

The standard for meeting room chairs

Over my umpteen year career in consulting, I’ve patiently sat through literally hundreds of hours of meetings. Some of them were time well spent; most unfortunately were not. Time, money, and even moral are lost during worthless meetings that go on and on seemingly without reason or care.

Over the years I’ve done some research and made my own observations about systematic ways to help ensure that meetings are more productive and not just a big time sink for everyone involved. In this session I’ll share some of the best practices I’ve learned that will help you conduct more effective meetings. I’ll also share some tips that can help you to make the meetings that you don’t run a bit more effective too.

The PowerShell Cookbook for the DBA

When PowerShell was first announced, I was very reluctant. Frankly, I didn’t want to spend the time learning a new technology that 1) may be found wanting when compared to counterparts like PERL and 2) may not be around after a few years due to a low adoption rate. My skepticism was pretty high and my enthusiasm was low.

However since then I’ve become a big fan of PowerShell. It definitely lives up to its name. It’s a powerful object-based scripting language built on the .net framework that’s completely integrated with the Windows environment. It natively knows about the Windows Registry, the devices, and the environment, making many tasks relatively easy.

In this session, I’ll share with you some of the scripts I’ve used to collect and analyze server settings and performance data. Most of my sessions are 50% demonstration; this one may have an even higher percentage of demos.

Question:

  • What tasks do you use PowerShell to accomplish?
  • What are some of your more monotonous activities that could be automated with PowerShell?
  • What kind of scripts would you like to see in my demos?

Now Serving: SQL Server 2008 SP2 CTP

chrome.jpg

For those of us who love to get our hands on the latest and greatest shiny new things, the wait is over for SQL Server 2008 SP2 CTP. You can download it now and “Gentlemen, start your testing!”

Read the SQL Server Team Blog Announcement.

And by the way, there’s really no such thing as too much chrome.

Life Guarding Your Data

life_guard_stand.jpg
Last week as an adult leader of my son’s Boy Scout Troop, I accompanied a dozen fine young men to a week-long summer camp. While they were working on various merit badges, I took a training course that was available to both Scouts and adult leaders – the BSA Certified Life Guard course.

There’s a reason that BSA Certified Life Guards are so well respected in the life guard community. It’s a rigorous program that’s both physically and mentally challenging. It’s considered the cream of the crop for life guard programs.

As I look back at the course, I see that there are some principles that are common to life guarding and protecting your server’s data.

Health Review

Prior to going to any camp outing, each Scout must turn in a health form that documents any medical conditions of the Scout. This allows the medical professionals to be better equipped with specific information should an emergency arise. For example, they know the medications he’s taking, conditions he has, etc.

A Server Run Book serves the same purpose in the IT world. It documents the settings on the server, the applications it supports, and the changes recently made to its configuration. Without a Run Book, diagnosing a problem is much more difficult, especially if multiple people administer the server.

Have a Plan

When things go wrong, it’s not the time to stop and think about your course of actions; it’s time to act. You need to know who’s going to do what and when. In Life Guarding it’s called a ERP, Emergency Response Plan, and it can be the difference between life and death.

The same is true for server issues. If your SQL Server goes down, you need to have a plan. You need to know who to call for what support. Know the contact information for the SAN administrator, your Windows administrator, and your boss. Know who is going to get the messaging out to the users. In short, know who will do what.

Know Your Tools

lifering.jpgA Life Guard has many tools available to him to rescue drowning victims. He can use a pole to reach out the the person, a floating ring to toss the the victim, canoes or other boats to go get them, or a floatation tube to help in a personal rescue attempt. The Life Guard must be familiar with each of these devices before the need arises.

Likewise, a DBA has many tools at his disposal when recovering a downed server. Some are built into the SQL Server SKU, others are available through third parties. In any case, you should become fluent in their use before you need them in an emergency situation.

Keep in Shape

As a Life Guard -in-training, I had to swim, and swim, and swim. And then swim some more. And when the swimming was done, we started the training. The swimming was just a warm up.

As a DBA, it’s imperative that you keep in shape as well. Go to training. Go to conferences. Go to user group meetings. Learn the features of the new version. Know what tools are available. Incorporate the best practices into your environment. Read.

Practice

During the 30 hours of Life Guard training I received last week, almost all of it was in the form of practice. The instructor explained various techniques to us while standing on the dock and then minutes later we were in the water practicing those life saving techniques. It’s one thing to know in your head how to do something; it’s something else entirely to actually be able to do it when the pressure is on.

As DBAs we should test and practice as well. Regularly verify the integrity of your servers’ back ups. Perform some test restores to make sure that everything is happening as you wish. Don’t be caught off guard with a need to recover data only to find you can’t.

As I tell my students and clients – back ups are really all that important. It’s the ability to restore that’s important.

Know the Risks

Life Guarding is a inherently dangerous activity. You must be ready to risk your life to save another. Additionally there are legal implications to being a Life Guard.

As a Database Administrator, we have risks too. How much data can we afford to lose? How much does each minute of downtime cost our organization? The answer to these questions will help us to understand the risk and make recommendations.

Follow

Get every new post delivered to your Inbox.