firewallport:HKLM\System\CurrentControlSet\Services\SharedAccess\Parameters\FirewallPolicy\DomainProfile\GloballyOpenPorts\List\\1313:UDP

If Windows Defender Real-Time Protection report returns this string:

"Path Found: firewallport:HKLM\System\CurrentControlSet\Services\SharedAccess\Parameters\FirewallPolicy\DomainProfile\GloballyOpenPorts\List\\1313:UDP"

This is a potential security risk. Although protocol TCP port 1313 is flagged as a virus, it doesn't necessarily mean that a virus is currently using port 1313, but does mean that a Trojan or Virus has used this port in the past to communicate with your computer.


Also if you get the string: "Path Found: firewallport:HKLM\System\CurrentControlSet\Services\SharedAccess\Parameters\FirewallPolicy\DomainProfile\GloballyOpenPorts\List\\1458:UDP"


This should be a concern too, as Port 1458 has known security vulnerabilities, because this port is commonly used by Trojans and viruses (for remote code execution).

if (typeof(Sys) == 'undefined')

usually implies 'ASP.NET Ajax client-side framework failed to load.'

How to disable the keyboard 'sleep' button on a windows PC

If you happen to own a keyboard with a sleep button in a terribly inconvenient location, such as next to a built-in keyboard volume control or next to your 'esc' key, occasionally causing you to accidentally put your PC to sleep, then there's hope. 


1). Go into power options in Windows Control Panel, (Start>Control Panel>Power Options)

 2). There should be an option on the left side menu to "Choose what the power buttons do". Clicking on that option will take you into System Settings, where you can 'define power buttons and turn on password protection'.

 3). Under "Power and sleep button settings", you can change the selected option for "When I press the sleep button:" in the drop down from 'Sleep' to 'Do nothing'

 4). Click 'Save changes', and Bob's your uncle! no restart necessary.

Help with debugging JavaScript and/or identifying performance issues in IE

One of the improvements in IE 8 was the introduction of a JScript profiler which can provide useful JScript-related performance data during web development, and this feature has also been carried over into IE9.

To access the profiler, from IE9, launch the developer tools window either by selecting 'Tools>F12 developer tools' from the menu (shortcut keys: ALT+T,  L) or toggle on/off simply by pressing F12.

From the developer tools window, switch to the 'Profiler' tab, and then click 'Start profiling' to begin a profiling session. Click 'Stop profiling' to end the session. You can then view the resulting performance report in either 'Functions' view or 'Call tree' view, using the 'Current View' dropdown at the top of the window.

The developer window has a number of other handy features as well, such as disabling the pop-up blocker, disabling CSS, or validating HTML & CSS, etc.

More information can be found on the MSDN blog at: http://blogs.msdn.com/b/ie/archive/2008/09/11/introducing-the-ie8-developer-tools-jscript-profiler.aspx

To configure Gmail on an Apple device (e.g. iPhone, iPad, iPod Touch), using Safari browser:

1. Make sure you've enabled 'IMAP' in your Gmail settings
2. Open the Settings app on your device
3. Tap Mail, Contacts, Calenders
4. Tap Add Account
5. Tap Gmail
6. Enter you account information, being sure to use your full Gmail address, uncluding @gmail.com
7. Tap Next
8. Tap Save

See full instructions on the Goggle Mail Help website, at : https://mail.google.com/support/bin/answer.py?answer=77702

OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "Linked_Server_Name" returned message "Could not find installable ISAM.". Msg 7303, Level 16, State 1, Line 1 Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "Linked_Server_Name".

The knowledgebase at support.microsoft.com indicates this error can be the result of missing files or wrong filepaths in the Windows registry, etc. Check out suggested fixes here: http://support.microsoft.com/kb/283881/en-gb

However, I have also experienced that you will also get this error if your @provstr= for the Linked_Server_Name is set to "Excel 97 workbook" instead of "Excel 8.0"

For Example:

EXEC master.dbo.sp_addlinkedserver @server = N'Your_Linked_Server_Name', @srvproduct=N'Excel', @provider=N'Microsoft.Jet.OLEDB.4.0', @datasrc=N'C:\MortgagesDatabase\MortgageProduct.xls', @provstr=N'Excel 97 workbook'

instead of:

EXEC master.dbo.sp_addlinkedserver @server = N'Your_Linked_Server_Name', @srvproduct=N'Excel', @provider=N'Microsoft.Jet.OLEDB.4.0', @datasrc=N'C:\MortgagesDatabase\MortgageProduct.xls', @provstr=N'Excel 8.0'

Rounding decimal or floating point numbers in C#

Example from stackoverflow: http://stackoverflow.com/questions/257005/how-do-you-round-a-number-to-two-decimal-places-in-c


decimal a = 1.994444M;

Math.Round(a, 2); //returns 1.99

decimal b = 1.995555M;

Math.Round(b, 2); //returns 2.00


Math.Round also has an overload for rounding-to-even:

Math.Round(a, 2, MidPointRounding.ToEven);