One of the best sources of free Windows system utilities is Sysinternals. Their Autoruns utility shows everything that gets auto-started when you machine boots. It checks more locations than the MSConfig utility does.
I must have been sleeping under a rock, but when did “Upsert” become a word? It refers to the combination of insert and update statements for a RDBMS. What it means is: add the row it does not exist, otherwise update the row using the primary key.
It would be cool if SQL Server had this feature. There have been a few times where it would have been useful, mainly with batch operations. In those cases, I wrote stored procedures to handle upsert operations. At the server level, it should be trivial to implement an upsert statement as opposed to manually coding it in SQL.
It was pretty hot Sunday afternoon. While Laura was napping, Kathryn and I went down to ToysRUs and pciked up some backyard toys. We grabbed a Wham-O Slip ‘N’ Slide and a pair of pump action squirt guns.
We went with the cheapast Slip ‘N’ Slide, the $4.95 model. It was well worth every penny, I wouldn’t get the fancy models, everything they want is in the basic model. I hooked it up and Kathryn had tons ‘O fun with it while I tried to inflate her pool.
We have an Aero pool that we bought last year on E-Bay. It’s a great little pool, but you can only inflate it with their rechargable pump and the pump needed a charge. While Kathryn was slipping and sliding, I was try alternative methods of getting that thing inflated. I have a small electric pump that I use for tires and I tried that, but after 20 minutes, it wasn’t pushing enough air in. The Aero pool has a large opening for air, it’s pump inflates the pool in just a couple of minutes. It was time to bring out the heavy artillery. I grabbed Anne’s hair dryer it was the same diameter of the pool’s intake. I was able to get the pool 95% inflated (close enough for toddler use) in about 40 seconds with the hair dryer.
By this time Laura was awake and wondering what was going on. She didn’t like the pooln last year and I wasn’t sure what her reaction would be this year. She was hesitant on going in, but when Daddy picked her up and swung her through the water, she started having fun. Then it time to go Slip N Sliding with her sister.
While Laura was napping and I was letting the tire pump attemp to inflate the pool, Kathryn and I broke out the squirt guns. We had some fun, but first we covered the rules of Squirt Gun.
- Don’t squirt Mommy
- Don’t squirt Grandma
- Don’t shoot the dog
- It stays outside.
With the ground rules out of the way, we had lots of fun. I’m not used to being outgunned by 5 year old, it’s a good thing I can still out run her.
It turns out Aero has an AC only pump, but it costs almost what I paid for the pool. And it’s out of stock.
Hot .Net Tip: This will save you a lot of time
Here’s a quick tip for adding the “View code” and “View designer” buttons to the main toolbar. That way, they are always visible.
Everything you ever wanted to know about color. I found the bits about color blindness to be very interesting. When we design programs and web pages, we always have someone with severe red/green color blindness use the program to make sure it’s readable to him.
When I was growing up, one of my friends that lived down the street had red/green color blindness. He would come out to the bus stop wearing strange color combinations. We would send him back in to pick other clothes. I assume that these days, his wife gets that task.
This is good article about the best practices for performing sting comparisons in .NET 2.0. It’s interesting to see how code written for English can behave badly when used with other languages.