Heading back to Japan

I'm sitting at Vancouver airport in the Air Canada business class lounge waiting for my flight back to Tokyo. I really lucked out on weather this week, dry and mostly sunny the whole time. It's raining at a solid, seady downpour at the moment but I really don't have to care about that since I'm inside.

Noon must be a popular departure time for Air Canada because the lounge is packed. I know this isn't all for my plane since buisness class isn't that big. Since I wasn't sure about the traffic and the boarder, I got here quite early. It gave me a chance to catch up on work related stuff.

It was a fun break and I had a chance to meet everyone. Not sure when my next trip is but hopefully not too long from now.

PowerShell profiles

Powershell has one oddity that is both useful but somewhat wierd. when you first launch PowerShell, it looks for "profile scripts" and if they are found, they are launched automatically. That's useful, but the location and filename of this setup script is hard-coded and fixed. The script located at [All Users]\[All Users Documents]\WindowsPowerShell\Microsoft.PowerShell_Profile.PS1 and [Current User]\[My Documents]\WindowsPowerShell\Microsoft.PowerShell_Profile.PS1 are run. This allows you to pre-load and preconfigure a variety of stuff, which is nice. Why they are in a hard coded place under My Documents with such a long name, I don't know.

As a side note, PowerShell will only run digitally signed scripts so you might need change that setting to create scripts of your own. You should probably just make an internal CA for signing scripts, though.

Another interesting thing is the transcript function. The transcript will record to text file all of the contents of the shell window. Whatever you type and whatever is reported to the screen will be recorded. I think that is very useful, so I've come up with a profile script that will start the transcript automatically. Of course, that's a lot of text files, so I have the script clean that up for me, too.

Here is my script, colored and highlighted by PowerGUI (an open source PowerShell tool). I may have to experiment with the formatting to get it work correctly in the blog screen.

[string]$TimeStamp= get-date -uformat "%Y-%m-%d at %H%M%S"
$MaxAge = New-TimeSpan -days 7
$LaunchTime = Get-Date
$MyDocsPath = Get-ItemProperty "HKCU:\Software\Microsoft\Windows\CurrentVersion\Explorer\Shell Folders"
$TranscriptFolder = $MyDocsPath.Personal + "\WindowsPowerShell"
[string]$TranscriptPath = $MyDocsPath.Personal + "\WindowsPowerShell\" + $TimeStamp + " Transcript.txt"
[string]$LaunchPath = $MyDocsPath.Personal + "\Script Experiments"
start-transcript $TranscriptPath
get-childitem -Path $TranscriptFolder -Filter *.txt | where { ($LaunchTime - $_.CreationTime ) -gt $MaxAge } | Remove-Item
cd $LaunchPath

The $TimeStamp variable is a date time formatted YYYYMMDD at HHDDSS so that the transcript that gets created has a unique, useful name.

The $MaxAge is how long I want to keep the transcripts. Date comparisions in PowerShell work completely differently than VBScript so you have to create a new date-time object for comparisons. It took a lot of experiments to get that working the way I wanted it to.

I read the location of My Documents from registry. I picked the registry so that I can be sure to grab the path of a relocated My Documents folder. I haven't tested this with a network-relocated My Documents folder, yet. One thing about reading the registry from PowerShell, you grab the key (the folder), then you retrive each value as a property. So, you'll notice that I grab the "Shell Folders" as $MyDocsPath and then get the value for the entry "Personal" by requesting the $MyDocsPath.Personal value. That is definately different than VBScript.

The $LaunchPath variable is just where I happen to keep my scripts, you would need to change this or delete this to match your preferences.

The script than purges any *Transcript.txt files that are older than the max age variable, starts the transcript for the current session, and changes the current directory to what I put into the $LaunchPath variable.

Let me know what you think...

Back in Seattle...

...well, Anacortes at least.

Flew in from Las Vegas to Vancouver BC and then rented a car to drive down to Washington. Amazingly, there was only one car in front of me in line at the border. For all intents and purposes, I only waited one minute (maybe two) for a border crossing on a Friday. That's never happened before.

Airport wireless

I'm sitting in Las Vegas airport and they offer free wireless throughout the terminal. The Vancouver BC airport offers free wireless, too, and it got me thinking - why do so many airports only have as a paid service? With DSL costs and equipment costs dropping all of the time, I have a hard time understanding why an airport can't provide it. If you were to take one of the satelite terminals at Sea-Tac as an example, I think you could cover that with two Cisco 1200 series access points with high gain antennas. Add a NetScreen or WatchGuard firewall and a DSL line, you could support 200+ users. Upfront costs would be about $3,000 (probably less), monthly costs for the connection would run less than a $100 per month, and warrantee support would cost less than $300 per year.

Isn't that a small investment for traveler convenience?

ILM from Microsft

I attended a session on Identity Lifecycle Management(ILM) for SharePoint and we walked through the process of configuring ILM and it is a pretty complicated system. Unfortunately, this is a mission critical service for my current company that controls everything about Active Directory. I wonder if I should be trying to learn that system or if I should stick with Exchange and SharePoint...

Cirque du Soliel show

Last night, I went to the Cirque du Soliel show at the MGM Grand called KA. It was really a good show but I was surprised at how short it was, however. I have been to several traveling shows and they were all two act, two-hour plus shows whereas KA was only 90 minutes long. It was still a $90 ticket, though.

Still, the show was worth the ticket price.

Presentation on how Microsoft deployed Exchange 2007

Harold Wong presented a seminar on how Microsoft deployed Exchange 2007 internally and it was an interesting presentation. They have 150,000 users worldwide so the scale is quite large but they took the time to do some price/performance/benefit experiments that produced some surprising conclusions. The ones that seemed unusual to me are:

• Exchange 2007 mailbox servers are typically 2 CPU / dual core servers, 24 gigs of RAM, and large Direct Attached SCSI arrays with 2.5 inch SFF, 10,000 RPM, 146 gigabyte disks.
• They are not Window clustered servers. Each server is part of an Exchange 2007 CCR cluster but the server itself is not a “classic” cluster.
• There is no SAN and no shared storage.
• With 10 terabytes of raw disk space, they have one server support between 4,000 and 6,500 users with 1gig and 2 gig mailbox limits
• Site to site replication via an SCR cluster is only partially implemented.
• They have chosen not to split CCRs across a WAN because of the way CAS servers and hub servers load balance. Both parts of the CCR need sit on the same subnet and AD site and their associated hub servers need to do the same. Since the CAS servers load balance automatically, roughly half of your clients will always be crossing the WAN to get from the CAS server to the mailbox server.
• Tests with 5400 RPM SATA arrays showed that Exchange could easily run on very slow hardware. They felt that they still kept the 10,000 rpm SCSI because of they could support a higher number of users at their preferred minimum response time for lower cost per user with the SCSI compared to the SATA. However, for environments with less than a thousand mailboxes, SATA would be perfectly acceptable for most organizations. These tests were run several years ago so newer SATA drives are probably even better values now.

I also attended a session on deploying large mailboxes in an economical way. This presentation referenced a lot of statistics produced by Microsoft and Dell about costs and impacts. Based on that data, the cost per user for 2 gigabyte mailboxes was only 25% higher than the cost per mailbox at 250 megabytes. The Microsoft design team is currently testing with 10 gigabyte mailbox limits to see what the impacts are to operations. They brought up some interesting points about large mailboxes that I hadn’t thought of:

• If you give them a large mailbox, there is no archive, everything is live. If everything is “live”, then everything is reachable from every access medium (OWA, Outlook, OMA, etc.)
• Server side data is backed up, local data is not
• Server side data is discoverable in a lawsuit, local data is not
• Server side data is access protected, local data is not.

I think I will propose a 10 gigabyte structure for my current company just to see what the cost impacts really are.

First impression of conference

