Mar 08

Outlook, Access, Excel

I have a utility database  that tells me what my inbox looks like.  You see many people asking how to get a count of mails BY SENDER.  It’s the ultimate spam-whacking tool.  This is why places like Gmail don’t support it and never will. They want that spam sitting right where it is, spilling metadata.  The more junk mail sits on your Gmail account, the more they know about you.

Well, long story short, here’s a pivot table of the whole thing.  This is mail received by week, but with an important caveat — this is only what remains after some mail is moved, and some is deleted.  The dip at the end of 2014 is not a reduction in inbound mail, but the result of a cleanup I did in January.  I whacked several thousand e-mails — more than the link to my hosting could keep up with.  I’ll get back to it.


Posted in Uncategorized | Leave a comment
Dec 22

Today is a Beautiful Day

Today is a beautiful day.

It’s cold and overcast, with a wind that is not actually hostile, although doesn’t seem to like any of us very much. But in my aimless pre-dawn wandering, I crested an overpass on the way to Manassas and was struck by a flare of gaudy salmon pink lancing the cloud cover somewhere over the Atlantic, flooding inland and suffusing a million miles of sky with a fiery underlight. By the time I found a place to take a picture, the world had turned, the glow was gone, and an unknown night had become a tentative day.

I had spent the day before with friends and coworkers at Arlington to pay respects. We took some natural fiber sponges and bottled water to do any upkeep that might be possible. We stood about a couple of the stones, sharing stories by way of introduction and lapsing into completely comfortable silence from time to time.

We met a nice lady, Mrs. Davis, who volunteered to take a picture of us. She had a chair and a thermos and was settled in for the long haul, spending the day with her son, her only child. We cleaned his stone as well, and asked her to tell us about him, and she did. She has nearly ten years invested in a community of similarly-situated moms who spend their days at the cemetery.

When my friend was killed, those of us in country joined a conference call with the wings of his family, and we were just staggered at how his family was so concerned for us. Similarly, the mother of one of the folks we visited (whom I did not directly know) asked military folks to stand for a moment at her own son’s memorial service and gave them a firm bucking. I cannot understand how people find the strength and grace to conduct themselves so richly, so beautifully, at such awful times.

Soon I will return to my own family, and I do so with a humility and gratitude for those who did not have such an opportunity — for both the fallen and for those who must carry on, never finishing, never resting, until some day they may be reunited with those whom they love.

It looks like the sun may come out. If so, I will consider it a blessing. And if it should rain, I will consider that a blessing as well.

Posted in Uncategorized | Tagged | Leave a comment
Dec 18

Returning from Afghanistan

It’s been a while.  I’m in the States right now, on the way back home.  I’ve intentionally stayed away from politics and blogging in general while deployed overseas as a mobilized reservist.

I probably won’t have much to say about the current deployment — the previous one was far more interesting.  I was able to accomplish a couple of goals on this one, however, so I’ll be happy to describe some of that.

It’s great to be back.

Posted in Uncategorized | Leave a comment
Dec 18

Powershell Rocks

I have more to say about this, but I am still learning.  My impression so far is that Windows has really grown up and acquired a shell worthy of the term.  I’ve always been a DOS fan in the Microsoft camp, but at the same time really miss the power of a shel like bash.  Well, Powershell may be thought of as an object-oriented shell with much of the power and philosophy of bash.  Note that a huge difference is that is typical unix shells “everything is a file”, whereas in PowerShell, “everything is an object”.  And yes, that means, methods, properties, and an infrastructure for referring to and invoking them.


Posted in Uncategorized | Leave a comment
Nov 28

Clicky Badness

I keep reading about things I am supposed to love about Windows 8.  There are no doubt some features which make it not just a version of Windows 7 that only touch-screen-licking children can use.  Powershell version 3 (available for Windows 7) is integrated seamlessly with Windows 8, so this has my attention.  Also, I recall something about the hypervisor (virtualization manager, I guess) being more capable, and something about encryption being beefed up.

So when I search the web for “Windows 8 Business” and get cruft 2.0 like the screenshot below, I get a little frustrated.  I’m a big-picture guy, see, and while I like the details, for me many details problems *go away* if you can attack the big picture.  So the big picture here is this question:  who benefits from this sort of interface?  You click and click and keep clicking just to read an article.  This one is only five items long, so presumably the seven (count ’em) slides in this set are the title page, plus five, plus an ad slide.  And guess what?  You are going to click on the ad slide.

