Just a quick list of lesser known keyboard shortcuts. If you aren’t used to using keyboard shortcuts give them a go, makes navigating around windows and working on […]
Sync Toy and portable drives
Handy tip for those of us who use portable drives these days. For myself my portable drive is used mainly to move files between my Media Centre and […]
Handy DOS commands
DOS Commands Below are some handy dos command to help diagnose networking issues. Quick LinksPing Tracert Finger Nslookup Telnet Net stat SFC Ping [top] Format ping www.domainname.com […]
Crossover Cable
A crossover cable is used to link two pc’s together without a hub (note. if using a hub, use patch cabling). It is generally easier and cheaper just […]
SQL – Add Years to a date
Most of us play with dates pretty regularly in SQL adding days here, finding how many days between dates. What about if you need to start adding years. […]
SQL – Table Skew(Teradata)
Ok this one is a Teradata speciality. Skew…. Before I go into any detail on Skew just a quick “how teradata works” to get everyone on the same […]
Teradata gets Autonumber
Hey all, Just something I found that I thought I would share. Don’t know if anyone else had tried this before apart from myself, but Teradata was previously […]
SQL – Convert
Need to replace a specific char in a string, say for example remove commas so you can export the file in CSV without hassles later on? Easy fix: […]
SQL – Vertical Concatonation(Merging Rows in single field)
Not something that comes up often, but can be a hassle to workout the logic behind merging multiple rows into a single field. If your not sure what […]
How to create an Automated BTEQ batch file with logs
You will need to create 3 files settings.bat @rem Sets all declarations and variables for use in automation. @rem automation_name = set folder name and solution names […]