Volume mapping and LUN associations with Dell Storage PowerShell Command Set

Posted Leave a commentPosted in General

I wrote this script sample for someone who was interested in managing their failover with Sync Live Volume, but wanted to get a high-level view of mappings including LUN information and WWNs ahead of time so they could compare that information across arrays and prevent conflicts as they worked out their disaster recovery plan.  Dell Storage Manager obviously has this information, but having it in a format in one place is convenient, and putting it in CSV format adds some flexibility. (more…)

Using the Disk Cleanup Tool to free up precious space

Posted Leave a commentPosted in General

It’s amazing the amount of stuff on a hard drive that can be overlooked, until you run out of space.  The Disk Cleanup tool that is built into Windows can help keep your machine extra tidy, but can also be a powerful tool when you’re in a space crunch.

Think of the Disk Cleanup tool’s basic functionality as a “squeegee”.  But it has a mode that deals with system level files and more important stuff; think of that as the “power washer”.

In “power washer” mode, I was able to free up almost an additional 29GB of disk space.  A lot of this was due in part to the recent upgrade to Windows 10 that was performed on this machine.  And there’s more to be saved too.  More on that later.

I’ll walk you through the basics of how to use the Disk Cleanup tool.  It’s pretty powerful, so if you’re worried that you might inadvertently clean up something that you shouldn’t have, make sure you backup your data first.

(more…)

Useful Excel Functions: YEARFRAC

Posted Leave a commentPosted in General

I was looking for a way to compare the total years between two dates in decimal format.  My brain immediately goes to the process of how I would do that calculation if I am were writing it in a programming language, but Excel VBA and Excel formulas are a different beast.

In Excel, do you use DATEDIF, “sum’ing” with TODAY() or NOW(), or something else?

Excel has lots of little functions that do simple date operations (and lots of other stuff too).  In my searches, I came across something called YEARFRAC.

It’s very simple to use, and takes three parameters: a start date, end date, and an optional setting for controlling the number of calendar days you’re working with for the locale and calendar you’re using (I used Option 1).

Quite simply, you supply those three parameters and Excel will return a number in the form of a decimal that is the sum of the years between the two dates.  Slick!

Here’s what it looks like in Excel:

2015-02-13_14-54-56

 

This would be handy for calculating service anniversaries, ages, or anything else where you need to know the difference between two dates.

You can find the syntax and usage reference for YEARFRAC here.

Running with the Crucial M4 SSD

Posted Leave a commentPosted in General, Performance, Reviews

I decided to do some hardware upgrades this weekend, and as prices on SSD continue to drop, I found a pretty good deal at my local MicroCenter.  The Crucial M4 256GB SSD normally retails for $239, but you save $50 instantly, and an additional $20 on a rebate, so you can take it home for $169 all said and done.

I installed it into my Dell desktop this afternoon, and thought at the same time I would start with a fresh build from the OS on up.  I timed some of these operations just to have an idea of the performance increase you can see when switching from spinning disk to SSD.  Of course, this isn’t a full comparison, since I don’t have existing data on these operations, but nonetheless, we all know how long we sit and wait for a new install of Windows or Office.

I’m pretty impressed with the performance.  There was a recommended firmware update for this drive, and I was able to install that directly from within Windows with only a reboot required to make it happen.

All in well, this seems to be a good investment.  After all, I was pretty spoiled when I received my XPS13, which also has an SSD on board.

Panoramics from the 2010 Minnesota State Fair

Posted Leave a commentPosted in General

I was having a little fun with my new phone, the Samsung Epic 4G and discovered that there is a panoramic mode built into the camera.  I experimented a little and think for a 5MP camera on a phone, that I actually got some pretty good results.  What do you think?

The Giant Slide, a State Fair staple

Ellie took her first ride on the Giant Slide this year.  The picture above was from Saturday, September 4, which happened to be a record setting day with over 234,000 people visiting the Minnesota State Fair.  You can tell by the amount of people that it was indeed packed.  KISS was the Grandstand act that night.  Need I say more?

The Main Gate

This panoramic was from Friday, September 3.  The weather was cloudy with chilly temperatures in the upper 50’s.  In addition to the chilly weather, winds were out of the north at about 20 MPH which made it barely tolerable.  Check back with me in January to validate that last statement.  I like this photo particularly because it captures the main gate to the Minnesota State Fair on Snelling Avenue.

Sunny day on the Midway

Finally, I had to throw in a shot of the Midway from Saturday.  I shot this normally in pretty bright sunlight and used a preset in Aperture to add a high-dynamic range effect.  If you’re not familiar, you can learn more about HDR here.

Ellie on her first merry-go-round

Not a panoramic, but definitely a great memory from this year’s Fair.  Ellie experienced her first merry-go-round.  She was a little nervous at first, but once it got going she was laughing and waving at the on-lookers as she went by (over and over again).