SharePoint Saturday San Diego 2014

Don’t miss the upcoming SharePoint Saturday – San Diego on November 15th!


This is a FREE one-day event hosted by the San Diego SharePoint User Group and will feature sessions for end-users, business users, IT professionals and developers. There will also be a track dedicated to Office 365! 

Who Should Attend

SharePoint administrators, end users, architects, developers, and other professionals that work with Microsoft SharePoint Technologies

Where will the event be held

imageUCSD Extension located at

6256 Greenwich Drive, San Diego, CA.




Who will be presenting

This event has confirmed many other nationally recognized SharePoint speakers and Microsoft SharePoint MVPs! Check out the Speakers page on If you are looking to enhance your knowledge of any aspect of SharePoint and/or network with other SharePoint professionals, we strongly encourage you to attend this community event.  image

Why you should attend

Beyond the knowledge and networking, this event will be a blast. There will be a large prize raffle and of course, a ‘SharePint’ social event in the evening. We hope to see you there! Please visit the SharePoint Saturday – San Diego site for more information or to review the recently published speaker schedule. For those of you on twitter, please tweet about this event using the #SPSSD hashtag.

Please register right away! See you there! Register Here!

Who are the Sponsors




Ivan Sanders

clip_image001 clip_image002 clip_image003 clip_image004 clip_image005 clip_image006


2014 Microsoft MVP Award!

Microsoft MVP Banner

Its official, I just received the notification included is an excerpt:

Dear Ivan Sanders,

Congratulations! We are pleased to present you with the 2014 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their high quality, real world expertise with others. We appreciate your outstanding contributions in SharePoint Server technical communities during the past year.

The Microsoft MVP Award provides us the unique opportunity to celebrate and honor your significant contributions and say “Thank you for your technical leadership.”
Mike Hickman Director Community Engagement Microsoft

Wow another year, this has been the most incredible award I have ever been privileged to receive. I have met so many awesome people. It was a little surreal at first as I was getting to hang with all of my heroes

Thank you for recognizing my community contributions for the 5th year in a row…





clip_image001 clip_image002 clip_image003 clip_image004 clip_image005 clip_image006

SoCal Code Camp San Diego 2014 – June 28th & 29th @ UCSD Extensions

June 28th & 29th @ UCSD Extensions

Hello SoCal Developer Community,

It’s getting down to the wire with only two weeks to go. Many new sessions that have been added see if anything new piques your interest.

The Topics You Want!
With almost 80 sessions at present, we know that more will be added in the days ahead. Sessions on ASP.NET vNext, Visual Studio Online, Typescript, Game Dev and lots more!

Take a moment to show your interest on the sessions page, and, while there, add a session of your own in your area of expertise so that your developer peers will benefit! All platforms, programming languages, and disciplines are welcome!

Geek Dinner – We have great ideas bouncing around for our Saturday night Geek Dinner.  Food and beverage with our dev peers is the perfect way to share our excitement after day #1. Stay tuned!

ASP.NET vNext –
There’s lots of exciting things happening in the ASP.NET space! Be sure to check out and to stay up to date on ASP.NET and Web Tools. You can also follow @aspnet and for news, tutorials, videos, and much more. But that’s not all! We’re also on GitHub (yeah, I said it) at It’s a great day to be an ASP.NET developer on the Open Web.

Remember, CODE CAMP IS FREE!!! 

June 28th and 29th!

RSVP Now at
Thanks and we look forward to seeing you at SoCal Code Camp SD @ UCSD!




Cant wait to hang out with old friends…. See ya there!!!

clip_image002 clip_image004 clip_image006 clip_image007 clip_image009 clip_image010




SharePoint Saturday Atlanta 2014–June 21


imageI hope you can attend one of my mew sessions on Business Intelligence in SharePoint 2013. You can download the Demos and Scripts from

If you like to participate you know ask questions, I will be signing copies of my book “Business Intelligence in SharePoint 2013” just for you. Also, I will have more than a few 16 and 32GB USB3 Flash Drives full of content on SharePoint 2007. 2010, and 2013 Admin, Developer, DBA, and Business User Content just5 for you

Speaker Dinner and Valet Parking

The festivities will kick off Friday evening, June 20th with the Speaker Dinner. We’d love to have you! Please confirm your attendance. In order to properly plan for the speaker dinner, we must have your RSVP no later than Wednesday morning at 9:00 AM EST. Please RSVP to

Speaker Dinner starts at 6:30 with a pre-dinner happy hour. Dinner Service starts at 7:30 PM.