The Devconnections conference seems to be really well organized. It is also quite a bit larger than I thought it would be. I took one of the preconference sessions for PowerShell scripting. It was actually a two full-day classes with a lot of hands on labs. I use VBScript for a lot of administrative tasks but all of my experience is self taught – I really didn’t want to redo all of that plain for PowerShell. The instructor was Don Jones, a Microsoft MVP and author of several books, and he was a really good teacher.

The class used a Windows 2008 Active Directory domain controller in a virtual machine for the PowerShell lessons. One oddity with the current version of PowerShell is that there are no commandlets from Microsoft for manipulating Active Directory. However, Quest Software has developed a set that they distribute for free that are pretty good. They were also smart enough to use names at are unlikely to conflict with the versions that Microsoft are bound to release eventually.

One of the best things that I learned about PowerShell is that you can call any existing command line command, program, or other executable from inside PowerShell. You can use PowerShell to grab a whole bunch of information, shove that into PowerShell variables, and then pass those variables as arguments to other programs. That should make it a lot more flexible then I originally thought.

PowerShell is almost too flexible, however. Since you can do almost anything, you have a hard time getting it to do what you actually want it to do.

Heading to Las Vegas

I will be heading out to Las Vegas for the www.Devconnections.com seminars on Friday, November 7th, at about 5pm (Tokyo time). The conference lasts for a full week since I added a two-day course in Power Shell scripting. Since Microsoft intends that to replace VBScript for day to day administration work, I figured I had better learn more about it. I learned about VBScript through simple experimentation - that was painful, so I wanted to get some class time for the replacement. If I learn anything good, I'll try to post it here or my www.SBWorks.com site.

I will be in Seattle from November 14th through the 20th and I hope to have lunch or dinner with as many people as possible. Let me know if want to meet.

SharePoint training next week

My company HQ recently contracted with Microsoft to run a three day training course for a bunch of people on SharePoint. We're actually flying people in from India, China, and Korea for this. I haven't seen the full training syllabus, yet, so I hope this is worth it. They recently ran it in the US, though, and I heard from a few people that is was pretty good. If I learn any new tricks, I'll add them to my site.

Speaking of techno tricks, I've redesigned my www.sbworks.com site to list my posts in rough categories. It's a bit sparse right now but I'm going to try and add more things there, including script samples. Keep an eye on in the future as I'll try to add more.

Halloween

Halloween is slowly, slowly trickling into Japan. It looks like some of the schools and stores in Makuhari decided to have a tick or treat time over the weekend. At the office, we're doing a "geeks night out" at a restaurant in Odaiba.

Found a couple of interesting blogs

I'm sure everyone has thier own favorites but I think I found a couple of good IT related blogs that I've been reading. They seem to post pretty slow (almost as slow as me):

Bruce F. Webster - Seems to be a real long-term IT programmer and project manager and his posts seem to be pretty good for big picture management stuff. His posts on Baseline are pretty decent, even if you have wade through a bunch of ads to see the content.

Ken Sharpe - Another big-picture writer, mainly about the politics of IT management but still a good read.

Finally found a useful SharePoint book

I've been buying a lot of books lately looking for good, solid advice on how to manage SharePoint and I've found a lot of fluff. There are a lot of books that talk about install and configure details, a good dozen books that talk about possible big-picture scenarios, but I hadn't found a single book giving advice about to really use SharePoint in a company. A book of what works and what doesn't not what you "could" do or "might" do.

I found one that is relatively small, well written, and packed with useful information: Real World SharePoint 2007: Indispensable Experiences From 16 MOSS and WSS MVPs (Programmer to Programmer) (Paperback). ISBN-10: 0470168358, ISBN-13: 978-0470168356.

The title says "programmer to programmer" but could really be labeled "techie to techie" because it does a good job of distilling information about the decisions you need to make and presenting them in a clear fashion. The chapter on branding a SharePoint site is a perfect example of this. It walks through the four or five options and tells you how much effort it takes for each option and what situations make sense to use each option. As a consultant or project manager, this will give you the information you need to really start planning and testing.

SharePoint - the Second Commandment

II. Thou shalt learn the Publishing Feature

The Publishing Feature in Microsoft Office SharePoint Server 2007 is the best part of the whole damn package. Publishing is a the system that allows you create web pages on the fly instead of using SharePoint as a web based file system. If you combine it with Dynamic Content Web Parts, you can create site that shows links, a nice roll up icon, with a nice look and feel.

If you deploy a site collection with the Enterprise Publishing Portal template, you get all kinds of useful workflows, document libraries, and tools that really quite useful. You can still use document libraries and things to your hearts content but if you turn on publishing first, you will make your life a lot easier.

Oops - 2+ weeks

So much for trying to keeping things up to date. I could claim that I was busy (which I was) but I should have taken the time anyway. I've finalized my trip to Las Vegas for the Devconnections training seminar. I will be leaving Japan on November 7th, I will be in Las Vegas through the morning of November 14th, and then be in Seattle from November 14th through the 20th. My connecting flight is Narita - Vancouver BC - Las Vegas so I am just adding a layover in BC and driving down to Seattle.

As a side note, I finally got around to recreating my SBWorks website. I'll try to build that up some more, too.

SharePoint - the First Commandment

I - Thou shalt use SSL for all SharePoint sites

Like a I said a couple of posts ago, I've been spending a lot of time with SharePoint lately. One of the things that I have decided is important is that all SharePoint sites should start out at the very beginning with SSL encryption. SharePoint suffers from a couple of irritations and one of the big ones is that sites don't want to be renamed much. There are too many things that default to hard coded links so you need to pick the right URL to use from the start. And, since you are logging on with your network credentials, why pass them in plain text? At least make a malicious user work for it.

So, what is the best way to set this up? When you run the MOSS 2007 installer, you are really just installing the basic SharePoint infrastructure and you are not installing a specific site. Once you install the software, it sets up the Central Administration website (and no other site) and from there you configure things like e-mail settings, search settings, and so on. After all of that is done, you then create a Web Application that will actually host the site. The terminology in v3.0 and MOSS 2007 is different than previous versions but a web application was referred to as virtual server in previos versions. You create a new web application and the options are there to use SSL for and port 443.

You can create this web application before you install a certificate. Once IIS is restarted, you can go to the IIS console, select the new SharePoint website, and walk through the SSL certification steps to get the certificate installed.

There will be no site to see on the Web Application until after you create a Site Collection on the new web application. You can't test your site, certificate, or anything like that until after you create the site collection.

For once, the MOSS 2007 / SharePoint installer does not overwrite the Default Website so after you create a new web application, it will sit next to the Default Website instead of overwriting it. This will be really, really useful. From the IIS console, open the default website. Go to the Home Directory tab. Change the radio button to redirect traffic and enter in the full URL of the SSL site you created. If you do that, IIS will redirect all traffic from the default, port 80, non SSL site to the new SSL site you created so that when people forget to put in HTTPS, they still go to the right place.

which are the one thing that an attacker really wants, you should make them work for it.

For anyone who's lived in Japan...

You have to see this site: http://www.engrish.com. It's a collection of odd signs, t-shirts, and more that have odd, not quite right, English slogans written on them. Normally by a marketing person and probably by someone without a lot of language skill.

DevConnection conference in November

It look slike I'm going to be able to attend a Microsoft-centric seminar/trade show in Vegas in November. The DevConnection company is hosting a triple-combo seminar on Windows 2008, Exchange 2007, and SharePoint. When you register for one conference, you can attend sessions in any of the other conferences freely - kind of a mix and match thing. I'm going to try and tack on some vacation at the end of it, too, but not that many. I want to horde my vacation days a bit since I haven't racked up that many, yet.

I don't know the company much but there are reviews of past events floating around on the Internet that sound pretty positive. I'll try to blog about it while I'm there.

WebEx and SharePoint

WebEx offers corporations a free Active Directory plug in that uses Active Directory Application Mode (ADAM) to allow your active directory to talk to WebEx. When you look at the WebEx site, it looks pretty easy. Install the SharePoint system, add some web parts, configure ADAM, run the batch import, and all of your users are ready to go with WebEx accounts.

