--- title: An Ode to the DBA description: What does learning Shakespeare have in common with becoming a SQL Server DBA? image: https://blog.coeo.com/hubfs/clark-young-QdRnZlzYJPA-unsplash.png --- [![](https://www.coeo.com/wp-content/themes/coeo/images/logo.svg)](https://blog.coeo.com/) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) | [Client portal login](https://my.coeo.com) # An Ode to the DBA # The Coeo Blog ![Edward Harrison](https://blog.coeo.com/hubfs/Profile%20photos/EdHarrison2Circle.jpg) ![quill and ink - Clark Young](https://blog.coeo.com/hs-fs/hubfs/clark-young-QdRnZlzYJPA-unsplash.png?width=700&name=clark-young-QdRnZlzYJPA-unsplash.png) It has been now quite a few years since I was sitting in school, being pleasantly bored by the works and sonnets of Shakespeare, and failing to grasp the meanings and intricate language he used. Now in hindsight, I realise that I just never understood (or tried to understand) some of the meanings and subtleties in his work. If I had just spent a bit more time trying to grasp it, I would have appreciated and enjoyed Shakespeare far more. When I first started work as SQL Server DBA, I also had very little understanding of how it all worked. I hadn’t come from an IT background, I had no idea how different high availability set ups worked, how backups were taken, how you would troubleshoot job failures or even going about resolving performance issues. One of the main early lessons I remember was one on how indexes worked and how the right index on a table could make all the difference to the performance of a query. It took time; lots of researching and a lot of testing. But over time, learning about all these separate aspects of SQL Server, understanding it and how they all fit and interact has made working with it much, much more enjoyable. There is still plenty more to learn and something tells me there will always be something new. So for those newer DBAs, or to those who are considering following the DBA route who may feel daunted by a technology that they may not have ever touched before, do not let inexperience, lack of knowledge or not the right degree or background put you off. Like many things, it's all about your ability and desire to learn something. So for all of you newbies (and those who remember it) below is my own version of Shakespeare’s Sonnet 18 (Shall I compare thee to a Summer’s day) in ode to one of the first lessons I learnt, when and why heap tables should raise warning flags for the DBA.   Shall I compare thee to a heap table? For it's less shrewd and far less delicate; With data mass and no index to speak Performance wanders like an Autumn Sun; Sometime too slow thy precious query trots, Hindered often by scans and rows galore, And its sedate pace fires the users vex; But by the admins smarts and tuning skills, The Winter of this hurt will cease to be; For as the Index planted deep in time, Will Spring new shoots and sprout fresh leaves of gold, That scan of heaps buds into index seeks; Ensure it is maintained and stats refreshed, And thy now present Summer shall not fade; ### Subscribe to Email Updates ## Related posts --- ### [Troubleshooting Ola Hallengren’s Maintenance Solution](https://blog.coeo.com/troubleshooting-ola-hallengrens-maintenance-solution) ### [Domain-Independent Windows Failover Cluster for SQL Server AlwaysOn Availability Group](https://blog.coeo.com/domain-independent-windows-failover-cluster-for-sql-server-alwayson-availability-group) ### [What's life like working at Coeo?](https://blog.coeo.com/whats-it-like-working-at-coeo) ### [Coeo has been awarded UK’s Best Workplace™ 2022](https://blog.coeo.com/coeo-has-been-awarded-uks-best-workplace-2022) ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | info@coeo.com ## Contact Us By clicking submit below, you consent to allow Coeo to store and process the personal information submitted above to provide you the content requested. You may unsubscribe from these communications at any time. For more information on how to unsubscribe and our commitment to your privacy, please review our **[Privacy Policy](https://www.coeo.com/privacy/)**. ## Upcoming Events [See all events](https://www.coeo.com/events/) #### NOW Building, Thames Valley Park Drive, Reading, RG6 1RB [![](https://www.coeo.com/wp-content/themes/coeo/images/social-glass.png)](https://www.glassdoor.co.uk/Overview/Working-at-Coeo-EI_IE959052.11,15.htm)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-in.png)](https://www.linkedin.com/company/coeo-ltd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-twitter.png)](https://twitter.com/CoeoLtd)[![](https://www.coeo.com/wp-content/themes/coeo/images/social-fb.png)](https://www.facebook.com/coeoltd/) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-icon.png) ![](https://www.coeo.com/wp-content/themes/coeo/images//menu-close.png) ![](https://www.coeo.com/wp-content/uploads/2016/12/logo-invert.png) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) - [Solutions](https://www.coeo.com/solutions/) - [Next Steps](https://www.coeo.com/next-steps/) - [Dedicated Support](https://www.coeo.com/dedicated-support/) - [Case studies](https://www.coeo.com/case-studies/) - [Technologies](https://www.coeo.com/solutions/technologies/) - [Industries](https://www.coeo.com/industries/) - [Finance](https://www.coeo.com/industries/finance/) - [Retail](https://www.coeo.com/industries/retail/) - [Technology](https://www.coeo.com/industries/technology/) - [The Team](https://www.coeo.com/people/) - [Join Us](https://www.coeo.com/careers/) - [Graduate Programme](https://www.coeo.com/graduate-programme/) - [About Coeo](https://www.coeo.com/about-coeo/) - [The Coeo Blog](https://www.coeo.com/blog/) - [Contact us](https://www.coeo.com/contact-us/) - [Privacy Notice](https://www.coeo.com/privacy/) - [Cookie Policy](https://www.coeo.com/privacy#Cookie_Policy) - [Events](https://www.coeo.com/events) Sign up to our newsletter ![go arrow](https://www.coeo.com/wp-content/themes/coeo/images/newsletter-go.png) Back to top