Archive

Archive for September, 2009

Can’t Synchronize TFS Warehouse after upgrading SQL Server to 2008

September 29th, 2009 No comments

I recently upgraded our TFS server from SQL 2005 to SQL 2008.  Since then, my remaining work report hasn’t run.  This makes me sad.  Bill Wang explained the reason for this and I’m grateful for it.

In a nutshell, there needs to be an assembly redirection.  This takes place per a couple settings in two (2) different web.config files.  Modify the config files in C:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Web Services\Warehouse\web.config AND  C:\Program Files\Microsoft Visual Studio 2008 Team Foundation Server\Tools\SetupWarehouse.exe.config as follows:

      <dependentAssembly>
        <assemblyIdentity name="Microsoft.AnalysisServices"
                          publicKeyToken="89845dcd8080cc91"
                          culture="neutral" />
        <bindingRedirect oldVersion="9.0.242.0" newVersion="10.0.0.0"/>
      </dependentAssembly>

Restart IIS, then send Bill Wang a thank you note!

Tags:

Windows 7 Sticky Notes Grievence

September 28th, 2009 1 comment

Windows 7 Sticky NotesSticky notes are cool.  I love taking a quick, digital note with the assurance that it will both be saved and save the environment; albeit one leaf at a time.  No need to litter the cubicle with 3×3 pieces of paper, right?

So Microsoft lifted a decent idea from MAC with the sticky notes as a widget in Windows Vista.  It’s even better in Windows 7. BUT!…There’s always a big “BUT”.  Let’s talk about Windows 7′s big “BUT”.

You know that little “x” at the top right of all of your windows applications since, oh I don’t know, Windows 3.1?  Closes the application, right?  WRONG!  Apparently, Microsoft decided to make it DELETE YOUR NOTE in Windows 7.  If I was a swearing man, now would be the time.

In Microsoft’s defense, you’ll be warned with a dialog like so:

StickyWarn

If you’re like me, you checked the checkbox long ago and forgot all about it.  If you want to bring the warning back, you can do so by modifying your registry.  Set the \HKCU\Software\Microsoft\Windows\CurrentVersion\Applets\StickyNotes\PROMPT_ON_DELETE DWORD to “1″.

Microsoft trained me for years to press Ctrl+S to save and then click the “x” to close the application.  My sticky note was a victim of Pavlov’s theory.

Tags:

Safe Internet Browsing: OpenDNS, AdBlock Plus, Profanity Filter for Greasemonkey addon and Firefox

September 27th, 2009 No comments

I logged onto Facebook this morning and one of my “friends” had posted a link to something he thought was funny.  It had profanity in the title.  I’m not a fan of profanity, but didn’t want to flat out block my friend, so I went in search of a profanity filter at UserScripts.org. To my delight, I found one and it works great!  For the script to work, you’ll need Firefox, Greasemonkey and the Profanity Filter (install in that order).

I’ve been a devout Firefox convert for a couple years now.  While impressed with Chrome and Safari, I just can’t leave Firefox.  I’ll even concede that, “in my humble opinion”, IE 8 SEEMS FASTER THAN FIREFOX?!  GASP!!! Dare I say?  Nevertheless, the “Add On” features of Firefox will keep me a Firefox user unless the competition does something about it.  Here are my top 5 “Can’t Live Without” add-ons:

  1. AdBlock Plus – I haven’t seen an ad on a website in a couple years.  I bet I wouldn’t recognize half the sites I visit if this add-on was disabled!
  2. Firebug – a web developer MUST have (features in Safari and IE are comparable, but not up to par)
  3. GreaseMonkey – Runner user scripts to make the net more enjoyable.  Here are a few of my favorite scripts:
    1. ExpertsExhangeFilter
    2. Google Account Multi-Logon
    3. PROFANITY FILTER (keep reading)
    4. Facebook Purity: For those annoying survey results on Facebook…blah!
  4. CoolIrisThe coolest way to search Craigslist!
  5. TwitterFox (recently renamed to Echofon, horrible name!) / TinyURL Generator – used in conjunction! :-)