Now I don’t know if this is a click-through ad model, click ad model, or no ad model whatsoever, as I didn’t stick around to find out.  If you cannot or will not put your five points in an article using the English language, I am certainly not motivated to follow you around the web.

An example of web design for morons. Keep clicking, just keep clicking...

Not only has this, the payload of the HTML page as rendered, not delivered me any value, neither has anything else.  This page is a content-free zone.  At the top (not included in this screen grab) is a banner with links to sign in or sign up.  Links to other content-free pages on the same site populate the right hand sidebar, and links to content-free pages on different sites round out the bottom of the page.

Now I don’t wish to be too curmudgeonly toward Windows 8.  All the tiles and swiping just leave me cold.  I think it looks like crap, and I don’t get it.  I like XP just fine, but I understand it is tottering on the edge of functional obsolescence.  I adored Windows 98 SE, and for that matter Dos 6.22 with WfW 3.11, Macintosh System 7.x, and several of the now defunct Ubuntu interfaces.  I don’t care much for Unity or whatever it is called now, and don’t get me started on the hostile Pulse audio subsystem.  I liked Slackware when a 28.8 Sportster was all the rage.  I saw that startup sequence so many times that I remember Patrick Volkerding’s e-mail address, despite never having used it.  So the Windows 8 interface is not to my taste.  But apparently there is a lot of good stuff going on under the hood.  Big, important changes that, if better publicized, would probably help shake off the image of being the latest attemt by the Beast of Redmond to bend us toward its will, in this instance to force us to Converge, Converge, damn you! on to some Nokia-pimping, XP-eclipsing, NSA-friendly iPhone-killer.

Most of us looking at this thing from a business (or at least systems administration) perspective are not amused by sliding tiles and “jam your thumb here to get to a useful interface”.  And in fact, there must be a way to get off of that touch-oriented (and ugly) Metro get-up.  But Microsoft seems none too eager to publicize it, and the website from which I grabbed the above shot will never convince me, because that interface is for idiots.

Sorry this post took so long to type up.  My Wordstar 3.3 is acting up again.


Posted in Uncategorized | Leave a comment
Nov 22

Mavericks? Free? What is Apple Doing?

OS Tentative

I have my own ideas as to why Apple is releasing the ridiculously-named “Mavericks” operating system update for free. While my favorite proposed reason, that they are the same stupid people who named the thing, just doesn’t withstand scrutiny, I have a couple more ideas.

1. Stick it to legacy. Adoption of the last two upgrades has been poor. Now I haven’t done a shred of research on this and I don’t have any facts to back this up. I can speak only from my own experience and those of people I know, what I read in magazines, on blogs, and so forth. I can’t understand what Apple is doing these days, and I don’t like it. I’m still on 10.6.8 on my MBP and on whatever my original MBA came with. I hardly use either. I can’t stand the new iTunes interface, and I’m still not going to move to iOS 7 any time soon. It’s ugly and flimsy-looking, and I don’t want its “features”. Nobody I know thinks these things are improvements, and while I’m the most curmudgeonly of the bunch, when I mention this Mavericks thing, nobody is interested in “upgrading”.

Now operating system upgrades accomplish more than eye-candy. They make security improvements and bring the system into better interoperability with other components of the ecosystem, and of other systems. Like the web, and the NSA. So there are many reasons that Apple wants us to upgrade without even wanting us to pay for it. It makes their jobs easier, and the NSA’s job easier/harder, depending on what’s under the hood.

For all I know, the recent cosmetic changes to iOS and OS X have just been window-dressing for urgent security changes, and slow adoption has been more than annoying, perhaps even critical for system integrity. I don’t know; I don’t follow Apple tech anymore. It would explain the apparent rudderlessness of the whole thing, which leaves me cold.

2. Stick it to Microsoft. If Apple can sell a prettier (ahem) interface to their hardware for nothing, while Microsoft must charge because that’s all they have, then Apple may be seen as solving on the side what Microsoft struggles to do as a main dish. For various reasons there are fewer problematic virii on the Macintosh side of things, and heaven knows that great creative and industrial things can be accomplished on Apple’s hardware, with Apple’s operating system. So it seems a tremendous thumb in Microsoft’s eye to unilaterally declare war on the notion of selling an operating system. You bought the computer, it should run, right? And not just this quarter, but next quarter as well, after the next upgrade.

