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.

Only one user showing during logon of Windows 8/8.1 Pro

After some some updates, you may notice that you cannot see all of the users when logging in.

Open GPEdit.msc (Group Policy Editor)

Navigate to Windows Settings, Security Settings, Local Policies, Interactive logon: Do not display last username and double click.  Select enable and reboot your computer or use gpupdate /force.

2