I subscribe to many of the KBAlertz feeds, one of which is for SQL Server. Sometimes the titles of these things just demand you take a look at them.
“FIX: A stack overflow exception may occur, and SQL Server 2000 may unexpectedly close when you submit a query that uses the UNION ALL operator more than 255 times”
I’m not positive, but I think this code has a future on the Daily WTF.
Microsoft’s SyncToy, used to synchronize folders between computers. Here’s their marketing blurb:
“SyncToy is a free PowerToy for Microsoft Windows XP that provides an easy to use, highly customizable program to help copy, move, and synchronize different directories. Most common operations can be performed with just a few clicks of the mouse, and additional customization is available without adding complexity. SyncToy can manage multiple sets of directories at the same time; it can combine files from two folders in one case, and mimic renames and deletes in another.
This is pretty cool! I got this in an email yesterday:
“For PDC05, we will be making available the breakout session content available not only as Microsoft PowerPoint files but also as Microsoft Office OneNote® 2003 files. Take notes during presentations the easy way! To help you take advantage of this, Microsoft is offering you one free copy of OneNote 2003-a $99 USD estimated retail value. OneNote is the popular note-taking program for desktops, laptops, or Tablet PCs.