Hon Richard Harris and Jens Dietrich

Richard Harris, Massey University, at Networks 2012

Compatibility and API Evolution in Java - Jens Dietrich

HTC ONE M7 Battery Issue

In case the HTC One M7 mobile phone:

• Takes long time to charge the battery
• Phone gets too hot during charging the battery
• Battery drained very fast even on a simple task

Take the following steps:

• Turn off (uncheck) the Fast Boot option under Settings > Power
• From Settings > About > Software Information > More, tap on Build Number until put the phone in Developer Mode
• Reset the phone and go to Recovery Mode (press Vol Down and Hold Power button)
• Clear the Cache and restart the phone

 

Remote Server Administration Tools for Windows 7 SP1

Remote Server Administration Tools for Windows® 7 with SP1 enables IT administrators to manage roles and features that are installed on computers that are running Windows Server® 2008 R2, Windows Server® 2008, or Windows Server® 2003, from a remote computer that is running Windows 7 or Windows 7 with SP. more...

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

Update the MySQL Query in Safe Mode

SET SQL_SAFE_UPDATES = 0;

APPML: Application Markup Language

What is <AppML>?

<AppML> is an application development framework, consisting of: 

• An XML language for defining application models
• A JavaScript running the the browser
• A PHP or ASP script running on the server

more on W3C School...
more on faculty.kfupm.edu.sa...

Generate Random Numbers in C#

private static int seed = Environment.TickCount;

// Generate random number tick
private static ThreadLocal<Random> randomWrapper =
            new ThreadLocal<Random>(() => new Random(Interlocked.Increment(ref seed)));
           
randomWrapper.Value.Next(additionMinValue, additionMaxValue);

Reading repetitive XML to memory using C#

Sample XML Document:
<Elements>
    <Element>
        <Name>N1</Name>
        <Type>T1</Type>
        <Color>C1</Color>
    </Element>
    <Element>
        <Name>N2</Name>
        <Type>T2</Type>
        <Color>C2</Color>
    </Element>
    <Element>
        <Name>N3</Name>
        <Type>T3</Type>
        <Color>C3</Color>
    </Element>
</Elements>


Sample C# Code:
XmlDocument myDoc = new XmlDocument()
myDoc.Load(XML_File_Path_Name);

foreach(XmlElement elem in myDoc.SelectNodes("Elements/Element"))
{
    XmlNode nodeName = elem.SelectSingleNode("Name/text()");
    XmlNode nodeType = elem.SelectSingleNode("Type/text()");
    XmlNode nodeColor = elem.SelectSingleNode("Color/text()");

    string name = nodeName!=null ? nodeName.Value : String.Empty;
    string type = nodeType!=null ? nodeType.Value : String.Empty;
    string color = nodeColor!=null ? nodeColor.Value : String.Empty;
} 

Enable remote MySQL connection

Put this as root: GRANT ALL PRIVILEGES ON *.* TO  'USERNAME'@'IP'  IDENTIFIED  BY  'PASSWORD'; where IP is the IP you want to allow acess and USERNAME is the user you use to connect If you want to allow access from any IP just put % instead of your IP and then you only have to put FLUSH PRIVILEGES or restart mysql server and that's it