Dec 30 2009

Missing TFS SharePoint Portal Action Menus

Category: SharePoint | TFS | Team Foundation ServerDavid @ 16:33

My team at work has finally gotten to a good point for migrating our source code for several of our products into Team Foundation Server.  I have been using the Workgroup edition of TFS at home for over a year now and really enjoy the features of both the source control as well as the project portals.  In fact, I haven’t had a single issue with TFS at home which is why when I ran into a puzzling issue with my project portals at work I really got thrown for a loop.  With my new portals I was experiencing an issue on both of my development machines that was preventing various action menus from being displayed on the home page as well as in my document libraries and on other pages.

For instance, if I was in a document library and tried to open the drop down menu for a given document I would get a Javascript error of Object expected generated in the script from the ~/_layouts/1033/ows.js file.  Here’s a screenshot of what I was getting:

image

 

 

So, after spending two days reviewing permissions in TFS, verifying that IE was up to date, working with our local SharePoint expert, and searching on Bing and Google till my eyes bled, I had just about given up.  Then this afternoon I found what I was looking for here. Come to find out my whole issue was the my User Agent string being generated by IE was too long for the TFS WSS instance to handle properly which resulted in the thoroughly baffling behavior I was seeing on my portals.  Since I have every version of the .NET Framework on my machine, plus a slew of other add-ins and applications my UA string was well over 200 characters.  So, to resolve it I made a few edits in the registry to eliminate the nonessential keys being used in IE to generate my bloated UA string.

If you are having these same issues, you can check your UA string length here. And if you need to shorten it, you can find a quick guide for the registry keys to pin point here.

Tags: , ,

Dec 18 2009

Deploying a SQL Schema Update Script from VS2008 DB Edition in SSMS

Category: David @ 13:32

One of the challenges that most every developer faces at one time or another is the challenge of pushing database changes to their production environment.  For some time now I have been using the database management tools in Visual Studio 2008 Database Edition.  One of the great things about this tool is that it allows you to perform both schema and data comparisons between different databases or between the project schema and a database.  Consequently those changes can also be synchronized through Visual Studio or by generating a change script. 

imageIn my organization changes to a database that involve schema objects must be performed by a DBA although the actually SQL scripts are often written by the developer.  The easiest way for me to provide the appropriate script for the DBA is to simply use the Schema Update Script that is generated by Visual Studio by default.  To show the script simply click the “Show Schema Update Script” button.  This will force the Schema Update Script panel to be displayed.  Often I simply copy the text out of that panel and paste it into a text file to send to my DBA.  He can then open the script in SQL Server Management Studio and run it from there.

image While explaining this process to a member of my development team I realized that there is one very important step that you need to take in SSMS to be able to successfully run the script.

By default the Query Editor in SSMS cannot run a query that has scripting in it compatible with SQLCMD.  Therefore it is necessary to turn on the SQLCMD mode in SSMS.  So, here it is, in SSMS simply click on the Query menu and then toggle on SQLCMD mode menu item. 

Now you can run the Schema Update Script successfully!

Tags:

Dec 7 2009

A New Old Friend: Windows 7 and a Tablet PC

Category: Hardware | Windows 7 | Tablet PCDavid @ 12:18

About a month or two ago I started looking into buying an eReader after seeing an ad for the new nook reader from Barnes & Noble. As an avid reader and graduate student I have more than a few books and the prospect of eliminating some of the need for bookshelves is pretty enticing. Ultimately after looking at various devices I discovered that Barnes & Noble provides their eReader software for free here. Once I realized that, I started to expand my search for a device and eventually decided that I could get a lot more functionality from a Tablet PC device for a cheaper price.

250px-Tc1100-2250px-TC1100-1After researching my options for a new device, and given my available funds, I opted for an older HP tc1100 on  eBay for right at the $200 mark. For those who aren't familiar with this device let me give you a quick run down. The tc1100 is a hybrid tablet PC that was manufactured by HP until late 2005. My particular model has a 1.1GHz Pentium M CPU with  2 GB of RAM. It has the ability to operate as a slate style tablet or with a removable keyboard it functions as a standard laptop as well. All that said, it's a modest machine when compared to current Netbook specs.

The great part of this device, and the point of this post, is that this Tablet PC  is just powerful enough to run Windows 7 and take advantage of the great features it has! To be honest, I never really thought seriously about getting a Tablet PC. I always figured that a laptop was good enough for my needs. Well, I wish I had this Tablet a long time ago! Here are a few of the features that have sold me on this Tablet and Windows 7:

1. Free Form Handwritten Notes

image The Windows Journal is absolutely awesome!  At work my constant companion is a notepad, mechanical pencil and a large pink eraser.  I often think best when I am writing things down, but I have also often wished that I didn’t have to deal with having to keep track of the multiple notepads.  Now with Windows Journal I can take as many notes as I want and never have to worry about keeping track of multiple notepad again (much less running out of lead in my pencil, or having to deal with eraser dust!).  There are a number of page templates from regular lined notebook paper to blank pages and graph paper.

2. Web Browsing

There are actually a couple of things I like about browsing the web with a Tablet PC.  The first is that the form factor of this one is just the right size to hold in your hand for convenience without needing to have a laptop in your lap burning your legs.  This particular Tablet has a 10.4” screen and the .  Secondly, since it’s Windows 7 it is the full version of your favorite browser.  I currently run IE 8 as my preferred browser.  One really cool feature of browsing with the digital pen is that I can click on any link and drag the pen a fraction of an inch off of the link and it will automatically open the link in a new tab.  This is a surprisingly convenient and intuitive feature.

3.  Handwriting Recognition

image Windows 7 has a handwriting recognition panel that can be displayed whenever the pen comes into active range of the screen.  This panel provides a dynamically sized area that will convert your handwriting into text.  I have been amazed at how accurately it can decipher my chicken scratch.  There is something about the tactile experience of writing that is quite fulfilling, of course it’s also nice to have a 95% keyboard to make things go a little faster when needed.

 

4. The Hardware Form-Factor

The last thing I’ll touch on in this post is the actual form-factor of the HP tc1100.  There are a huge number of things I like about the “convertible” Tablet PC form-factor.  The ability to minimize the thickness and weight of the device by removing the keyboard is absolutely cool.  I love being able to just carry the screen around without the bulk of the keyboard.  Without the keyboard attached the design resembles a closed Macbook with it’s smooth rounded corners and edges.  The three side hard buttons and jog dial are customizable.  I was even able to add some custom script that locks the tablet when you press and hold it.  Switching between screen layouts is a breeze with the press of a button.  There are even three soft buttons built into the bezel of the screen that perform various convenient tasks.  All-in-all I, along with thousands off others, wonder why HP chose to stop making this particular model when it was absolutely unique to the market (and still is) and has so many great features.

Finally,  If you happen to be on eBay and can get a tc1100 for cheap then by all means I think you should give it consideration. (I recommend going with one that has either a 1.1GHz or 1.2GHz CPU.)  Even if you don’t want to go the older hardware route, go ahead and check out a newer Tablet PC, I think you too will be surprised at what you find.

Tags: , ,

Dec 1 2009

Silverlight 4 Overview @ PDC 2009

Category: .NET | SilverlightDavid @ 13:41

If you haven't been paying attention to Silverlight lately then you may not know that Microsoft released a beta of Sivlerlight 4 during PDC.  Here is a great webcast, presented by Karen Corby, that gives an overview of the new Silverlight 4 features.  Check it out when you get a chance...No, strike that, go right now and watch it!

Tags: ,