While I’m on the “safe browsing” kick, please check out OpenDNS.org.  Thank you OpenDNS.org, Mozilla, Greasemonkey and the countless open source developers for helping me keep the garbage out of my house!  Surfing without OpenDNS, AdBlock plus and Profanity Filter is like driving without your seat belt fastened.

UPDATE:  This Profanity Filter script for Greasemonkey seems to work with far less latency than the aforementioned.  It also allows for customized replacement strings.

Listing checked-out files in Team Foundation Server 2008 (TFS)

September 18th, 2009 No comments

I needed a list of all checked-out files in TFS today.  This page came in handy! Thanks Clay!  Here’s what he had to say (slightly modified for VS 2008)

You can get a complete list of checked out files by using the tf.exe command line tool found in: C:\Program Files\Microsoft Visual Studio 9\Common7\IDE or C:\Program Files (x86)\Microsoft Visual Studio 9\Common7\IDE for you 64 bitters.

All checked out files in $/MyProject:

tf.exe status $/MyProject /user:* /s:http://MyTfs:8080 /recursive

All files checked out to Mark:

tf.exe status /user:mark /s:http://MyTfs:8080

You can write the output to a file:

tf.exe status /user:* /s:http://MyTfs:8080 > c:\tfsCheckedOut.txt

I also created this little batch file that will automatically output results to your desktop. It’s very simplistic, but saves time having to mess with the command prompt. Edit with your favorite text editor, save, and away you go.

Synergy: Share Mouse and Keyboard between multiple computers with different operating systems

September 10th, 2009 No comments

Synergy rocks. In their own words:

Synergy lets you easily share a single mouse and keyboard between multiple computers with different operating systems, each with its own display, without special hardware. It’s intended for users with multiple computers on their desk since each system uses its own monitor(s).  Redirecting the mouse and keyboard is as simple as moving the mouse off the edge of your screen. Synergy also merges the clipboards of all the systems into one, allowing cut-and-paste between systems. Furthermore, it synchronizes screen savers so they all start and stop together and, if screen locking is enabled, only one screen requires a password to unlock them all. Learn more about how it works.

Synergy has been around for awhile.  I don’t pretend to be revealing a hidden gem.  So why do I share?  Because I’ve got an interesting setup that I hope someone else may find useful!  Also, my mother told me to share.

The majority of my time at work is spent in .NET development.  I have a MacBook Pro configured to dual boot to Windows 7 (Boot Camp) and it runs like a champ.  My company’s VPN is such that it disables connections to the general internet.  When I connect to my VPN, I lose my internet connection.  Nooo, it doesn’t support split tunneling or allow me to clear the “Use gateway on remote network” checkbox.  So if I want to work from home AND have an internet connection….enter Synergy! Synergy allows me to control my Windows 7 laptop AND my iMac with a single keyboard and mouse. Also, Synergy connected systems share clipboard settings.  Awww yeeaaah!

I setup my windows laptop as the Synergy server like so:

synergyScreenConfig synergyServerConfig

Next, I created a couple basic AppleScript scripts to connect to and disconnect from the server. The startup script assumes that you have the synergy client in a folder called “synergy” in the root directory.

Client Connect (technically, you can do this without “tell application”, but I like the visual):

tell application "Terminal"
 activate
 do script "/synergy/synergyc -f <ServerHostNameOrIpAddress>"
end tell

Client Disconnect:

set synergyName to "synergy"

set synergyPid to (do shell script "ps ax | grep " &
  (quoted form of synergyName) & " | grep -v grep | awk '{print $1}'")

if synergyPid is not "" then do shell script ("kill -9 " & synergyPid)

Download Synergy
Download Synergy Client Launch AppleScript
Download Synergy Client Kill AppleScript