Verizon Home Monitoring and Control

VerizonIf you have been following this blog at all, there have been a number of posts related to various upgrades I have made over the years to my Verizon FiOS service.

Upgrade from Cox to Verizon FiOS

Verizon FiOS IMG Update Lottery Winner

Verizon FiOS Router – Model #: MI424WR

Verizon FiOS Multi-Room DVR External Storage Expander

Upgrading FiOS Internet from 35/35 to 50/20

Yes, I’m a loyal Verizon customer.   I even had their cell phone service when I owned a Palm Treo 700W before getting an interesting smartphone named iPhone in early 2009.  Believe it or not, I thought the Treo 700W was the best smartphone on the planet at the time until Apple told us otherwise…

For the past few months, I have subscribed to Verizon’s Home Monitoring and Control services designed to enable homeowners to remotely view and control premises-based cameras, thermostats, lighting and other appliances.  The monitoring service costs $9.99 month excluding equipment costs.

Verizon’s home monitoring services consists of three different equipment packages, tailored to meet your home monitoring needs, such as:

  1. video look-in capabilities to enable customers to remotely turn lights on and off.
  2. an energy control package which allows devices to monitor energy usage, such as a thermostat control.   There are also adaptors to control appliances.
  3. a home monitor control kit which offers both the home monitoring and energy-monitoring equipment

Now I opted to go for option #1 above because I already owned a Filtrete 3M-50 Wi-Fi Thermostat since 2011.

Filtrete 3M-50 Wi-Fi Thermostat

Filtrete 3M-50 Wi-Fi Thermostat and ThingSpeak

Suffice it to say, I’m perfectly happy with my Filrete 3M-50 which works flawlessly with my iOS devices to remotely monitor and control home thermostat while away.  If it ever breaks, I may consider moving to Verizon’s thermostat control.   Unfortunately for me, Filtrete does not offer a Windows Phone app for this product yet.

I ended up spending approximately $300 for all my components:

Since you have to have a home monitoring gateway router, I ended up purchasing their “Home Monitoring Kit” and added on my additional devices.

The hardware is relatively easy to install.  I don’t think my mother could install it though; so there is some work there.   For me, probably the most difficult part is configuring the z-wave devices and the wireless camera.   The front door deadbolt keypad lock did not want to pair with the gateway router and it took a number of failed attempts to finally get it to work.  I spent over an hour initially trying to get the wireless cameras to detect find my wireless network and eventually plugged an Ethernet cable into the camera so that I could configure it.  All of my devices have worked flawlessly since their initial setup!

In general, I would say I’m pleased with my setup.  The reviews on Verizon’s product pages and forums seem to be mixed.   Some folks simply can’t get it to work, or they find that Verizon’s closed system is limiting.   By that I mean, you must purchase all your devices from Verizon.   You cannot hook-up your own z-wave sensor or wireless camera on their system and expect it to work.   Verizon has a Home Control administration web page where they list all your purchased devices and you have to select it in order to configure it and bring it on-line.

This is probably the single disappointing aspect about the product, since technically there isn’t any difference between Verizon’s hardware and the z-wave products you can buy online.

For me, I love the ability to remotely access my cameras, light sensors, and deadbolt using either my PC or my iOS device.   I will say that although the iOS app works, it does appear to crash often and not connect to the home monitoring service for some reason.  One missing feature over using the PC is that you do not have the ability to pan/tilt the camera using the iOS app.  This seems to be the number one request enhancement to the app.

When the iOS app first launches, it typically will prompt you for a pin # before allowing you remote access to your devices.  I’ve learned that if you exit the application and return without starting at the main application screen, it will either hang trying to continue where you left off and/or prompt you for a pin # again and never really respond after that.

Since upgrading my wife to a Lumia 900 running Windows Phone 7, I don’t see where Verizon offers a Windows Phone app yet.   This is a bit disappointing and hope they provide something relatively soon.

For the most part, I’m happy with my Verizon Home Monitoring and Control.   If they can continue improving the system, make their iOS app more stable and add the pan/tilt, and provide alternative apps; naming for Windows Phone, I think they will have something all their customers will thoroughly enjoy.

Time will tell -

Posted in Rant, Reviews | Leave a comment

Goodbye Re-invent.com

