published on SQL Server Central https://www.sqlservercentral.com/articles/standards-matter At first, this was going to be a technical article about an index maintenance horror story. I received an off-hours page. The index maintenance job was running for a long time on a big table. I have an agent…
Category: SQL Server
We have a fair number of pretty large databases, and I was having a hard time scheduling full integrity checks to run at least once a week. For a long time, I only ran physical_only with my fingers crossed, but finally, I got a new…
This is a super simple way to retain the data and settings that you create and change on your SQL Server Docker instance. There’s a lot of talk about attaching databases after you recreate your Docker container, but I found that you just have to…
I want the ability to search through all the SQL Server logs without having to know how many log files there are, so I created this script to do that:
The main reason for creating this script was to compare user permissions when someone came to me saying “I need the same permissions as so and so,” and then I would scratch my head trying to figure out how to get this quickly and easily.…
Install Docker Community Edition for Mac (free) https://hub.docker.com/editions/community/docker-ce-desktop-mac?tab=description Launch Docker Docker will need privileged access so grant it when prompted SQL Server may need more RAM and you can set that in Docker preferences. I found it runs fine on a mac with 4GB of…
This came up because we had many sql agent jobs that DBA’s don’t want to be alerted to like sql agent jobs that run SSIS packages. Those alerts need to be sent to the database developers instead. We use Idera Diagnostic Manager to send failed…