Rebuild a V1 DBCapture Database Queue
We have an issue where on a rare occasion a scan from V1 DBScanner to DBCapture can corrupt the queue […]
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. […]
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: […]
Method of working out check digit for an SSCC code
Method of working out check digit for an SSCC shipping code in SQL on a system with Sage Line 500 […]
Apply ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to SQL Server
We needed to enable ALLOW_SNAPSHOT_ISOLATION and READ_COMMITTED_SNAPSHOT to specific databases on a SQL Server 2008 instance, I found to do […]
Add a user to DatabaseMailUserRole on msdb
I had a user unable to use a script which generated an email, I found the user didn’t have permission, […]
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 […]
Microsoft Access 2010 loader
Credits (As what I consider the hard stuff was actually done by other people): TheSmileyCoder for the solid awesome little […]
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, […]
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 […]