All Posts by Lori Brown

Follow

About the Author

Lori is an avid runner, cross fitter and SQL enthusiast. She has been working for SQLRX for 15 years and has been working with SQL in general for 25 years. Yup...she is an old hand at this stuff.

Oct 14

Find All Databases with Less Than 20 Percent Free Space and Grow Them

By Lori Brown | Function , Helpful Scripts , SQL Administration , SQL Maintenance , SQL Server

This is kind of a continuation of one of my previous posts.  (https://www.sqlrx.com/find-and-modify-file-growth-settings-for-all-databases/ ) Thousands of databases in a SQL instance can make a DBA’s life a bit challenging.  Automation suddenly becomes very important.  My new client had been shrinking their databases frequently, mistakenly thinking that doing so was a good thing.  I needed to […]

Continue reading
Sep 23

We’re Baaaaaack!!!

By Lori Brown | SQLRX

If you have visited us within the past year, you may have noticed that we have been pretty quiet on our blog and may have wondered what happened.  Well…..we had some technical difficulties (our syntax highlighter plugin stopped working), then we got super busy, then came the holidays, then came COVID.  I know, Excuses…Excuses….Excuses.  Well, […]

Continue reading
Aug 29

Backup and Restore Databases with CHECKSUM and VERIFYONLY

By Lori Brown | Backup and Restore , SQL Administration , SQL Maintenance , SQL Server

I found out that I have been missing something from our regular database backups that I had no idea that I should have been using all along.  I know about verifying your backup file and have incorporated into our standard maintenance routines one that will periodically test backups by restoring using VERIFYONLY.  However, I totally […]

Continue reading
1 2 3 9
>