2806, 2019
2106, 2019
SLES: Search & install specific CVE
In SLES you can search & install specific CVE patches using the commands below.
1806, 2019
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.
1006, 2019
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.
0806, 2019
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 the ‘old gateway’, replace that gateway, and put the deletes/add in a batch script which then can be executed when
1905, 2019
SAP Hana: How to Check SAP Hana Services from Command Line
You can check the status of SAP Hana using the following command line:
1505, 2019
T-SQL: Give views permissions to all stored procedures
You can use the T-SQL code below within your database to give permissions to ‘MYUSER’ for viewing all stored procedures. (of course, replace “MYUSER” with your own user) Once executed, you can copy and paste the output to a new query window an execute it.
1005, 2019
T-SQL: Check progress of DBCC checkdb
Doing a dbcc checkdb can take a lot of time, and in case of corruption you really want to see the progress. You can use the t-sql statement below to find the progress. Keep in mind to replace the YOUR_DB_ID to the id of your database. (find out in sys.databases)
2904, 2019
Oracle: solving block corruption
Step 1: If block corruption was found, first find the corrupted blocks: Stzp 2: Check to which table/index/etc that block belongs to. Step 3: Resolve the block corruption using RMAN (which is one of the possibilities):