Webinar review of: ‘DBA vs the Developer‘ by Pinal Dave and sponsored by Solarwinds.
Pinal started by saying ‘DBA vs the Developer (relationship) is like Tom and Jerry (the cartoon)’.
He also stated ‘SQL Server DBAs are dinosaurs? People still code in Cobol!’
Pinal then led an interesting code walk-thru and discussion on these items that can lead DBAs and developers into wrong conclusions.
- Data type precedence with implicit conversions
- Auto_create_statistics on/off as well as Auto_update_statistics on/off
- Fix query without changing query or data by using a computed column
- Resource_Semaphore wait type
This is a worthwhile webinar to watch as it shows ways DBAs and developers can jump to wrong conclusions when code goes bad on SQL Server.
And the winner of the SQL Server DBA vs the Developer is? NOBODY!
Nobody wins when both DBAs and developers can’t find common ground to fix any issue. Right?
Advertisement
Amazon Prime Visa - Get a Amazon Gift Card instantly upon approval of Amazon Prime Visa
Chase Checking - Open your Chase checking account and get a bonus!
Chase Freedom Flex - Earn unlimited cash back with the Chase Freedom Flex credit card.
Chase Freedom Unlimited - Earn cash back with the Chase Freedom Unlimited credit card.
Chase Saphire - Open your Chase Saphire Preferred or Reserve and get bonus points and more!
Discover - Get a bonus when you open an eligible Discover account.
Marriott Bonvoy Credit card - Open your Marriott Bonvoy Credit card and get a new Cardmember bonus!
Rakuten - Sign up for Rakuten and earn cash back on your purchases at 3500+ stores. 20M+ members in the U.S. have earned over $3.2B in Cash Back at their favorite stores.
Schwab - Open a Schwab account and get up to $1,000 depending on your net deposit.
Xfinity - Open an Xfnity mobile or internet account and get a bonus