A few days ago, I created a post that explained my experiences with migrating from Subtext to WordPress.  My motivation from leaving Subtext was primarily because it wasn’t being updated as frequently as I wanted and didn’t support mobile devices too easily—especially when creating blog posts on iOS.

re-invent

It has been a few days since I got everything switched over and I thought it be beneficial to request that my old hosting company, known as re-invent.com create a temporary URL for me so that I could continue accessing my old blog in case of last minute post migration issues.

a brief history:

I have been a loyal re-invent.com customer since early 2006 and during that timeframe, have only requested support from them once.  My experience from that one time was not too positive, as it took multiple support ticket requests to determine if they could restore a SQL Server backup.   At the time, something got corrupted in my blog posts and I could no longer create a BlogML backup from my Subtext blog due to errors.   They finally responded and said they don’t do backups.  I was a bit annoyed, as I wasn’t asking for a recent backup, just something that would get me to a point prior to some of my latest post corrupting the database.   Unfortunately, I hadn’t performed a BlogML export in a few months before running into the issue.

I ended up restoring an older backup locally at home and then migrated all my content locally back to re-invent.com and updated everything to get things working again.   I lost probably 15-20 posts and ended up Googling to find old copies that I could copy/paste and bring back to life.   Restoring images were the most painful of the bunch.

Now I understand there isn’t much of a margin for hosting companies to have full-time staff and I would expect some sort of human to respond within 24-48 hours.   My issue, however has been that each time I created a support ticket, it would show in my control-panel, in addition to me receiving the automated e-mail providing me the ticket # and links to review, etc.

The problem is, after 2-3 hours, I could no longer review my tickets and they would disappear into oblivion.  Their system would say I had no outstanding tickets and when I provided them a ticket #, it said it did not exist.  Even though it worked for a while after initially creating.

I have received no follow-up e-mails or anything from re-invent.com.   Therefore, I can only assume they are either incompetent, almost out-of-business, or simply don’t care – they got their money from me a long time ago.   Since my renewal was due in the next couple months, I have decided to cancel my subscription with re-invent.com.  I have gone ahead and deleted all my old content.

For what it is worth, they seemed to be a good hosting company over the years and I only recall a few times that my site was down due to SQL Server problems on their side.  Their slogan is “re-invented and reloaded”.  Maybe it should now be changed to “revolutions” since we know how that trilogy ended.

To that end, goodbye Re-invent.com.

Posted in Blog, Rant, Reviews | 2 Comments

Upgrading from iPhone to a Windows Phone Lumia 900

Lumia900

I have been an iPhone fan boy since owning my first iPhone 3G way back in 2008.  It’s funny when I say this as four years wasn’t that long ago.  I guess, due to the rapid pace of technology and hardware, it just seems to be ages ago.

Since 2008, there have been a iPhone 3GS, iPhone 4, iPhone 4s, and expected later this year, the “new iPhone” running iOS 6.   I say “new” here because I suspect that Apple will do the same thing with the next iPhone that it did with changing the iPad 3 to “new iPad”.  We shall see.

My wife had an iPhone 3GS and recently I managed to convince her to check-out the new Lumia 900 by Nokia running Windows Phone 7.   Since she has always been a Nokia lover before getting an iPhone, I thought this was the perfect opportunity for me to persuade her into making the switch.   Since my iPhone is for work and used both for work related calls and personal, there really isn’t a need for me to have second phone; but I still wanted a Windows Phone 7 in the household to play with.

Lumia900-1When my wife first touched the Lumia 900, she immediately fell in love with it.  It was really big, compared to the iPhone 3GS, sporting a 4.3” AMOLED clear black display, and a nice capacitive touch screen.  Resolution is 480×800, which seems kind of low compared to the Retina display of the iPhone, but you really don’t notice this with the Metro interface.  The built-in camera includes a Carl Zeiss optics 8MP and 1MP front camera.

Even though this phone comes with only a 1.4 GHz processor, it doesn’t seem slow and everything is very responsive.

If you want more detailed specs, please read here.

What’s really nice about this camera besides its look, feel, and Metro interface, is that it’s designed for social networks and includes Facebook, Twitter, email, Chat, SMS, etc., directly from its People Hub.

Nokia includes a few cool apps with the phone.   The one that I find especially useful is its “Nokia Drive and Nokia Maps” application.   This is a full-featured mapping application similar to TomTom that for some reason is not available for the Windows Phone 7.