This is totally, completely, and utterly FALSE. The WebEx integration tools are UTTER CRAP.

The ADAM component will not read any user account that is not the in default "user" container. So, if you use any intelligent Active Directory design, then the WebEx components will not import users.

The ADAM component and built in batch import have different restrictions than the WebEx site. There are different user name requirements, password requirements, and e-mail address requirements are different from the WebEx site.

If WebEx tries to sell you this as solution, tell them to take a hike.

MOSS 2007 - You REALLY want the Enterprise version

Like I mentioned before, I've started a project that is pretty SharePoint heavy. Since we have a very flexible license with Microsoft, I could pretty much run whatever version I thought was best, a luxury that a smaller company doesn't have. However, if you are a Microsoft partner, you do have access to both version of MOSS as part of your partner benefit.

There is no reason to purchase and install the standard version, in my opinion. The additional search features, site publishing features, InfoPath support, Business Intelligence (BI) web parts, and default site types in the Enterprise version are extremely useful. If you have access to both, pick the Enterprise version.

I would strongly recommend that you look long and hard at the Publishing feature that is included with MOSS 2007. Rather than using the SharePoint site as a web-enabled file share, the publishing features lets you create documents as webpages directly. Since web pages are smaller, load quicker, and can be displayed on a wide variety of devices (cell phones, Macs, etc.) without special plug ins, it really simplifies the long-term life of the documents you are creating.

And, you get a multi-lingual option called Variations that can be quite useful... and amazingly irritating at the same time...

Temperature is improving

Tokyo is starting to move into fall and is finally starting to cool down. Unlike back in July, the temperature has moved below 30 C and is sitting at around 27C (77-78 F). The humidity is still up a bit (especially compared to Seattle) but it is pretty livable. Right now, there a typhoon sitting to the southeast that sending a fair amout of rain our way. It might be the source of the humidity, too.

So, other than the occasional rain, late September and early October seems to be the best time to come to Tokyo.

Microsoft Office SharePoint Server 2007 - the saga begins

I've started working on project that is in a lot more of a rush the previous project. It's actually a worldwide deployment of WebEx to a 7500 person company but the real fun is the WebEx portions that tie into SharePoint. I've had to set up the SharePoint server in a very specific way to get the WebEx web parts to work correctly and I've actually learned a lot about MOSS 2007 in the process. As time permits I'm going to post as much as I can about it. Especially since the included Microsoft documentation stops at the initial point and skips so much stuff...

Cirque du Soleil in Tokyo - ZED

On Monday, we went to see the new Cirque du Soleil show that is being staged at Tokyo Disneyland. The show, called ZED, was absolutely amazing. It is a little expensive, just like every other show, but it is completely worth it. This show is not one of the traveling shows but is permanently housed in a new theater. If you get a chance to go, you do not need to pay extra for the VIP seats. The regular seats in the second section are still excellent seats. I would go for the sections that are not on the absolute outside but one or two sections in from the edge. Any of of the seats there are going to be really good.

Boy, I am behind

It's been a month and half since I posted an update. I have to be more organized than that. I'll see what I can do over the next couple of days.

The Gaijin Effect

Now that I've been here for about 6 months, I've confirmed several "Gaijin Effects" - behaviors that I notice that occur around me just because I look like a foriegner. There are many that I've known before:

• When I sit on a train in Japan, the seat next to me will almost always stay empty. I hope it's not my B.O.
• When I try to speak Japanese, most people will assume I'm talking English. I wrote about that a while back.
• Little kids (less than 3) will stare a lot - sort of "wow, he looks different..."

But I noticed a new one recently. When people line up for a train in Japan, it always a two lines side by side because the doors can let two people enter at the same time without bumping. However, when I am the first person to stand in the line, no one actually stands next to me. The double line starts right behind me. I still don:t understand that one...

InfoPath 2007 - odd piece of software

We just installed Office 2007 Enterprise across the 7,000+ workstations at work and that included InfoPath 2007, Microsoft free-format, ultra-flexible, form based front end for entering structured data into a database. I've only just started messing around with the software (creating a daily checklist form) and I'm a bit confused, really. It kind of reminds me of Excel - it can do anything but trying to figure out how to do the one thing you really want is damn near impossible.

I find myself dipping into the help menus constantly for almost everything I'm doing. For example, let's say you create a table, setup a couple fields and radio buttons, and get all of the formatting the way you want it.

Now, you wan to duplicate a couple of the rows and make it 5 or 6 row table instead of three you just copy and paste. Since the fields are bound to a data source, the new rows are all tied to the original fields.

So, after you publish the form, when you type something in to the fourth row, that same information is then displayed in four differently fields. The process to associate these new fields with new data fields is by right-clicking, selected "Change Binding". each process of assigning a new field is about a 9-click process and it has to be repeated for every field. In this simple table, I actually have 5 fields per line - each radio button has to be modified individually. This three-row copy and past is going to be a 135 click process to create new fields that look like the fields I already created. Since there is no "format paint" button, I can't use the insert field tools to simplify the process.

There might be a faster way to do this but I can't find it in the InfoPath documentation. That's why it reminds me of Excel. It feels like a software that requires you take a class or read a big thing text book to understand it.

Summer vacation

We have an office holiday coming up next week which is our company's scheduled Obon holiday. Unlike most national holidays, obon occurs "sometime in August" rather than on a specific day and each company picks its own window for time off. For us, it is Wednesday through Friday of next week. A lot of people are taking the full week off but I decided I'd stockpile my vacation instead so I'll be at work.

There are a variety of local holidays, festivals, and fireworks shows that are scattered throughout August because of variability of obon. You can actually plan on attending one almost every weekend in August if you wanted to. A lot of people use the August festivals as a good excuse to dress in traditional yukata. In the past, I remember only women wearing the traditional dress for summer festivals but this year, I've noticed a lot of 20-something and 30-something guys wearing traditional clothes, too. I guess the fashion cycle has come back around. It looks like colors and fabrics are bit different than the true traditional patterns, though. The ones in the stores are a bit more colorful or a bit more creative.

Chiho has a couple of yukata in the closet but she's not 100% sure that she knows how to wear one correctly. The couple of times she's worn them, she's had help putting it on and tying the obi. Overall, the yukata is relatively simple but you need to tie it correctly so that the yukata doesn't come loose or bunch funny as you walk around. Maybe I should talk her in to giving it a try this year and see if she can figure it out.

Of course, going outside in August in Japan is kind of difficult - it's so damn hot...

Build vs. Buy

Since my current company is a software development company, we seem to have one big problem: they always want to build a custom system instead of buying something off of the shelf. That is one additional difference in my current position compared to all of my clients back in Seattle. Most of them would be completely uninterested in building something - they probably wouldn't even know where to start.

"So what?" you might say. After all, the same people who create such nice, incredibly expensive, and incredibly popular software should be able to make internal tools that work well. Seems logical, but that does not reflect reality. After all, an internal tool is "overhead" so the large teams of people and careful QA testing are not available. Instead, you get this mess of home-brewed parts that no one really understands and can't update well. Our IT ticketing system runs this way, unfortunately, and has been offline 5 or six times in July and August. Since it is only maintained at the HQ, we have to wait for their business hours to get it fixed. And, if the one or two people that understand the system is on vacation....

From my current standpoint, the build vs. buy call goes like this:

• Payroll and Accounting Systems: Buy. Too many really good solutions available and making your own offers no advantage
• HR systems: Buy. You'll have to do a lot of customization with a large company but start with a real package
• Document Management: Buy.
• CRM/ERM: 1/2 and 1/2. there is so much customization that you're really doing both
• IT Management: Buy. Save yourself some pain and suffering

