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 →
Bored with SQL Server? Looking for something new, and/or cheaper? Got a bunch of interesting alternative databases:
I've mentioned REL and VistaDB previously. VistaDB has made some significant improvements since then (including a 60% reduction in engine size, to 400KB!
Read more →
Article text moved here.
Legacy Comments
rr
2006-02-15
re: The For Command: Part 2 - Multiple Tokens, AutoGenerate Files ok
Read more →
Article text moved here.
Read more →
I've set up a new category on my blog where I plan to post some articles about using command-line utilities to perform various tasks for, or in support of, SQL Server.
Read more →
I almost feel like I'm making a career out of bashing MySQL. Make sure to check all the links and read the comments. Especially "Ode to a MySQL Fanboy" :) Seriously, it is probably the most succinct observation ever made.
Read more →
Dare Obasanjo has an article called the XML Litmus Test to determine if XML is appropriate for certain applications. It seems to be an elaboration on a response he made to my earlier rant, although I doubt that was the entire motivation.
Read more →
OK, the review is kinda lame, but the comments on this Slashdot book review are pretty good, many of them really funny…but oh so true. I won't go into my opinions of MySQL…ooops, too late.
Read more →
I will use Bill Graziano, Ken Henderson, and Fernando Guerrero as my examples for this:
Pick a good topic, cover it thoroughly, and try to provide more than what's expected (Graz, Ken, Fernando) Create good slides that are descriptive enough so that notes aren't required (Graz, Ken, Fernando) Provide handouts anyway, in case you want to take notes (Graz, Ken) Allow for a Q&A session (Ken), or allow attendees to ask as you present (Graz).
Read more →
I just got out of a presentation on “Performance Tuning and XML Support in MS SQL Server 2005”. Here are some high/low-lights:
Zero discussion on performance tuning, except for “use showplan, it's great”.
Read more →
Fabian Pascal responds to an article on Slashdot about XML and Relational Databases. Slashdot discussion and feedback on it is especially entertaining. More kind words from Fabian add to the verbal melee.
Read more →
Damian was kind enough to send this little nugget: http://sql-info.de/mysql/
It's not exactly a debunking of MySQL, but it does have a list of what it describes as "gotchas" regarding MySQL's behavior.
Read more →
If you want to learn things about SQL Server that you'll never find anywhere else, you must read Ken Henderson's Guru's Guides to SQL Server. I just got his most recent book, The Guru's Guide to SQL Server Architecture and Internals, and like his previous books it is amazing.
Read more →
...but endlessly cool nevertheless:
http://www.rednova.com/news/stories/1/2003/10/02/story001.html
Read more →
About a month ago I was asked by a contractor I work with who needed to import some very plain, fixed-width, ASCII text file data into SQL Server. In fact, this SQL Team post is very much like his situation, in that he also was going to convert PLAIN, FIXED-WIDTH, ASCII TEXT (did I mention that already?
Read more →
As Damian pointed out, you can do a lot of cool things with DOS command-line functions. Lately I'm particularly enamored of the for command.
The DOS for command works like a for.
Read more →
Figured no one would remember this blog next year during the presidential election... :)
So now our rampant SQL Team egos can rant unchecked by the need to remember we too were once SQL n00bs who didn't know anything!
Read more →