Voting Day is Here

Comments: 1 Comment
Published on: November 2, 2010

Tis the season for voting and SQLServerPedia has thrown out an election as well.  The SQLServerPedia awards are under way and voting will last until Nov. 9th.

Surprisingly, I have a couple of nominations.  I would ask for your vote and am delighted by every single vote I get.

I hope you vote for the best in each category.  Let’s get out and make our voices heard for something that really matters.  There is a lot of good stuff that has been nominated.

You can cast your vote here.

T-SQL Tuesday #012 – Skills

Comments: 2 Comments
Published on: November 2, 2010

November is upon us and in some areas this also means that the leaves have changed color.  With the change in leaves we also have a change in TSQL Ones…err Tuesday this month.  The change is with good reason as well.  November is a busy month in the DBA world.  PASS is holding the Summit Nov 8 – 11 in Seattle (that involves the second Tuesday).  We have Connections this week in Las Vegas (despite being in Vegas, I won’t be there due to budgetary constraints).  And we have Paul Randal (Blog | Twitter) hosting TSQLTuesday this month.

Paul has chosen the topic of “why are DBA skills necessary?”

You know, like nunchuku skills, bow hunting skills, computer hacking skills…

Oh wait, maybe I do have some of those computer skills.  I don’t have nunchuku skills though, and that could be useful from time to time.

As a DBA, we occasionally have the opportunity of attracting a new client or a new job or a new database.  It seems that more often than not, some of the skills requisite (at least they should be) of owning a database are missing.

Some of these include:

Backup and recovery of a database
Disaster Recovery
Normalization and De-normalization
Performance Tuning
Server Patching
Proper Storage recommendations
File and Filegroup Creation
Performance Troubleshooting
User and Database Security
And more…

And more…

I want to touch on some of the other skills of a DBA.  These are the skills that a DBA must use in order to be successful (besides knowing the craft).  For me, these skills help make the job just a bit easier and they seem to be present in many of the top tier Database Professionals.  For me, these skills include:  Communication, Participation, Sense of Community, and Drive.  These may also appear as attributes – but I think they are things that a professional can work on and improve on to improve in the work place.


This is a skill employed in many different ways in the profession.  Many have chosen to communicate via blogs and via speaking at events, while others have written books.  This skill is a must have in the day to day business and helps to mend fences between DBA and business as well as DBA and Development.  Learning how to interact with both the positive as well as the harsh feedback is critical to career growth.


As a database professional, it is essential to be involved in meetings and the decision making process.  Just being present does not always mean that you are participating.  Are you engaged in thought of getting out of the meeting or about the next level on Angry Birds?  Or are you listening, taking notes (if necessary), and interjecting comment that is constructive to the meeting?  When a task comes across your desk, what is your reaction?  Do you just do it or do you interface with the requester to ensure that the request meets the needs?  Occasionally it will happen that the requirements do not reflect the true need from the person making the request.  Without talking to that person, a level of frustration is accomplished when you return to them having completed the request but not having fulfilled the underlying needs.

Sense of Community

One of the best networks available to use is the social network for the Database Professional.  There is a good amount of people always willing to help via twitter (#sqlhelp) and online forums (  A good DBA knows his/her limits and knows that they don’t know everything.  Admit it early and be willing to rely on the community when you don’t know something.  Part of being a good database professional is knowing where to find help and where to find the answer.  This also ties in with the communication skill.  There is no need to memorize every nook and cranny of SQL Server.  Learn how to take notes, create documentation, and how to talk to the community.  This will help you learn more about SQL as well as help you build friendships.


This one is a lot more difficult.  A skill that is helpful in being a better Database Professional is an internal motivation to be better and to create a better database environment no matter the employer or project.  If this means longer hours or making significant changes – then do it.  Sometimes it also means that we need to make a list and present the good with the bad of the environment and then make suggestions on how to improve.  If you are really good and don’t put in any extra effort – imagine how good you could be should you dedicate a few extra hours here and there to becoming a better Database Professional.

Oh and the other stuff

I don’t want to completely ignore those important skills.  There are many accidental DBA’s out in the world due to a database having come into existence.  Many times a database can exist without a DBA due to various variables such as vendor support, little to no activity, or low criticality of the data.  Many times one of these databases eventually explodes into being much more than initially planned (high transaction or high criticality or even reduced vendor support).  At this point a DBA is needed.  DBA’s help protect the data and are an investment for the company.  A DBA can help provide timely information as well as protect the data and ensure business continuity.  For me, it is a worthwhile investment – and not just because I do the work.

In Conclusion

Today is Election Day throughout the United States.  Get out and Vote!

There are elections at SQLServerPedia, SQLRally and then there are also the political elections.

November Snuck Up on Me

Tags: ,
Comments: 1 Comment
Published on: November 1, 2010

I should have gotten this post out last week with another follow-up this week.  Well, looks like I will have to get a couple out this week to try to remind people.  This month SSSOLV has moved up 1 week due to Connections being in town this month and PASS being next week.  With Connections being in town this week, I was able to convince Steve Jones (Blog | Twitter) to come and speak to us.  It works well if we move our regularly scheduled meeting from the second Thursday to the first Thursday of the month.

Steve is going to talk to us this month about the modern resume.  And for those that don’t know who Steve is, Steve is a co-founder of SQLServerCentral and is currently the Editor of SQLServerCentral.

We will be hosting this presentation via LiveMeeting as well.  Here are the details for joining the meeting virtually.

Attendee URL:

Meeting ID: PPBZ4S

The meeting will be from 6:30 – 9 PDT at the Learning Center ( 777 N. Rainbow Ste. 250 Las Vegas 89107).  I am still working on the evite at this time (the contacts list is unavailable currently).

We hope to see you there.

page 2 of 2»

November 2010
« Oct   Dec »

Welcome , today is Tuesday, June 2, 2020