Make sure you don’t miss out on posts by Subscribing to the Blog Feed. You can also receive this Blog feed via Email.

The PASS nominations process got under way this week. All the recent shenanigans aside, make sure you don’t forget to vote! This is your chance to have your say on who you feel can best represent your interests within PASS.

Here’s your weekly roundup of SQL Server Blog Posts, News and Techie Stuff. Enjoy!

Time is running out for you to register for this awesome event. If you are still undecided about whether or not to attend then I suggest you take a look at the following items:

UK SQL Server Usergroups

• Bracknell - 17th September – SQL Server CLR and T-SQL Functions – Colin Leversuch-Roberts aka GrumpyDBA, Data Tier Applications (DCA) – Neil Hambly
• Leeds - 15th September – Using XML data in SQL Server with Anthony Brown, and Martin Bell explores change management in SQL Server 2008 and Iain Kicks from Quest Software.
• Manchester - 16th September – User group evening with Allan Mitchell and Iain Kick from Quest Software talks of Managing SQL Server in a global economic meltdown.
• Maidstone - 22nd September - Kent User Group – Analysis Services (Andrew Calvett), TSQL Techniques (Dave Ballantyne)
• Cardiff - 23rd Septemeber – Chris Testa O’Neill will be creating a cube with SSAS, Ian Archibald from Attunity demonstrating their CDC products.
• Edinburgh - 7th October – Implementing Hierarchies using TSQL and the HierarchyId type and understanding aggregation problems (Tony Rogerson); TBD (Allan Mitchell).
• Leeds - 27th October – User group evening with Martin Bell and SQL Server and Virtualisation with Mike Kiersey.
• Manchester - 28th October – SQL Server Replication with Neil Hambly and Martin Bell explores change management in SQL Server 2008.

Keeping up with PASS - Useful links for keeping up with all the PASS community events, collated by BradMcGehee.

That’s it for this week. If I’ve missed anything that you think deserves a mention this week then be sure to let me know! You can leave a comment below, send me an emailor message me on Twitter(@JohnSansom).

You know what I’m talking about. There are DBA’s out there that go way above and beyond merely getting the job done. Managing huge workloads with ease and delivering them with class. But how do they do it?

I’m certain you have seen and experienced first hand what I’m talking about and yet it can be difficult to quantify what exactly it is that makes these individuals such outstanding professionals. Personally I do not consider there to be a magic formula but rather an assortment of desirable qualities and traits that are commonly present in outstanding DBA’s.

“What character traits and qualities do you think make an outstanding DBA?”

In no particular order, here are some of the traits that I have been able to identify and consider as desirable qualities of outstanding DBA’s.

1. Excellent Attention to Detail

"Ninja-like focus"

A DBA is regularly expected to perform complex administrative tasks incorporating multiple steps. Even with the assistance of a Play-By-Play or other detailed documentation, the outstanding DBA needs to be on the ball at all times and leave nothing to chance.

Working with mission critical production systems means you need to expect the unexpected. Check, double check and triple check implementations. The outstanding DBA knows through experience what to watch out for when administering a SQL Server environment but on no occasion will anything be left to chance. They have mastered the DBA Survival Skill of Thinking Defensively.

2. A Natural Problem Solver

Problems or rather delivering solutions to problems is the outstanding DBA’s bread and butter. They have a passion for problem solving and relish the opportunity to take on any challenge that comes their way.

Within an organisation it is quite common for the DBA to be consulted on problems that may not initially be within their domain of responsibility because their problem solving talents can be leveraged in a variety of parallel business disciplines.

Problem solving is fun for these people. The more difficult and challenging the problem, the more determined they are to solve it.

Enjoy solving puzzles? Check out this SQL Server Crossword.

3. Assertive

Being a DBA means you need to be able to communicate your views confidently, clearly, calmly and concisely, oftentimes under high pressure circumstances.

Your opinions will almost certainly be challenged, which is a good thing because it means your peers are thinking about the issue at hand. A DBA who successfully asserts themself is both polite and firm, without being an ass. See The Politics of SQL Server Performance.

"Don't be this guy!"

4. Tactful

The outstanding DBA is a master tactician, understanding that decisions will be required that at times result in a conflict of interest. The production DBA for example can often be viewed as a path of resistance to a development team and must walk the fine line of ensuring security & availability, whilst at the same time not hampering delivery.

Understanding the business and more specifically their role within it enables the DBA to maintain an objective outlook and operate more effectively within their organisation.

5. Manage Relationships

The outstanding DBA is a corporate chameleon with a talent for communicating effectively with all levels of the business. In order to operate successfully within larger organisations the DBA must forge and manage relationships across the business.

Corporate politics aside, good communication skills and character are the key.

6. A Good Decision Maker

Able to quickly weigh up the pros and cons of a situation, whilst keeping the big picture in mind, enables the outstanding DBA to make good decisions. It’s all to easy for a data professional to become bogged down in the detail but it’s important to always consider the bigger picture of all tasks undertaken.

Developing and demonstrating an understanding of the business not only assists in making good decisions but also highlight the value of the outstanding DBA to the business and it’s decision makers.

7. Humble

Far from being arrogant, the outstanding DBA has an in depth knowledge and understanding of SQL Server but is humble in it’s application. They teach rather than preach.

As a knowledge expert the outstanding DBA is keen to share their knowledge with all who wish to learn. Often very active in the SQL community, posting on forums, blogging and Tweeting, these data professionals make for excellent mentors.

Conversely the outstanding DBA is always looking to learn, understanding that no one data professional knows all there is to know about SQL Server. See Jump Start Your SQL Server Learning Today to find out more.

"Everybody Be Cool"

8. Calm Under Pressure

When it’s all kicking off and panic ensues, the outstanding DBA keeps a cool head and takes it all in their stride. You will often find this quality in Production DBA’s that work with highly available OLTP platforms daily. Pressure just goes with the territory.

9. Business Minded

Those that can demonstrate an understanding of the business, apply big picture thinking and prioritisation to their activities will deliver more value to their company. Business decision makers notice this skill, ensuring that the outstanding DBA is considered as a knowledge expert and is consulted on all business decisions that affect the environment they administer. This in turn empowers the DBA further to deliver even more value thereby continuing the cycle.

10. Approachable

Got a problem with SQL Server? The outstanding DBA is “the” SQL Server go-to-guy within their organisation. No matter what else they have going on they will make time for you and are always available to provide guidance, support and assistance.

Whether or not it is possible to master or to implement all of these traits is debatable but what is clear is that they are both common and present amongst outstanding DBA’s. What character traits and qualities do you think make an outstanding DBA? Share your thoughts and comments below.

Other Professional Development Posts

• Top 10 Junior DBA Interview Tips
• With Great Advice Comes Great Responsibility
• Blog your way to becoming a better DBA
• How to Provide Great Feedback

Same as before, the answers are all SQL Server words that you will be familiar with from your experience of working with SQL Server. It’s not easy and I’m not in the business of giving out clues.

Crossword Format Options

• For an interactive Crossword using JavaScript click here.
• For a printer friendly version click here.

Good luck and enjoy!

I’m toying with the idea of making puzzles, games, and quizzes a more regular feature so if this is something that you would like to see more of let me know!

Below you will find a SQL Server themed Crossword for you to complete. Now be warned this is not going to be easy. The only guidance I will offer is that the answers are all SQL Server words that you will be familiar with from your experience as a SQL Server guru.

Crossword Format Options

• For an interactive Crossword using JavaScript click here.
• For a printer friendly version click here.

Good luck and enjoy!

SQL Server Guru Challenge