1 / 10

Challenge for all the Seniors (DBAs)

Challenge for all the Seniors (DBAs). Using the the questions that follow in the next 8 slides, evaluate your areas of expertise in the today column. Design New Tables. Never , I deal with tables other people made. A couple of times a quarter. Once a month.

afram
Download Presentation

Challenge for all the Seniors (DBAs)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Challenge for all the Seniors (DBAs) Using the the questions that follow in the next 8 slides, evaluate your areas of expertise in the today column

  2. Design New Tables • Never, I deal with tables other people made. • A couple of times a quarter. • Once a month. • Every week – I’m very familiar with data modelling tools and I own data modelling books.

  3. Write Queries • When you write a query, you use the same syntax you havebeen using for years • Use books and blogs on line – sometimes. • Regularly watch web casts or subscribe to blogs to improve T-SQL • Present to local user groups.

  4. Deploy Changes • Make them live in production. What, is there something else? • Script them out first and test them in development. • Script them out, test them, document the change that I’m expecting, and monitor afterwards to make sure I got the change I was expecting. • Check the changes into source control, have someone else test them, and then deploy them in an automated fashion.

  5. Tune Queries When I tune queries, I • I feel like I’m back in high school, in the back seat of a car, fumbling around in the dark, groping indexes and execution plans blindly. • I know when I should apply a missing index recommendation, and when I shouldn’t • I know how to hand craft an index to improve a query even when there is no missing index recommendation. • I can recognise when I’m getting the wrong join for a query, and I know when I should influence the Server to pick the right one.

  6. Monitor Performance When they say SQL is slow, I • Am completely surprised. • Know which SQL server metrics to look at. • what my server’s normal baselines are for any given metric. • Tell them I already knew about it because I have alerting set up correctly, with thresholds configured properly for my baselines, and I don’t have email rules set up to push all alerts into a different folder.

  7. Troubleshoot Outages When SQL goes down, I • Am completely surprise. • Remote desktop in and start poking around. • Have a rough idea of what logs I need to hit, in what order, and I am confident in how much time it will take to fail over to my secondary servers. • Grabs my customized First Responder Kit and step through mywell-rehearsed troubleshooting steps.

  8. Install & Configure SQL When I install SQL Server, I • Run setup.exe • Google for a setup best practise checklist • Grab my customized checklist that has my company-specific settings • Get my prepped installation files off the file share and run an automated installation

  9. Design & Test DR When I design SQL HA / DR, I: • Wait, what do you mean design? My instances are standalone • Use the same techniques I’ve been using for years • Have a good idea of what my options are, and work with the business to pick the right solution • Get the business’s RPO and RTP requirements in writing, then write down a few options for them with budget estimates

  10. How many Companies have these DBA Types? A score of 4 indicates a position of senior

More Related