All Posts by Jeff Horner

About the Author

Jeff Horner has been working in IT for 30+ years and has 26 years of SQL Server DBA experience. Jeff has worked in the transportation and distribution industry and is a super experienced DBA despite being the new guy. Jeff is located in Indiana and enjoys cooking and playing keyboard at his church.

Apr 02

Finding Databases That Have Not Been Accessed (And An Adventure with ChatGPT)

By Jeff Horner | Expert , SQL Administration , SQL Server , SQLRX

I have a client that has thousands of databases. They asked for a script that would tell them which databases had not been accessed in the last 90 days. I thought this would be an easy ask because we could just look at the index usage stats DMV and see which databases had no seeks, […]