Archives: September 2009
I'm trying to finish up the last few things here at work before taking the weekend off. I scheduled off the next two days and plan on tiling my bathroom. Tia says it's not really time off, but it's a good project, it's mindless (relatively), I've been wanting to do… Read more
I'm taking the next two days off, heading down into the basement for a four day weekend. Nothing particular going on, just a little stressed with life. Between work here and a busy life with kids, I realized a few weeks ago that I was feeling stressed. So I decided… Read more
create table MyTable (id int)
Create Table #Test (id int)
create proc MyProc
insert MyTable select @id
insert #test select @id
exec MyProc 2
select * from #test
drop table MyTable
drop procedure MyProc
I saw a question recently about temp… Read more
I stumbled on this article about a spin-off from MIT using solar power to create hydrogen. I think it's a great idea, one that I'd like to have working in my house, but it's not as simple as having a storage tank and a solar panel.
To me this… Read more
I actually got back from camping Sat night, but since I wasn’t scheduled to come back until Sun afternoon, I avoided the computer. I let both the desktop and laptop remain at idle, not even checking personal email until Sun night.
When I checked Sun night, I saw a newsletter… Read more
It seems that often I see posts that say “I’m out of space on my drive, what do I do?” The answer, as with most anything in SQL Server is, it depends.
The most common issue I see for running out of space is the lack of deleting database… Read more
This is a great write-up that shows what is important in a phone. It's how you interact with it, not the features, not the specs, it's how you use it.
I tend to agree with that. With both the G1 and the iPhone, the interaction with the device for the… Read more
I've been wanting to play with the Chroma Key features of my video editing, but I haven't really spent time on it. Today was the day that I tried it, and it worked out pretty good.
With snow coming down outside, I needed to shoot in the basement. I have… Read more
I was reading the most recent issue of TechNet from Microsoft one morning and flipped through the column on SQL Server. This is one of the few paper magazines I get, and for some reason I see things in there that interest me.
It’s not the topics, but often the… Read more
We have a couple of boxes at a local Denver co-location facility for the training business, SQL Share. Our firewall died a few weeks ago, and so I called a friend that I've typically used for network stuff. He found us one on eBay for $200 and last night… Read more
The more I think about this, the more I think it should be built into SQL Server as a default. Why not ask for the information to create an operator and email at install and then create a few nice default alerts, like one for which log is full Read more
I started watching Leverage this season, after it was recommended by Wil Wheaton (blog/twitter). For those of you that don't know Wil, he is an actor and writer, best known by me for playing Wesley Crusher on Star Trek: The Next Generation. I had been working… Read more
I noticed that the keys on my laptop were pretty dirty the other day. The heavily used ones have a nice brown stain in places, mostly from just skin oils, and normally I don't notice them, but it bugged me one afternoon, so I wanted to clean them.
How do… Read more
This would probably be a good editorial, but I thought I'd drop it out here as a short note.
You ought to be tracking the build (or version) of all your SQL Server instances and Windows. I'd suggest you automate this, maybe even drop it in a table in every… Read more
The Prius is having a few issues. I’ve had a slow leak in a tire that required two trips to the tire guy to get fixed. It wasn’t so bad since I had to get an oil change as well. I combined a few trips and things worked out well. Read more
All the Denver area groups are having their meetings this week. If you're in the area, try to attend a meeting. You'll meet some great people and learn a few things.
- Boulder SQL Server User Group - Tuesday night, Sept 15, 2009, Level 3 in Broomfield. A discussion on…
I saw a post recently that asked about backing up the Resource database. The person said they just realized that it wasn't included in their backup scheme and was worried.\
Don't worry, you don't need to back it up.