Sometimes I need to import file information into SQL Server, or just get a list of files, sizes, etc. Normally I use the dir command, but it generates a fixed layout that is sometimes difficult to parse.
Read more →
This is Part 2 of the series on the for command. In an earlier article I covered using for to deploy SQL scripts against multiple servers. I'm going to enhance this a little by specifying multiple databases as well, and generating server and database lists automatically.
Read more →
I've already posted an example in a previous article, and I'm going to post a couple more on neat things you can do with the DOS for command.
I recently helped out a friend with a method to deploy stored procedures to multiple servers.
Read more →