I was worried about disrupting an active install of SQL server and wasn’t sure where the installation file was for the management studio on the disk.

Many other blogs, help files, and forums said to look in a Tools folder of the installation disk.  No such luck for me.  The company I’m working at is subscribed to the Action Pack which is why, I’m guessing, the disks were a bit different.  No tools folder.

If you’re subscribed to the Action Pack, there is a two disk set.  Simply pop in disk 2.  You won’t see an individual installation file for the management studio, but no worries.  The setup program will let you choose which components you wish to install.

It’s likely that when someone was installing your SQL Server that they didn’t bother with the second disk.  If you’re looking to add a new Maintenance Option (for say, making automated backups), Management Studio Express isn’t going to help you.  When you right click, the only option you get is ‘refresh’.

After installing the real mccoy (and starting the Agent XP service by right-clicking on it), the New Maintenance Option was available when selecting the Maintenance Plans folder in the object explorer.ex

Hooray for the full version of Management Studio and automated daily backups.

And also a big thank you for the backup scripts located here: http://www.sql-server-performance.com/2007/creating-backup-jobs/

How do you know if a domain name is really available?

When you want to reserve a domain name, just typing it into the browser isn’t a good enough check to see if it is available.  Someone might have registered but didn’t set up any DNS or hosting for the domain.

To find out for sure if a domain name has been registered or not, you’ll need to visit a domain name registrar and do a search either through their registration process or through a whois lookup.

This is what returns for Niftygeek.com at Godaddy after doing a whois lookup.  I prefer to use the network solutions whois lookup but I used the godaddy whois lookup just for the heck of it.

I have to preface with a note that I registered this domain quite some time ago.  They send me notices every so often that the contact information has to be correct for the domain.  I didn’t do it correctly and I haven’t yet updated it.  I’ll should make that a priority to fix. [Note, I've since updated it to the correct contact information]

That said, here is the results from the whois query for niftygeek.com:

The whois results for niftygeek.com courtesy of godaddy.com

You don’t have to use the whois tool.  You can check if a domain is available simply by starting the domain purchasing process available on the home page of either Network Solutions or Godaddy.

As a side note, for more choices in price or different types of top level domains there is the complete list of Accredited Domain Name Registrars.  This is useful to have on hand when someone needs to register a .tel, .info, or .aero instead of a .com.  This will show you not only the list of registrars but when ones are allowed to let you register which top level domains (a top level domain means .com or .net or .org, etc…).

If you are registering a domain and you are not entirely sure what to choose, you could give domain tasting a shot.  Domain registrars are required to offer a five day grace period during which time you can get a full refund for the domain.  This is good to use for instance if you have ten options for your domain, but you would like to see if any traffic will naturally be going to one over the others.  The benefit should be clear there.  Free traffic!  Unfortunately, people abuse this to register thousands of sites at once to determine advertising viability to create useless websites.

An overview of DNS (short for Domain Name System) is a system for giving you different types of information on request about a domain name.

A request made to a DNS server about a domain name is called a DNS Query.  These requests happen any time someone sends an email or tries to load a web page.

As professor Sanford used to say (one of my B.C.C. College professors), people like names and computer like numbers.  People find names easier to remember.  Computers like numbers.  They’re easier to distinguish.

Any time you type a domain name into your web browser, this translation between a name to a number happens.  Your computer browser takes the domain name that has been entered and asks a DNS server where that web site is located.  DNS responds with a number.  A specific kind of number.  An ip address.

DNS does more than the name to number translation, but that’s a great starting point.

I type in yahoo.com and hit enter in my web browser –> Internet Explorer or Firefox or Safari asks this computer’s DNS server for the IP address of that server –> The web browser makes a request to that IP address.

If all goes well, the web server is contacted by it’s IP address and responds with the page that I’ve requested.

After entering the domain name and pressing the enter key on your keyboard, the DNS request begins

Here is a typical browser request in a series of steps.

• You type in a domain name and press enter in your browser.
• Your computer checks a local hosts file to see if there is an IP address set for that domain name
• If not, it checks the DNS servers that your computer was assigned when it connected to the Internet.
• The DNS server checks its locally cached records to checks the DNS servers that are authoritative for that domain.
• An IP address is given back to your local computer.
• Your web browser sends the IP address, domain name, file requested, any post data, what browser you are using and a slew of other information at that IP address.
• If all goes well, the correct web page is returned to you by the web server at that IP address.

How many computers are involved in one web request?  Well, there’s your computer, the server with the web site on it, your ISP’s DNS server, the authoritative DNS server of the website.  If you take into account the number of servers it takes to keep all the records up to date for DNS, there are more, though I’m not sure how many.

Here is a youtube video describing and overview of a successful DNS request.  I think I could do better.  I’ll give that a try at some point.  Here it is for now.