Max Lager’s

  • 320 Peachtree St NE, Atlanta, GA 30308
  • (404) 525-4400

Website  |  Yelp  |  Google Maps

If you could please take this opportunity to help us promote the event tell all of the SharePoint folks and Business User who want to know more about SharePoint 2013 we would greatly appreciate it! Please  Tweet at @SPS_ATL or use #SPSATL to get the word out and please feel free to link to our site at  Our event registration can be found here, #SPSATL 2014 on EventBrite. You never know there will probably be prizes for the folks with the most tweets about the event..

Parking and Event Location

clip_image005Georgia State University Student Center will host SharePoint Saturday Atlanta 2014.

Georgia State University Student Center

  • 44 Courtland St. SE
  • Atlanta, GA 30303.​

Parking will be available at the M-Deck at Georgia State. Parking is $7.00. The M-Deck is located directly across the street from the venue.

Please see the agenda for your timeslot and other event day logistics.

Again, thank you for your support!


Warm Regards,

SharePoint Saturday Atlanta Planning Committee

Developers Association of Georgia
615 Sailwind Drive
Roswell, GA 30076

Visit our new website for the latest info on #SPSATL2014!

I Don’t know where the after party “SharePint” Event is being held, but will let every one know as soon as I get the details in the mean time keep checking the website..

Oh I almost forgot to mention:this will be my first Business Intelligence presentation and Demo using only Voice Commands with SharePoint 2013 SP1 April 2014 CU, PowerShell, SQL Server 2014, and Windows Server 2012 R2 Update 1



clip_image002 clip_image004 clip_image006 clip_image007 clip_image009 clip_image010

SharePoint 2013 Migrations, Are you having fun yet??

Wow what an incredible couple years SharePoint 2013 is still rockin on premise and online

Time Consuming Steps

However, there were two time consuming steps that didn’t have anything to do with the mechanics of the migration or the technology like moving WebParts, Pages, Items, Documents and creating Site Collections from Sites in Additional Content DBs.

  1. 1.The conversion of the Binary File Format documents to the OpenXML File Format.
  2. 2.Teaching folks why managed metadata is important and the creation of a Global Taxonomy, that includes Navigation

Luckily, there were two sources of information that made this easier but still not painless Waldeks Post – Building Global Navigation in SharePoint 2013 (it works) and the WAND Library. Unfortunately, though I have access to the Library the client did not choose to purchase the subscription so we didn’t get to take advantage of the huge library of terms.

WAND has started offering its entire catalog of taxonomies from the cloud, where you have the ability to subscribe monthly and download the parts that your Client needs to either start their taxonomy or fill out their taxonomy.  I have just been through a relatively easy migration 8 Content Dbs and a small 1TB of Content.

Missing Tools for In-Flight Conversion of Site Columns

The largest notable part missing, though metalogix will help you modify Multi-Choice Site Columns to Managed Metadata Site Columns In-Flight, there are NOT ANY migration products that will convert your binary File Format documents to the OpenXML File Format.

The Microsoft tools like Office Migration Planner will not work with a mapped drive using WebDav, but you can still use PowerShell though we found it was actually better to use a staging Farm, Convert all of your Documents using Word Automation Service. then perform a final migration where we modify the columns In-Flight to take advantage of the managed Metadata Site Columns.

This is important, if you want to take advantage of changing the Multi-Choice Site Columns to managed Metadata Site Columns In-Flight. Because if you have not converted all of your RTFs, HTMs, DOCs to DOCX then you will lose the metadata associated with these documents.

I’m not sure why metavis, sharegate, metalogix, tsunami or others do not build document conversion into their products since we need to be moving off the Binary format for many reasons and embracing the OpenXML Format




clip_image002 clip_image004 clip_image006 clip_image007 clip_image009 clip_image010

SharePoint 2013 NOTICE: Microsoft Deactivated SP1 Download

UPDATE: 04-22-2014 Reference: Stefan Goßner

The updated version of Service Pack 1 has been released today!

Refer to the information below to acquire the updated Service Pack for your product:

NOTE The KB articles for the re-released Service Pack is different from the recalled Service Pack.

  • KB 2880551 – SharePoint Foundation 2013 SP1
  • KB 2880552 – SharePoint Server 2013 SP1
  • KB 2880553 – Project Server 2013 SP1
  • KB 2880554 – SharePoint Server Language Pack
  • KB 2880555 – SharePoint Foundation Language Pack
  • KB 2880558 – Office Web Apps Server 2013 SP1

Download links for updated SP1:

