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.…
Category: sql server administration
Yes, a database on SQL Server can be owned by no one! This is a NULL value as the owner. Apparently, this can happen because the login that owned it no longer exists. I discovered this when I was going through databases owned by users…
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…
When migrating to managed instance from SQL Server, most features are supported, but you need to assess your SQL Server and the databases you want to migrate to ensure there aren’t any features enabled that aren’t supported. You can do this with the Data Migration…
We have a monitoring tool that tells us when a backup fails. This only works if the agent is running. If the agent isn’t running, then you don’t get an email that a job failed since the job didn’t run, and the monitoring tool doesn’t…
I was approached by some developers that wanted to benchmark performance on a development server. Good for them thinking ahead before it’s in production potentially ruining performance. Instead of using an Idera Diagnostic Manager licence, which means taking one away from a production server to…
https://www.brentozar.com/archive/2016/01/cheat-sheet-how-to-configure-tempdb-for-microsoft-sql-server/ 1 volume for all tempdb files Use SSDs 8 equally sized files Size them and log file to fill up the tempdb drive
There’s a really good guide on installing and setting up AG by Brent Ozar, but if you want to setup a multi subnet failover cluster, you will need a lot of ports opened up so that your AG will actually work. Port number Between Reason…
good to do b/c the bigger it is, the longer it will take to load into memory — USE msdb; GO EXEC sp_cycle_agent_errorlog;
Very detailed https://www.brentozar.com/?s=What+to+Do+When+DBCC+CHECKDB+Reports+Corruption