Latest Posts
📅 2019-07-21
✍️ Bart Schelstraete
If you have upgraded your old Commvault agent, or you still use an old Commvault agent on your Linux 'systemd' system, there won't be any start/stop script for the agent. You can use the workaround…
Read more →
📅 2019-07-14
✍️ Bart Schelstraete
In order to optimize all databases & tables within your MySQL instance, you can use the code below. mysqlcheck --all-databases --optimize --skip-write-binlog You can also use a more specific…
Read more →
📅 2019-06-28
✍️ Bart Schelstraete
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…
Read more →
📅 2019-06-28
✍️ Bart Schelstraete
;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,…
Read more →
📅 2019-06-21
✍️ Bart Schelstraete
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…
Read more →
📅 2019-06-18
✍️ Bart Schelstraete
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…
Read more →
📅 2019-06-10
✍️ Bart Schelstraete
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…
Read more →
📅 2019-06-08
✍️ Bart Schelstraete
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…
Read more →
📅 2019-05-19
✍️ Bart Schelstraete
You can check the status of SAP Hana using the following command line: <hostname>:/usr/sap/<SID>/HDB00> /usr/sap/hostctrl/exe/sapcontrol -nr 00 -function GetProcessList 28.10.2017 18:45:27…
Read more →
📅 2019-05-15
✍️ Bart Schelstraete
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…
Read more →
