WHITE PAPERS SPONSORED PROFILES JOB BOARD WEBINAR CENTER FREE SOFTWARE BZ RESEARCH ALMSHAREPOINT EVENTS CALENDAR PRINT/PDF EDITION PRINT/PDF BACK ISSUES

SUBSCRIBE TODAY CUSTOMER SERVICE EDITORIAL CALENDAR EDITORIAL BEATS GUEST VIEW GUIDE SD TIMES 100 GUIDE EVENTS CALENDAR ADVERTISING ARTICLE REPRINTS REPORT A BUG SITE MAP

ABOUT US BZ MEDIA NEWS BZ RESEARCH NEWS ON MONDAY SPTECHREPORT SPTECHWEB SPTECHCON IPHONE/IPAD DEVCON ANDROID DEVCON PRIVACY POLICY CONTACT US

HOME >> OPINIONS

Guest View: Developer DNA, DBA DNA

By David Intersimone and Greg Nerpouni

December 1, 2009 — (Page 1 of 3)
A fictional conversation between Greg Nerpouni and David Intersimone, play-acting the roles of database administrators and developers, respectively. Do they speak the same language?

[11:08:41 AM] DBA says: I am on vacation in Hawaii this week and got an SMS last night at 2 a.m. that our production database in San Francisco was grinding to a halt. Can you tell me if any application patches were applied that I was unaware of?

[11:12:47 AM] Developer says: No problem. The recent update of my code (build 2.1.24) is perfect. I’ve unit, system and performance tested it on the development database server and the pre-production test database server, and all is well. I got a notice that operations performed the change update successfully last week. And so far, everything seems okay!

[11:14:59 AM] DBA says: But that doesn’t explain the sudden drop in performance last night. Can you investigate?

---------------------------

[12:15:17 PM] Developer says: Okay. I grabbed a copy of the production database, ran some performance tests on my code, watched the execution profile, and I did find a performance hit in one of my reusable objects. I made the change, but there still seems to be some issues in the stored procedures that I use but didn’t write.

[12:17:31 PM] DBA says: My wife and kids are out snorkeling and looking for sea turtles, and I’m stuck under the umbrella with my laptop and Wi-Fi working on production issues—some vacation! Anyway, rerun your tests and take a profile of the database as well. We can get a sense of any SQL that might be causing bottlenecks on the DB. Once you have that, you can save it and send the snapshot to me and I’ll take a look.

---------------------------

[1:20:22 PM] Developer says: Thanks and sorry to interrupt your vacation (wish I was snorkeling too). I started the database profiler, ran my tests and captured a snapshot of what took place during the one hour of unit and stress testing. I’ve e-mailed the snapshot for you to look over. I did see some suspicious time periods, especially in my use of recursion in the SQL statement that counts the number of orders by a customer for each employee in a store. There are also two stored procedures (“CalculateTaxTotal” and “GetManagers”) that seem to take a long time to return results.

Related Search Term(s): professional development, testing

Pages 1 2 3

Share this link: http://sdt.bz/33954

Most Read Latest News Blog Resources

Zeichick’s Take: Radio moves from analog waveforms to digital packets
Streaming radio highlights the need for streaming applications to be designed to take up as little bandwidth as possible

Taking enterprise architecture to the business side
Startup Corso is bringing out a cloud-based planning platform that ties into business plans

Appcelerator Acquires Cocoafish to Add Instant Mobile Cloud Capabilities to its Industry Leading Titanium Platform
Appcelerator Offers Messaging, Social, Location and Storage Mobile Cloud Services to All Mobile App Publishers

ComponentOne Releases a Collection of 40+ UI Widgets Powered by HTML5 and jQuery
ComponentOne has announced the 2012 release of Wijmo: a kit of UI widgets for HTML5 and jQuery development

Taking enterprise architecture to the business side
Startup Corso is bringing out a cloud-based planning platform that ties into business plans

Top five apps to manage your workload
Web applications offer new ways to track your “to-do” lists

Not so fast when it comes to testing in the cloud
Developers face outsourcing, virtual lab management and mobile devices as obstacles

Xceed releases UX-focused suite for Microsoft’s WPF
"Blendables" helps match user experiences to developer visions

Are you at risk for burnout?
Burnout is a severe problem and it can strike at any time. Here's how to tell if you are nearing the edge.

Agility, mom, and apple pie
If we're to evaluate the state-of-the-art in software development, we should start with the values espoused in the Agile Manifesto.

RIM woos developers with free tablet
How do you get more apps ported to the BlackBerry PlayBook? By giving every developer a free tablet, of course!

GitHire: Use Headhunters to Find Your Perfect Programmer
Are you a hiring manager tired of scouring the job boards? Check out this new service that will find 5 people interested in your jobs.

The Hidden Costs of Software Licensing Moving beyond paper-based software licensing to more flexible, software-based licensing is a business decision. There is a growing trend tow...

Case Study: You May Need a Development Mechanic As a contractor for a major financial player in Germany, SOBEGE, a German-based consultancy specializing in embedded IT and web services, wa...

Ensuring Software Quality at a Major International Bank One of the world’s leading international banks has adopted AgitarOne technology for delivering generated unit tests for their Java software...

Load Testing Adobe Flex Applications Adobe Flex applications may be different from applications you’ve worked with before. For classic HTML web applications, the server does all...

Technorati

Digg

Slashdot

Facebook

Friendfeed

Twitter

del.icio.us

Third-party tools showcased at Professional Developers Conference ComponentOne has a new development kit for the iPhone and the iPod Touch, while Infragistics created a version of NetAdvantage for Silverlight. Also, Developer Express and Microsoft announced a joint code-quality effort for C#.

Lost in translation Product testing often brings together the disparate worlds of requirements and specifications, which can lead to development problems. Testing experts weigh in on ways to overcome such hurdles and provide users with the code quality they demand.

News Briefs: July 15, 2008 Enea is named to the board of CP-TA, Teradata introduces a new version of its data warehousing tool and SOA Software upgraded its Repository Manager to accommodate its Policy Manager software.

Add comment

Name*
Email*
Country

Comment

Third-party tools showcased at Professional Developers Conference
ComponentOne has a new development kit for the iPhone and the iPod Touch, while Infragistics created a version of NetAdvantage for Silverlight. Also, Developer Express and Microsoft announced a joint code-quality effort for C# Read More...

News on Monday
more>>
SharePoint Tech Report
more>>

Download Current Issue
FEBRUARY 2012 PDF ISSUE

Need Back Issues?
DOWNLOAD HERE

Want to subscribe?

Are you at risk for burnout?
Burnout is a severe problem and it can strike at any time. Here's how to tell if you are nearing the edge.
02/09/2012 02:16 PM EST

Agility, mom, and apple pie
If we're to evaluate the state-of-the-art in software development, we should start with the values espoused in the Agile Manifesto.
02/07/2012 11:57 AM EST

RIM woos developers with free tablet
How do you get more apps ported to the BlackBerry PlayBook? By giving every developer a free tablet, of course!
02/04/2012 01:57 PM EST

GitHire: Use Headhunters to Find Your Perfect Programmer
Are you a hiring manager tired of scouring the job boards? Check out this new service that will find 5 people interested in your jobs.
02/03/2012 12:17 PM EST

Facebook claims hacker cred
Facebook's SEC S-1 filing form includes a short essay on the Hacker Way by Mark Zuckerberg himself.
02/02/2012 08:26 AM EST

Ryan Dahl steps down
Ryan Dahl, creator of Node.js, steps back from his position as gatekeeper for the project.
02/01/2012 04:58 PM EST