Tuesday, October 26, 2010

VHD

Ok, so my VHD is a little too small for what I'm trying to do.

My local disk is cheap to use - it's built in, and already paid for. Buying another one is not. This is part of the reason I run VHD's - it's much easier to spend only time to stand up a new server, rather than the outlay for a new server box.

That said, if I can get a bigger VHD/Hard Drive File when I need it, VPC/VHD isn't going to do me much good, is it?

I found this great writeup:

http://www.cosky.com/expanding_a_virtual_pc_vhd

Tuesday, October 19, 2010

Groceries

What if you had a list of groceries you wanted to store in a shopping list style list?

How would you do that?

I would define a simple table, like this:



ItemDefault_Qty
Milk1

So then what?? How do you turn that into SQL? Well, that's easy, right?

First you define the table:

create table groceries
(
Item varchar(50)
, Default_Qty int
);

And then you insert some sample data:

insert into groceries (item, default_qty) values ('Milk', 1);

Tuesday, October 12, 2010

Still rebuilding....

I'm still digging out from my PC rebuild.

Tuesday, October 5, 2010

PC Rebuild

My PC is being rebuilt. This is causing me to go off-schedule a bit. Hopefully I'll be back next week.