I think you should only build systems that actually give you competitive advantage. If you know that a SQL driven, distributed CRM system with offline synchronization will give you an advantage, then build one. If your 99.999% uptime is your main sales point, build a custom monitoring solution. Otherwise, buy it - you are buying someone else's QA, testing, and customer feedback experience instead of slogging through all the details yourself.

VMWare is the way to go

At my current company, about 80% of the servers are virtualized into VMWare's ESX system which has a ton of flexibility. We have Dell 2850s and 2950s with fiber channel cards connected to SAN and they live as clusters in the VSX infrastructure. As long as the SAN storage is visible to each server that makes up the cluster, virtual servers can be moved around at will. The management software can do it automatically or you can do it manually. That means if you have a hardware problem on one machine in the cluster, you can move all of the virtual servers to the other hosts, take the host off line, fix it, and bring it back up without any of the servers going down.

The ESX system does need at least one physical server to act as the control and management server and you need an available SQL server. After that, you can add and cluster hardware to hearts content. We have a pricey EMC SAN but you can get the same cluster support with iSCSI devices. As long as each host can see the shared storage, you're good.

There are a couple of servers types that just don't virualize well. Maybe I'm not spending enough effort to find out how to do this, but I would recommend against virtualizing:

• Active Directory domain controllers
• SQL servers
• Firewall / Routing devices (ISA or m0n0wall)
• Any server product that needs IPSEC support
• Servers that need really, really fast hard drive I/O

Almost all other servers are easy to virtualize. This way, you can actually have one dedicated web server per application, too.

Cost is a bit of a problem, I suppose. The VMWare pricing is fairly cheap compared to the feature set but the costs of the Windows licensing is not included. You have to do a lot of research and digging to make sure you are really buying what you need.

Ichikawa Citizens’ Fireworks Display

Over the weekend, we went to see the fireworks near Ichikawa (市川) station. It was about an hour or so from our condo by train and it was really, really, good. I found a clip on YouTube from the 2007 display http://jp.youtube.com/watch?v=_RoQOU0ksqk that is pretty similar to what we saw over the weekend. The show was about an hour long and launched thousands of fireworks. I have no idea how much it would cost.

The fireworks are shot from a park that is along a river so you can watch it from either side. The river has pretty tall flood-control levees so you get pretty good seats from a lot of places. We didn't plan our trip out there quite so well and really didn't bring enough snacks and drinks for the couple of hours we waited for the show. We also forgot our camera... We'll just have to plan better next time.

They announced that the crowd was about 500,000 right at the start of the show. If that was accurate, then it was actually quite a bit smaller than previous years. Most of the websites said that crowds topped 1 million.

Found a good one

This blog: http://lovelylisting.blogspot.com/ posts "less than ideal" pictures from real estate listings. Some of the past history is pretty hilarious.

More Japanese Convenience

A couple of weeks back, I had posted about how things in Japan are designed at a better level for people. I found another good example in the plain, humble, everyday egg. When you buy a dozen eggs in America, the date of expiration is printed on the box. However, if you use the handy egg-basket tray that comes with the fridge, you probably through the box away, right? So, how do you know when the egg is past it's due date.

Most of the farms in Japan have come up with a simple solution: they print the expiration date right on the bottom of the egg. I am not really sure how they do this and the font looks like a dot matix style ink jet of some sort. Clever, isn't it?

Project management in IT companies

I've moved from a consulting company targeting smaller companies to a fairly large global company and it's interesting to watch the differences in IT management. There are a lot of similarities, too.

On the differences:

• Budget: Most of my clients in Seattle had to be convinced, cajoled, or outright pushed to by high quality hardware. In my current company, they are so paranoid about downtime that they through money at redudant hardware that they really, really don't need.
• Schedule: Right now, I was working on an "accelerated" project - I only had three months to plan and deploy it. I don't think I had three months to plan anything with my Seattle clients.
• Turf: There arent't enough people in a small company to really generate big turf wars whereas larger companies can't seem to function without them. There were definately some "I built it, you can't touch it" moments with my Seattle clients but the amount of time spent manging that was quite small compared to now.

Similarities:

• Dithering: When it comes to tech related issues, there are always "what if" dicussions - "what if we build a custom app instead of buying it?", "what if we outsource it", "what if they have a new version?", "what if we using an open source product?", and so on. The amount of time that it takes to explore options, discuss things with leadership, and get approvals for things seem to take the same amount time. Even though my current company is 700 times bigger than my largest Seattle client, they don't actually move noticably slower. I'm actually kind of suprised by that.
• Managing change: It seems that both small and large companies don't do a good job of actually preparing thier employees for major changes. Very few of my clients would send employees to training before pushing a new software (Office, timesheet tracking, or whatever was being deployed). I tried very hard to push for end-user training in my Groove project but it was delegated to local offices instead of being pushed from HQ. And that has devolved to "go read this website" rather than any structured training. And now, I am not surprised that most of the questions I get are "what is this thing and what can I do with it".
• ROI: Both my Seattle clients and current company seems to suffer from an odd approach to new technologies. They seem to start with some big plan that will have some big benefit (new communciation tool, smoother operations, time savings). Then, about half way through the planning process, the technical details take center stage. Whenever there is a hiccup, the project shifts towards ease-of-implementation rather than maxium-user-benefit. It seems that the big picture goal gets forgotten slightly - it's subtle but very noticable.

It's only been a short time, though, so I'll keep an eye on other interesting things as it develops.

Yup, it's hot

89-degree F and 79% humidity today and likely to stay that way all week: http://www.intellicast.com/local/weather.aspx?location=JAXX0085

Ouch...

It's pretty dang hot

We've had four or five days of over 30-degrees (Celisius) weather here in Tokyo. That means at or above 90-degrees Fahrenheit. Humidity is up in the tropical levels (~80%), too. Chiho and I haven't quite gotten used to that.

It's likely to get hotter over the next week or two. Kyoto and other cities south of Tokyo have been at 36 or 37 C (96-99 F) and the warmth is moving north. Oh well...... at least we have air conditioning.

Adding sites to Trusted or Internet zones

You can add sites to the Internet zones in Internet explorer by manipulating the registry directly. I normally do this via VBScript but that is starting to become an unsupported technology so I suppose I will have to learn to use PowerShell or something. The documentation for this is a bit scattered in the MS documentation, so here's a quick explanation:

The path in the registry related to the URL. The pattern is 2ndlevel.TLD\4thLevel.3rdLevel.

• http://share.domain.com/ = HKEY_CURRENT_USER\Software\Microsoft\Windows\
  CurrentVersion\Internet Settings\ZoneMap\Domains\domain.com\share
• http://audit.workspace.domain.com/ = HKEY_CURRENT_USER\Software\Microsoft\Windows\
  CurrentVersion\Internet Settings\ZoneMap\Domains\domain.com\audit.workspace

You can also switch it to LOCAL_MACHINE instead of CURRENT_USER if you want to make this setting apply to Local Service and machine controlled access systems.

At each location, you then create DWORD values. The name of the DWORD is the protocol and then the value of the DWORD is set to match the zone you want to use. I find that I use these protocols the most:

• http
• https
• ftp
• file

The values are:

• 1 = Intranet Zone
• 2 = Trusted Zone
• 4 = Prohibited

If you enter 3, I don't think is does anything.

Minor note on Junction

I recently deployed a big VBScript that used the Junction software from Microsoft that I wrote about earlier. When you use Junction the first time, you get a EULA pop up. Since that would be very, very annoying as a logon script, I found a way around it.

The only thing that the EULA pop up does is set a particular registry key. If you set that key in advance, you won't get the pop up at all. The registry key is:

• HKEY_CURRENT_USER\Software\Sysinternals\Junction
• DWORD: EulaAccepted
• Value: 1

Once that is set, via VBScript, a REG file, or whatever, the user won't get a pop up.

List recovery model of all databases

I put together a quick SQL query this morning that can be run against an SQL database to retrieve the list of database names and thier recovery models. I only tested against an Microsoft SQL 2005 server but it should work against any SQL server.