3. Stick it to you. Yeah, you knew this was coming. I don’t know the real angle here, but it would have to be something in the license. If they charge you for the OS, then you have rights, however fleeting they may be. But if the OS is just another component, like the space bar, then it really belongs to them and their willingness or unwillingness to fix or replace parts. It’s their operating system, not yours, and you don’t need to know how it works. Say good-bye to some preferences, utilities, applications?

4. Stick it to application developers. I don’t know why they would do this, but assume they need to. This would be facilitated by making the OS a part of the computer as sold as mentioned above, so that when like Microsoft they wish to claim that the browser is an integrated part of the OS, they can make it stick. If the OS is free and merely a component of the system, and security updates are likewise free, then the browser is easily seen as just one more component with a particularly high need for more of these free security updates.

They wouldn’t even be wrong in this. Microsoft in-housed much of the system protection ecosystem by issuing Microsoft Security Essentials (MSE), and I’m glad they did. Once I changed from various products to MSE, I stopped having malware issues on XP and later on 7. Been running it for years, I let it do what it wants, and I just don’t have trouble. So there’s much to commend a monolithic approach to the stack, right up to the applications. Until it breaks, of course, but this is the big gamble they would be taking. Like a jumbo jet with only one gigantic engine, they would be wagering increased reliability against the relentless arithmetic of parts count in complex systems. What’s the right answer? Time will tell.

For now, Apple can get bent. I don’t like the stuff they make these days, I can’t figure it out and I think it looks like washed-out crap. And apple’s thumb in my own eye is getting a bit much — I can’t imagine why they think I want to buy music from somebody called GORILLAZ with crude, hostile cover art, but they’ve been pounding me over the head with it for years.

So Apple can take their monolith and polish it on their own time. Now, I could be wrong. Maybe the whole thing is great. But I’ve been burned by allowing Apple updates to run free, and wound up with systems that chew on battery and wade through processor like Godzilla through the suburbs. So I’ll sit this one out, trying to figure out why this thing is free. Not because free is bad, but because I have resisted recent “improvements” from Apple at any price.

Free is no bargain when I don’t want it to begin with.

Posted in Uncategorized | Tagged | Leave a comment
Oct 20

Voice Recognition Test

This is a test post written using Microsoft Voice Recognition.  I’ll tell you what I’m having a lot of fun with this.

It takes some getting used to.  I’m also having a lot of trouble with Google Chrome.  It seems Chrome uses some other voice recognition scheme.  It seems to not be compatible with Microsoft’s voice recognition scheme.  It doesn’t look like an issue that training that will remedy either.  It seems that Google Chrome doesn’t refer to the Microsoft voice recognition API and will never get what Microsoft is sending it.

That’s why I’m using Internet Explorer to post this.  While the WordPress admin screen will not let me jump directly to the text input form, I’m only one mouse click away from a speaking everything you see here directly into my blog.  Naturally there is a lot of correction to be done.  You may notice I’m not using much punctuation.  You do have to speak all of your punctuation, which is cumbersome not actually to perform a but to go back and locate the cursor to insert punctuation in the right place.  That is a pain in the butt. 

Just now I get to a point where I had to edit things by hand.  You would not believe the trouble you get into trying to refer to the Italics button while adding text.  I have a secret devious plan you see I would like to record blog posts and post them from afar.  And as text recognition stuff is going to be T.  I like the Microsoft approach because it does not rely on anything that external to this machine–no Internet connection, no online service–to do a text recognition.

As I get better at this–even in the course of a single blog post–I find the navigation within text to be rapidly increasing in ease.  Also you may notice my diction that becomes a bit strained.  It is a very different process than writing to begin speaking and have your words taken down verbatim.  If you like I think as you speak you realize that you’re already committed to the beginning of the sentence by the time you’re about halfway through it.  So I imagine this will result in some clumsy constructions toward the end of sentences, for obvious reasons. 

