IE 8 Download

The Internet Explorer 8 beta 2 is now available download IE 8 from http://www.microsoft.com/windows/internet-explorer/beta/default.aspx

OneNote Web Exporter - Display OneNote on SharePoint

This free add-on to OneNote gives the user the ability to export a web page view of a OneNote document. You can even export it to SharePoint and use a page view web part to host the webview.html page within a SharePoint site.

http://www.codeplex.com/ONWebber

This add-on sure beats my Word2OneNote.

Even better idea, create a Shared Notebook that is stored on SharePoint, export this Notebook to the same SharePoint library. Now multiple users can open and edit the Notebook and export it back to update the web page.

Hmmm.... wonder how concurrent updates are dealt with?

Sitecore 5.3 Archive Item

Here is the documentation on how to archive a Sitecore 5.3 Item.

http://sdn5.sitecore.net/SDN5/End%20User/Site%20Administration/Item%20Management/Archiving%20Items.aspx

Sitecore Restore Archive Item

Once again Sitecore lets me down as there is no way to easily restore an archived item from the Archive database within Sitecore 5.3. Note that there is no Archive database in Sitecore 6. But for those of us that are still on Sitecore 5.3 until they release some sort of migration tool we still have the Archive database.

Anyway, this guy has a nice post on how to add the missing Restore option for Archived items. http://usoniandream.blogspot.com/2007/07/tutorial-restore-from-archive.html

One thing to note about Archiving items, just because you archive them doesn't mean they still aren't published. To truly archive an item, you should first make it as not publishable, then publish it (this will ensure the page is removed from the web database, then Archive the page, then save it. If you refresh the parent node of that page you'll notice that the page is now gone and now exists within the Archive database.

Job Justifications, Systems you manage... my experience is not good

At my previous employer my manager came to me one day asking me to detail what I work on i.e. what systems do I manage and to provide a weekly percentage of this work in an Excel spreadsheet. I thought ok, he just wants to know what I do everyday. Not quite, 2 months later the company announces they are being acquired by another. People get cut, my manager did, somehow I remained.

What I learned: When a manager asks for this type of information it might indicate the company is about to be acquired.

Current Day: My manager asks all of us to provide information about the systems we support and what we work on weekly. This scares me a little as it sounds a lot like my previous employer.

My list is going to be 10 pages long this time.

Anyway, for those of you out there that encounter this type of situation, either come up with a huge list or pack your bags. In my case, I was young and had a lot of potential, I think that's why I was kept, plus I was making dirt for pay.

SQL 2008 Open Table is gone

Another change that wasn't obvious at first is that the Open Table option is gone when a table is right clicked. I'm sure that was probably ambiguous so MS had to take it out.

The Open Table command has now been replaced with Edit Top 200 Rows.

Well what if there is a row at 201 that I want to edit. Is there no easy way to right click and just open all the rows.

SQL 2008 Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.

I've just started using SQL 2008 and have encountered a very annoying problem. Whenever I change a table I get an error:

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can't be re-created or enabled the option Prevent saving changes that require the table to be re-created.

WTF? I was able to change tables whenever I wanted to in SQL 2000 and 2005 and now I'm not allowed to in SQL 2008. Oh wait, I need to disable some stupid option that shouldn't have been enabled in the first place. To do this follow these instructions:

Within SQL Management Studio click on the Tools menu. Then Options, then the Designer node and uncheck the box that says: Prevent saving changes that require the table to be re-created.

Now we can actually work with tables like we were able to do in SQL 2005. Nice extra step MS, next time make it more difficult to do what we need to do.