Schmaltz ..

.. sort of defines me. Not that I’d confess that ..but  let’s discuss:

So .. when I can, I find the Schmaltz story on the video player on a plane. You’ll LOVE how the Web defines it:

.. I get that (those).

You’ll find me, on the aisle, watching an unnecessarily sentimental film and feeling deeply about it.


Thanks Comcast!

New modem .. wahoo!


New Digs, New Speed

Just ran a quick speed test from my mobile phone in my new digs .. the first is over Wi-Fi (Comcast). The second is LTE (ATT).


In a word: wow.

Hiding Everything on Facebook ..

Dear Lord .. how does this happen?

I am sure, through a convoluted series of posts and ‘accepts’ that it does.

Let’s not let THAT happen again.

Yeah, I’m fifty (something), but I talk like I’m thirty (something)

Here’s what I know:

Beyond that, I also know:

  • TTBOMK (always fun).
  • STFU (reminding all that ‘U’ somehow manifests itself as ‘door’ for the FCC-proper-types).
  • WTF (Whisky-Tango-Foxtrot, which, in no way, shape or form can be FCC-proper).

For (my) whimsy, I’d add:

So .. where does that put me? Where does it put you?

When I was 25 ..

.. it was a very good year.

Granted, mine was styled in copper .. diesel, but a very nice ride.

1979-1985 Cadillac Eldorado

It Just Works: Excel 2010 to SSAS

It’s been a while since I posted a geeky article .. so, it’s well over time.

I have the pleasure of working with a talented data warehouse architect on my current project, and the need to connect Excel 2010 to SSAS became a reality this past week. The instructions to do so are easy enough:

  • Navigate to the Excel 2010 Data tab.
  • Click the ‘From Other Sources’ from the ‘Get External Data’ section of the ribbon.
  • Select ‘From Analysis Services’; you’re presented with a ‘server name’ and ‘credentials’ dialog. We are using a Windows Azure Virtual Machine for this project, so you may have to create an endpoint that maps to a obfuscated port number (write me for details). Fill out these fields, adding “: port number” after the server name and your local login information (ensure your local login information represents a local account with an SSAS role on the system).
  • Click “Next”, and here’s where it gets dodgy:

  • You should be presented with a “Select Database and Table” dialog box. Select the cube you want to use and click “Next”.
  • In the “Save Data Connection File” dialog, click “Authentication Settings”, and then “None”. Trust me on this: you won’t see all the screens you need unless you have the system force you to enter login information in another step.
  • Click “Finish”; you may be prompted to save the .odc file, replacing the old one (I did this many, many times).
  • You will then see the “Import Data” dialog, which lets you place the PivotTable in your current worksheet. Select the location and click “OK”.
  • Now the fun starts:

  • You may get an error dialog: “An error occurred in the transport layer”. Click “OK”. Because you selected “None” in the previous step, you’ll be presented with a new dialog, the “Multidimensional Connection”.
  • In the “Multidimensional Connection” dialog, select “Analysis Server”; you will see the server you identified earlier.
  • Your User ID should come over too .. enter your system password and click “Next”.
  • Select your database in the next screen and click “Finish”.
  • Your .odc file should now be set up properly; save your Excel sheet and re-open, you may see the “transport layer” error again, but after this, you’ll be prompted to re-enter your system password.

    Ideally, you should be able to cache this login information .. I’m looking into that and will update the post.

It was an Asteroid after all ..

.. confirmed (or, at least firmly postulated) by a herd of American and European researchers.

This bunch have tested (and re-tested) debris from the Chicxulub impact crater off the Yucatán Peninsula in Mexico. Their findings include a timeline that spans 11,000 years for the impact, almost simultaneous with the Cretaceous-Paleogene extinction. From the article:

When dealing with geological timescales, a range of 11,000 years is about as accurate as you can get. As the research paper puts it, though, “the Chicxulub impact likely triggered a state shift of ecosystems already under near-critical stress.”

