Selecting a range from a table is easy in MYSQL. Say you want to bring back results that you are paginating. Bringing back thousands of results is inefficient and needless. MS SQL there isn’t a simple way of doing this. The best way I have found, or my colleague Daniel has found, is to wrap [...]
Quick SQL Copy Table
Just a quick SQL tip that I have been using recently, and is aimed mainly at MS SQL, but I cant see any reason why this wouldn’t work on MY SQL, except for the fact the MY SQL has easier Backup facilities. The background for this is that I was making changes to a table, [...]
SQL Custom Order
I recently had a problem while creating a list of players for a project. I needed to list them in a certain order based on their position. I knew there were only 4 possible positions, but wanted them returned in the order of GK, DEF, MID and STK. I managed to find two ways of [...]
Adding Camera Raw to Photoshop
My first new post! I’m still working on the theme behind the scenes, and trying to add all my old posts from my old site, but had this new idea for a post so thought I would add it while I remember. I recently reloaded my computer and had to figure out how to add [...]
Hello world!
I have just installed WordPress in a vain attempt to re use my deanpugh.com domain. I have a long list of posts that I have put off uploading because I want to shift over to WordPress. Eventually I want to design my own WordPress theme and install it here, but at the moment, my current [...]
Cheat Sheets
There are a few websites that I read on a daily basis. On MakeUseOf.com I came across a very good article that had a load of 14 Great Cheat Sheets. The first few are to do with Microsoft Office programs, which I wasn’t really interested in. But if you scroll down, that page there are [...]
Stop .net from automatically formatting code
I do a lot of coding for websites, and to do this, I use Notepad++ which is brilliant. When I have to do programming in .net, whenever I do IF statements or loops, .net loves to automatically align everything and try to tidy things up. Now for most people this is a wonderful feature, for [...]
Changing the My Music and My Pictures folders
I have set up my computer so that all my work files are on a seperate hard drive. I changed the My Documents folder to point to a directory on this. I have my own Music folder that I manage, along with the Pictures folder and Videos folder. But Microsoft insist on having a ‘My [...]
Top 65 Free Software for Windows
I am a daily reader of PC Mech. Their link is also on the menu to the right. One of their recent post’s that I have been meaning to blog about is their list of free software for Windows which I have used a few times since. I recently was having a tidy up and [...]
Windows Installer CleanUp Utility
I tool that has become very handy for me on Vista machines is the Windows Installer CleanUp Utility. This little program installs (looks like something to do with Office), and then can be found under the program menu called Windows Install Clean Up. This little Microsoft program then shows you, in a little more detail, [...]
©2012 deanpugh.com Powered by Wordpress
Theme Designed and Created by
