I Wish I Took This Advice ...

... then, as the man says, you couldn't blame me for any of the mess!

Do what you like today. I voted absentee a few weeks back. At least I could tune out most of the garbage that flies through the air during election time.

This Is No Way to Promote Tourism

How about extreme nasty tours. The weather is Cleveland is turning sour. It should stay that way for a while. Tourists are now few and far between. But it's not so bad that one can't enjoy a brisk walk by the sea shore!

Beats me where the audio went on this, but just think shwwwwwwwwew ...

and a little rock and roll at the end.

I Verse Uverse, We All Verse

Ma Ma Ma Belle! I'm not sure what the AT+T breakup was really all about in the first place, since so much of it came back together. Once upon a time there really was very little competition in the U.S. in most of what was then the telephone business, but look what it is now. AT+T has a few competitors, but it has huge market share in so many of today's (much broader) communications markets.

They now have all of my personal communications. And long before even cell phones, in the early days of home Internet service, I was wishing for a single provider to sell it all to me. Somehow I now wake up in the middle of the night and it has happened (it could be because I missed one of my Lyrica pills, though, because my skin also feels like it's peeling off).

My TV, home phone, cell phone, and Internet are all from the same provider. AT+T Uverse was the latest addition to this pile, with television and Internet services. So, what's it like? It certainly is impressive to look at the router config screen and see that 25 megabits of IP are coming into my house.  I haven't had the service long enough to say much about reliability. 

There definitely are limits to what it can do. I am supposed to have 6 mbit down and 1 mbit up of Internet. This seems to be rock solid, unlike the cable TV provider, which felt inconsistent. Cable was supposed to be faster on the down side, but it seemed to be spotty. On the TV side, yesterday we were recording two HD programs and watching one regular program in one room. When I tried to tune to an HD channel in another room, it said it could not (sorry, Dave). I can live with that (I watched a different, recorded HD program).

We bought the whole bevy of channels - 341. There are maybe 10 more HD channels than we had with cable (48, I think). It comes with a DVR you can access from other sets (or even control over the Internet). It can record 4 programs at once, two HD. American HD is a lot of data - 1920x1080 - so that's pretty impressive. Although we usually are not technologically deprived, we didn't have a DVR before this. It a keeper, something we can't do without. Pausing live TV. Gotta have it.

As a quality freak (but really only an expert on the audio side), I was concerned about excessive compression on the HD cable channels. With cable, you could see lots of artifacts if you looked at where subtle gradations of color were supposed to be. Uverse was supposed to be better, using MP4 compression. I don't think it holds up very well under close scrutiny either, though. Color gradations seem less blotchy, but animation of things like background colors is jumpy. Only a picky person would notice, and I would need side by side installations to give a more accurate account. And that ain't going to happen.

So, I am happy, but I won't save any money (not much, anyway) and the difference in the amount of service we are getting is negligible.

"Route 66" on WRUW

Eclectic. To me, that's always a positive word. I suppose there may be some things eclectic that I would want to avoid, but I'm not sure what they would be.

The term is perfect for describing a radio show I have been enjoying the last few years. It is inexplicably called "Route 66." You can find this show on WRUW 91.1 FM in Cleveland or http://www.wruw.org/ every Wednesday from 9:00 A.M. to Noon.

Your DJ Carl's shows normally cover multiple genres, often within one set. It is always fresh and heartfelt programming. And eclectic. Not to the point of obscurity, but in range. You can get everything from jam bands to punk rock, classic rock, any form of jazz, world music, odd imports. Nothing is off limits (although I'm not sure I've ever heard him delve into any orchestra music).  All mixed up and presented with a curious thread. 

You can check out some older shows as well: http://www.wruw.org/guide/show.php?show_id=163

Carl - for that dip into orchestra music that I think you should feel challenged to make, rather than the usual 19th century longhairs, maybe some Moondog would work.

Happy Birthday John Lennon

John Winston Ono Lennon

9 October 1940 – 8 December 1980

---

... and an early happy 72nd birthday to Bill Wyman (October 24, 1936). This is a picture of me with Bill a few years back. It was at a book signing at the Rock Hall. I was standing with a few other people waiting for Bill and didn't realize that I was standing almost right next to Gary Brooker ("Whiter Shade of Pale").

Relative URL's In a SharePoint Masterpage

I've mentioned that I hate branding, right? It is kind of nice, though, when you get it right. I've had some recent little successes that have made me happy. Or it may be the Lyrica I've been on for the past month that keeps me happy (nice drug).

OK, so while you are out there messing with masterpages, you might want to add a static URL link that goes to the current site. Here's mine that worked so nicely:

NavigateUrl="$SPUrl:~Site/../Search.aspx"

Text="Metadata Search "

Target="_new"

runat="server" CssClass="ms-SPLinkButtonInActive" Font-Size="XX-Small"/>

               

"$SPUrl:~Site/../Search.aspx" goes to a page saved at the root of the subsite. Naturally, you could specify a path into the subsite as well.

There also was a significant amount of pain that went into the meticulous placement on the masterpage. I'm not sure if I am satisfied with the way I did that. We'll see when I roll it to the QA and production environments. It is pretty! Likewise, I'm still debating on the actual location of that file, etc., but in the mean time, you've got your relative URL.

Adding a "Fake" Item to the Views Dropdown

I recently built some demos using Bamboo Solution's fantastic "List Search Advanced" web part. I called it "Metadata Search" since that's what it really is - a search on any of the columns (but not documents in a library). We needed to have a search limited to individual lists but we couldn't use the out of the box Advanced Search web part because it needs a defined scope.  We have too many subsites (Microsoft recommends no more that 200 scopes, or something like that). We could have tried to roll our own, but Bamboo Solutions to the rescue! Highly recommended.

The primary use of the Bamboo search web part will be from a special search page that I will add to the site template. In looking for other ways to incorporate it, I came up with something interesting. I created a view called "search."  It didn't matter what was on the view because I hid it.

Then I edited the web part page and hid the view web part (in the Layout section). It is now a web part page which shows in the view drop down, and I can add web parts to it. I added the Bamboo Solutions search web part, but it could be anything. Instructions, maybe.

Do not remove the list view web part from the page. If you do, the page will no longer show in the drop down. You may then need to delete it with SharePoint Designer.

The users turned down my idea, but it's still a nifty (stupid) SharePoint trick that I'm sure I will use someday.

SharePoint Search Hammers and Crowbars

Search can get stuck in some funky ways. Who knows why - disturbances in SQL connectivity, disturbances in the force? 

I recently had a rather nasty bout with some stickiness. One of the query servers was not communicating properly for some reason. Even after a restart, our full crawl would stop almost immediately (when it tried to propagate). The last message it would show was "the query server xxxxxx is not responding." xxxxxx was one of my web front ends and which also is a query server. As I said, the restart (small hammer) of that server did not help.

The BIG hammer I used to pound this out was to go into Central Admin and remove the search query service from this server and then re-add it. Ultimately, this got us past this bump.

Along the way, I was finding the full crawl stuck, and it would not respond to a stop command. The crowbar I used to get this done was to restart the Office Search service on the indexing server. 

It pains me to do these things!

SharePoint Reminder - Tickler System

OK, I know you really smart SharePoint people won't even have to think about this one. But I thought about my user's application needs for a good 10-15 minutes before I came up with this one. So for the really smart ones, this is no use, but for anybody not feeling quite that sharp, maybe you can save half that think time (you still had to google "sharepoint reminder" and find this post!).

So this is really simple. All you need to do is:

1. Have a reminder date (not necessarily the due date). This can be a calculated field, based on due date (like =[Expiration Date]-30).
2. Create a reminder view that filters based on the reminder date (is less than or equal to today).
3. Use an alert or an RSS feed (now that was easy).

This thing does not need to be any particular kind of list or library. I know it's a brain dead simple solution, but if you were having a mental block, maybe this will help.

Holy Cash Flow, Batman

Scott Hoag pointed out that Bamboo Solutions has released this very interesting SharePoint price calculator:

http://community.bamboosolutions.com/blogs/sharepoint-price-calculator/default.aspx

We stuck in everything for our four farms and it spit out an estimate of the list price of the SharePoint implementation. It is somewhat staggering - list prices.

I have been a long time Microsoft stockholder. To me, this is further evidence that the stock is way undervalued (in case their outstanding earnings weren't enough)! Buy some stock today.

Dogfish Head 120

Those of you who have known me for a while know that I have this thing about Dogfish Head brews. They are my favorite, even though I come from a town where we have one of the best craft breweries - Great Lakes - and I worked with the people who started the very large creative brewery, Crooked River (I think it was mostly software money that financed that company in the beginning). I probably told far too many people about the beer aging in my basement. There is a big pile of it. It's an investment! After you drink with me, you may think that I am this huge beer snob (snob is so cruel, I just appreciate the good stuff). I'm just a connoisseur for crying out loud.

So today I finally popped open one of the "holy grail" beers. A Dogfish Head 120 that had been aging for a couple years. Here is my review from BeerAdovcate.com:

"If anyone asks, Dogfish Head 90 is my favorite "everyday" beer. That's not to say that it isn't special, it's just that it is readily available and I wish I could drink it every day (but of course that would cause health problems). I have always loved it, and I have never aged any of it.
At first the Dogfish Head 60 was a disappointment to me. But I later realized what a dope I was. It was just something completely different. Now I love it, especially on tap.

"A few years ago (when my son started at Purdue) I was able to procure a few bottles of 120 in Indiana (they can't sell it in Ohio - too much alcohol). They were around $10 each. I just let the suckers sit in storage until today, when I finally had one (I have been meaning to do this). I had good reason, I wanted to relax and enjoy something special - I deserve it. 120 did not disappoint.

"I had an opportunity to buy preaged bottles of 120 at their brew pub in Delaware last summer but for whatever reason I passed (I am pretty sure the price was in the $15 range and I was already spending a bundle there). But the one I am drinking is one I aged myself. It's over two years old. Everything seems to be settling in on it.

"It is sweet, hoppy, well balanced. There does not seem to be a boozy smell whatsoever. The alcohol is definitely there, but the smell is not. The smell actually is a bit weaker than I would like. Everything else about this beverage is what I would expect from a well aged, over hopped, over malted ale. Smooth.

"It was worth the wait and the $10. Now I have to think about (1) when to drink the rest of them and (2) how to get some more to put up for later. And how the hell do you follow that act?"

The Curmudgeon's Guide to Practicing Law

I can be a curmudgeon. For me it's "acting my age" (and settling in to the years ahead). I have a right to act this way. An example of curmudgeonly behavior in public might be insisting on being addressed as "Mr. Klass." At work or at home it might include niceties and protocols just "because I say so."

Our lawyers have an (at least partially deserved) reputation for curmudgeonly behavior. Many of them demand respect in a way that is difficult for the uninitiated (and especially IT persons) to appreciate. This has always worked OK with me since I naively give everyone credit for having made it this far through evolution. The fact that they are here at one of the biggest law firms in the universe must mean something. Never mind the amazing academic and professional accomplishments of these people.

This lawyerly curmudgeoness is amplified (exaggerated, at times) in Mark Herrmann's The Curmudgeon's Guide to Practicing Law. This nifty little legal best seller is required reading for new lawyers wanting to make their way through the ranks at a major law firm.

As a long time law firm IT person, I also think it is useful for non-lawyers to get the curmudgeon's pointers about quality of work, his basic rules for writing, etc. It is a quick read (more like a big pamphlet) and the humor makes it fun. So I declare it required reading for anyone who works in this environment.

"It's a shame that they waste licenses to practice law on people who ask questions like this."

Fairport Lighthouse Triathlon July 27, 2008

Back when I ran marathons I got into quite a rut. Although I had traveled to some out of town races, I found it very easy to simply do Cleveland's in May, Erie's Eriesistable Marathon in September and the Toe to Tow (Towpath) Marathon in October. I think I did those same three races six years in a row. That's the definition of a rut.

Towards the end of my marathoning days I started doing the Fairport Lighthouse Triathlon. I have now done that race something like 10 out of the last 11 years. But it never feels like a rut. It is always exciting!

It never ceases to be amazed me how comfortably I can complete this race with little or no training. Yesterday was no exception. I went in worried (I had swam that distance once in 2008 and rode bike the distance only once, and never had I combined events). I have been running a little more lately, upping my puny mileage a bit.

I didn't worry about much else. I was forced to stick new tires on my bike on Friday, but that was an improvement. The race went very smoothly for me. I swam strong, biked strong and ran OK. I don't really keep very good track of my times on this race from year to year - they are always about the same.

Two of my close colleagues from the firm were also doing the race, making it that much more fun. Mona Lombardi, who also did this race last year, improved her time substantially. Jean Ference flew in from New York to do the race (bringing her bike on the plane!). She took second place in her age group. Jean just whizzed by me on the bike! I am honored to be in the company of these athletic women!

The race is one of Lake County, Ohio's best kept secrets. It may be run simply and the old fashioned way, but it works. It is a beautiful setting and the weather is almost always perfect. Yesterday was gorgeous. 168 men and 100 women participated. Since Jean won an award we stuck around for the ceremony. Check out the photo album - click on the photo-link (I will add a few more in a couple days).

They Don't Put Out Any Good Music Anymore -- NOT!

I recently ran into an old acquaintance who is an aging rock music aficionado and he said something to the effect of "They don't put out any good music anymore." I think he meant it, and I told him he was wrong.

Last night I heard The Raconteurs "Consolers of the Lonely" for the first time. Right now I am listening to it for the third time. This album single handedly shoots my old friend's statement to pieces. Although I've listened to a bunch of other great new albums this year (how about Aimee Mann's "@#%&*! Smilers," for instance), this one is at the top of my best of 2008 list.

Great songwriting, brilliant production and a powerful rocking sensibility put this up there with the best albums in recent years. Get it!

Moving Central Admin (Again!)

You will note that I wrote about misadventures moving Central Admin a while back (http://bobklass.blogspot.com/2008/03/how-to-move-central-admin-site-even-if.html). Maybe I should have read my post before I went to do it again, but things seem to have worked out OK this time, sort of doing it the right way.

We added two more servers to our main North American farm (now four WFE's and an indexer, and I'm not sure how we will distribute other shared services - Enterprise stuff is new to us). We had previously been running Central Admin on one of our two WFE's and the indexer ONLY indexing. One of the new WFE's is to be dedicated to indexing, and it seemed like a good idea to move Central Admin there. This will make even more sense when we add decent load balancing to this setup.

So I ran the Config Wizard for the first time on the freshly built box and indicated that it should host Central Admin. When it was all done, it pops up Central Admin, running off the old host. Hmmm. Time to read my old post. Those misadventures didn't really seem to be relevant, but I was considering running the Config Wizard on the old host to remove it. Or mess with alternate access mappings. I may still have to do that - there is some baggage in there.

In the end, though, I typed in the URL to the new host and Central Admin was running (in two places!). From the new one I just stopped it on the old and everything seems to be fine. I guess that was the right way!

P.S. - There was just one more thing. After an IIS reset the CA site stopped functioning (I don't even care why). So I went into ../_admin/AlternateUrlCollections.aspx and changed CA there to point to my new site. NOW I'm golden.

Elegant Solution or Kludge?

According to those who know, SharePoint databases shouldn't get extremely large. What I gather this means, is 50 GB is large, 100 GB is very large and 200 GB is excessively large. In an industry like mine, that's not a lot of data.

Our main SharePoint litigation support application has been a big hit, and it is beyond very large and on its way to being excessively large. We present visitors to this site a "My Sites" table of contents as there are hundreds of sites but very few users are members of more than a couple sites.

With the success of the application, it is easy to foresee growth many times what it is today, so we needed a way to deal with this. Our solution is to have multiple site collections and a custom table of contents that represents them all in one place. Users create new sites self-service, so we just force them to the one site collection that is open for new cases. It's seamless to the users - they do not need to know anything about what is under the hood.

In answer to the title question "Elegant Solution of Kludge," I'll glom the two together and call it an elegant kludge. What do you think?

In Training

Well, I am, sort of. Some of you might not know that I used to run marathons (very slowly). I quit in 2000 after about 13 years and 36 marathons (including three or so where I did not finish, but I did at least 20 miles). My time varied from 4-5 hours. Back in that day, I did have to follow a strict training schedule in order to get to the STARTING line (more important than getting to the finish).

Now ... not so much. I usually do the Turkey Trot in Cleveland on Thanksgiving (5 miler). And I may do the Johnnycake Jog in Painesville this month, just so as to get together with my old neighbor, Chris Emminger. My one big event is something I've done for the last 10 years or so, the Fairport Harbor Lighthouse Triathlon. It's a real mini - 500M swim in Lake Erie (can be a little choppy), 20 KM bike, 5 KM run.

I actually have been "training" a little - a couple bike rides, a very little bit of swimming. Lots of excessive eating and drinking (no, wait a minute). The first time I did the race I found out about it two days before and "trained" for one day. It's always fun (see last year's blog on it). July 27th, Fairport Harbor - come on out!

From "Summer" 2008

The other side of the "training" thing was going out to see my friend Frank Foti's steam engine running this weekend. This hobby is definitely model trains gone wild. They carry many passengers on these miniature trains, winding through the lovely woods in Kirtland.

Here is their track from the air.

Frank - Thanks for the ride.

Clapton, Return to Forever and Patrick Sweany

Of these varied shows I've gone to recently, the most pleasing was the wonderful Patrick Sweany (Band) at the Rock Hall last night. Let me explain.

I saw Eric Clapton at Blossom a few weeks back. I had never seen him before (it's hard to believe because I have HUNDREDS of his recordings), and I wasn't doing anything better, so I grabbed the GPS, jumped in the tC and headed South. Traffic was horrible, and if it weren't for a bold move (passing the Blossom exit and using the GPS to take back roads), I would have been late, as was much of the crowd.

What we were treated to was vintage Clapton - sounding much like a 90's show of his. Doyle Bramhall II was his second guitarist. Even though he is a major talent, I wished I could see Clapton with Derek Trucks - or both Trucks and Bramhall. Trucks is amazing. As it was, it still was a quality show, and very exciting in parts.

I had poor seats, and the venue is too big - these are the reason I had never seen him anyway - he always plays big venues. Schoolboy was there with his iRiver H120 Rockbox and was sitting right in front of a speaker, so the recording sounds pretty good.

I saw Return to Forever last week in Cleveland's lovely (sort of) Plain Dealer Pavilion (at least the place is lovelier than the name). It's a 5500 seat outdoor venue with a pretty urban setting and a cute tent. Unfortunately, the seats (at least on the floor) are very uncomfortable (too close together), and the sound is bad. It was a first for me for both the band and the venue.

Return to Forever always was one of my favorite fusion bands. This re-incarnation of the band is the perfect line-up of virtuosos - Lenny White, Stanley Clarke, Al Dimeola, and Chick Corea. They played some of their challenging repertoire and schoolboy's recording shows that the performance was somewhat sloppy. The solos by Al and Chick made it all worthwhile, but the poor sound and seating made the concert a disappointment.

Patrick Sweany is one of the treasures of Northern Ohio. I've seen and recorded him several times. At last night's Rock Hall performance Patrick was his usual energetic and spontaneous self. Pretty much throwing the set list away after the first song, he worked the crowd, trying hard to include everyone. He was especially good at bringing the small children in attendance into the show - inviting them on stage and letting them screw up his songs.

It was all very entertaining and I wished I could have gone to Patricks other gig later that night, but I'll just have to vow to catch him more frequently. Keith (the frequent taper) was there with his family. I forgot that he has recorded Patrick hundreds of times. The crowd consisted of maybe 50% tourists and 50% hard core fans. We all enjoyed it.

I was disappointed to see he had a new bass player and drummer, but they were great. Part of Patrick's act is for the bass and drums to jam in between songs. The new guys did up some classic jams in the vein of John Entwhistle and Jack Bruce. Wonderful. The opener, Christine Jackson, was also very good. She had a full band (I had previously seen her open for Buddy Guy as a solo act).

So of these three shows, I enjoyed Patrick Sweany the best. Better than Eric Clapton or Chick Corea and Return to Forever. And it's not because I'm cheap (the Rock Hall show was free).

Changing Breadcrumb Text for a Sub Site

We had some sub sites that had been created a while back and part of the breadcrumb was all caps. We since had changed the parent to be mixed case but the sub site still showed it as all caps (Firm > DEPARTMENTS > Subsite instead of Firm > Departments > Subsite ).

I tried re-saving the "Title, description and icon" but that didn't work. It was simple enough, though, to move the site elsewhere and then move it back. All better.

It may be kind of low-brow, but it works.

Regional Settings Are Simple

Regional setting look like something they got right in SharePoint. At least sort of.

This very clear and simple article sums it up nicely: http://office.microsoft.com/en-us/sharepointserver/HA101774731033.aspx

I will attempt to make things even more concise, so as to distill this down to what I needed to know as we prepare to roll out farms in Asia and Europe.

1. Don't set a time zone in the Central Admin Web Application General Settings as this will override the settings on the site collection or sub site (unless that is what you really want to do).
2. Users will need "Edit personal user information" permissions if you want them to be able to set "My Regional Settings" (off the Welcome menu).

When a sub site is created it inherits the locale settings from the parent. These can be changed at the site level.

If a user has permission, they can override the setting for the sub site. When they uncheck Always follow web settings, they get locale, time zone, calendar and alternative calendar(??), work week and time format settings.

That's pretty simple. I will need to verify that this works consistently.