Category: Windows
Updating a network location in Windows 2012
I had an issue where a server which was joined to a domain had incorrectly set its network as Public. A TechNet article and TenForum article provided the answer (As it states Windows 10 it also applies to Server 2012) so I have placed credits above the steps I followed. Following a re-occurrence I have…
Filtering in Event Viewer Windows Server 2008 onwards
The Event Viewer from Server 2008 onwards is XML based. Filters based on XML syntax can be used such as: <QueryList> <Query Id=”0″ Path=”System”> <Select Path=”System”> *[EventData[Data and (Data='<Search Parameter>’)]] </Select> </Query> </QueryList> <QueryList> <Query Id=”0″ Path=”Application”> <Select Path=”Application”> *[EventData[Data and (Data='<Search Parameter>’)]] </Select> </Query> </QueryList> You…
Simple error checking when running batch files from T-SQL in SQL Server
A while ago we added error trapping to the batch file called by a SQL script, this was to ensure if a program failed the rest of the process would not run: After ensuring the program would return an error level if something went wrong we then I then used the ErrorLevel and an if…
Microsoft Access 2010 loader
Credits (As what I consider the hard stuff was actually done by other people): TheSmileyCoder for the solid awesome little VBS File, this basically gets around the limitation of not actually getting Access to load another Access Database. At the time I only ever needed one modification (A rarely issue affected two P4 machines with…
Why use ACCDE and then ACCDR Access Front Ends
Nearly every single Microsoft Access “database” I use has a proper database attached instead of using the internal Jet Engine, this means data is not actually stored in the Access “database” and I therefore call them Access Frontends. Compiling your Access front ends to ACCDE provides a compiled copy of your Access Front End. I…
Within a batch file run a program for a certain length of time before killing it
I needed to run a scheduled batch job and kill it off after a certain amount of time, this was because the program would run what it needed and then run as normal (If it exists then there is no reason to use start or timeout). As it actually ran as a service I didn’t…
Windows 10 Remove Unwanted Bloat from Windows 10
A number of the default “apps” that Microsoft provide tend to get on my nerves, as I have Skype and Office already installed I was annoyed to see the “Get Skype” and “Get Office” were listed. I tweak the below on all new machines as some members of my family do have a Windows Phone…
Outlook 2010: VBA delay sending of emails until the next working day if outside of reasonable hours
This Outlook 2010 VBA code was used to impose a time when emails could not be sent and were instead delayed until the next work day. This was put together (Credits go to key parts of this VBA are in the actual code) because the Managing Director where I work realised he was making people…
Compress and move existing Windows 2012 and Microsoft SQL Server 2008 Express backups
The following has been used to backup a server with Cisco Cubac on. The software runs on Windows 2012 machine and uses SQL Server 2008 Express. As its not on a managed server I had to find a way to backup the server and the database, plus keep the backup as small as possible. I…
Synctoy 2.1 setup batch script
This code was used to speed up the setup of SyncToy 2.1 (I see no reason to backup the entire user profile folder, but I hate having to setup multiple sync jobs). As Microsoft has not updated SyncToy it may not work on anything other than Windows 7. The script expects SyncToy 2.1 is installed…