All about Information Technology!

Find

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;

>>

, , , , , ,

Find out which process is listening on a port

Open windows command line Type netstat -bn -b Displays the executable involved in creating each connection or listening port. -n do not resolve hostnames Check for any suspicious connection.

>>

, , , ,

How to find computer name using command prompt

Open your cmd and enter: hostname or tracert [ip_address] for ex. tracert 192.168.1.2

>>

, , , , , ,

How to find files in Linux

find / -name ‘myfile’ search from the root directory for the file named myfile   find /home -iname ‘tes*’ search from the home directory for files that their name starts with tes   find /home -name ‘*.bak’ -size -10000k search from the home directory for bak files that their size is less than 10MB   [...]

>>

, ,

Find the biggest files and directories

To find biggest files in current directory: ls -lSrh To find biggest .bak files in current directory: ls -lSrh *.bak To find largest directories (this command takes a while – wait to finish): du -kx | egrep -v "\./.+/" | sort -n

>>

, , , , ,