Helpful Scripts Archives

Oct 12

Using Extended Events to Find Statement Causing a Job to Run Long or Hang

By Lori Brown | Extended Events , Helpful Scripts , Jobs , Performance Tuning , SQL Administration , SQL Server

On one of the servers that we monitor, it was reported that periodically a specific job would seem to hang and take forever to complete. I was asked to set up something to help find exactly what statement in the job that was the root cause of the hang. Since the issue only occurred intermittently, […]

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 […]

Sep 30

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 […]

May 31

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 […]

Apr 18

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 […]

Oct 18

Find Out Which Databases Have Multiple Files

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

This might be kind of basic but since I am working on a comprehensive script to discover things that a DBA really needs to know about, I made a couple of queries that will produce a list of the databases that have multiple files along with the locations of the physical files. One query finds […]

Aug 16

Find the Last Time Databases or Logs were Restored

By Lori Brown | Backup and Restore , Helpful Scripts , Log Shipping , SQL Administration , SQL Maintenance , SQL Server

I have a client that uses a lot of disconnected log shipping on a few servers. They do this because they want to have a copy of their database that is actually hosted by software vendors for reporting purposes. So, disconnected log shipping it is! We pull down files that have been FTP’d to the […]

Jun 08

Get a List of all SQL Instances on a Server

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

It is pretty common that I frequently am asked to take over a server with SQL on it sight unseen. Many times shops many not be fully aware if additional instances are or have been installed on their server. Since I am working on a set of scripts that we can use for discovery on […]

Mar 08

How Enabling Change Tracking Can Cause Backup Failure

By Lori Brown | Backup and Restore , Helpful Scripts , SQL Administration , SQL Server

Recently I had a client who contacted me because all of the sudden the backup for a couple of databases started to fail. While those backups had been running successfully in the past they suddenly started failing with this message: With a little more digging he found more info. Here is more verbiage from the […]

1 2 3 … 5 Next »

Category Archives for "Helpful Scripts"