Not a bad timeline after all. Please see: Finally confirmed: An asteroid wiped out the dinosaurs | ExtremeTech

Now. If we can only solve the chicken or the egg question.

Warming up to SkyDrive

Just a little. Someone mentioned SugarSync to me the other day .. may have to take a peek at it.

With the loss of Live Mesh (see Live Mesh.. We Barely Knew Ye), I’ve had to do a few things a little differently. Besides reliable sync, local storage and pinpoint sharing accuracy, two of the nice features of Live Mesh included were Email Signature and Favorites sync. with Mesh, you could simply click a property box, and those items get synced across any of the systems in the Mesh. From the looks of it, these are not support as easily In SkyDrive.

I haven’t solved the Email signature sync, but here’s how I resolved the Favorites sync:

Your IE Favorites are stored in a personal directory called Favorites in the \Users folder of your system. The simple way to ensure you can access your favorites would be to sync this folder. Under Mesh, the folder was left in place and connected into the Mesh. With SkyDrive, it’s a bit different .. instead of moving to the mountain, we move the mountain to us, In Windows Explorer (not IE):

  • Navigate to C:\Users\yourname\.
  • Right click the Favorites folder.
  • Click on the ‘Location’ tab.
  • Browse to a folder underneath the root of your SkyDrive folder.

In a few moments, SkyDrive will obligingly copy your Favorites folder, making it available to other systems. The process is the same on the other system .. navigate to the folder as above and point to the Favorites folder beneath the SkyDrive root. You might see some duplicates of system- or  OEM-created shortcuts, so replace with care.

I’ll keep looking for a way to sync Email signatures and advise. For the moment, I keep them in a SkyDrive-synced folder in a Word document, which works well enough.

Live Mesh .. we barely knew ye ..

That’s actually not true .. but it was so catchy.

I’ve been using Windows Live Mesh since it first came out in Technology Preview in 2008. Originally the brainchild of Ray Ozzie (some would say the master of sync), Microsoft has made the decision to discontinue the service in favor of SkyDrive, another product with similar synchronization functionality.

Live Mesh offered folder synchronization with Mesh Synced Storage (under several other names, but essentially an early version of SkyDrive), and the capability to connect multiple machines into your provide synch network (a “device mesh” in 2008 terminology). Mesh or SkyDrive, synchronization has some great features:

If you’re a user of multiple PCs or other devices, synchronization gives you the ability to drop files into synched folders:

  • Very handy if you leave a desktop machine at your work and want to manage those files when you get home. Your work is waiting for you when you arrive.
  • Also handy for working on the go .. Mesh had a Windows Phone component.
  • World-wide accessibility, either by PC, device or by downloading files from the web.
    The coolest of the cool: synchronization with cloud storage effectively eliminated the need to do PC backups .. all you need to do is sync the folders you want to protect and your backup worries are over.
      • Buy a new PC? No problem .. install the sync software first, and your files (including driver and device drivers) will follow you to the new machine.
      • Need to rebuild your old machine? See the above.
      • Lose your machine entirely? Your work is safely stored in the cloud.

I’ll follow the masses to SkyDrive and give it a good shakeout .. will be interesting to see if it will satisfy my use cases:

  • A root folder called ‘sync’ under which I have a number of folders, each shared with different people or machines. I use this for various virtual connections .. pulling files onto cloud servers, and so on.
  • A desktop shortcut into which I can simply drop a current file to ensure it will find it’s way to my next machine.
  • The ability to share individual folders with specific people or teams .. all while keeping other folders secure for myself or other teams.
  • Synchronization of my Email signatures and web favorites.

So, join the crowd and grab SkyDrive. Navigate to, log in with your LiveID and set up some folders to sync or share. While you’re there, investigate the SkyDrive apps for various devices and applications (including a SkyDrive-synchronized OneNote). There is also a SkyDrive Pro version (call it SkyDrive’s bigger brother) with more capacity (and a price tag).

%d bloggers like this: