The Daily Dose

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

Find and Modify File Growth Settings for All Databases

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

I have a client who is challenging me in a lot of ways.  They have over a thousand databases in one of their 2 SQL instances.  Over. A. Thousand.  Admittedly, the databases are not big but the sheer quantity of them is daunting to say the least.  To make it more fun, some of the […]

Continue reading

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

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

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

In Part 1 of this series, we demonstrated how to copy a full SQL database table from a SQL Server database into an Azure Blob Storage account as a csv file.  My client needed data moved from their on premise SQL Server database to Azure, and then needed the daily incremental data changes uploaded as […]

Continue reading

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

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

Adding a Missing Index Killed Performance

By Jeffry Schwartz | Indexes , Missing Indexes , Performance Tuning , Query Tuning , SQL Server

SQL Server 2017 suggested an index to improve performance, so we added it in a development environment. The “improvement” made the query run almost 50 TIMES longer than the original! See how we fixed this issue.

Continue reading

Use DDL Triggers to get Instance and Database Change Notifications

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

I have been working on some improvements to some of the regular ways we monitor for important changes.  We always have to be on the lookout for unexpected changes being made in the SQL instances that we monitor since often times we are not the only team who has sysadmin access to the instance.  We […]

Continue reading

And Now a Couple of Job Queries

By Lori Brown | Helpful Scripts , Jobs , SQL Administration , SQL Server

Hooray!!  We finally have our 70-764 and 70-765 certification exams done and can turn our attention back to blogging more regularly.  Those exams were pretty tough mostly because there was a lot of information that had to be memorized since there are always aspects of SQL that we don’t regularly use and there is no […]

Continue reading