So I have some recurring tasks running on an old server running Windows Server 2003. One of these tasks likes to fill up the directory %windir%\temp (usually that’s C:\windows\temp) with lots of files, which – if I don’t watch it – results in the C: drive filling up. Disk cleanup doesn’t clear out files left… Continue reading Deltree on Windows Server 2003
I was recently trying to find out how to automatically set the date on a windows machine(windows XP, but solution here should be generic I think). I tried using the system date and time setting “Automatically Update Time”, but that failed because the date was different/wrong also (contrary to this info from MS (http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/windows_date_it_overview.mspx?mfr=true) it… Continue reading Automatically update the System Date and System Time in Windws XP (and beyond!)
In processing some XML into an SqlServer db it can often be useful to have the element name or the parent element name output, depending on how your xml data is organised. Below is an example of using meta properties in MS SQL Server for just this purpose.
Using SQL Server Managment Studio to connect to various database servers, where these servers have a naming convention that is not intuitive (to me at least), one may be frustrated trying to quickly recall which server connection is for what just by having a glance.
So, you want to run a query in sql server and get the output into a fixed record format flat-file / flatfile? This solution involves some manual process and the use of excel (though other spreadsheet software may work as well).
For the last few days I’ve been annoyed that some of my application icons have been ‘lost’, reverting to some default system icon. This was particularily prevalent for applications pinned to the Windows 7 Taskbar. Most detail I found involves rebooting the computer, but I tried a slightly different approach just now and it has… Continue reading Restoring lost icons on Windows 7 Task Bar
On Windows 7 I very quickly got used to use the window snap feature. You can hold the windows-key and then use the direction keys to snap the window to the side of the screen, and it takes up half of your screen real-estate. I am often comparing window content so I find being easily… Continue reading Snap windows to an area of the screen in XP, Vista just like on Windows 7