7/29/2005

handy sql

Filed under: Housing — Hoosier @ 2:48 pm

So I don’t have to spend 2 hours searching for this yet again:
sp_change_users_login @Action = 'Report'

And, for those using WSUS looking for some nifty queries:
SELECT [LastReportedStatusTime],
[IPAddress],
[FullDomainName],
[ComputerModel],
[BiosVersion]
FROM [SUSDB].[dbo].[tbComputerTarget] order by ComputerModel, BiosVersion

SELECT COUNT([IPAddress]),
[ComputerModel],
[BiosVersion]
FROM [SUSDB].[dbo].[tbComputerTarget] group by ComputerModel, BiosVersion order by ComputerModel

Update 08/29/2005:
SELECT COUNT([LastReportedStatusTime]) AS Number,
[FullDomainName]
FROM [SUSDB].[dbo].[tbComputerTarget] group by FullDomainName order by Number DESC

7/25/2005

Red Rabbit

Filed under: Books/Reading — Hoosier @ 9:59 pm

I just finished reading Red Rabbit, by Tom Clancy. While reading, I got a little confused by the timeline. Using the power of Google, I found that others are just as confused as I am.

Oh, and what I thought was the last of the Jack Ryan series isn’t, so I need to go find The Teeth of the Tiger.

But, I think I’ll switch to Joel on Software first, I need some non-fiction in my book diet.

7/22/2005

More rain

Filed under: General — Hoosier @ 9:41 am

We got another .9 inches of rain last night, and we lost a tree in the front yard. Looking at the stump/trunk, it looks like there was an injury of some sort to it at a young age that weakened it pretty badly. Now I’m glad I didn’t bother trimming it earlier this year.

7/19/2005

WSUS and Update Rollup 1 for Update Rollup 1 for Windows 2000 Service Pack 4 (KB891861)

Filed under: Housing — Hoosier @ 10:55 am

Looks like MS had some issues with the initial release of the Win2k SP4 Rollup package. They have expired the original update and released a new one, so if you think you’ve approved it, you haven’t.

It only took me 10 minutes of searching around on the web to figure out that I wasn’t going insane.

7/18/2005

Garage drywall done

Filed under: General — Hoosier @ 11:52 am

Updating a previous entry, Mom and Dad insulated the garage last week and I took Friday off to help hang the drywall on the walls. 12′x54″ drywall makes things go real fast when you only have to trim the bottom of the bottom sheet and make a few other cuts. It took us just over a day and a half, including several delays due to rain on Friday and the sweltering heat both days.

Now, somebody has to tape, mud, sand, tape, mud, sand, prime, paint and paint everything….

7/13/2005

Rain

Filed under: General — Hoosier @ 8:59 pm

Thanks to what’s left of hurricane Dennis, Champaign is getting something like real rain. I’ve had nearly 2″ so far. And, like ck, I’m worried about what mowing my yard is going to be like once it dries out.

7/6/2005

Highlights from this week’s Carnival of Education

Filed under: General — Hoosier @ 6:52 pm

Reading over this weeks Carnival of Education, a few things jumped out at me:

  • Ever heard of MySpace.com?
  • A 10 paragraph report assignment generates a parent mailing surveys to every other parent? Maybe I’m missing something, but if there really weren’t any other smaller reports leading up to this, then I think the parent might have a valid complaint. The teacher should be giving more detailed expectations, as mentioned in the comments.
  • With quotes like this, Mr. Babylon needs a book contract, NOW!

    It was perhaps the most awkward six minutes of my life. Everyone just sat there, crammed into the little student-desks in the bare-walled, stifling hot classroom, staring at the floor.

  • Computers in the classroom are a touchy subject for me, but suggestions to teach more computer repair/troubleshooting skills to high school students that want to learn are right on the mark. Heck, that’s how I got my start, and just look at me now! (Also check out the same guys wonderful details on massive TRS payouts in perpetuity.)
  • Maybe my t-shirts and jeans aren’t appropriate for working at the school district, but I’m hardly ever there during the school day.

Powered by WordPress