Keyboard Face

when you find QWERTY imprinted on your cheek - it's time to go to bed.

Tags

asp CSS css menus dreamweaver flash gallery2 hosting iis7 Javascript jquery jquery ui left mac mssql os9 php printer rdp SEO sql sql server windows wordpress

Backup Instructions

by Leave a Comment

Tom Bristol wrote:

Backup Instructions

How to Back Up Outlook Data File

 

  1. Go to File > Data File Management

 

 

  1. Select the data file you want to backup and click the Open Folder… button.

  1. Copy the highlighted file to your backup location.

 

 

Color Schemes for Your Blog or Website

by

One of the first and hardest part of starting to design a site is to get the color scheme. The scheme can come from a number of places. For example:

  • A site you want to imitate
  • A photo you want to include in the site – for instance in the header
    You can then pull colors from the photo
  • A holiday – certain holidays have color associated with them. Halloween has black and orange, Christmas has red and green, etc.
  • A profession – for instance the medical profession tends to favor blues

No matter where you get your inspiration, it is good to have a few tools to help you. I recently ran across a page that lists a number of these tools:

http://www.kelieresources.com/color.htm

I’ve included the most valuable tools, from my perspective, here:

    That’s it – if you have any others you think should be on this list, let me know and I’ll add them.

@@Identity Best Practices (MS SQL)

by

I just ran across this post that was referenced from an article written on MSDN.

For the past 2-3 years I’ve been working under the idea that @@Identity would return the identity of the most recently added row in the table you were just working with. Not so – it will give you the identity of the most recently added row in the entire database! I believe, however, that @@identity is limited to working within the connection to the database. For instance, if you have 2 scripts and they both add a row to the database, they would be using separate connections to the database and thus wouldn’t be confused. If your database uses triggers and your trigger adds a row in another table, @@identity will return the identity of that row, not the one you want.

The alternative offered in the article is to use scope_identity(). It acts the same way, only without this little idiosyncrasy.