LogOn tab of service greyed out

Cmd promt as Admin
sc.exe config “Service Name” obj= “DOMAIN\User” password= “password”

SQL server database owners

select SUSER_SNAME(owner_sid) As [Login], [name] from sys.databases

PowerShell: Turn Off the Windows Firewall in Windows Server

Set-NetFirewallProfile -Profile Domain,Public,Private -Enabled False

Disabling SQL Server Agent Jobs

USE MSDB;
GO
UPDATE MSDB.dbo.sysjobs
SET Enabled = 0
WHERE Enabled = 1;
GO

Powershell: switch from normal mode to administrator mode

Start-Process powershell -Verb runAs

SQL databases recovery model

SELECT name, recovery_model_desc
FROM sys.databases

GO

Send Email with PS

Send-MailMessage -From “email address” -To “email address” -Subject “Test email” -Body “Test” -SmtpServer “SMTP server address”