How To Turn Your Webcam into a Security Camera With Dorgem

How To Turn Your Webcam into a Security Camera With Dorgem 

Download the software from here 

 

Turn Windows Phone to Security Camera

Need to download the following applications from Windows phone app Store:

CameraFTP App from Windows App Store: CameraFTP App

CameraFTP Viewer from Windows App Store: CameraFTP Viewer

Remove restrictions from MS Word and Excel Files

Remove passwords / editing restrictions on MS Word and Excel Files: more...

Reinstalling Packages and its Pitfalls

Reinstalling a package is a simple act of uninstalling a package and installing back the same version of the package that was uninstalled. The 2 steps involved are nicely bundled up in the –reinstall switch of the Update-Package command as shown below. more...

Query Cache SELECT Options

SELECT SQL_CACHE id, name FROM customer;
SELECT SQL_NO_CACHE id, name FROM customer;

More... 

Enable the query cache in MySQL to Improve Performance

To see the cache size: 

mysql> SHOW VARIABLES LIKE 'query_cache_size';  

To manage the cache size:

mysql> SET GLOBAL query_cache_size = 16777216;

More... 

MS SQL SERVER - String Comparison

Sometimes, comparing 2 strings can be a bit tricky in MS SQL Server. For example, if there is a field of name as varchar(n), containing the value of "Microsoft", it is actually treated as "Microsoft        " (fill the rest of field with spaces). Therefore using = always return wrong answer. Using LIKE however, return those strings which contains word Microsoft which is not the desired answer. The solution is to use PATTERN MATCHING as follow:

SELECT "Microsoft        " = "Microsoft[ ]%"

[ ]% represents the spaces