There are a plethora of reviews of the Lumia 900 online, so I’m not going to try and repeat what has already been said.  It’s worth mentioning, however, that the Amazon customer review of the Lumia 900 all seem very positive with five stars.

apps

I know a lot of you are probably thinking, “what about the apps?”   Well, I will admit that the Windows app store is nothing compared to iPhone and Android.   But at the same time, how many apps does the average user use?

I think Microsoft and Nokia have done a pretty good job in getting other companies and developers to write the must-have apps that most users expect.   Plus, it’s kind of nice not to have to wade through 60,000 apps just to fine the one you’re looking for.

So far, I do not think my wife will be returning her Lumia 900 for a newer iPhone.   So I think this phone is a definite keeper and a good investment for her.  Good job Microsoft and Nokia!

Can’t wait to see what Windows Phone 8 brings later this year!

Posted in Reviews, Windows Phone | 1 Comment

Using lynda.com and pluralsight.com with AppleTV

As of June, 2012 this year, I will have been working in the IT field for 25 years.   Working with computers, mainframes, networking, web, databases, programming, you name it… as a career (or as a lifestyle) and as a hobby, has afforded me the opportunity to learn many things.  A jack of all trades, if you will.

Unfortunately, after having kids, one of the challenges I face is finding the time to stay current and relevant with all the emerging technologies and tools.  Although I enjoy traveling and going to schools to learn a specific application or technology, spending a week or more away from home nowadays is almost impossible.

The CNE and MCSE gold rush is over and there doesn’t seem to be anything else worthwhile other than maybe a CCNA, in my opinion.

LyndaSince early 2004, I have been a member of lynda.com and thoroughly enjoy the level of quality, detail and professionalism that goes into every training course that they produce.  They have set the standard for on-line training.

What’s nice about lynda.com is that they have a huge selection of courses.  They provide sources in Photoshop, iOS, .NET, video editing, etc.  Best of all, you can watch your videos on your PC, iPad or iOS device easily.

If you have never tried lynda.com, I encourage you to do so.   They have reasonable monthly and yearly plans, and a vast array of sources.

Pluralsight

Since mid 2011, I have been a member of pluralsight.com and find it extremely beneficial for any Microsoft developer interested in learning and staying current with the latest technologies… They provide content for WCF, C#, Azure, Windows Phone, and much more…

You can also watch videos either on your PC, iPad or iOS device easily.  If you have never tried pluralsight.com, they offer a free 10-hour-trial in addition to various monthly and yearly plans.

There are other good training companies, but I find these two the best!

Now, I recently purchased an Apple TV.  I’m not too interested in renting movies or television shows using it – I can do this today with FiOS , NetFlix, and a bunch of other widgets that I have on all my television appliances.

If you’re not familiar with Apple TV, it is basically a little device that plugs into your HD TV using an HDMI cable.  It comes with a remote and supports a neat technology called AirPlay.   The latest version (as of 2012) now supports HD content in 1080p format.  There is also a new GUI that sports a new look geared more towards an iOS device.

AppleTVMain

Now for the cool stuff!!!

If you have a Mac, iPhone, or iPad in your household and an Apple TV, you can use AirPlay to stream your content; whether photos, music, or videos straight from your idevice to your TV!

AppleTV

If you have an iPad 2 or the “new iPad”, then they support an option called “Mirroring” with AirPlay which allows any content on your iPad to be mirrored to your TV.  If not, only selected apps support AirPlay.

Since I literally sit in front of my computer screen 8-16 hours a day, I am usually too tired to sit around another 2-3 hours watching videos.  I tend to fall asleep after 20-30 mins. ZZZzzzz

With AirPlay, however, I now have the benefit of using the iPad apps from both lynda.com and pluralsight.com to stream my videos to my big 65” LED TV.   It works really well and you would be surprised how easy it is to see and read the content—especially a desktop view or full screen view of an application.   I’m sitting approximately 15 feet back.

050

Simon Allardice, you look great on the big screen and I love all your iOS training content you have available on lynda.com!   Keep up the good work!

If want to get the most out of lynda.com and pluralsight.com and you do not have an Apple TV, I highly recommend you get one so you can enjoy the content from anywhere you want in your household!

Posted in Reviews, Training | 3 Comments

Migrating from Subtext 2.5 to WordPress 3.3

A couple days ago, I took the plunge and migrated this blog of over 5 years from Subtext to WordPress.

