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:
Category: SQL Server
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…