Author: Chris Smith
Batch script to help with launching files for correct version of Windows
We encountered an issue during a migration to Windows 10 where I had missed a program which had hard coded […]
Generate a text file with subfolders in a location on explorer
I needed to generate a list of folders and their subfolders, I used a simple command for dir command and […]
Find unused MSSQL indexs on a database
Credit: Basit’s SQL Server Tips The following is very handy to check for any unused index’s on a MSSQL database, […]
SQL Server 2008 – Find which stored procedure is part of a scheduled
Find a stored procedure (or any text) inside a scheduled on on SQL Server 2008 and 2012 by querying the […]
Getting a Kodak i160 to work on a KEC 1582t card in Windows 7
We had an issue where a Kodak i160 scanner would appear when a Windows 7 machine booted but then disappear […]
Maintain MSDB email tables
Credits: SQL Server Central SQL Authority Microsoft Docs Microsoft Docs We recently had an issue where MSDB was growing very […]
Find processes which have been using tempdb
Credit: Microsoft TechNet On some occasions a few MS SQL databases have exhausted tempdb space, this was due to users […]
Sage Line 500 EDI IN Intermediary tables inner join on sql query
On ocassion I need to look at what is in the EDI IN modules intermediary tables, scheme.eiordtm has an annoying […]
Display advanced properties of scheduled tasks in command line
The following command requests a detailed display of the tasks on the local computer. It uses the /v parameter to […]
A simple batch file which compresses every folder into a 7z Archive
For backing up old files I tend to sort into lots of different folders, anything I am finished with I […]