BorderLayoutBoxedLayoutOpenLayoutMaximum textMedium textSmall text


Register
Thursday, November 20, 2008

SQL Server News & Information

tsql, performance tuning, industry trends, & bad jokes

exec spSubscribeMinimize
Print  
sp_help 'jmassie'Minimize

This site is maintained by Jason Massie. He has 10 years experience as a DBA and has specialized in performance tuning for the last five. He was recognized by Microsoft as a SQL Server MVP. Jason has spoken at the Professional Association of SQL Server Conference, the North Texas SQL Server Users Group, SQL Connections and TechED. He has worked at Terremark (formerly Data Return) for nearly a decade.

You can contact him at jason@statisticsio.com or 469.569.5965

Jason has the following certifications:
  • Microsoft Certified IT Professional Database Administrator (early adopter)
  • Microsoft Certified IT Professional Database Developer
  • MCDBA (7.0 and 2000)
  • MCSE
  • MCSD
Print  
tblTagCloudMinimize

Abstracts addition Affinity Aggregation allocation Always Analysis Announced another API Appending article Authentication backup be Behavior between Bootstrapper Breaking Build Cache Caching Check checksums Codeplex collection Connecting contest Controller Creating CTEs CTP CUBE cursors Data Database DATALENGTH Debugging Design Diagnosing Diagnostic Differences Documentation DTS Emergency enhancement Entity ETW Exchange execution Express Extensions Fall February Filestream Filtered group GROUPING have Hosting Idle impact Improvement Increase Index Indexes Inserts Instances Interoperability Introduction IO large Late LOB local Localized Magazine Maintaining Maintenance Management maps March Microsoft minutes missing Mix Never November Offline OLE Online operations operators optimizations Optimized Overlapping Package Page Paging Panacea parallel part Partial Partition partitioned Partitioning PASS Performance PFS plan Plans Practices problem Problems Procedure Program programmatically Programming Protection Queries query read recent Recursive Related released Reports Restore return ROLLUP ROWCOUNT Runtime Security Select Sequence sequential Server Services set SETS Shooting shorts sizes Solutions Sortable SPARSE Spool SQL SQLIOSim SSIS Stalled Star Statement Statements stats Stored strategy Stuck Studio Submission Subreports Suggested Summarizing system Table Tables Tampa Task Than there through Timeouts Total Traces Transaction transfer Tricks Trouble TSQL turning understand Understanding undocumented Unique unused upgrade Upgrading Useful Value variables VDI Vista Will Windows Wireless

Print  

What Makes a Great Database Professional?

Posted by Jason on Monday, July 28, 2008 to Professional Development
346 Views | 7 Comments | Article Rating

I think a good database professional knows their domain inside and out. Whether you are a classic production support DBA, a SQL developer, an ETL guy, or a mutant database guy, you have to know your stuff just to be considered "good". This is or should be expected so that alone doesn't necessarily make you great.

What crosses you over into "greatness"? This is just my opinion but I think it is being a generalist even if you are a specialist. When the sh!t hits the fan and all fingers are pointed at SQL,  not only do you have to identify that it is or is not a SQL problem but you have to prove it. How do you prove it is not a SQL problem? You find where the packets are being dropped. You find the latency in the SAN. You find the bad .Net code. When you can do that, you get elevated to "Goto guy" status.

I am not going to pretend to be the goto guy. Maybe back on NT4\Win2k\VB6\ASP but I have had the SQL goggles on for the past couple of years. I am planning on changing that this year but I am not sure how yet. Maybe OS. I would like to get really good at Windows Server 2008. However, being good C# in VS2008 would be a nice asset too. Hmm...

What do you think makes a good database professional a great one? What non-db skills would you like to add to your arsenal at the expert level?

email it! |   |   |   |  | 
Permalink     7 Comments  

Rate this Post:
COMMENTS:

This is an excellent post. Some people are unaware of the breath and depth of knowledge that will be required to be a good database professional. I can start with these:
1: System Center 2:Hyper-V 3: Enterprise Storage Networks. 4:Network Protocols 5: Application Protocols 6:Visual Studio,CLR, C#

posted @ Monday, July 28, 2008 3:37 PM by Emmanuel Anumonwo


One word: Depth.

Just as you say, being able to be a kind of generalist beyond your specialty makes a big difference. I also belive that thinking 'in depth' about your are of expertise makes a huge difference. Once you master the 'inner domain' of T-SQL, you need to know how T-SQL lives in MSSQL; what's different in MSSQL? and MSSQL runs on Windows. And the storage might be local, DFS, SAN, etc.

Working from the 'inside' to the 'outside' gives you added skills many people don't have. It can make you an true 'goto guy.'

posted @ Monday, July 28, 2008 4:54 PM by Mike Amundsen


wow, I read your "using visual interdev 6" book a long time ago.

posted @ Monday, July 28, 2008 5:36 PM by Jason Massie


(Saw on Twitter.) I think a rare but important trait is for a DBA to have sufficient interpersonal skills to get along well with both the software developers and the network team. DBAs with ONLY great technical skills can tick everyone off, and the goal of technical excellence cannot be achieved.

posted @ Monday, July 28, 2008 8:18 PM by cio007


I second cio007's comments. I've found that my skills as a DBA are good, but that its my ability to work with people and break down technical topics when talking to non-techies that's really made me valuable where I am (or so they say :p)

posted @ Tuesday, July 29, 2008 7:11 AM by Jim


Really good DBAs are jacks of all trades. They get on a conference call or go into a meeting, and within a few minutes, they can identify where the real application problem is (network? storage? app? database?) and show some basic proof.

Those kinds of DBAs are like practical versions of architects. You call in an architect when you're planning, and you call in a DBA when the plans didn't work out the way you planned. (Or at least, that's the attitude companies seem to have!)

posted @ Tuesday, July 29, 2008 9:13 AM by Brent O.


Comments from the following blog entry: http://www.postsaver.org/tags/etl

posted @ Saturday, November 01, 2008 3:05 PM


Name (required)

Email (required)

Website


Simple BBCode can be used like [URL]...[/URL] and [B]

Copyright 2006 by Statistics IO, My SQL Server Blog