Well, that’s enough for this blog post.  As an aside I was able to say that by saying well comma that’s enough for this blog post period.  And I was able to say that by saying a well literal comma that’s enough for this blog post literal period.

Posted in Uncategorized | Leave a comment
Jun 15

HP Envy 14 Beats 4-1038nr Disassembly

I seem to be the first person ever to do this. I love the machine, but spilling cheap beer all over it has not made things better. But you probably got here due to the following terms: hp envy ultrabook beats 14 model 4-1038nr cover case bottom disassemble remove open screws damn feet drive battery spare replace remove hell instructions guide howto RAM memory HDD SSD hybrid … So here’s what you came for.
There are only 12 screws to take out. All on the bottom, yes you must take all 12 out. None of them are special, no hinge-clutch-anchor Jesus screw. No, you do not need to remove the feet. No special tools required, I pried the case edges with the back edge of the world’s cheapest tweezers. You can do it with a dime. I fiddled and cajoled a starting point for prying it open on the corner close to the network port.

There are FOUR screws holding the drive cage in place. The fourth is under the battery.
The battery is held down by three screws, but one of those feels and works like a captive screw. That is, you can get it backed out far enough to remove the battery, but good luck removing the screw itself. No prob. The battery comes right out anyway.
The hard drive cage is actually two rails along the edges of a heavy foil sheet. Careful. You’ll probably need to take the “cage” off if you need to plug the standard SATA connector drive into anything.
So my keyboards (built-in and USB for troubleshooting) and hard drive are not seen by the system during boot, although later it will see kb hits. But by then it’s only accepting “any key” in order to try to boot again. No dice.
Time will tell if I get my machine running again. I did however want to share the particulars of disassembly. Hard-won knowledge.

Update.  Bought another, merged best parts, learned that the hybrid drive is a RAID (which recovered itself gracefully, thank heavens), and now I have a laptop I love with all my data and apps, twice the RAM, and a spare case.  You know. If I ever needed one.

Posted in Uncategorized | Leave a comment
Apr 26

Response to SooperMexican on my calling him pro-Amnesty

SooperMexican says I am misrepresenting his position when I say that he has come out for amnesty (and benefitted mightily from it). The benefit I’m talking about is that now (I say) that he has come out for amnesty, he gets guests like Dana Perino, famous Bushie and fairly RINO TV personality.

But it’s my characterization of the position itself he objects to, so I will just briefly describe why I say he’s now pro-amnesty. All of my evidence comes from his podcast, episode #21, after which I stopped listening. He made his case clearly, repeatedly, bluntly, and at times by stepping all over his co-hosts by pulling racial expertise as some sort of trump to plain facts and an ideological basis for positions.

He says that the situation as it is is a huge problem sapping America’s economic vitality, that we need to do something about it, that any decision is preferable to no decision, and that we need not make perfect the enemy of good, yet that if we can’t have “absolute assurance that we can lock down the border” then he won’t support whatever amnesty bill comes along. Then he mentions that the thing that makes him angry is that “so many conservatives who will *never* accept anyone saying anything about any immigration bill about amnesty and roads to citizenship.” Then he says that we are simply going to have to compromise.

My problem with this is that it pre-supposes that Congress needs to act. Congress has acted, has repeatedly passed enforcement laws which go unenforced, and granted boons and amnesty which of course are in full force.

If Congress needs to “decide” anything, it is not what new amnesty laws should be emplaced and in return for what, but what penalties should be levied for circumventing existing law.

He seems to accept that “absolute assurance” of locking down the border would be sufficient grounds to allow amnesty, despite the fact that we have literally had “acts of Congress” promise us just such security and yet all we ever get is the benefits extended to illegals, with enforcement and security falling by the wayside.

Notice it’s conservatives he’s angry with, and whose position he must paint with a big old generalized brush. He defends the idea of amnesty and “roads to citizenship” against those unreasonable conservatives who are in no mood to discuss this awful trap yet again, and this time quite possibly for all the marbles. If we do amnesty again, we KNOW that there will be no enforcement, as we will have lost all bargaining power, which by the way we should not need at all, if Democrats didn’t hate America.

America is faced with several mortal threats, and unopposed (in effect subsidized) illegal immigration is one of the larger ones. With what should conservatives compromise? Reagan signed an amnesty bill in 1986, and I am still waiting for the Democrats to make good the promises they made then. Until that happens, why should I accept any “absolute assurances” they may give now?

