Geeks With Blogs

The Wrecking Bawl Destructuring query language, one keyword at a time. January 2007 Entries
SQL Server and daylight savings changes
In case you don't already know, Daylight Savings Time starts three weeks earlier and ends four weeks later this year than in previous years. This does not affect SQL Server directly because it uses the Windows clock as its clock, but you might have some stored procedures, views, or functions that try to calculate DST based on the old dates. If you think you might, try running the following on each of your databases. Feel free to change the "LIKE" arguments or add "OR" clauses. -- proceduresSELECT ......

Posted On Tuesday, January 30, 2007 8:53 PM

Perific wireless mouse
So I decided a while back to get a new mouse that would ease my shoulder and hand pain, and I happened upon this. Well I've been using it for a few weeks now on my Dell 4550 with Windows XP, and I thought I'd share my thoughts on the Perific wireless mouse for anybody considering a new mouse. Pros If your posture is good (or if you start trying harder to straighten your shoulders), it really does seem like it's good for the shoulder and whatnot. It's very easy to use it in your hand rather than on ......

Posted On Tuesday, January 30, 2007 8:12 PM

idea for McDonald's commercial
I have a fun idea for a new McDonald's commercial. It opens with the latest jingle (bah dah bah bah bah), followed by Ronald McDonald driving his Hummer up to the edge of a rainforest. He precedes to light the rainforest on fire, and as he watches it burn, he eats several Big Macs and throws the wrappers on the ground. Then we cut to a fatter Ronald McDonald testifying before Congress that global warming isn't really happening. Then we cut to an even fatter Ronald marching the cows into the slaughterhouse ......

Posted On Monday, January 29, 2007 8:39 PM

silly meteorologists (if that is your real name)
Has anybody else noticed that the weather forecast makes no logical sense sometimes?  On occasion the low for one day is higher than the high for the next day.  How can there be a gap?  The only answer is that the forecast is not for a 24-hour period, which is just weird, even though people generally don't care what the weather will be like between midnight and 5 A.M.

Posted On Thursday, January 25, 2007 10:27 PM


This is a great explanation of the mssqlsystemresource database in SQL Server 2005 and how to look at what's inside it even though it's hidden.

Posted On Thursday, January 25, 2007 4:25 PM

I'm about to say something that many people will disagree with:  Siamese Dream, the Smashing Pumpkins album, may be the best-produced album ever.

Posted On Thursday, January 25, 2007 1:05 AM

the ideal vehicle
Here's what I want in a vehicle. I think so many people in the United States want the same thing (or something similar) that it's ridiculous that there's nothing for sale that even approaches it. - it should be 100% recyclable - it should be a plug-in hybrid and get around 80-90 mpg (if possible with the previous requirement) - it should contain airbags all over the place (along with all the other good safety features) - it should have night vision - it should be all-wheel drive - it should have ......

Posted On Monday, January 22, 2007 11:29 PM

shows to watch
If you're looking to watch some new (i.e. new to you) shows on DVD (thru Netflix or whatever), here are some recommendations:Six Feet Under: completely original and addictive, very emotionalLost*: riveting and original storyline, good casting, marginal dialog Entourage: light and funny, and a nice view of what an acting career can be like Weeds: funny, original The West Wing: smart, great acting, great dialog * I've only seen the first season of Lost, so I can't comment on anything after that. ......

Posted On Monday, January 22, 2007 6:54 PM

It's great to be echoed...
I love this article, it echoes my thoughts from yesterday about how high gas prices are a wonderful thing (yes the article is nine months old, but I just saw it for the first time, and it's still valid): To add to what I said, it's not just high gasoline prices that we should be hoping for, it's high ENERGY prices. I'm sure this is obvious to most people, but I'll state it anyway: the higher the price of energy, the less people will use. I've communicated with Jorge ......

Posted On Friday, January 19, 2007 11:43 PM

C# loops: Performance Iterating Generic Lists

This is a very interesting post, the important thing to take away being that using "for" rather than "foreach" seems to be noticeably faster in big lists.

Posted On Friday, January 19, 2007 10:12 PM

The time for high gas prices is now...
Unless you don't like science (defined here as knowledge derived through observation and experimentation) and would prefer to live in the Dark Ages, it should be clear that humans can't continue polluting Earth without severe consequences. There are several kinds of people in this world: those who believe that non-cyclic global warming is happening (whether they care or not); those who know nothing about it because they're too concerned with their own lives (rightly or wrongly); those who believe ......

Posted On Thursday, January 18, 2007 11:50 PM

What separates an expert from a guru?

The brain of an expert has been trained to access a good deal of the knowledge that he or she has attained through study and experience in his or field.  The brain of a guru can readily access almost anything about his or her field that he or she has learned, but at times can also see beyond that to find solutions that are new or unheard of.

Posted On Wednesday, January 17, 2007 6:18 PM

ListBox bug in C#?
I don't know if this would be considered a bug or not, or if I'm just missing something, but when you use ListBox.DataSource in Windows.Forms (.Net 2.0), and you add or remove an item from an ArrayList that is set as the DataSource, there is no method to refresh the listbox. The only thing I know that works is setting the DataSource to null and then setting it back to the ArrayList. That just doesn't seem right. addendum (the next day): I may have found another bug! When I move an item up or down ......

Posted On Wednesday, January 17, 2007 1:15 AM

new words
It's always bothered me that there's not a single word for multiples of ten and a single word for multiples of five. It bothers me because society determined long ago that these "round" numbers were far more important than others (e.g. the 75th anniversary gets far more attention than the 74th). To that end, I'm creating two new words. decager: any integer containing a zero in the ones column; examples are 0, 10, -20, 250, 370 quinteger: any integer containing a zero or a five in the ones column; ......

Posted On Tuesday, January 16, 2007 4:52 PM

missing Windows versions?
Did anybody ever figure out what happened to the 91 versions of Windows that should have been between Windows 3.0 and Windows 95?  I'm pretty sure I never saw them...

Posted On Thursday, January 11, 2007 9:46 PM

checking for RESTORE permissions with C#/SQL
In case anyone's interested, here's a line of C# that lets you check to see whether the selected user (Windows or SQL) has RESTORE permissions on a specific database. It uses SMO, and you'll need to use System.Security.Principal to get the Windows user logged on to your application, if not using SQL authentication. Pull out the stuff in quotes if you want to try it in Query Analyzer. This page is helpful in understanding the RESTORE command and who should have permissions to run it. Boolean canRestore ......

Posted On Wednesday, January 10, 2007 8:20 PM

I should be a professional proofreader...
It never ceases to amaze me how little proofreading goes on at major media outlets. I can't remember the last time I went a full day without seeing a mistake. Check out the sentence below from an article on both the Houston Chronicle's website and the Boston Herald's website: "U.N. Secretary-General Ban Ki-moon is concerned that U.S. bombing in southern Somalia could escalate hostilities and harm civilians who are reported to have been killed in the airstrike, a spokeswoman said Tuesday." ......

Posted On Wednesday, January 10, 2007 3:56 PM

compatibility mode
This is an interesting post about how compatibility mode in SQL Server 2005 can really make a difference: If anybody has run into any other gotchas or whatever related to the compatibility mode, I'd love to hear about it. I once tried upgrading a db from 80 to 90 and got so many errors it was unbelievable, mainly because of "incorrect syntax" or "ambiguous column name" in stored procedures. The following is from the BOL, I'm posting ......

Posted On Thursday, January 4, 2007 4:15 PM

Copyright © Alex Bransky | Powered by: