Tuesday, December 1, 2009

SQL Server and a Domain Service account

In my last post I described setting up a new server. Well, I also wanted to try learning ASP.Net with IIS and with SQL Server 2008 express. The SQL Server 2008 install documents recommend using a domain user, in fact they require it if installing on a Domain Controller. It took me a couple tries to get an account with the correct privileges to run the SQL Server service. I used the Group Policy Management tool to edit the Group Policy Objects (GPOs) of the domain.

The Web Install wouldn't work, so I downloaded the large file. I then failed the first install, tried to repair, then uninstalled and started over. I messed up the user account and permissions the first time and managed to get them correct the second time. The following two pages help explain what permissions the user (or group the user belongs in) needs.
Finally I had to enable TCP and open the firewall so I could access it from my other computer. As explained in Configuring the Windows Firewall to Allow SQL Server Access.

Windows Server 2008 on old hardware

I thought I would use a computer from 1999 for a server at home. It was a Dell workstation designed for two CPUs. I bought it with just one and a few years later added a second CPU and more memory, later I added a second hard drive. I managed to have one of the fastest computers on my floor in college for at least two or three years.

Now with two 450 MHz Pentium III processors and only 512MB of memory, I decided that the minimums for Windows Server 2008 didn't matter and I would try it on this computer. I wanted to learn more about managing a server. I also wanted to move my other computers at home to a domain so inter-computer sharing would be better managed.

I experience using roaming profiles at work and thought it might help with using multiple computers here at home (my desktop and my laptop).

Here are some websites that I found helpful in this endeavor:
The reason for the middle one is that it seemed to a more correct listing of the security settings for the redirected folders share.

Thursday, September 24, 2009

Shows series that I watch

Here is a snapshot of the shows that I record on an ongoing basis.

  1. Nova scienceNOW, HD Preferred, New & rerun, anytime, keep up to 6 recordings until I watch.
  2. Smallville, 119.4 only, New, anytime, keep as many as possible until I delete
  3. The New Red Green Show, 89.4, New & rerun
  4. The Mentalist, Any, New & rerun
  5. House, 115.4, New
  6. Sesame Street, 89.4 only, New & rerun, anytime, keep up to 3 recordings until space needed
  7. Aurthur, 89.4 only, New & rerun, anytime, keep up to 3 recordings until space needed
  8. Curious George, 89.4 only, New & rerun, anytime, keep up to 3 recordings until space needed

Clear QAM channels on Mediacom




Channel
Number
Network Name Std/HD
82.1 QVC SD
82.3 CSPAN SD
82.7 WGNAMER SD
82.9 SHOPNBC SD
82.19 3ABN (3 Angels Broadcasting Network) SD
82.23 HSN SD
89.4 KIINDT (IPTV) HD
89.8 KIINDT2 (IPTV Learns)
89.10 KIINDT3 (IPTV World)
99.4 KFXADT2 (Fox 28) SD
99.6 KCRG (ABC) SD
99.8 KWKB (The CW) SD
99.9 BYU (Mormon) SD
99.10 KGAN (CBS) SD
99.12 KWWL (NBC) SD
99.16 KFXB (CNT) SD
99.20 MC22 (Mediacom Connections Channel) SD
114.1 KWWLDT (NBC) HD
114.2 KWWLDT2 (this) SD
114.3 KWWLDT3 (Retro TV) SD
114.6 KGANDT (CBS) HD
115.2 KCRGDT (ABC) HD
115.4 KFXADT (Fox 28) HD
117.1 PUAC018 SD
119.2 KPXRDT (Ion) SD
119.4 KWKBDT (The CW) HD

Monday, September 7, 2009

Using NHibernate ActiveRecord and LINQ

I'm trying to learn NHibernate ActiveRecord and LINQ all in the same day. I ran into the following exception:
Session is closed!
Object name: 'ISession'.

When trying to execute the following code:
      public static User FindByUserName(string username)
{
// Note that we use the property name, _not_ the column name
return (from p in User.Queryable
where p.Username == username
select p).First();
}

It took me a couple hours to get by this one, so I thought I would post it. I had to wrap it in a using (new SessionScope()) statement. Like this:
       public static User FindByUserName(string username)
{
using (new SessionScope())
{
// Note that we use the property name, _not_ the column name
return (from p in User.Queryable
where p.Username == username
select p).First();
}
}


Happy Coding.

Riddle

Here's a riddle that I though was pretty good:

It's present everywhere, but occupies no space.
We can measure it, but we can't see it, touch it,
get rid of it, or put it in a container.
Everyone knows what it is and uses it every day,
but no one has been able to define it.
We can spend it, save it, waste it, or kill it,
but we can't destroy it or even change it,
and there's never any more or less of it.
—Jespersen and Fitz-Randolph

Saturday, August 29, 2009

Learning ADO.NET

I had recently tried to write a program which accessed a database and found that I was unfamiliar with ADO.NET which C# uses. Deciding to learn, I started out with Sams Teach Yourself ADO.NET in 21 Days, but found that it was targeted to Visual Studio 2002 and .Net 1.1 and totally missed the current state of Visual Studio 2005 and 2008 and .Net 2.0 and above. Deciding to try again with another book, I'm currently working through Microsoft® ADO.NET 2.0 Step by Step. I have also liked the idea of using SQLite as the database engine since it is totally self contained, so I converted the sample database and have been working through every exercise using System.Data.SQLite instead of Microsoft's SQL Server.

Get the SQLite version of the example database included in the ADONETSBS.exe Sample Files here:
AdoStepByStep.sqlite

Have fun

Monday, August 3, 2009

Software on my computer

Since I'm going to re-format my computer, I figured it would be a good time to list the software on my computers.