Sooooo, this is all just in reaction to about three minutes of the show. His co-hosts proceed to grill him on some of the ludicrous assertions and unfounded complaints he issues, and El Soop begins combating with non sequiturs (“you propose to punish citizens for the actions of non-citizens”) and yes, the dreaded perfect as the enemy of good (Ah, but how can you GUARANTEE that your enforcement scheme will work?).  He grows more agitated, and throughout the middle of the show is fairly hollering down his co-hosts, who after all are not in charge, do not command the El Soop audience, and ultimately know they are passengers.

My summary is that Soop presumes the need to achieve some sort of bill, but this conclusion assumes that a new bill would be treated with a greater amount of respect for the law than the previous similar amnesty projects were. Yet the evidence we have from this administration is that laws be damned, they will do whatever they want. Add to that the fact that amnesty takes effect in a day and is irrevocable, whereas enforcement must be carried out every day for the infinite future, and any lapses are permanent.

You have to work pretty hard to ignore these issues, and Soop is not having any of them; in fact he will shout you down for bringing them up on his podcast. When one of the co-hosts, @DefendWallStreet, mentioned bringing enforcement to bear on business owners who hire from crowds of people who don’t speak English hanging about in front of HomeBase, Soop cut him off repeatedly, saying “All you are doing is re-affirming your biases on what an illegal looks like. You don’t know. I can tell you that I do know, because I’ve been in that society, and I’ve talked to these people, and I know. So don’t tell me about your confirmation bias.” And so forth. Even allowing for the vagaries of extemporaneous speech, this is a hostile and dismissive line of argument, and not one which reflects well upon any intelligent person, regardless of ideology. He defends the nebulous amnesty bill against reasonable alternatives such as enforcement mechanisms which do no rely upon new legislation, but upon existing law. Why? Because the only new thing the Amnesty bill can bring is a new wave of amnesty.

And this is why he is now popular with the Bushies like Dana Perino. He is toeing the company line, and it will cost us our country.

Unless he has recanted some of his more egregious remarks from his podcast, episode #21, SooperMexican is most definitely pro-Amnesty. He just doesn’t want to admit it, even to himself. So I don’t think he’s evil, but he is dreadfully wrong, and is compromising his claimed values in order to maintain the illusion of conservatism. I like Soop a lot and I hope he changes his mind. Publicly and swiftly. Yet I cannot accept, I cannot overlook, this fatally flawed and dishonestly defended position.

Sorry, Soop. You’re wrong, and you’re just doubling down on wrong with your wishy-washy evaluation of the bill. It’s easy: reject this piece of crap amnesty bill. Your Jersey City co-host is right. Enforce this problem into submission. Don’t appease it.

Posted in Uncategorized | Leave a comment
Apr 23

Putting iTunes on my NAS

So far so good.

The tools I have used are Dupin2, TuneUp, and an interminable series of iTunes versions. Also in the mix, the embedded iTunes server on my Western Digital MyBook Live.

Briefly, I used Dupin2 to analyze my MacBook Pro iTunes library for possible duplicates.  There were a lot of false positives at this stage, because y library was all hosed from years of dumping and insufficient curation of my stuff.  Turn Dupin2 loose on your library, and then inspect the results — take no action on the first several passes.  This is a laborious process, and I had to get comfortable with tuning the thing in order to start seeing the results I wanted.  Of course, what makes this valuable is that we have the ability to tune it, unlike iTunes.  Eventually, I reached a risk/reward decision point, and pressed PURGE.  Dupes nuked.

Then, I used TuneUp to attempt to fix as many tracks as possible.  TuneUp is an awesome piece of software, and there is a reason it rakes in the dough hand over fist.  They want twenty bucks for it, and they get it every time.  You want something to fix your iTunes metadata?  THIS IS IT.  Pay up or keep suffering.

Then I used Dupin2 once again to detect dupes now that the metadata is right.  This turned up a larger number than I suspected it would, which is a testament to TuneUp’s superior ability to ferret out the true identity of tracks in your library.  Again, there are a lot of false positives, which is fine — tune and inspect, then execute.

