Display not keeping up with the keyboard in MS Word?

So you’re typing away in Word, when you notice that the display hasn’t refreshed! But now you’ve stopped typing and you can see the sentence unfold infront of your eyes! What gives?

I’m not sure what causes the issue to occur in the first place at all, I’ve now had it happen twice. But the fix is relatively straight forward, if time consuming, especially if you have a slow internet connection I’m afraid.

Fire up the Windows Control Panel App and go the Programs section. From there click on the Programs and Features link and it should now display all the software installed on your PC. Scroll down to the office program, “Microsoft Office Professional Plus 2019”, in my case, and click on it. The menu should now show the three options: Organise, Uninstall and Change, it’s this last we want. Click on that and go for the “Online Repair” option and then click the “Repair” button, eventually it will come back and say it’s finished. And so far, well two out of two times, it’s fixed the lagging display issue.

Need to clone a disk with corrupt sectors?

So there you are the current boot drive, well only drive in this scenario, is failing, there are no backups, the Windows installation is corrupt. Finally you’re operating under a budget.

AOMEI backupper standard to the rescue, link here: https://www.ubackup.com/free-backup-software.html

Running a command as Admin

Or how to run a command with elevated privileges on Windows.

Tried to run a chkdsk this morning via a Windows account that wasn’t in the Administrators group and found out that I couldn’t do so. This was when I chanced, by searching t’internet, upon the Control (Ctrl), Shift and Enter magic key combination, never heard of this! Using these keys, instead of just Enter, runs the selected command with Admin privileges, fab!

Exact filename searching on Windows 10

Trying to find a file by filename and file type and getting matches that include the filename and type as well? Windows 10 search seems to have taken a step backwards by being “helpful” in search file contents and filenames, or types, when you use the search box.

Then you need to use the “name” keyword in the quick search box. The name option has two ways of being used:

name: web.config” This does what you don’t want! i.e. it returns files that contain the words “web” and “config”, but it doesn’t return files that have file contents including those words.

name:= web.config” This command will return only matches for “web.config” nothing else.

Windows 10 restarts after shutdown

Currently have an issue where most of the time shutting down the PC just performs a restart, annoying to say the least, been going on since late 2018.
I’m currently trying out this solution to see if it can be resolved.

6-Dec-19: A couple of test shutdowns later and it seems to be working, one to monitor.

Remote Desktop: Map a local drive on the remote host

If you repeatedly use a Remote Desktop session and that session needs access to files on the machine you’re connecting from then you’d normally set up a network drive, possibly mapped as follows:

net use z: \\yourmachine\c$ /persistent:Yes

But, depending on how Draconian your network security is then mapping folders on user machines may actually be blocked. Strange one as this ability is mostly essential when working on a remote machine, especially if a developer. Fortunately you can map using the built in sharing of RDP. Same format as earlier just the machine name changes and effectively becomes a constant, so the mapping is now:

net use z: \\tsclient\c /persistent:Yes

And job done, until the next group policy is introduced blocking that…

 

Search an MS-SQL database for a specific named column

Need to find a column in a database? The following SQL will return the tables, and columns, that contain a wildcard value

SELECT c.name AS ColumnName,
       t.name AS TableName
FROM sys.columns c
JOIN sys.tables t
 ON c.object_id = t.object_id
WHERE c.name LIKE '%column_name%'
ORDER BY TableName,
         ColumnName;