Search This Blog

Google Analytics

Tuesday, November 24, 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.

Tuesday, November 17, 2015

Monday, November 09, 2015

Learn Android and Web Development from Google for FREE

What is better than learning Android and Web Development from Google experts for FREE? Google courses hosted on Udacity caters for beginners to advanced developers are opened for enrolment.

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.

Popular Posts