Windows Archives - Domain Web Center

Remotely Power Up or Wake Your Wired PCs Over the Internet

2018-10-09 Udar Gromov 0

Idea – Reduce Noise, Save on Electricity My electric company installed an electricity consumption gadget, and ability to monitor usage online. A few month into the experiment I realized, that I can easily reduce electric usage, if I turned off my server. It is been over a year since I […]

Properly Validate TextArea Length (IE vs. Firefox)

2018-09-08 Udar Gromov 6

Let’s consider this example, where HTML page has a TEXTAREA and an INBOX. When user types inside TextArea, Inbox should show the length of TextArea string. <script type=”text/javascript”> function TTLength(objTT){ var tt= document.getElementById(‘TXT1’); tt.value = objTT.value.length; } </script> <textarea onKeyDown=”TTLength(this);” onKeyUp=”TTLength(this);” rows=”10″> This Text Area Contains a string With Newline […]

Block PC Outbound Connections on Router Level (All but RDP)

2018-09-07 Udar Gromov 1

This article applies to a scenario, when you already can establish RDP to a machine on your internal network from a remote network. Now you’ve decided to tighten security screws and close all external access to and from that machine except for RDP on the router level. Inbound connections to […]

SQL DB2: Concatenate TEXT from multiple records

2018-09-05 Udar Gromov 0

Scenario Here is a recipe on how to concatenate a field from multiple records into one field. There are two pre-conditions for this method to work: First. Your source file needs to have an equivalent of a line number field. This should be a numeric field indicating the sequence in […]

Cannot open database … requested by the login. The login failed.

2018-09-04 Udar Gromov 2

Cannot open database “Your_DB” requested by the login. The login failed.
Login failed for user ‘NT AUTHORITYNETWORK SERVICE’.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot open database “Your_DB” requested by the login. The login failed.
Login failed for user ‘NT AUTHORITYNETWORK SERVICE’. […]

Apply Color Scales Conditional Formatting to Multiple Rows in Excel

2018-08-22 Udar Gromov 0

When you might need to apply color sales Conditional Formatting to multiple rows in Excel using a Macro? We found that is most useful, when you have a perfectly arrange row-by-row conditional formatting, and you are trying to insert a new row. You can try to fix the resulting formatting […]

Win 7 and Win 8 – How to Rename All System Directories
(and W2K8 Server, and R2, and XP too)

2018-08-20 Udar Gromov 7

If only you could control names of directories, where Microsoft installs Windows, Data and Program Files. If you could, you would be able to install multiple instances of operating system on the same drive. So. let’s do it anyway. To do that you need two parallel installs of you favorite […]

Moving Win XP from RAID to RAID Machine

2018-08-12 Udar Gromov 6

After several days of heavy exhausting battles and sleepless nights, after testing dozens of options, after browsing many proposed Internet solutions, I finally was able to move an old instance of Windows XP on a new machine with new RAID drivers. That happened at 13:23 on December 12, 2010. I […]

How to Get SQL Table Field Structure?

2018-08-04 Udar Gromov 1

Sometimes you need to display or print a SQL table structure. This article provides a SQL statement that allows you to do that. We are using MS SQL 2008 Studio interface. […]

Count Number of Cell with Errors in Excel

2018-07-30 Udar Gromov 0

This problem occurs, when you have a column with a formula that sometimes returns an error. That is very typical for all kind of look-up situations . Let’s say, you have a column E with formula that returns good values and errors. You need to count how many errors are […]

How to Reset Win XP Admin Password

2018-07-29 Udar Gromov 0

There are two ways to reset forgotten Administrator password. Method one – Reset During Repair Reinstall: Use Win XP installation disk Run Recovery (not Recovery Console) Press Shift+F10 during GIU portion of repair / install Run LUSRMGR.MSC to reset any user password to whatever you want During my tests, this […]