The blog will wrap the text incorrectly, of course. when you copy and paste, the commands should work correctly.

USE master
GO

-- Declare a variable to store the value [database name] returned by FETCH.
DECLARE @dbname sysname, @mode varchar(1000)

-- Declare a cursor to iterate through the list of databases
DECLARE db_recovery_cursor CURSOR FOR
SELECT name from sysdatabases

-- Open the cursor
OPEN db_recovery_cursor

-- Perform the first fetch and store the value in a variable.
FETCH NEXT FROM db_recovery_cursor INTO @dbname

-- loop through cursor until no more records fetched
WHILE @@FETCH_STATUS = 0

BEGIN
Set @mode = CONVERT (varchar, DATABASEPROPERTYEX(@dbname,'RECOVERY') )
PRINT 'Database Name: ' + @dbname + ' Recovery Model: ' + @mode

FETCH NEXT FROM db_recovery_cursor INTO @dbname
END

-- close the cursor and deallocate memory used by cursor
CLOSE db_recovery_cursor
DEALLOCATE db_recovery_cursor

Mimi

A little bit of bad news from Japan today, Mimi, our lop-eared rabbit, passed away last night. Mimi had started to not eat and drink much in the last couple of days ad we had brought him to the vet to make sure it wasn’t an infection, abscessed tooth, or something that could be fixed. He seemed to have good energy and was cheerful all the time. According to the vet, it looks like it was just age. While she was packing, Chiho found the receipt from Jones & Co. pets and it showed that we bought Mimi in the summer of 1997 so that made him about 11 years old. That was really, really old for a typical rabbit so we just have to console ourselves that he lived a long life. We’re still going to miss him, though.

Groove Project going well

The Groove project that I've been working on is going well but it is really sucking up a lot of time and energy. The software itself it only medium complicated and the infrastructure was all rolled out weeks ago. I've been writing up documentation, an absolute ton of documentation, really. I've been writing deployment plans, backup and recovery plans, data retention plans, security policies, installation instructions, help manuals, FAQs, and more. I feel like I'm writing a damn novel or something. I've gotten some assistance in writing up this stuff but only one person seems to be actually completing things on a schedule. I try to coordinate and delegate but I'm not really thier boss so I don't have much control over thier work.

Honestly, the only really silly part of the whole software is how it forces the local workstation to put everything on the C:\ drive. I wrote about this before and I found a manual fix for it, but now I'm trying to come up with an automated solution for a 7,000+ desktop roll out. Really, what other software published in 2007/2008 requires you you create a VBScript hack to change where the data is stored? At a minimum, couldn't they have made it a sub-folder under My Documents so that if you already pointed My Documents somewhere with more room, Groove would just go with that?

Microsoft support is kind of clueless on Groove

During the run up to this big Groove project, I've had to open two different Microsoft support cases. Since we are a big Microsoft shop with a global contract, we have fairly easy access to high-level technical support.

Even though I'm dealing with developers right out of Microsoft HQ on these issues, people who really should know the software, the actually fix came from a Paris-based consultant that my boss found. These guys were able to get better answers and get back to us faster than Microsoft critical product support. It was kind of annoying that the peole who make the software couldn't troubleshoot the software correctly.

Of course, they did buy the software rather than build it in house but they bought it almost three years ago. Shouldn't they have learned it by now?

E-mail is really up, this time

I finally got my e-mail situation finalized and I have e-mail to my @SBWorks.com accounts up and running again. I have the @thedamps.com e-mails available, too, for those interested. I'm using e-mail hosting through Fat Cow and they are pretty cheap and simple. I haven't set up a website just yet. I have configured the website to redirect to this blog for a while. Maybe I'll use it for something else, soon.

Not entirely in love with Groove 2007

I've been working on this Groove Server 2007 project and work and there are alot of things I like but I'm not sure it is worth the hassle. The server side for large companies seems a little complicated but it isn't that bad, it's just that the client side software isn't that really that good.



Groove lets you keep things in sync no matter where you are or how you're connected to the internet. The synchronization works transparently across firewalls exactly as advertised. Considering how technically complicated that can be, that is a pretty slick software. But there are some usability things that are odd:

• If you want to use the most secure method to share files, you need to drag and drop them into the workspace. There's no right-click >> send to workspace option and your workspaces don't show up in any file save dialog box.
• Files that are in the workspace are not accessible from any "open file" dialog box. You have to access the file by double clicking it from the workspace.
• You can link to a document in a workspace (hyperlink or OLE embeddd object)
• You get a lot of pop ups when saving documents asking for confirmation and overwrite that you don't get from just storing it on the disk.

There were a lot of cool features in Groove 3.5 that offered all kinds of customization opportunities that are missing from the new version. Since this is the first Microsoft version after purchasing the company so I guess they had to cut things out to get things integrated.

Overall, the software is a relatively small niche product. It works well for highly mobile people with high security requirements. They can accept the oddities of the user interface.

SBworks e-mail delayed a bit

Since my credit card info and contact info are not identical, it looks like my order for hosting services was flagged for additional information. My SBWorks e-mail is still down for the moment. I thought it would be up by now.

Convenience

There are a lot of different ways to describe Japan but one thing that I have seen lately is the convenience of things. There is a well-engineered, user-oriented outlook to everyday things. Let's take something really boring: ATMs. Here's a picture of one I pulled off of the Internet:

The phone to call the bank and the calculator on the right is kind of useful but I'm pointing out to the place were you put the ATM card into. It's hard to see but there is a small slot underneath the card. That is were the receipt prints out. Why is that useful? The card and the receipt are ejected right next each other and you can pick up both with a single motion.


That level of engineering is hardly of life-shattering importance but that is fairly common throughout Japan. Prepaid train pass cards that you don't even have to take out of your wallet, vending machines that lift the drinks to waist height you don't have to bend down, advanced barcodes that can be scanned by a cell phone camera - all of these things are really nice to use.


I'm not sure why these types of devices are so common in Japan and so rare in the states. Maybe it's an engineering attitude...

SBWorks e-mail should be back up soon

I signed up with an external hosting service so e-mail should be back up and running in about 12 hours.

Sloppy...

I screwed up and managed to loose the small wallet that contains my two train passes. I have two different passes, one for the JR line and one for the Yurikamome line and I had them in a separate mini-wallet since you have to pull them out at each train gate. Somehow, I had it when I left the last train station and headed to the office and I didn't have it at the end of the day when I started to head back home. I have no idea how, or where, I managed to loose it. Since I had only bought the three month passes on June 2nd, it was pretty irritating to loose something that costs 81,000 yen (~$800 US).

Chiho called the train station offices and filed the paperwork I needed to cancel and reissue the pass. The JR pass was on the new Suica system and I could get that reissued for 1,000 yen (~$10 US). I had purchased the classic style commuter pass (ていきけん) instead of the new PASMO cards so I couldn't get that reissued. That pass cost 31,800 yen so I'm out over $300 US thanks to me being sloppy.

Painful - I better not do that again.

Been a bit busy

As you've noticed, I've been a bit behind in updating this blog. I've been buried in this roll out of Groove at work and haven't had much time. My SBWorks server in Seattle died, too, and I haven't even had a chance to move my mail to alternate web host.

I'll try to fix that in the next couple of days...

Lucky 13...

It is our 13th anniversary today - measuring from the ceremony we had in Tokyo, anyway. Our Seattle anniversary is in July. I'm celebrating by working late on a phone call to the rest of the team in Paris and America. Oh what fun...

By the way, my mail server in Seattle went on the fritz and I hope to have an alternate set up shortly.

Actually, the security check was worse than I thought

Leaving the Bangalore airport actually had more silliness then I expected. Security checked my ticket, passport, and the stamps that were put on my luggage tags at the top of the jet way. And then, for some weird reason, there was a security guy at the bottom of the ramp that checked my ticket stub.

