Script files are great, they enable you to run bespoke code on a machine to achieve all kinds of things that would be difficult or time consuming to do otherwise without needing a full coding environment to create and without… Continue Reading
Batch files can be great for running small sections of code against the operating system and this is a lovely little tip on how to make a reasonably complex folder structure without all of the usual clicking around all over… Continue Reading
When amending data in a large SQL database it makes sense that the bread-and-butter command is the classic UPDATE statement. this statement is reasonably simple and has the following syntax: (the MSDN link is here: https://msdn.microsoft.com/en-us/library/ms177523.aspx ) UPDATE TABLE_NAME SET column1=value1,column2=value2,…… Continue Reading
As I mentioned in another post on keyboard shortcuts the windows run command can be summoned with Ctrl + R and can be really useful for opening applications easily (for a few examples). For the shortcuts listed that’s great but… Continue Reading
Using keyboard shortcuts can often be much quicker than finding the right menu option to do things and having just a few shortcuts under your belt can speed up your navigation of windows and applications massively (as well as making… Continue Reading
In trying to keep organised with my files and folders I’ve often used naming conventions so that I can sort items in a way that makes it easy to find things. For folders that I use regularly I’d prefix with… Continue Reading
You will likely be aware of the ‘like’ operator and its use and the common use of the % symbol to denote a string of 0 or greater length of any characters. What you may not know is how to… Continue Reading
Querying the sys, tables in a database can make looking for references to objects or listing out columns a very simple task. Whilst the tables being queried hold a lot of interesting and useful information it’s generally necessary to be… Continue Reading
On a number of occasions I’ve found it necessary to escape characters within the .csv format that is used by excel or try and output data that when entered directly into a .csv file shows oddly because the data source… Continue Reading
Whilst trying to come up with ways to make life easier at work I noticed that automating an email to appear with a subject, addressee and body pre-populated could save a lot of time in some circumstances – genius. Trying… Continue Reading