All about Information Technology!

check

Check for null passwords in Sql Server

One of the many ways to secure SQL Server is to review all passwords. You must also check for null passwords and if you locate any, change them. To list all users with null passwords, execute the following sql command: USE master GO   SELECT name, password FROM syslogins WHERE password IS NULL;

>>

, , , , , ,

Check Ram speed and type in Linux

sudo dmidecode –type 17 | more sample output:

>>

, , ,

Check Status of Linux Service

To check if a local Linux service is running or not, open terminal window and paste the following command: /etc/init.d/service_name status for example /etc/init.d/apache2 status

>>

, , ,

Check Status of Windows Service

To check if a local or a remote Windows service is running or not, create a batch file, name it for ex. check_service.bat and paste the following code: @echo off sc \\localhost query Apache2.2 > service_status.txt Find /i "RUNNING" service_status.txt >> service_status.txt IF %errorlevel% == 0 ( echo service is running ) ELSE ( echo [...]

>>

, , , ,