stuart@stuclark.uk SQL Server versions A simple table to help convert SQL server release names (i.e. SQL Server 2017) to versions Version Year Release name Code name Internal database version 1.0 ( OS/2 ) 1989 SQL Server 1.0 ( 16-bit ) Fil...
stuart@stuclark.uk Exchange (on-prem) Server versions This is not of much interest to anyone, unless you suddenly need to restore a system's health, and need to know the internal build numbers of Exchange. Without further ado; the list of Exchange versio...
stuart@stuclark.uk Upgrade Win10 / Win11 HOME to PRO for free! Microsoft helpfully allow you to upgrade from Windows 10 Home to Windows 10 Pro (on devices such as the Surface Go) by simply entering a new product key. The issue is, you have to purchase said key fr...
stuart@stuclark.uk Get all instances of O365 "user@domain.com" Get all instances of " user@domain.com " on an on-prem / Office365 environment $path=[Environment]::GetFolderPath("Desktop") Start-transcript $path\objects.txt Get-OrganizationConfig | fl Get-Msoluser...
stuart@stuclark.uk Connect PowerShell to O365 To connect Powershell to Office365 (with MSOnline module and ExhangeOnline modules loaded - run on an on-prem Exchange server for full benefits) ((Powershell 5.1 or better needed!) Set-ExecutionPolicy...
stuart@stuclark.uk Remove EN-US in fresh Windows builds In Windows 10 release 1803 Microsoft have managed to create a new bug whereby on some localised (i.e. non US English ) computers, you suddenly fiind US English has been installed and is non-removable ...
stuart@stuclark.uk Set mailbox permissions for users in Exchange To give an user (USER2) permissions to a different user's (USER1) calendar / contacts etc. run the following PowerShell commands on the Exchange server: Firstly check the existing permissions for USER...
stuart@stuclark.uk Discover which Exchange mailboxes an user can access For all those times when you want to find out which Exchange calendars a particular user has access to, use this script: (in this example, we pretend our user is called Fred Bloggs ) ForEach ($mbx in ...
stuart@stuclark.uk Create a UEFI bootable Windows Installer Creating a UEFI bootable Windows installer USB stick or HDD should be easy these days, but for whatever reason it remains one of those awkward things to do. Consequently, I've put together some instru...
stuart@stuclark.uk Install .Net 3.5 on Windows 10 & 11 Most of the time, the Add / Remove Windows Features method of installing .Net 3.5 fails under Windows 10. Here's how you fix it. Dism /online /enable-feature /featurename:NetFX3 /All /Source:D:\source...