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  

RE: Dead DBA's

Posted by Jason on Friday, August 01, 2008 to Professional Development, consolidation
416 Views | 5 Comments | Article Rating

I have half written post called "The Rebirth of the DBA". I am not sure if it is going to make the cut. There is not enough time before I go on vacation and there is some good community discussion both in the comments and in the blogosphere(Brent O, Grant Fritchy, Pythian).

I will summarize really quick. I was halfway playing devil's advocate. While it is possible that they could write some really amazing software that could script the DBA, it is unlikely that they can totally do it. The DBA will still be around. The numbers may be less. Maybe substantially. The roles may change. Maybe drastically. Hell, your SQL Server 2015 VM may have a "cloud partition" in a physical table. There are other factors in the mix like consolidation, virtualization and LINQ\ORM that are also going to have to have an effect. It is all speculation but the only constant is change.

email it! |   |   |   |  | 
Permalink     5 Comments  

Rate this Post:
COMMENTS:

As a guy who wrote a blog post titled "SQL Server 2008 Sucks", I officially give you permission to play devil's advocate as often as possible. :-D

posted @ Friday, August 01, 2008 2:17 PM by Brent O.


Hi!
I agree that DBA's role is not going to disappear anytime soon.

While some ORM-tools, LINQ etc can generate quite decent SQL, I wouldn't trust on them in more demanding queries like searches, complicated reports etc. They require so much fine tuning of queries, indexes and partitions when there is lot's of data.

Then there is the IT-pro -side of installing, maintaining, backing up. These won't happen by itself.

I may be more of developer/architect kind of guy, but I always try keep my db-skills up to date to make sure that the database is not the bottleneck.

posted @ Friday, August 01, 2008 2:23 PM by Jemm


I think you're right to bring visibility even if you feel DBAs aren't going the way of the punch card operator. Let's face it, cloud computing has been at the fringes for a while, but companies who have been more traditional in IT approach like Sun (even if they had a "grid" in 2000) are making a hard play at it.

It will be interesting to see where this ride takes us. It wasn't too long ago that DBAs weren't concerned about VB or C++ code much. Now, with CLR, more DBAs are having to pay attention and that means learning VB.NET and C#. LINQ has brought its own visibility. So the role of the DBA, at least the SQL Server DBA, is in flux and has been for a few years now.

posted @ Friday, August 01, 2008 4:12 PM by K. Brian Kelley


"DBA's"?

Please read:

http://www.apostrophe.fsnet.co.uk/

posted @ Saturday, August 02, 2008 11:40 AM by Apostrophe Protection Society


A real gramm'r nazi would know DBA's is an has contraction. I sez it so.

posted @ Sunday, August 03, 2008 11:29 PM by J'a's'o'n'


Name (required)

Email (required)

Website


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

Copyright 2006 by Statistics IO, My SQL Server Blog