Windows 7 Slow Boot and Long Delay Time on Startup After Installing SSD

After installing the Windows 7 x64 on a machine with new Solid State Disk, Windows works slower than usual and has long delay on login screen. To overcome this problem, install the following update:

• Update for Windows 7 for x64-based Systems (KB980408) 
• Windows 7 and Windows Server 2008 R2 Service Pack 1 (KB976932)

Limited WiFi Connection Problem in Windows 8.1

After installing the Windows 8.1, wireless connection keep dropping saying "Limited Connectivity". To resolve this issue:

Open "Command Prompt" as administrator and issue the following commands in sequence:

    1. netsh int tcp set heuristics disabled
    2. netsh int tcp set global autotuninglevel=disabled
    3. netsh int tcp set global rss=enabled
    4. netsh int tcp show global
    5. Restart the computer

Enable Remote Connections for SQL Server Express 2012

1. Run SQL Server Configuration Manager.
2. Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.
3. Make sure TCP/IP is enabled.

Then,

1. Right-click on TCP/IP and select Properties.
2. Verify that, under IP2, the IP Address is set to the computer's IP address on the local subnet.
3. Scroll down to IPAll.
4. Make sure that TCP Dynamic Ports is blank. (Mine was set to some 5-digit port number.)
5. Make sure that TCP Port is set to 1433. (Mine was blank.)

If follow these steps, it's not necessary to enable SQL Server Browser, and only need to allow port 1433, not 1434

After all, go to Windows Service Manager and RESTART the SQL SERVER service to apply the changes.

Soild State Hard Disk Performs Very Slow in Windows 8.1

To fix this problem, execute the following command and restart the computer:

Start > Run > Winsat Format

Opening Excel File using Task Scheduler

It might be the DCOM permissions issue. One solution is to set Excel to run as a specific user through DCOM permissions.

1. Open Component Services: Start > Run > DComcnfg
2. Drill down to: Component Services > Computers > My Computer > DCOM Config
3. Right-click on 'Microsoft Excel Application' and choose Properties
4. In the 'Identity Tab', select 'This User' and enter the username and password of an interactive user account (domain or local) and then click Ok

Keeping it as the interactive user or the launching doesn't work with the task scheduler, even when setting the task to run under an account that has admin rights to the machine.

React

A JavaScript library for building user interfaces. more...

Bootstrap

Bootstrap is the most popular HTML, CSS, and JS framework for developing responsive, mobile first projects on the web. more...