Archive for the ‘ Microsoft ’ Category

Disable Cortana on Windows 10

If you’re using Windows 10 Professional or Enterprise, the easiest way to disable Cortana is by using the Local Group Policy Editor.

Launch the group policy editor by pressing Windows + R, typing gpedit.msc into the box, and pressing Enter:

gpedit

Navigate to Computer Configuration > Administrative Templates > Windows Components > Search.

Locate the Allow Cortana setting in the right pane and double-click it:

allow-cortana

Set the Allow Cortana option to Disabled and then click OK:

allow-cortana-2

You can now close the group policy editor. You’ll have to sign out and sign back in – or restart your PC – for this change to take effect.

See original article here:
https://www.howtogeek.com/265027/how-to-disable-cortana-in-windows-10/

 

Disable hiberfile.sys

hiberfile.sys is a huge file normally found in your Windows root directory. Normally it’s a file 75% size of your total amount of RAM. So if you have 32GB installed, you’ll have a 24GB hiberfile.sys file sitting there taking up space for no reason.

If you can live without the hibernation feature (this is more the case for desktops – hibernation is actually quite useful for laptops) then you can disable the feature and remove the file with this simple DOS command:

powercfg.exe -h off

Just remember to launch the  command prompt and “Run As Administrator”.


More info here:
https://www.cnet.com/how-to/how-to-enable-or-disable-hibernate-in-windows-10/

Batch rename file extensions in Windows

This is a handy trick I found when I needed to batch rename a hundred .THM files to .JPG.
Open DOS and run the following command:

ren *.XXX *.YYY

Where XXX is the source and YYY is the target extension.
That’s it!

Remote Windows shutdown

To remote shutdown a workstation in 5mins from now:

shutdown /s /t 300 /m \\EWEAW00020

To cancel the command:

shutdown /a /m \\EWEAW00020

 

Fix a broken PST?

Outlook can rely on local data files called PSTs for archiving emails. Sometimes these PSTs can get corrupted.
In the unfortunate instance that they stop working, you can use a tool called “SCANPST.exe” that ships with Outlook to try and repair it.

  1. Navigate to C:\Program Files\Microsoft Office\Office15
  2. Locate the SCANPST.EXE icon and double-click it.
    scanpst
  3. Locate the broken PST and click on “Start”.
    scanpst-01
  4. The tool will take a while to scan the broken PST.
    scanpst-02
  5. Then it will tell you what’s wrong with it and ask you if you wish to repair it.
    Click the “Repair” button.
    scanpst-03
  6. The tool will work away (you will probably get a “non-responsive” status until it’s finished, but ignore it and just let it do its thing).
  7. Finally you should be presented with the “Repair complete” dialogue box.
    scanpst-04
  8. Open Outlook and see if your PST is now accessible.

Deleting the winsxs folder

In C:\Windows there is a system folder called “winsxs” which stores all the installation files used to update and upgrade Windows.

This folder, on my Windows 7 64-bit system, took up 12GB of space on my precious 80GB SSD drive.

Launch the DOS prompt with administrator rights and run the following command to remove all the files.

Dism.exe /online /Cleanup-Image /SPSuperseded

Moving the MSOCache files

When you install Microsoft Office, by default it will leave a folder of installation files on the C: drive. You cannot delete this folder because every time MS Office needs to update itself, it uses those files.

With the MS Office 2013 edition, I have a folder with 830MB of files! On a small SSD, this is precious space that needs recovering. So what to do?

One trick I came across today is to move those files to another disk and create a symbolic link to them:

mklink /D "C:\MSOCache" "D:\MSOCache"

And that’s it!

 

Creating symbolic links in Windows

I learned today, it’s possible to create a symbolic link in Windows! Here’s what you need to do:

  1. Run the DOS prompt as Administrator.
  2. Use the following command as an example:

    mklink /D "C:\MSOCache" "D:\MSOCache"

  3. Without the “/D” it’ll be a symbolic link for a file. To link a directory and all its files, use the “/D” option.
    The first variable will be the actual symbolic link.
    The second variable is where the files will actually reside.

Android unable to connect to Exchange Server

After a local server maintenance, my Galaxy Nexus (Android 4.1.1) stopped connecting to the Exchange Server.
I removed the account to try re-adding the account and doing so lost all my emails, calendar and contacts.

No matter how hard I tried, I could not add my account “wind\jason.bickley”.
I received the error “Could not connect to the server”.

However, when I put in a random intern’s credentials it could connect.
Our I.T. Manager then found the following solution and corrected it in Active Directory.

http://technet.microsoft.com/en-us/library/dd439375(EXCHG.80).aspx

“In Exchange Server 2010, you may also experience this issue if the Exchange Servers group does not have the appropriate permission to the mailbox object in Active Directory. The most common cause for this is broken Access Control List (ACL) inheritance in Active Directory.

To check whether inheritance is disabled on the user:

  1. Open Active Directory Users and Computers.
  2. On the menu at the top of the console, click View > Advanced Features.
  3. Locate and right-click the mailbox account in the console, and then click Properties.
  4. Click the Security tab.
  5. Click Advanced.
  6. Make sure that the check box for “Include inheritable permissions from this object’s parent” is selected.

If the user is a member of certain protected groups such as Domain Administrators, it is normal for this box to be unchecked. If you are experiencing a problem with members of these protected groups you should check the permissions on the AdminSDHolder object.”

UTF-8 encoded data corrupted in CSV exports

When exporting from PHPMyAdmin as CSV, Excel usually doesn’t know how to deal with the special characters, resulting in corrupted data.

csv_corruption

 

In order to avoid this, we use the following method:

  1. Open a new Excel book
  2. On the “Data” tab, click on the “From Text” button:
    data
  3. Locate your CSV file and click on “Import”
  4. In the dialog box, select the appropriate encoding (i.e. UTF-8) from the dropdown list:
    utf-8
  5. Next, select the delimiter for the CSV (i.e. comma):
    delimit
  6. Then click on Finish (you will be asked where to insert the data – normally [A1] is the place to put it).
  7. Now the data is correctly displayed in Excel:
    csv_fixed