Is your SQL Always On experiencing a delay? Use the T-SQL code below to find out the performance of SQL Always On. --Check metrics first IF OBJECT_ID('tempdb..#perf') IS NOT NULL DROP TABLE #perf…

;WITH UpTime AS ( SELECT DATEDIFF(SECOND,create_date,GETDATE()) [upTime_secs] FROM sys.databases WHERE name = 'tempdb' ), AG_Stats AS ( SELECT AR.replica_server_name, HARS.role_desc,…

In SLES you can search & install specific CVE patches using the commands below. List the patch for a specific CVE#: # zypper lp --cve=CVE# Get information about the patch: # zypper info -t patch…

In SSMS you have the "schema changes history" report. You can get the same (or even more) details from T-SQL. You can use the T-SQL statement below to find schema changes from the last day in a…

The T-SQL code below will give you an idea of the memory used by your reporting service. This query should be executed on the "reportserver" database. Please be aware that executing this statement…

It's possible that you want to change routes on a system which point to a certain gateway, and replace them with a new gateway. The only thing this silly PowerShell script does is get the list of…