T-SQL: Getting lag figures for SQL Always On replication
If your SQL Always On having a delay? Use the T-SQL code below to find out the performance of the SQL Always on.
SCHELSTRAETE.ORG
I.T. minded
June 2019
Read MoreT-SQL: Getting lag figures for SQL Always On replication
SLES: Search & install specific CVE
In SLES you can search & install specific CVE patches using the commands below.
T-SQL : find schema modifications which occurred the last day
In SSMS you have the “schema changes history” report. You can have the same (or even more) details from T-SQL. You can use the t-sql statement below in order find schema changes the last day, in a particular database.
SSRS: Find out memory used by reporting service.
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 executing this statement can take some time.
Powershell: Create new routes based on existing routes
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 is doing, is getting the list of routes, filter out…