Limit OneDrive bandwidth hogging

  1. Open Local Group Policy Editor.
  2. Go to User Configuration / Windows Settings / Policy-based QoS.
  3. Right-click and hit Create new policy.
  4. Set DSCP Value to 1 and/or Outbound Throttle Rate to something appropriate.
  5. Set QoS policy to apply to applications with executable name onedrive.exe (or skydrive.exe, check your process list).
  6. Reboot, perhaps.

Note sure if it’s actually working though…

IIS: Redirect HTTP to HTTPS

To cleanly redirect HTTP to HTTPS with IIS, first install the URL Rewrite module, and then add the following to your web.config. Also remember to have bindings defined for your site for both HTTPS(443) and HTTP(80).

        <rule name="HTTP to HTTPS redirect" stopProcessing="true">
          <match url="(.*)" />
            <add input="{HTTPS}" pattern="off" ignoreCase="true" />
          <action type="Redirect" redirectType="Permanent" url="https://{HTTP_HOST}/{R:1}" />

Source: StackOverflow

SQL Server evaluation license expiration date

Running the following SQL should give you how many days left until your evaluation license runs out. Also tried adding a calculation of when that date is. Either way, beware of off-by-one errors…

sp_configure 'show advanced options', 1;

sp_configure 'Agent XPs', 1;

DECLARE @daysleft INT
DECLARE @instancename sysname
SELECT @instancename = CONVERT(sysname, SERVERPROPERTY('InstanceName'))
EXEC @daysleft = xp_qv '2715127595', @instancename
    DATEADD(dd, @daysleft, CONVERT(DATE, getdate())) 'Expiration date',
    @daysleft 'Days left'

Source: When will my SQL Server Evaluation Edition expire?

Shortcut to Resource Monitor in Windows 8.1

In Windows 7 there was a shortcut to Resource Monitor in the start menu, which meant you could launch it quickly through search. In Windows 8.1 this didn’t seem to be the case for some reason. Might have missed something… but found the shortcut for it on a Windows Server 2012 installation, and it worked just as nicely in Windows 8.1. So, note to self:

%windir%\system32\perfmon.exe /res

So after quickly making a shortcut to that in my menu, I’m once again back to launching it directly rather than through the button in Task Manager.

Change license key of Windows Server

Needed to install two Windows Server 2012 R2 instances today, but didn’t have a valid production license key yet and didn’t seem like there was a way to skip the key in the setup. Found you can remove a license key using a command, so worked around it using a temporary dev key from MSDN for the installation and then removed that key afterwards. For future self-reference, here’s how…

  1. Open elevated command prompt
  2. To remove key
    > slmgr -upk
  3. TO add new one
    > slmgr -ipk NEW-KEY or use regular activation process

Ignoring files and folders in Sublime Text

I love the file search (ctrl+shift+f) and quick navigate (ctrl+p) in Sublime Text. What can be annoying however is when these present you with library code in your project, files related to source control, binary files or minified files.

Since I keep forgetting how to clean that up, here’s a note to self (and others) on how to clean that up. Easy peasy.

  1. Save as project (if you haven’t already)
  2. Edit project file
  3. Add file_exclude_patterns and/or folder_exclude_patterns to the folders section.

Below is an example from one of my current projects which excludes the git repo folder, a cache folder, minified files and some binary files.

            "path": "/D/dev/www/sdaweb-ssl"

With a hint of Social Ineptitude