Customers with Service Pack 1 Deployed

For customers who have previously deployed Service Pack 1, download the updated Service Pack 1 and install over the existing Service Pack 1 running PSConfig or PSConfigUI immediately following.

Customers without Service Pack 1

For customers without Service Pack 1 deployed, download the updated Service Pack 1 package and deploy as per the KB documentation.


There is no update to the integrated ISO ("slipstream") from MSDN, VLSC and MPN as it was not affected by the issue.

Reference: see official announcement in Bill Baers blog post.


“Notice: We have recently uncovered an issue with this Service Pack 1 package that may prevent customers who have Service Pack 1 from deploying future public or cumulative updates. As a precautionary measure, we have deactivated the download page until a new package is published.”


“Notice:We have recently uncovered an issue with this Service Pack 1 package that may prevent customers who have Service Pack 1 from deploying future public or cumulative updates. As a precautionary measure, we have deactivated the download page until a new package is published.

A known issue in SharePoint Foundation 2013 SP1 can affect the functionality of the Search WebPart. We encourage you to limit production installations of SharePoint Foundation 2013 SP1 until a fix is available. SharePoint Server 2013 is not affected by this issue.”

I would like to thank Andy Williams the Nikon TAM (Microsoft Technical Account Manager), for bringing this to our attention Thursday. Unfortunately, we are affected since we have deployed SP1 to All DEV and PRD Servers. The only good news (I guess) is that our topology consists of Standalone farms for both WAC and WFM.

You may want to also check out Todd’s post as he states that Bill Baer has said that the ISO downloaded from MSDN does not have this issue.




Technorati Tags: ,

clip_image001 clip_image002 clip_image003 clip_image004 clip_image006 clip_image008

Stay Competive with Business Intelligence in SharePoint 2013 & O’Reilly

book cover

Stay Competitive

O’Reilly Media spreads the knowledge of innovators through its books, online services, magazines, research, and conferences. Get the information you need from the experts you trust; visit to purchase this book.

Business Intelligence in Microsoft SharePoint 2013

Get 40% off of the print book and 50% off of the ebook version of this book by entering discount code AUTHD.

By Norman P. Warren, Mariano Teixeira Neto, Stacia Misner, Ivan Sanders, Scott A. Helmers

May 2013, ISBN 978-0-7356-7543-8

406 pages, $34.99


© 2014 O’Reilly Media, Inc. O’Reilly logo is a registered trademark of O’Reilly Media

clip_image001 clip_image002 clip_image003 clip_image004 clip_image006 clip_image008


The SharePoint Conference 2014 Part 1

imageMy favorite sessions so far has been Develop Advanced Search-Driven SharePoint 2013 Apps, my favorite Exam so far was 70-332, and my favorite party so far? was the Annual RED Party hosted by AvePoint.

My Favorite Keynote (so far) was Bill Clinton, he Rocked, and the message is clear. As the next generation has grown up without the traditional borders due to the technology revolution. They are more inclusive and think nothing of playing video games or talking on Skype with other members of their generation anywhere in the world. I know on any given night my son Jon is online with Germany, India, Italy, China, Korea, and many more. playing video games, watching youtube,  and talking about college (how boring and useless). this is in stark contrast to the typical exclusiveness of previous generations,  the us verses them mentality. image


Regardless of where you live, the color of your skin, the language you speak, gay or straight, the God you believe in, you are still one of us, and not one of them.

We are ALL in this together!@




But the Best Part of the Conference (so far) was a small dinner for the SharePoint Server MVPs at Dal Toro. Its really cool when a group of us have the opportunity to get together in a quite setting, have dinner, and discuss some of our more interesting war stories, life in the trenches.

But, its more than that it’s about our community.


As in all communities there is always change and after dinner Jeremy Thake announced that this would be his last MVP Event. Most of you probably know Jeremy from his current job with AvePoint. I was lucky enough to have met him prior to his move to AvePoint and America. Though I am sad that we may not get to hang out at the MVP Summit (LOL) the way we have in the past, I am more than thrilled he has taken a position with one of the best companies in the world (Microsoft) and in the best product group (SharePoint).

Congratulations Jeremy, I think its really cool that though you may have left AvePoint and are no longer a SharePoint MVP we will still be able to hang out and continue to work with you in your new position.

TAO at the Venetian Las Vegas



      AvePoint ROCKS!!



Oh, and Club SPC was pretty cool last night as well, I loved the Disco Ball and music thumpin in the Exhibit hall….