My main motivation was that Subtext, although very simple and provided all the basics, was falling behind.   Especially due to the lack of mobile apps for posting to your blog.  The limited choices out there that supported the Metawebapi was pathetic, to say the least.

There is a cool WordPress iOS app that I’m dying to try; once I get things working.

WordPressiOS

Prior to Subtext, I used various generic blogging solutions that used PHP and MySQL.  Being a .NET guy, I jumped on Subtext as soon as I could and haven’t looked back since, until now.  I guess Subtext loss the blog engine wars.  Fortunately for me, PHP and MySQLAdmin haven’t changed much over the years…  it didn’t take me too long to get back into the groove of things.

While migrating Subtext to WordPress, I faced a number of challenges opportunities along the way; therefore, I thought it would helpful for to try and document some of the steps I took.   If you were to Google around, you will literally find dozens of posts related to folks trying to move from Subtext to WordPress.   Some successful, and others less successful, without a lot of post-migration work.

My plan seemed fairly simple: migrate my blog posts from my older Subtext blog engine which uses .NET to my new host using WordPress and PHP/MySQL.   I would keep the same domain and simply change DNS when all was said and done.  Seems simple enough…

My issues I think started a few years back when I began using Windows Live Writer (WLW) for creating my blog posts.  Older versions of WLW seemed to put files in a totally different folder under the website content folder than the newer versions.   This didn’t present a problem, until sometime later when I began having database issues and exported my blog and re-imported it locally on my IIS server.   I later found the although the content exports fine, all the images become orphaned and have bad links.

I know I spent a number of hours after getting database restored going through each blog post and manually checking hyperlinks and copy/pasting the files from old folder to new folder to get things back to the way they were.

Exporting your blog posts in Subtext uses a format known as BlogML.  This is an XML file that contains all your blog content.  The idea is that since this is a standard, you can take this file and re-import the content to a new blog engine.   Sounds simple enough, until you find out that WordPress doesn’t support BlogML format natively.   Luckily there is a free plug-in that you can download that will add this option.

The one I’m using is from Sean Patterson named “BlogML Importer”.  You can find this plug-in within the WordPress Plugins menu.

Unfortunately, you will find right away that after import, all your posts look like a long string of alphanumeric characters.  Basically, a base64 encoded string.   Evidently, Subtext supports the standard and base64 encodes the “content” within the XML file.   The WordPress BlogML plug-in, unfortunately just imports the content as-is.

You’ll find that you then need to delete all your posts.   Another plug-in named “WP Mass Delete” from CyberSEO.NET worked for me and allowed me to easily mass delete all my bad posts.

Since WordPress was not going to allow me to import the BlogML file that contains base64 encoding content, I needed a utility that would decode it.  Luckily, I found Rob Garfoot’s  blog where he created a most-excellent utility to convert my file.

I fired up Visual Studio 2010 and compiled the code and it ran flawlessly.

I attempted to re-import my decoded BlogML file and it worked.  Unfortunately, I found that none of my images migrated and and links were still pointing to my life site.   I had a couple options here, but since my images were already all over the place from WLW and I didn’t feel like spending hours fixing this… I had a choice to either drop all my blog posts and start fresh or find another, more automated option.

Since I had a number of posts, I wanted to find another option so I wouldn’t lose everything.   I then ran into a neat utility from from Ricci Gian Maria that basically used the Metaweblog API to copy/transfer each post from your old website into your new website.

I did have issues trying to open his Visual Studio project and ended up making a new blank one and simply copy/pasting his code into the new project.  I then downloaded the dependency assemblies, Joe Blogs on Codeplex and HtmlAgilityPack on Codeplex and creating a reference.

When you run the utility, the trickiest part is making sure you get the credentials and the URL path to your source and destination blog correct.  Otherwise, it just sits there for a while and will eventually timeout and return an error.

BlogMigrator

The import piece here is the XMLRPC URL.

Source XMLRPC URL for me was http://myblog4fun.com/services/metablogapi.aspx

Destination XMLRPC URL for me was http://66.147.244.127/~myblogfo/xmlrpc.php

Since I I hadn’t changed DNS yet, I was using a temporary destination URL to my WordPress site using the TCP/IP address.

Before testing and hitting Load Recent, you will need to log into WordPress administrator and enable XMLRPC.

EnablingXML-RPC