What possible security risk could occur between the top of the jet way and the bottom? Or is this just a jobs program for security companies?

Microsoft Junction v1.05

While I was getting Groove training, they mentioned that the Groove client puts all of the files on the C:\ drive by default. What the Hommes et Process guess recommended was an old SysInternals application that Microsoft maintains called Junction. The software allows you create a virtual folder or mount point that points the C:\...\Groove directory to another drive. Since Groove can’t let you change it, you can have the OS point all requests for the default directory into a different location. Windows Vista has this as a native option but you need the additional software for XP.

To use this on Groove, you need to:

• Logon to Groove and configure it for the current user
• Exit from all Groove applications, including the systems tray icon
• Move the %USERPROFILE%\Local Settings\Application Data\Microsoft\Office\Groove folder to a different location
• Download Junction
• Create a virtual folder called Groove at the Office level that points to the new locations
• The command will look like this: junction "%USERPROFILE%\Local Settings\Application Data\Microsoft\Office\Groove" "D:\Groove"
• Junction does not currently support UNC paths
• Restart Groove

I think this trick would work for other programs that have hard-coded file paths. It is a pity that Groove doesn’t let you move all the data. The Groove workspaces could get pretty big over time.

Flying out of Bangalore

The trip to Bangalore is wrapped up and I’m sitting at the new airport here. It looks pretty nice but the airport is a long way out from downtown (and that is just the start of the problems). I left at 6pm (pretty much rush hour) and it took just over two hours to get here. Even when I arrived at midnight, it took over an hour to get here. One of the business people who talked at the regional meeting summed it up as “organized enough to build a new airport but not organized to build a good road to the airport”. It seems to be pretty accurate to me. There is a nice, broad highway that goes from the airport to the main highway out of Bangalore but they didn’t make any improvements to the highway for the airport traffic. For a Seattle comparison, it would be the same as if you put a new airport near Carnation and built a nice freeway to Monroe to hook up with Highway 2, don’t bother to do anything to any of the highways that feed Monroe, and assume that the Seattle-bound traffic will be fine.

As hard as it might be to believe, but the security check at the airport is worse than the TSA.

Here’s the flow:

• They check your ticket and passport to let you into the building.
• At check in, they check your passport.
• After you check in, you go through an outgoing immigration where they check your passport and collect an outgoing passenger form. They stamp the passport and the boarding pass
• After you leave the immigration, they check it again to make sure both were stamped
• At security, they check your boarding pass and passport again
• They let people through one at a time and perform an individual search for every person going though the hand pat-down and wand treatment
• The security people stamp your boarding pass
  

So, from door to the gate, you get your passport checked six times. I am sure that they will check my passport at the gate again, too. For extra irony, the security and immigration people are all within easy viewing distance of each other and the flow of traffic is controlled and guided. Even with almost no line, the process took almost 20 minutes. I can’t imagine how it works with a typical rush. Good thing I got here early…

Bangalore is an odd place - reminds me of parts of the Philippines and Malaysia in the dust, unruly traffic, and the odd combination of old and new buildings. Bangalore is high-tech boom town that rivals Silicon Valley for creativity and energy but the living conditions are no different than any other part of India or Southeast Asia. The regional office is in a really nice building that is only a couple of years old but it is immediately adjacent to building that could have been there since ‘50s and haven’t had and repairs since the ‘70s.

I didn’t have much of chance to look around but I did get to sample some good food. For the meals that we had earlier in the week with the large groups, they toned down the spiciness a little but later in the week I talked them into turning up the spice when it was just a couple of us. There was some good stuff to be had. Only one person out of the group of 12 visitors managed to get sick so it looks like the food was fairly trustworthy. They did take us out to some of the fancier restaurants, though, so I can’t say for sure that the food is completely safe. It tasted great, though.

On the ground in Bangalore

I did finally get to Bangalore (at midnight, local). I've been in the meeting all day so didn't get out and look around but it seems pretty chaotic around the city. Bangalore is definately a boom town - roads always underconstruction, every other building seems to be underconstruction, and everyone seems to be in a hurry.

In Bangkok for a couple hours

I've landed in Bangkok for a couple hours and I think I've found the real advantage of traveling business class. Sure, the seats are wider and the food is better but I think the real advantage is the business class lounges. Here I am, stuck on the ground with nothing to do for 5 hours and instead of hanging out at a coffee shop or those little uncomfortable chairs at the gate, I can sit on a sofa with a near by juice and snack bar and get free internet.

The Bangkok airport is seriously confusing. It's a sprawling building that really needs an outside archictect or interior desginer to overhaul the signage. I started down a long consourse base on one sign that said "international transfers" and didn't see another sign for 10 minutes or so of walking. I was starting to wonder if I'd gone the wrong way. At least I have plenty of time to get lost.

I'll have even more time in Bangkok on my way back from India. The flight with the best connection (2 hours in Bangkok) is full so I'm on standby. I have a confirmed seat on the next flight but that is 10 hours later. If I get the standby seat, I will land in Tokyo at 4pm Saturday but the other flight gets me there at 6am sunday so the difference is acceptable. I don't get much sightseeing time but that's okay. I'm traveling for a specific business meeting, not for pleasure, after all.

95% Unpacked and Moved-in

Chiho's been busy unpacking things while I've been out of town and it looks like most of our stuff in unpacked and usable. My office stuff and computer stuff is only partially set up and I think that is all that is left. Chiho found out that the basic internet access service is free (included in the rent, I assume) so we don't actually have to pay a seperate bill for 100Mbs internet access. Sure, the internet is shared amongst the whole building but that is still 60-70 times faster than Comcast's real throughput back in Seattle and they charge about $50 a month for that.

I am going to India after all

After some last minute heroics by our travel agency, I finally got my visa to India at 5:00pm last night. I'm sitting at the airport now, waiting for my flight to board. I guess it's good news from a business perspective but now I have to go give 8+ hours of training lectures over the next three days. Somehow, I think I'm going to be drinking a lot of coffee...

Visa silliness continues

Well, my trip to Bangalore is hanging the breeze again. The Indian embassy has outsourced their visa process and it's pretty obvious that they really don't want people to visit the country.

• Two weeks ago, I dropped off my application.
• The paperwork says to return in a week
• One part of the paperwork says to come by in the morning, another says to stop by in the afternoon.
• I went to the visa processing office for India this morning
• They sent me to the main embassy to drop off my passport
• I got to the office to find it closed. (It was about 11:50 so I am hoping it is just closed for lunch)
• I called the visa processing center to find out the hours but they only accept phone calls between 3pm and 4pm

So, I am sitting at a Tullys having a coffee and I'll go check on the embassy office at 1pm and see if it is open again. If it isn't open, then I guess I'm not going. I love this kind of back and forth - doesn't everyone? I'm supposed to fly out tomorrow at 11am and we haven't been able to buy my tickets yet. I bet all of this screwing around is going to cost the company a couple thousand in extra airfare at this rate.

Also, I'm supposed to be giving about 8 hours of technical training over the next three days. I guess everyone is going to just sit around and waste time. And DS flew people from all over the world to Bangalore to get this training, too...

I was In Paris this week

The business trip for Paris finally went through and got scheduled and I am just wrapping up a 5-day training seminar for Groove. Things were pretty busy while I was here so I wasn’t able to update this blog or even really sightsee. The trip was tied tightly to my work week – arriving late on Sunday and leaving Friday afternoon. After this Paris trip, I have to fly to Bangalore for an IT regional summit. I was originally planning of flying straight from Paris to India but there was a delay in getting my visa for India. I have to fly back to Tokyo instead of flying straight to India so I couldn’t stay in Paris like I originally planned. I couldn’t come early, either, because our household goods shipment arrived on the Friday before and I needed to be there for the unpacking. So, I got out to a couple of Paris restaurants but absolutely no other side trips at all.

