--- title: The Coeo Blog | Joe Pollock description: I am a Principal DBA in the Managed Services team at Coeo, and have been working with SQL Server since 1998 in a variety of roles including developer, DBA, and consultant. My main interest now is in teaching DBA and T-SQL skills, and writing training materials to assist this. At Coeo we see such a wide variety of systems and problems, so that every day there is the chance to learn and pass this knowledge on both internally and as part of training courses. --- [![](https://www.coeo.com/wp-content/themes/coeo/images/logo.svg)](https://www.coeo.com/) +44 (0)20 3051 3595 | [info@coeo.com](mailto:info@coeo.com) | [Client portal login](https://my.coeo.com) # The Coeo Blog ## Joe Pollock ![](https://blog.coeo.com/hubfs/Profile%20photos/JoeCircle.jpg) I am a Principal DBA in the Managed Services team at Coeo, and have been working with SQL Server since 1998 in a variety of roles including developer, DBA, and consultant. My main interest now is in teaching DBA and T-SQL skills, and writing training materials to assist this. At Coeo we see such a wide variety of systems and problems, so that every day there is the chance to learn and pass this knowledge on both internally and as part of training courses. Find me on: ### Recent Posts ## [Does SQL Server Lose an Hour of Sleep?](https://blog.coeo.com/does-sql-server-lose-an-hour-of-sleep) At the start of Daylight Saving Time (DST), which is this weekend in the UK, the clocks will move forward by one hour at 1am. Apart from the fact that we all lose an hour of our night’s sleep, what effect will this have on your scheduled jobs in SQL Server? [![Joe Pollock](https://blog.coeo.com/hubfs/Profile%20photos/JoeCircle.jpg)](https://blog.coeo.com/does-sql-server-lose-an-hour-of-sleep) [Joe Pollock](https://blog.coeo.com/author/joe-pollock) | March 24 , 2022 ## [SQLBits 2022 session - Field Testing Ola Hallengren’s Maintenance Solution](https://blog.coeo.com/sqlbits-2022-session-field-testing-ola-hallengrens-maintenance-solution) As far as maintenance solutions for SQL Server instances are concerned, those based on Ola Hallengren's scripts work beautifully out of the box. They have also transformed many a SQL Server and boast an impressive track record. Nevertheless, a critical question arises: How do you get the best out.. [![Joe Pollock](https://blog.coeo.com/hubfs/Profile%20photos/JoeCircle.jpg)](https://blog.coeo.com/sqlbits-2022-session-field-testing-ola-hallengrens-maintenance-solution) [Joe Pollock](https://blog.coeo.com/author/joe-pollock) | March 02 , 2022 ## [Does SQL Server Get An Extra Hour In Bed?](https://blog.coeo.com/does-sql-server-get-an-extra-hour-in-bed) Many countries follow the standard of Daylight Saving Time (DST), where twice each year, the clocks will move either forward or backwards by one hour to maximise the evening daylight in the spring, summer, and autumn months. For countries that follow this, there is a specific side-effect of this.. [![Joe Pollock](https://blog.coeo.com/hubfs/Profile%20photos/JoeCircle.jpg)](https://blog.coeo.com/does-sql-server-get-an-extra-hour-in-bed) [Joe Pollock](https://blog.coeo.com/author/joe-pollock) | October 12 , 2021 ## [Killing Your SQL Server with Kindness](https://blog.coeo.com/killing-your-sql-server-with-kindness) When you discover a poor, uncared for SQL Server instance that has been neglected for years, your immediate response is to get maintenance going and give it some love. Get it back to its former glory and running optimally. But you need to approach this with caution. [![Joe Pollock](https://blog.coeo.com/hubfs/Profile%20photos/JoeCircle.jpg)](https://blog.coeo.com/killing-your-sql-server-with-kindness) [Joe Pollock](https://blog.coeo.com/author/joe-pollock) | May 28 , 2020 ## [SQL Agent history - A most confusing dialog box](https://blog.coeo.com/sql-agent-history-a-most-confusing-dialog-box) On a new installation of a SQL Server instance, by default, SQL Agent will automatically manage the job history retention, however this may not work the way you expect it to. This post explains why, and how you should set this up for best results. [![Joe Pollock](https://blog.coeo.com/hubfs/Profile%20photos/JoeCircle.jpg)](https://blog.coeo.com/sql-agent-history-a-most-confusing-dialog-box) [Joe Pollock](https://blog.coeo.com/author/joe-pollock) | February 27 , 2018 ## [First Fix and Second Fix](https://blog.coeo.com/second-fix) When DBAs are troubleshooting issues, solutions are sometimes applied in the heat of a critical incident which solve the problem, which are then walked away from because the issue has been “fixed”. With experience and a better understanding of the broader issue of long-term solutions, you realise.. [![Joe Pollock](https://blog.coeo.com/hubfs/Profile%20photos/JoeCircle.jpg)](https://blog.coeo.com/second-fix) [Joe Pollock](https://blog.coeo.com/author/joe-pollock) | February 13 , 2018 ## [Understanding COPY\_ONLY backups](https://blog.coeo.com/understanding-copy_only-backups) When you have a database which has just been created and is in the FULL recovery model, or you have an existing database you are changing from SIMPLE to FULL, you need to take a full backup before you are able to take log backups, as there needs to be a starting point for the log chain. There is a.. [![Joe Pollock](https://blog.coeo.com/hubfs/Profile%20photos/JoeCircle.jpg)](https://blog.coeo.com/understanding-copy_only-backups) [Joe Pollock](https://blog.coeo.com/author/joe-pollock) | January 30 , 2018 ## [What happens when TempDB grows?](https://blog.coeo.com/what-happens-when-tempdb-grows) The TempDB database is special in many ways, but an interesting aspect is that when its files automatically grow when they become full, this growth is not persisted and will be undone on the next restart of the SQL Server service. We can see how this works by looking at two system tables:.. [![Joe Pollock](https://blog.coeo.com/hubfs/Profile%20photos/JoeCircle.jpg)](https://blog.coeo.com/what-happens-when-tempdb-grows) [Joe Pollock](https://blog.coeo.com/author/joe-pollock) | January 23 , 2018 ### Recent posts ### Categories - [SQL Server (118)](https://blog.coeo.com/topic/sql-server) - [Azure (58)](https://blog.coeo.com/topic/azure) - [Microsoft (49)](https://blog.coeo.com/topic/microsoft) - [Dedicated Support (47)](https://blog.coeo.com/topic/dedicated-support) - [Coeo News (43)](https://blog.coeo.com/topic/coeo-news) - [Professional Development (34)](https://blog.coeo.com/topic/professional-development) - [Industry News (27)](https://blog.coeo.com/topic/industry-news) - [cyber security (27)](https://blog.coeo.com/topic/cyber-security) - [power bi (25)](https://blog.coeo.com/topic/power-bi) - [Opinion (21)](https://blog.coeo.com/topic/opinion) - [Cloud (17)](https://blog.coeo.com/topic/cloud) - [Business Intelligence (16)](https://blog.coeo.com/topic/business-intelligence) - [analytics (15)](https://blog.coeo.com/topic/analytics) - [Security (14)](https://blog.coeo.com/topic/security) - [career (14)](https://blog.coeo.com/topic/career) - [SQL Server updates (13)](https://blog.coeo.com/topic/sql-server-updates) - [windows Updates (11)](https://blog.coeo.com/topic/windows-updates) - [Azure Databricks (10)](https://blog.coeo.com/topic/azure-databricks) - [data platform (10)](https://blog.coeo.com/topic/data-platform) - [Clustering (9)](https://blog.coeo.com/topic/clustering) - [Finance (9)](https://blog.coeo.com/topic/finance-news) - [podcast (9)](https://blog.coeo.com/topic/podcast) - [azure sql database (8)](https://blog.coeo.com/topic/azure-sql-database) - [data (8)](https://blog.coeo.com/topic/data) - [Data Science (7)](https://blog.coeo.com/topic/data-science) ### Popular posts ![](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