Skip to main content

Posts

Showing posts from November, 2015

MsSQL: Shrink ALL Databases Using 1 Single Line of SQL Statement

Over time, the database logs on your database server may take up significant amount of disk space especially if there are many databases with lots of transactions. One quick method to free up disk space is to "shrink" your databases. Instead of shrinking one database at a time using the GUI, you can run a single line of SQL statement to do just that.

EXEC sp_MSForEachDB 'DBCC SHRINKDATABASE (''?'' , 0)'
Hope it helps.

Putin's Perspective On 'Who Created the ISIS'

Putin, President of Russia, discussed on his perspective on who actually created the ISIS.


Putin also accused countries including some G20 members are financing the ISIS.

Find the Wi-Fi network password in your saved list on Windows

There may be occasion you may have a second mobile device and would like to be connected to the Wi-Fi network but sadly, you could have forgotten the password completely. What you need to do now is to run a command on the Windows command prompt in administrative mode to reveal the already added Wi-Fi network password in clear.

Replace THE_SSID with your own Wi-Fi SSID.

The below will show details of the Wi-Fi network.

netsh wlan show profile name=THE_SSID key=clear
To see only the password ignoring the rest of the details, feed it with the findstr command like below.

netsh wlan show profile name=THE_SSID key=clear | findstr Key
For similar hack for Mac and Linux, read How to Find the Wi-Fi Password of your Current Network.