The Dassault Systemes HQ is located in Suresnes near La Defense and it seems to be a pretty nice area. My jet lag woke me up a little early the first day so I decided to walk around the area a bit before I went to work. The area is full of classic, two story row houses and single homes that are in excellent shape. A lot of them have very nice yards, nice cars parked out front, and other hints that you’re in a very well to do area.

The hotel I’m staying, however, is not so nice. It’s not that bad but it really isn’t that good, either. I’m staying in the Best Western Atrium Hotel Suresnes and it is a reasonably priced business hotel but it seems to have some issues. The biggest drawback as a business hotel is that the wireless internet access doesn’t cover the entire building. You need to go to the atrium area to get a reliable connection. At least they have plenty of couches and tables to work at.
The smaller annoyances are the fact that that it doesn’t have air conditioning, the elevator is amazingly slow, and the rooms are pretty noisy. Since May isn’t that warm, I guess I don’t care about the a/c but Paris can get pretty uncomfortable in summer. And, the hotel fronts a busy street so you can’t leave the windows open.

I’m writing this on my way back but I won’t be able to post it until I get back. I’m at Charles de Gaul airport right now and the price for wireless access is a little high for just a blog post. I’m at Terminal 2E at CDG airport and it looks like they are 2/3rds of the way through a very nice looking remodel. However, that also meant that the security lines were incredibly long because they only had a couple of scanning machines running and all of the stores are closed up. There is one little coffee stand open but that is it.

For this trip, I flew business class on Korean Air from CDG to the new(ish) Inchon airport near Seoul to Narita. They are flying a fairly old 747 type but they have done some recent upgrades so it fairly comfortable. The business class seats are definitely a better way to travel then coach but they aren’t that comfortable. I still had trouble sleeping and it is still a 16 hour flight. However, the short check in lines, nicer food, first off the plane, first through immigration, and first at baggage pick up is definitely worth it. My trip to India will be by coach, thanks to the last minute change of schedule, so I guess I should enjoy my trip now as much as possible.

Default behavior of Outlook Auto Archive might be different than users expect

If you are relying on Auto Archive to help our users stay below the a mailbox limit, there is something important that all end users need to be aware of:


If you create new folders in your mailbox, those new folders are not automatically archived. This may cause problems for people who think that all folders in their mailbox are covered. Any new folder will need to have the archiving option set manually during creation by selecting the properties of the subfolder. You can also reset the folders for the entire current mailbox from the Tools >> Options >> Other >> Auto Archive >> Apply these settings to all folders now.



There appears to be no way for us to change this default behavior without creating a custom Outlook plug in from scratch. Programming for Outlook is incredibly difficult so it is highly unlikely to be worth the effort. If you know of any existing plug in, please let me know.

Getting settled

We’ve got keys for the new condo and have started to get appliances and stuff. We had refrigerator a combo washer/dryer delivered on Thursday. Almost no one uses a real dryer in Japan because the cost of electricity is so high. The vast majority of people line-dry their clothes so as you travel around Japan you will see a lot of clotheslines – even in the fancy parts of town.

Japanese retail stores have a different spin on the “90-days same as cash” financing scheme that American retailers do. The majority of salaried positions in Japan have a twice-a-year bonus, one in summer and one at new-years, so the retailers offer delayed billing. They will not charge your bank account or credit card until your bonus is scheduled to arrive. It’s a lot simpler than the “open an account” process that you get at American retailers.

The major appliance stores are willing to negotiate a little, too. The one that we finally bought from was willing to go lower in price after Chiho found some advertised prices online for the same products. It’s not quite a match-or-beat-the-price guarantee but it functions in a similar fashion. Chiho shaved about $150 (USD) off the price of everything with a half-hour worth of online searching.

Paris and Bangalore

It looks like I’ve got a business trip coming up at the end of May that could get kind of long. There is a training session for the Groove software in Paris the week of May 19th and it will be followed by an IT Regional Meeting in Bangalore from the 25th to the 29th. I might actually end up flying direct from Paris to Bangalore. Not all of the details have been worked out, yet. I sure hope all of our household goods arrive before I have to leave. I think Chiho would kill me if I wasn’t in town when it came time to unpack.

I’ll try to take pictures and send gifts if I do go on these trips. I’ve been to Paris but I’ve never been to India at all so this should be interesting.

Major typo in SQL article

In my SQL 2005 article for changing the model database, I made a big typo: second section, step #4. The real settings are:

4. Enter ;-c;-T 3608 at the end of the current string. As a side note, the Microsoft documentation for this does not mention the semi-colons

The space is really important and placing at the end of the string is more likely to work (post SP2). You will need the semi-colon in front of the -c, too.

Default location for SQL Backups

In an earlier post, I showed how to change the "model" database to have new databases created in the correct location. In tandem with that, I've found out how to change the default backup location. This one is a little easier:

• The setting is contained in the registry on a per-instance basis. First, find the MSSQL.[Number] directory for the instance you are working with. 95% of the time, it will be MSSQL.1
• Open REGEDIT and find the following key: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer
• Change the DefaultBackupLocation key to whatever path you would prefer.

This change effects the wizards related to the maintenance plans and the one-off special backups.

Removing Groove Indentities from a workstation

I've been learning a lot about the Groove software over the last couple of weeks and one of things I've learned is that Microsoft's documentation is HORRIBLE.

I know, that's not very surprising but this has been worse that usual. Even the client-side help documentation is bad and Microsoft does a better job than most at client-facing documenation. From an end-user prespective there is acouple of important items to note

Groove Identities

Groove ties very hard to be network OS neutral so it uses special terminology for itself. Instead of a Groove user account, the logon process is through a Groove identity. These identities are very tightly bound to the management server and have a fairly paranoid built-in security system. Each identity is tightly bound to a workstation and you allow or deny privledges based on that identity. The logon process is sepereate from any other logon process and the username and password are unique.

Because of this tight binding, you have to remove the identity from the local workstation. You have to options:

If I can still login to this identity:

• Logon to the Groove client software.
• From the toolbar, select Tool >> Preferences
• Select the Identity tab
• Select Delete

There will be a couple of prompts to warn you that you can't undo this action and that all data will be deleted.

If you can no longer logon to an identity

If you can't logon to this identity, you will get annoying pop ups about how it can't logon and will will always see the user name in the list. There is no real way to delete the identity from inside the Groove software. The only way to do it is to purge all the identities from your computer.

• Backup, archive, or export any existing workspaces that you want to keep. Remember, this process will delete all Groove data from the local workstation so you have to backup anything you want to keep.
• Close out of all Groove software (including the system tray icon)
• Run the following command: %ProgramFiles%\Microsoft Office\Office12\GrooveClean.exe -all. This will delete all of the cached data.
• Go to the current user's profile at %USERPROFILE%\Local Settings\Application Data\Microsoft\Office\Groove\User and delete all files and all sub-folders
• Restart Groove. You should be presented with the first time user wizard.
• Configure the user account and import the workspaces that you archived.

Major Japanese Holiday

Over the next two weeks, there are four national holidays in a tight grouping, normally referred to as Golden Week. The vast majority of offices are closed during this week and most Japanese take a major vacation. This year, several of the days occur over the weekend so it kind of warps the traditional tight cluster of days. It looks like about half of my office took this week off and half will take next week off. I'm actually going to come in for a couple of these holidays so that I can take comp-time for whenever our household goods arrive from the states.

