Increase performance on MySQL with a SSD and modifying your my.ini or my.cnf file

Always backup your data along with the my.ini or my.cnf file

To add to the performance of a MySQL database, there are many tweaks for the my.ini or my.cnf file.  Two things that you can do is first add a SSD as a secondary drive and then move your temp file to the SSD by adding the following line just below the [mysqld] section -

tmpdir=”H:/mysqltmp/”

You must change the letter H to the drive letter of your new SSD drive.   If you have a linux based computer, set the appropriate permissions.

Restart mysql or restart the computer.

SCADA Security

SCADA devices are systems that control manufacturing or infrastructure devices.  We are always calling for the need to protect these devices with appropriate security measures.  Here’s a look at how easily they can be found and seen by anyone on the internet.

Steps to protect SCADA (Supervisory control and data acquisition networks)

Microsoft SQL slow after updates

While disabling LLMNR can speed up your SQL connection sometimes, ironically you may be slowed down by MS14-066 (KB2992611).

See this article -
“Microsoft does it again, botches KB 2992611 SChannel patch” – Infoworld

What do you do?  The article above gives some advice and more advice comes from the link at the bottom of this blog posting.
Here’s a couple of fixes if you installed KB2992611 and your SQL server came to a crawl

Possible fixes if you’re already affected:

Open gpedit.msc

Go to computer configuration > administrative templates > Network > SSL Configuration Settings > SSL Cipher Suite Order

Set it to enabled

Reboot or gpupdate /refresh at an elevated command prompt

The policy populates the Windows registry with the legacy cipher suites less the 4 new cipher suites added by MS14-066 /2992611.

Source/Credit : http://blogs.msmvps.com/spywaresucks/2014/11/16/hold-off-installing-ms14-066-kb-2992611/

Note:  ALWAYS backup your data before your try reversing a patch or modifying policies or the registry.

Microsoft should fix this soon…

Here’s how to improve performance – LLMNR -

http://ttcshelbyville.wordpress.com/2009/11/30/slow-sql-connection-to-windows-7/

A love for computers and music

One of the most talented people I know is Jared Ledlow.  A former student, Jared was remarkable at diagnosing computers, learning new technology and absolutely loved playing and writing music.   His personality is contagious and his unselfishness in learning and teaching others is above reproach.

171847_1812638963652_7258580_o

After graduation, Jared started as a government contractor resolving help desk tickets.

He went on to become a Technical Assistance Associate in one of the largest data centers.

Jared now monitors the critical infrastructure behind the day to day operations in his company’s data center.

Some of his responsibilities include monitoring UPSs, CRAC units and a ton more.

In IT you need motivation, initiative, worker ethics, a desire to learn and more.  Jared Ledlow has these qualities and more.

Cannot switch users in Windows 8/8.1

If you cannot change accounts in Windows 8, 8.1 or Windows 8.1 Update there are several things you can try -

First try editing the registry

In the search box, type regedit
Navigate to the following:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System

Modify the registry value of HideFastUserSwitching from 1 to 0

Log off and restart the machine

Did it work?  If not, try editing the group policy

In the search box, type gpedit.msc
Navigate to -
Local Computer Policy/Computer Configuration/AdministrativeTemplates/System/Logon
Double click Hide Entry Points for Fast User Switching to bring up a dialog box to change Fast User Switching policy setting.
Choose Enabled
Close the group policy editor
Open a command prompt and type gpupdate /force

If the above did not work, try a refresh pc

Go to a “Command Prompt” as an Administrator
Next enter
shutdown.exe /r /o /f /t  00
The computer will restart
Select Troubleshoot
Select Refresh PC