Satisfied that the MBP iTunes library was as good as it was going to get for the time being, I restarted the machine and told Time Machine to take a backup.  I hadn’t restarted in several months, so that was a little troublesome, but there were no real problems).

The goal of this is to get my stuff up on the NAS and see if I can have a dedicated MacBook Pro run the library, while clients connecting to the network have the same collection streamed to them by the embedded iTunes server on the NAS; not from the MBP.  One very large reason for this is that I cannot sync my iPhone to the NAS.  I need the MBP as an authoritative central point.

One huge wrinkle on all of this is that I already have a very large collection of music on the NAS.  Several, in fact, with a large percentage of duplicates, many of those duped many times over.  So right now, I have satisfactorily organized the library on the MBP, and am working on the NAS itself.  Why?  I know that there is a lot of music on the NAS which was not present on the MBP, and I would like to keep it.  But only one copy, and without all the stuff that’s already present on the laptop.

So I Option-clicked iTunes to make it start up and ask me about a library, and I pointed it to the existing poorly set up one on the NAS.  If that library had not been there, I could easily have created on at this point.  But it was there, and it sits in a folder on top of a large collection of music which is A) not in the library itself (has not been processed in), and B) not even the majority of what is on the NAS.  So we’re starting small, with about 100GB of music; just the stuff in the folders under the “proper” iTunes folder on the NAS.  There’s a lot more up there, though, including other attempts at setting iTunes on the NAS (I didn’t realize how much of it was already done for me or where I had to dump the stuff), and several dumps of refugee volumes of music rescued from various dying computers.

There’s also a bunch of files collected along the way which have never been in an iTunes library.  I was a WinAmp guy for a while; had a whole shard on a USB stick with WinAmp actually ON THE STICK, so it was portable, metadata and all.  Until the stick came undone, and I lost everything.  Unfortunately, that stick had been the result of about a year’s worth of merging and pruning, so that what remained on the drives which originally sourced that material was three large collections of highly overlapping track sets.  I dug out those drives, dumped it all on the NAS, backed THAT up once to the other NAS, and trashed the drives.  Never looked back until now; hadn’t been able to get my motivation up for the task.

So-o-o-o right now the MBP is chewing through a large part of a much larger collection up on the NAS.  It has “processed” all the files in the NAS’s proper iTunes Library folder, and is now “organizing” them, which I think involves taking each file and poking in a /artist/album/file.mp3 structure.  Whatever, it’s not my problem.

Let the machine do the work.   Been running about six hours, and a thumbnail estimate of the progress bar says it’s  maybe fifteen to twenty percent done.  Tomorrow after work, perhaps it will finish.  If not, no sweat.  It will finish someday, and if it hangs, I can just restart the whole process; since the changes are being written to disk, it should do maybe an hour of “processing” to see where everything is, and then resume wherever it crashed.  if it crashes; which has not been happening recently.

Just a peek ahead: the MBP library is now in a very good state.  I’ll append the text MBPXYZ or some such in the comments field of EVERY track on the MBP as an explicit marker of the track’s “blessed” status.  The NAS iTunes proper library is getting its first cleanup.  When that’s done, I’ll back that up to the second NAS.  Then the NAS library will get the Dupin2, TuneUp, Dupin2 treatment.  This will all be run on the MBP as it administers the NAS library — during the whole NAS grooming process, the MBP’s own local native library is disconnected from the iTunes app.  Then those NAS tracks will get the TENXYZ comment (the NAS’s device name on the network is ‘Tenshi”.  I’ll begin importing the heathen tracks from the trackless wastes in all the wrong places on the NAS.  This will be done in batches (same way I did it on the MBP), which works very well, and then those will be bounced against the TENXYZ tracks; TENXYZ comment wins the dupe contest.

Finally, I’ll have to consolidate the MBP library and newly groomed NAS library.  Notice something?  So far, nothing has moved across the network.  No files, that is, only metadata about those files, which is nominally an order of magnitude or two smaller than the files themselves.  I definitely want to reduce as much as possible the sizes of the libraries involved before i start doing network moves.  I will probably move the MBP library up in chunks (ask me about magic folders, a.k.a. brilliant playlists), and do dupe checking in increments.  but we’ll see how it goes (a long time from now), and adjust as necessary.

Excited about this.  Hope it all works.  So far, so good!


Posted in Uncategorized | Leave a comment