The Daily Dose

The Prescription for SQL Server

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
Oct 24

Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 1

By Ginger Daniel | Azure , Cloud , SQL Administration , SQL Development , SQL Server

One of many options for Reporting and Power BI is to use Azure Blob Storage to access source data.  Most of the documentation available online demonstrates moving data from SQL Server to an Azure Database, however my client needed data to land in Azure Blob Storage as a csv file, and needed incremental changes to […]

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 21
>