When ready, you need to make sure you highlight any/all the blog posts from the source before hitting the Transfer Selected button.  You can then monitor the activity within the right-hand pane.

The Blog Migrator application worked flawlessly.

I then changed my DNS to point to my new host’s DNS servers.

The only thing remaining, though was changing the WordPress site from my temporary TCP/IP address URL to my actual domain name.   This was simple enough from the WordPress settings page, but I ran into another snag where all my images since running Blog Migrator, now contained a http://66.147.244.127/~myblogfo prefix in front of the image instead of http://myblog4fun.com.    If I was actually migrating to a new domain name and not using the temporary TCP/IP URL, then I would have been fine.

Therefore, I then had to figure out how to mass change any URLS that had the temporary to the live.

I then learned that I can launch PHPMyAdmin and run some SQL against my post_content database to mass change the absolute URLs to the correct live address.   Sample SQL is below:

UPDATE wp_posts SET guid  replace(guid, ‘http://66.147.244.127/~myblogfo’,’http://myblog4fun.com’);

I then needed to change the URLs within the post content in case I linked within my own post to myself.   Sample SQL is below:

UPDATE wp_posts SET post_content = replace(post_content, ‘http://66.147.244.127/~myblogfo’,’http://myblog4fun.com’);

Once both SQL statements above have executed, I was then able to browse back out to my blog and see that all my images and hyperlinks were pointing to the correct http://myblog4fun.com URL.

Although creating a WordPress site at my new host was very easy and a 1-click process, if I hadn’t had an old blog and just started fresh, I would have been fine.   Even migrating to a new domain name would have eliminated having to run the Blog Migrator tool.

The blog posts categories didn’t come over, so I still need to go recreate those and reassign, but in the end, however, I am pretty happy with the migration.

If you’re interesting in some cool plugins, I highly recommend the following:

Hopefully, if you plan on migrating Subtext anytime soon, you will have a smooth migration as well.   If not, hope this post helps you.

Good luck!

Posted in Blog | 5 Comments

Introduction to KegDroid

If you’re looking for an interesting hardware project, KegDroid may be a good choice.  Built using an Android tablet, Arduino, an NFC reader,  and various other components; including beer. 

KegDroid

For some, the internet of things has just got even more useful.  Below, Paul explains the whole process and gives us a complete tour of the system in his video.

You can catch up with Paul from his Google+ page, here.

Posted in Android, Arduino | Leave a comment

Migrating from Subtext 2.5.1.20 to WordPress 3.3.2

Today I am happy to report that I have successfully migrated from Subtext to WordPress!

Posted in Blog | Leave a comment

Windows 8 Consumer Preview Available

Win8-ConsumerPreview

Today is Leap Day!  Microsoft has launched it’s Windows 8 Consumer Preview along with Visual Studio 11 Beta.

Channel9 has a good preview demo here.

You can download the latest Windows 8 Consumer Preview bits here.

You can download the latest Visual Studio 11 beta bits here.

And VisualStudioMagazine has a nice guided tour of Visual Studio 11 here.

If you happen to have a Samsung Series 7 slate, Brad Wilson has an excellent post on getting it installed here.

Now go download the files and start writing your Metro apps now!   You can get the tools, SDKs, etc., from here.

Posted in Windows 8 | Leave a comment

Cannot process argument because the value of argument “name” is invalid

Today I was trying to use Powershell to read a simple CSV file that I created from DB2 using DB2’s EXPORT command.  It seemed simply enough.

The Powershell command was:

$csv=import-csv “c:\temp\junk.csv”

Unfortunately, I kept receiving the following error:

Import-Csv : Cannot process argument because the value of argument “name” is invalid. Change the value of the “name” argument and run the operation again.

The error would indicate that there is something wrong with the path.  However, it ended up being related to having one or more empty columns.  Powershell uses the first row of the CSV file as names for the columns (unless you change it using the –header option).   When you have multiple blank columns, you will get the above error.

The solution was simple as adding the column names to the import-csv command:

$csv=import-csv “c:\temp\junk.csv” –header(“column1”,”column2”,”column3”,”column4”,”column5”)

I think I wasted about 30 minutes on this issue verifying my syntax, the path of the file, etc.

Hope this helps!

Posted in Powershell | Leave a comment

Using Powershell to access SQLCE 4.0

I totally dig Powershell.  I tend to find myself using it almost daily for some kind of scripting task, no matter how small or large, because it makes things so much easier.   In a prior post, I discussed using Powershell to access DB2.   I thought it only fitting to basically do the same thing for SQLCE.

I write a bunch of utility applications for my job.  Typically these are simple C# console applications that perform a particular task.  Sometimes I even use Powershell’s hosting feature to embed Powershell within my C# application.   It’s tabular reporting makes it easy to produce nice output…

One of my latest creations was monitoring  some web applications that we have.  I used WatiN to automate logging into our website, log the results, and basically report whether the attempt was successful or whether the site returns any errors.  In addition to using log4net to capture activity and tracing information, I wanted a way to track my login attempt; where I’m storing the url of the site, the amount of time it took to get logged in and reach the main page, and log any errors that the site may return.

My first thought was just write the info out to a text file or .CSV file.   But that didn’t seem very user-friendly, especially since I knew that I’d have to go back and run queries against the data.   The obvious option for me would have been to use SQL Server, but since this was a simple task, I didn’t want to have to rely on using either a local or remote SQL Server.   Since I’ve never used SQLCE before, I thought it would be a great opportunity to learn something new…

One of the things I learned was that I needed to make sure to install the SQLCE 4.0 runtime.   You can download it here from Microsoft.

On my machine, it is installed to C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v4.0\Desktop folder.

Once the runtime is installed, I simply loaded up the Powershell ISE and execute the script below.

Note that I’m changing the default host’s buffer size so that when using the PowerShell ISE, I can see all of the output.   Some of my table fields are over 60 characters in length and the Powershell ISE truncates the output.

In addition, the $connectionString variable points to your SQLCE .SDF database file.  Mine is simply called Watin.sdf.

# http://stackoverflow.com/questions/978777/powershell-output-column-width
$Host.UI.RawUI.BufferSize = New-Object Management.Automation.Host.Size (500, 25)

$binpath = "C:\Program Files (x86)\Microsoft SQL Server Compact Edition\v4.0\Desktop\";
[Reflection.Assembly]::LoadFile("$binpath\System.Data.SqlServerCe.dll") | out-null
$connectionString = "Data Source='C:\TEMP\WATIN\watin.sdf';Password=password123"

$connection = New-Object "System.Data.SqlServerCe.SqlCeConnection" $connectionString

$ds = new-object "System.Data.DataSet" "dsLogEntries"
$q = @"
   SELECT
      CustomerGroup, AccessTime, TimeTaken, ErrorResult, CustomerUrl
   FROM
      LogEntries
   WHERE
      (CustomerGroup LIKE '%M072331%' OR CustomerGroup LIKE '%M083313%')
      AND ErrorResult NOT LIKE '%WatiN%'
      AND ErrorResult NOT LIKE '%Microsoft.mshtml%'
      AND ErrorResult NOT LIKE '%mscorlib The process%'
      AND AccessTime > '01/30/2012 00:00:00'
   ORDER BY
      AccessTime"@
$q

$da = new-object "System.Data.SqlServerCe.SqlCeDataAdapter" ($q, $connectionString)
$da.Fill($ds)

$dtLog = new-object "System.Data.DataTable" "dtLogEntries"
$dtLog = $ds.Tables[0]
$dtLog | format-table -autosize | out-default
$dtLog | Export-Csv 'C:\TEMP\WATIN\output.csv'

$dtLog.Dispose | out-null
$connection.Dispose | out-null

In the example above, I’m connecting to the SQLCE database, creating a DataSet object, using a here-doc to easily copy/paste a SQL query into Powershell, then using a DataAdapter to load the DataSet.   I’m then copying the first table from the DataSet, $ds.Tables[0], to a DataTable object.   Finally I’m simply outputting the contents and passing it to the format-table command.    For good measure, I’m also creating a .CSV file, just in case someone wants me to send them the data.

Note that due to a bug in Powershell, without passing the format-table results to out-default I would receive the following error:

out-lineoutput : Object of type “Microsoft.PowerShell.Commands.Internal.Format.FormatStartData” is not legal or not in the correct sequence. This is likely caused by a user-specified “format-table” command which is conflicting with the default formatting.

It seems others have had this issue as well and until there is a permanent fix, using out-default is an acceptable workaround.

Well, that’s it.  I hope you find this snippet of code helpful.

Posted in Powershell, SQLCE, Uncategorized | Leave a comment