Speaking of that, the moving company seemed to get us on a pretty fast boat. The truck was packed on April 18th (in about 4" of snow, too) and it looks like the container ship is expected to dock on May 1st (as scheduled). We don't know how long the customs process will take and the Golden Week holiday will probably slow it down a bit. I'm guessing that the move-in date will be the week of May 12th. We'll see...

Fully packed out of Seattle

Chiho wrapped up the house move, the moving company stopped by last week, and Chiho arrived in Tokyo yesterday. That wraps up the first half of the home move... well, except for all the stuff my mom and dad are taking care of for us this weekend.

The flight over for Chiho was pretty uneventful. The plane was almost completely empty which seemed pretty surprising. We've flown at this time of year before and it was normally pretty full. However, we normally flew on Thursday or Friday so maybe it's the day of the week. So if you have to fly to Japan, try to do it on Wednesday.

Mimi (our lop-eared rabbit) seemed to survive the flight without too much trouble. He seemed to be in a very grumpy mood when Chiho dropped him off at the airport quarantine. We'll be picking him up on Saturday from the airport.

Hardcore flashback time

I saw an advertisement on the train today that really, really, shocked me. It was for a live concert from these guys. What the heck are these guys doing staging a global reunion tour - they weren't that good in the '80s...

Found a new domain-naming wrinkle

Several of my clients in the past had not followed Microsoft's domain naming recommendations and made thier internal domain name match thier external domain name. This always caused problems connecting from the outside, screwing up routing, and other irritations but I've actually found something that is worse - incredibly worse, actually - the Single Label Domain (SLD)

In a single label domain, instead of domain.local or something.domain.com, you actually make your domain without a dot-anything like INT or LOCAL. This makes your internal domain names kind of simple, server.int, web.int, or whatever but you be amazed as to how much breaks when you do you this:

• Live Communicator breaks


• Kerberos authentication between Active Directory and any other kerberos based service brakes


• Windows authentication to an SQL server breaks


• Domain trust become extremely difficult


• Groove Server Active Directory Integration breaks

Trust me on this one, you never want to do a single label domain. And, guess what we have at my new company....

Address in Japan

We've picked our preferred place and have it pretty much locked in. The new address will be:

Beach Terrace #111
3-1-1 Mihama-ku Utase
Chiba-shi 261-0013
Japan

〒261-0013
千葉市美浜区打瀬３－１－１　
幕張ビーチテラス１１１号
JAPAN

We will get keys on the 26th or 27th of April. I got a chance to look at it last weekend and here are some pictures:

• From the front entry way
• The big windows out the back yard area (note how tall the windows are - we had no idea the condo had such high ceilings)
• The back patio and fence
• Kitchen (with dishwasher, very important)
• Looking from the main living area towards the kitchen

It's hard to take good interior shots so I don't have much. Hopefully, I can get some more in a couple of weeks.

Configuring SQL 2005 so new database put files on different drives

Microsoft's SQL 2005 best practice recommendations include splitting binary, database files, and transaction logs onto different drives. When you install SQL 2005, you can used the advanced options to change the default data directory but this will put the MDF and LDF files in on the same drive. This really doesn't matter for the system databases but you don't want that to be true for all database that get created later. You actually need to do two different processes to ensure that new databases get configured correctly:

Change the defaults for manually created databases

1. Use SQL Management Studio and connect to the database
2. Right click the server name at the top of the hierarchy and select options
3. Go to Database Settings
4. Change the Default Database location

Change the model database

Databases that are created by scripts or software installers do not grab the settings we just changed. They copy the settings from the model database. Since the model database defaults to putting the MDF and LDF files in the same folder you need to modify it. This gets a little tricky, though:

1. Open SQL Configuration Manager
2. Find the service that defines you database, right click it, and select properties
3. Go to Advanced and find the start up parameters section
4. Enter ;-c;-T 3608 at the end of the current string. As a side note, the Microsoft documentation for this does not mention the semi-colons
5. Restart the SQL service. The parameters that we put in will let you modify the temp database. Without those tags, the database is "locked".
6. Use SQL Management Studio to connect to the database
7. Open a new query and make sure the current database is set to master
8. Run the following query: sp_detach_db 'model'
9. Move the modellog.ldf file to the path you want logs to be
10. Run the following query:sp_attach_db 'model','[Path to Data Files]\model.mdf','[Path to log files]\modellog.ldf'
11. Use SQL Configuration Manager to remove the parameters we added.
12. Restart the SQL service

That should make your SQL server create new databases the way you want them to.

Groove Server 2007

I've been placed in charge of world wide roll out of the Groove Server 2007 infrastructure. I've played with the software and a couple of Seattle clients had asked me to look into it so I'm kind of familiar with the concept. Now that I've had a chance to really dig into it, the system is kind of fascinating.

The main core of the software is amazingly simple - (1) create a way for end-users to setup their own shared storage systems, (2) copy the files to whoever is working on it, and (3) keep the various copies up to date wherever someone happens to be working. Simple in concept but tricky to actually pull off. SharePoint's web-accessible document front end can make the files easy to share and ensure that people have access to the latest version but it only works while you're connected to the Internet.

Groove is kind of confusing because there is a client software and server software and you don't always need the server versions. The software needs access to a management server but your company doesn't need to have one of its own. For small offices, Microsoft has a free, public support infrastructure that you can register your client software with. You can be set up and running within a minute or two of starting the software. The Groove Server infrastructure is really only needed if you want more control. In Microsoft's documentation, offices with fewer than 100 users shouldn't even bother setting up an Groove Server installation at all.

From all of my reading and research, it looks like it should be an easy setup. I'm going to be creating a test network over the next couple of weeks and I'll try to write about what I find out. Well, I have a budget of only 40,000 euros to pull this off so I guess I'll just have to make do... :-)

...Did I mention that I'm still having difficulty with the scale of my new company? 40,000 euros is over $60,000 US and that was one of the smallest budget items on the list this year...

Gold’s Gym Makuhari幕張

When Chiho was back in Japan last time, we signed up for the local Gold’s Gym in Makuhari. There are actually two gyms across the street from each other that are the “main gym” and “annex”. Gyms are kind of expensive in Japan, we found, probably because the cost of keeping employees in Japan is kind of expensive. I rented a locker at the annex gym so I can leave my shoes and a change of clothes there. It should really help for trying to go to the gym after work. Chiho joined the gym, too, so we got a family discount but it still ended up at about $100 per month, about three times the cost of Gold’s in Mukilteo.

Rented out the Mukilteo house

We decided to take our house off of the market and rent it out. As it turns out, one of Chiho’s ex-coworkers was looking for a new rental so we rented it to them for a year. We’ll test the waters for a sale next year. Of course, since the dollar took its big plunge against the yen, maybe waiting is a good idea.

Furniture for sale (3)

One more time, here's another list of what we have for sale:

• Glass angel table - $125
• Vanity table with mirror - $150 SOLD
  
• White bench with storage - $135
• Blue china hutch or curio cabinet - $135
• Off-white end table/cabinet - $50
• 48" round center post table - $500
• Magnavox 27" TV - $25
• Black oval free-standing mirror - $40

Our spot in Japan

We’re 99% sure that we’re going to take the rental condo that is the same building as Chiho’s parents. It’s a different floor plan than theirs and is slightly bigger. The apartment will be 100 square meters (or about 1,000 sq. ft.). That’s less than half the size of the Mukilteo house which is why we’re trying to sell so much of it. Here's the floor plan:

Standalone image: http://www.sbworks.com/images/apartment.jpg. I color coded and labeled the floor plan if you follow the link. The rooms that are "missing" doors actually have sliding doors.

It’s on the first floor of a fairly tall (14 story) building. It faces the ocean side of the complex but that’s not as good as it might sound. There’s a busy road right in front of the condo there. On the dining room & living room side of the house, there is a small yard, probably 30’ x 20’ that is fenced. Then there is a small berm with landscaping on it between our little yard and the street. The noise will probably be quite noticeable when the windows are open but we talked to the current renters and they say that the rooms are very quiet with the windows shut. Since the apartment has air conditioning, that will probably be workable. For the size of the apartment, there is a fair amount of storage. The kitchen is a little small (quite small in comparison to American kitchens) and that will take some real effort to get used to.

Right now, the company that owns and rents the condo is in the middle of refurbishing it after the previous renters moved out. I should be able to see the inside of it in a week or two and I’ll make sure to post pictures.