I hope everyone will be at the Las Vegas Motor Speedway for the Evening Event Tonight, from 7-10pm PST! The blowout party is sponsored by Neudesic. We will see if its more cool than the AvePoint Party last night at TAO.




Access Day 2014 Wednesday, April 16, 2014 Register Now

Access Day 2014 Wednesday, April 16, 2014 Register Now


Join us for a one-day conference on the most popular desktop database application development platform – Microsoft Access! We have an exciting lineup of internationally respected presenters, including Microsoft Access MVPs, book authors, and members of the Access development team at Microsoft.

Here’s what attendees said:

Great information, great networking and well worth your time!
~ Andy T.

  • Access Day has provided a welcoming environment for professionals to meet and get acquainted with peers…
    ~ Craig R.
  • The presentations focused on real-world solutions and scenarios and reminded me how much I like Access.
    ~ Luis C.
  • I really enjoyed the great mix of topics and the enthusiasm of each presenter was excellent.
    ~ Craig A.
  • Organizer

  • Armen Stein, Access MVP and president of J Street Technology, is organizing a one-day conference on Microsoft Access Wednesday, April 16, 2014 in Irvine, CA.


  • Speakers

  • Access Day features internationally-respected presenters, including Access MVPs, book authors, and members of the Access development team at Microsoft. So far we have sessions lined up from Alison Balter, Kevin Bell, George Young, Tom van Stiphout, and Armen Stein.


  • The intended audience is Access developers and advanced users who want to learn ways to make their applications more powerful and develop Access solutions for the web. The conference will be held at The Microsoft Technology Center in Irvine, CA, which is close to many hotels.

  • More information, please visit FAQs | Irvine 2014.

    For a list of presenters, please visit Presenters | Irvine 2014.

    For a detailed schedule, please visit Schedule of Events | Irvine 2014.

    To Register, please visit Register | Access Day 2014 | Irvine.

SPC 2014

Check out this local event Orange County everything you wanted to know about using Microsoft Access 2013

Hopefully I will see everyone there……

I know you will be in Vegas for the SharePoint Conference March 3 – 6th 2014



clip_image001 clip_image002 clip_image003 clip_image004 clip_image006 clip_image008

metalogix content matrix resolves errors

I recently posted on my disappointment of metalogix due to the continual system crashes. The crashes have been resolved and occurred in version There were numerous errors removing version

However, all issues have been resolved in version and greater.

metalogix version ROCKS!! Thanks to the folks at metalogix for working with me to get the issues resolved

Creating Managed Metadata Fields in Flight

After resolving the issues I wanted to check out the inflight creation of Managed Metdata Field migrated from SP2007 MultiChoice Field in flight. The new Managed metadata Field was created along with the term set based on the old SP2007 MultiChoice Field.

Screenshot Metalogix Creating the Terms in flight


However, there is an issue that is not handled in Flight if you have any .DOC files (the old Binary format Office Documents) you will lose all of your, metadata.

The workaround for this issue is to first bring over the libraries as they are. Once they are in SharePoint 2013, you can run the following PowerShell Script if you have configured Word Automation Services to Convert the old binary format to the Open File Format DOCX ,

Then create the Managed metadata field and term set use content matrix

$wasp = Get-SPServiceApplicationProxy | where { $_.TypeName -eq "Word Automation Services Proxy" }
$job = New-Object Microsoft.Office.Word.Server.Conversions.ConversionJob($wasp)
 $web = Get-SPWeb
 $inputFolder = $web.GetFolder("Shared Documents")
 $outputFolder = $web.GetFolder("Shared Documents")
 $job.UserToken = $web.CurrentUser.UserToken
 $job.Name = "Convert Docs to Docxs"
 $job.Settings.OutputFormat = [Microsoft.Office.Word.Server.Conversions.SaveFormat]::Document
 $job.Settings.OutputSaveBehavior = [Microsoft.Office.Word.Server.Conversions.SaveBehavior]::AlwaysOverwrite
 $job.AddFolder($inputFolder, $outputFolder, $false)
 $status = New-Object Microsoft.Office.Word.Server.Conversions.ConversionJobStatus($serviceAppProxy.Id, $job.JobId, $null)
 $timerJob = Get-SPTimerJob "Word Automation Services"
 Write-Host $timerJob

.csharpcode, .csharpcode pre
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
background-color: #f4f4f4;
width: 100%;
margin: 0em;
.csharpcode .lnum { color: #606060; }

ScreenShot of SharePoint 2013 Technical Library using Managed Metadata Columns











ScreenShot SharePoint 2007 Content Type using the Choice Column type