For the most part, the Disk Defragmenter application (located at %SystemRoot%\system32\dfrg.msc) that comes with Windows XP does a decent enough job of defragmenting a hard drive for most users.
But if you’re a developer, you are not like most users, often dealing with very large files and installing and uninstalling applications like there’s no tomorrow. For you, there are a couple of other free utilities you should have in your utility belt.
Recently I noticed my hard drive grinding a lot. After defragmenting my drive, I clicked on the View Report button this time (I normally never do this out of hurriedness).
A few days back Jon Galloway and I were discussing a task he was working on to document a database for a client. He had planned to use some code generation to initially populate a spreadsheet and would fill in the details by hand. I suggested he store the data with the schema using SQL extended properties.
We looked around and found some stored procs for pulling properties out, but no useful applications for putting them in there in a nice, quick, and easy manner.
A few days later, the freaking guy releases this Database Dictionary Creator, a nice GUI tool to document your database,...
UPDATE: In one comment, szeryf points out something I didn’t know and invalidates the need for the tool I wrote. This is why I post this stuff, so someone can tell me about a better way! Thanks szeryf! I’ve updated the post to point out the better technique.
Based on my recent spate of posts, you can probably guess that I am working on improving a particular build process.
In this situation, I have a pre-build step to concatenate a bunch of files into a single file. I tried to do this with a simple command like so:
FOR %%A in (*.sql)...