General

Programming
Media

Drivers (Laptop)
  • Intel Graphics Media Accelerator Driver
  • MultiTouch Driver *
  • Wacom Enhanced Graphics Driver *
  • Pen Tablet
  • ThinkPad Modem
  • ThinkPad Power Management Driver
  • ThinkPad Power Manager
  • ThinkPad Tablet Button *
  • ThinkPad TrackPoint Driver
  • ThinkVantage Active Protection System *
  • ThinkVantage Fingerprint Software

Other

Saturday, July 25, 2009

Why American beer is 'ice cold'

We recently went to Britain and there they pride themselves with Ale that is served at cellar temperatures (about 55 °F). I thought it actually tasted quite good. I thought about this as I drank my milk this morning and about how cold it was. I realized that we make stuff really cold simply because we can't taste it as well when it's cold.

This is why I give by child warm formula milk but I drink cold milk. Formula milk for infants is sweeter and actually tastes good warm.

So, when you hear one of the ads that the American beer companies have about how 'ice cold' their beer is, remember that this is just a way to convince us that we really shouldn't be tasting our beer at all.

Sunday, January 11, 2009

Lack of good backup programs

I have been trying various backup programs to protect myself in case of a hard drive failure (and with RAID 0, it's twice as likely). I have tried the built in Windows Vista backup, Acronis True Image, and FileBack PC. None of them really seem to meet my needs. I know there is a proliferation of backup programs, but why do none of them work for me?

The requirements I have are the following:
  • If image based, then it can deal with files moving around from defragmentation
  • Makes an image of at least the system drive.
  • Versions the files in an appropriate manner
  • Tracks deletes, but doesn't remove file from backup for a specified period of time (like a month)
  • Can handle all the advanced things in an NTFS file system like sparse files, hard links, soft links, etc.
  • Compression really can slow down a backup; Uses smart compression and only compresses items that will compress. Perhaps a way to track the past compressibility of extensions and let the user select which files are not to be compressed.
  • Allows folders and file types to be excluded from both the image and the file base backup.
  • Can be scheduled through the Windows scheduler
  • File history can be compared using a diff tool
  • Images can be mounted or at least explored
I've used the backup program in Windows 7 Beta, and it's close except it takes too much time. It took 4 and a half days to backup my computer, way too long. Also, what are users of other versions of Windows to use?

Wednesday, January 7, 2009

Will enterprise care about Windows 7?

I don't see why enterprises should move to Windows 7. Most of the features are geared for the home. Maybe the only thing for companies will be Window XP Pro not being sold anymore. Maybe companies should just start pirating it, especially if the fines for that sort of activity are lower than the rising cost of ownership for a new Windows versions.

Microsoft is loosing focus on who really buys computers, the enterprise. Home users are important as well, but not at the cost of the bread and butter for this operating system.

Windows 7 out, no different than leaked version

Well, Windows 7 is out now, and it's the same version that was leaked several weeks ago.

I started writing down problems with it since I installed it. I now have 3 pages of problems written, and I haven't even gotten anything installed. I had really hoped that it would have been more fleshed out, especially with the current build out there for a few weeks for people to test and give feedback on.

Friday, January 2, 2009

Things I hope Windows 7 fixes

I decided to make a list of quirks that I have experienced in Microsoft's Windows Vista (Ultimate) and will check too see if they are fixed in the next version of windows; Windows 7.

Windows Media Center (When connected through a Windows Media Extender and to my TV)
  • Programs that decide to show a window at startup (logon) flash a window over the media extender window.
  • When the computer needs to be restarted for an update, a notification keeps flashing on my TV.
  • There is no on screen keyboard for those forms that web pages like to have
  • There is no virtual mouse for the remote to navigate those web page interfaces.
Networking
  • When I have VMware installed with the virtual network drivers enabled, Windows Vista likes to block me from my own network. It clams that the (unconnected) virtual network cards are Public. If I change this to Private, then they are reset at least every time the computer is resumed if not more often. As long as a single network card is Public, I can't browse the computers, shares, and networked printers on my home network. At least enable this but block the public networks.
  • There is no option to change the name of a network. I am using Hamachi and it can't detect a name, so let me name it.
Backup
  • The backup files functionality only allows for some files, not .exe's and other files that I want backed up because that is how I downloaded them. Common example is installers.
  • It's not clear if the image based backup allows for deframmenting. I don't know of any other image based backup program that can account for files having been defragmented. Windows Vista automatically defragments files, so any image backup program should take this into account. I've usedAcronis True Image Home till now, but can't do differential backups because of the size.
If one of the goals of Windows 7 is to upgrade enterprise computers from Windows XP Pro, it seems odd that the Windows 7 beta installer does not allow for upgrading from Windows XP.

On my laptop, Windows Vista will sometimes freeze for about 50 seconds after logging in upon resuming from sleep. I log in with a finger, so even then I have to wait for it to be done freezing and the wait curser goes away before I can swipe my finger and it is recognized.

Automatic login of notebook computers based on location. Use secured WiFi that are "Home" to verify the cumputer is at home, otherwise prompt for a password upon resuming.

Windows 7 LightScribe DVD Label Image




I have a LightScribe DVD drive, I am also waiting for Stargate Atlantis to record, so I thought I would create a image to burn to the label side of my DVD for when Windows 7 comes.

What I came up with looks like this:



I used Paint.NET for the creation, but I have found definite limitations in the way it handles text. Anyways, to use this for your own LightScribe DVD, open the LightScribe Template Labeler, use the blank template, and then import the PNG below into the program as a graphic, then burn. For best results, click through on the image below for the full size image, then save to your computer.