Leave a comment

Major announcements coming out of TechEd Europe & AzureConf14

Exciting updates to Microsoft Azure at TechEd Europe, enabling simplicity, scale and innovation

Office 365-Our latest innovations in security and compliance

OneNote gets even better on Mac and iOS

Announcing the Azure Marketplace

TechEd Europe 2014 News: Developer Tools

Enterprise Mobility Game-Changing Announcement #1

Azure AD Support for JavaScript Single Page Apps using OAuth2 implicit grant now in preview!

…and from AzureConf14 last week:
Azure’s getting bigger, faster and more open

Leave a comment

Another #SPC14 check list… with a different spin


Flying at 34k feet over the midwest on my way to #SPC14 and I realized that I had not stopped to enjoy the moment.  We are once again about to dive head long into a week filled with the greatest technical community around.  This is my 4th SharePoint Conference, but the first time that I will be presenting.  Over the past 3 years as a speaker in the SharePoint Community I have found my way to Las Vegas about a dozen times now, not including my regular enjoyment trips for March Madness, the occasional bachelor party, and what used to be a semi-annual gambling trip.  While there are several blogs out there talking about what not to miss while you are in town for the conference, I hope to throw a different spin on the conversation.  Here goes:

1.)    Speed walking the trade show floor

Personally I like to do a full lap of the floor before walking up to any of the booths.  Just from perusing the floor you can get a sense of where you will want to spend your time.  If you just start at the entrance and dive in you may miss out on some of the hidden jems of the floor.

2.)    Pick up a carry around bag

You are going to get some form of bag from the conference itself, but more than likely this is going to be a backpack or a messenger style bag.  I am talking about an open top two handled bag.  Lots of vendors have them at their booth and they come in very handy.  If you are carrying your laptop\tablet around in your backpack you don’t want to have to rip it off your back every time an exhibitor gives you a piece of swag or collateral.  It is much easier to drop it in your bag and move on.  Sort through it all later.

3.)    HYDRATE

I am not just talking about drinking water, which you should do at every opportunity.  Most of us do not come from the very dry climate that Las Vegas features.  Couple with that the recirculated air of the conference center and double that up with the open smoking indoors that you find on the casino floor and you have a nasal nightmare.  Get some saline spray and keep your nose moisture laden or you will regret it.  Also, utilize the lotion from your hotel room to keep from turning into a dry scaly mess.

4.)    Note taking in your sessions

This year with the second screen experience you are getting the slide deck directly from Yammer.  Rather than trying to take notes in OneNote and correlating that to a slide that the speaker is talking about, simply use the notes field in PowerPoint and take notes directly in your copy of the deck.  This will make for a more cohesive recollection after the conference.  I tend to insert a slide where the presenter is doing their demos and take notes directly on that blank slide for the demos.  Remember that you are going to get access to the recordings of the sessions afterwards.

5.)    Pay attention

I have been very guilty of this at some conferences and missed out as a result.  You are immersing yourself in the largest collection of SharePoint talent gathered in one place.  What do you think is going to get talked about in the hallways between sessions?  At dinner? Over drinks? If you haven’t been paying attention during the day, how are you going to keep up with the conversations?  Take the time to listen and learn in the sessions and then continue the learning with your peers after.

6.)    People

The best part about being in the SharePoint Community is the people.  This is the best networking opportunity you will have all year to meet people and grow your network.  Whether you are looking to meet someone who you respect from reading the blogs, books and watching the PluralSite course or if you are just trying to meet likeminded people who are just getting started, don’t miss out on this opportunity to connect and make new connections.  Be sure that you have a Twitter & LinkedIn account so that you can expand your network and connect with the people you meet.

7.)    Enjoy yourself

If you cannot find fun at SPC, then you are doing something wrong.  There are always multiple somethings going on every night.  Keep an eye on the Yammer network, #SPC14 on Twitter, and FourSquare to find the open invites all over the place.  Can’t get in to a vendor’s party because the line is too long?  MAKE YOUR OWN PARTY.  There is a bar every 22.7” feet in Las Vegas.  We did this at SPC in Anaheim because we weren’t willing to wait on a 2h line to get into a club.  While the club party was amazing from what I heard, I wouldn’t change a thing about the night that we had.

…and on lucky #7 I will leave you.  I hope that these tips are useful to you and I look forward to seeing you throughout the course of the conference.  I will be hanging around playing Xbox One between sessions at the Atrion booth #2140, so please stop by and say hi.

Please join me for “Achieving better business productivity through Apps for Office” on Tuesday morning at 9a.  I am very excited to present this awesome topic on the first Executive track at SPC!

Leave a comment

MVP Award – My new year’s day suprise


With my vacation coming to a close I opted to spend one last morning with the boys and let Jill sleep in this morning. The day started like any other, Sam (age 3) came into my room and immediately started talking while Max (age 5) was hunkered down in his bed surrounded his books. We went downstairs to start the day and have breakfast, for which they had requested my special chocolate chip pancakes.

We finished our breakfast and had some fun play time before the pathetic plea for movies kicked in. I’m a sucker and had some web surfing to do so I caved quickly. When Jill came down stairs she found the 3 of us in the middle of the Lorax.

I popped onto Twitter to see what was doing in the world and saw Marc Anderson‘s tweet stating that he had been renewed for his MVP (and deservedly so). I had been informed that I was under consideration this cycle, but had not put much stock in my chances of being awarded. I was about to tell Jill about Marc and that it looked like I had not gotten it this year when my Outlook dinged and a message titled “Congratulations 2014 Microsoft MVP!” popped up.

I was speechless. Jill & I have been married almost 7 years and I can count on one hand the number of times that she has seen that happen.

I am humbled and honored to have been presented with this award. There are too many people for me to name here to whom I owe a debt of thanks & appreciation, so I will simply say thank you to the SharePoint Community as a whole.  I have to give the credit for this award to the people who have given them most, and that is my amazingly supportive wife and kids without-whom I would not be able to do any of the community work that I do.

I look forward to another great year of blogging, speaking, geeking, and community building. See you all in March at #SPC14 in Las Vegas if not before!

1 Comment

Order is everything when setting up SharePoint on Azure IaaS

I spent a bunch of time with my buddy Kirk Evans while at DevConnections in Las Vegas last month, some drinking and watching football, but mostly learning about running SharePoint on Azure. Azure IaaS has come a long way, but is still confusing & troublesome at times. I have written a few PowerShell tools that help me and I will share them in some future posts.

I started playing with SharePoint on Azure IaaS on my own without doing much reading. My goal in this was to see how intuitive it was to get things setup and going for the average person. Once in the console creating a VM was very quick and simple. I was up and running on a pre-built Windows Server image in no time. This was great.

Then I decided that I wanted to build a SharePoint farm. I deployed out 2 addtional VMs. I built an Active Directory and attempted to join the other 2 servers to the domain. This is where I ran into problems.

There are some building blocks that need to first be put in place before you start building servers if you want them to be able to communicate with one another.

The first is the Affinity Group (AG). An AG is required before you can create a Virtual Network. The way that Kirk explained it, the AG is a container to keep your Virtual Network in a single data center. To create an AG you will either use PowerShell or go to Settings at the bottom of the Management Portal and find Affinity Groups as the fourth of five options.

1-1-2014 10-30-49 PM

Next create the Virtual Network and assign it ot the AG.


After the Virtual Network is created you will be able to setup a Cloud Service. The Cloud Service is going to be the container for your VMs.


This process sounds uber simple, but the order of things matters here. Now you can create your VMs. Once you have your VMs and your DNS server built you can go in and specify the Domain Controller as a DNS server.

This is where you will hit a snag. In the normal course of events you would be running a domain controller on a static IP address. Unfortunately this is not something that you can do on Azure IaaS. Every time you deprovision a VM, which you have to do unless you want to get charged, your IP address reservation can get taken by another machine.

My solutions to this problem was fairly simple:

1.) Create a virtual network for each of my environments
2.) Always start the VMs in the same order so that they pick up the same IP address each time

The first part was easy, however the second part is difficult when you get beyond one or two people using the same Azure subscription. I needed an easier way to ensure that my VMs would start in a specific order. After a late night with one of my favorite single malts I came up with a fairly simple PowerShell solution.

As a result of my conversations with Kirk, and some annoyance at the inconsistent nature of shutting down VMs using the Management Portal, I decided to look into how I could shutdown my VMs using PowerShell. There is a nice cmdlet for doing this called stop-AzureVM.

Since I want to do this for a set of VMs I needed to be able to run a for-each loop, so I wrote a start and stop function into the script.


I started to use a CSV or text file method for loading the VMs that I wanted to start and stop together when I realized that I didn’t want to have to maintain a series of files on every environment that I create and then distribute that to my team. Not to mention that I have multiple Azure subscriptions that I am using for clients and personal use. The management of that would get cumbersome quickly.

Then I remembered that all of the VMs that I will want to use together are going to be a part of the same Azure Cloud Service (ACS) and that each farm or group of servers that I want to use will have their own unique ACS. There is a cmdlet to get all of the ACS in an Azure Subscription called get-AzureService. I have opted to get the Service Name, Affinity Group, and status of the ACS in my script.


The status field is not overly useful, but if something other than “Created” is returned it is worth investigating since that is the expected value.


Once you have the correct ACS the script will list the VMs that exist within and ask if you want to start or stop them.

The obvious question at this point is “How does this solve the IP address problem that you set out to solve?”

The answer is that the script will always start and stop the VMs in a specific order. Starting the VMs using this script will ensure that the same IP addresses are obtained every time.

The script was originally designed to solve this problem however I have been using it to ensure that my VMs get shutdown cleanly rather than using the Management Portal which, as I mentioned earlier, is inconsiestent at best.

I hope that you find this as useful as I do. I have been using this script since I wrote it Thanksgiving weekend and I stopped tweaking about a week ago. You can find the script here: http://www.jasonhimmelstein.com/scripts/Azure/set-AzureVMs/set-AzureVMs.ps1


Leave a comment

#SPSRI Wrap up


The inaugural #SPSRI is now in the books! When I joined the team putting this event on I had a few goals:

1.) select speakers who would elevate the event & give the attendees an amazing learning experience

2.) follow through on Chris’s goal of running the event on a minimal budget & get just enough sponsors to make the budget doable

3.) provide attendees & speakers with an fun, interactive, lively event that would be worth staying all day

4.) cross the 100 attendee barrier

5.) make the SharePint something that people wouldn’t have to leave the venue to participate in

I am happy to say that most of these goals were met & exceeded. We had a terrfiic panel of speakers (including several first timers), ended up with over 110 people in attendance with more than 70% staying until the closing raffle, and our SharePint was at the restaurant bar directly next to the venue which allowed us to retain the majority of the folks still around at the end of the raffle.

The one goal that was not quite met was the budget goal. Due to some spending choices we made we ended up needing less money than we originally planned. As a result were able to do far more than we expected for both attendees and speakers, including making some pretty awesome shirts with the logo you see above as well as help to seed next year’s event.

Thanks to everyone who put in time to make this event the success that it was.

…oh, and the deck from my session “PowerShell for the Anxious ITPro” can be found here: https://www.slideshare.net/jasonhimmelstein/powershell-for-the-anxious-itpro

Leave a comment

#SPSDFW Wrap up


Another great community event is in the books! Kudos to the #SPSDFW team for the triumphant return of this keystone event. It has been suggested that I will take any excuse to go back to Texas… guilty as charged… A weekend of BBQ, Shiner & phenomenal SharePoint folks.

You can find the deck for my session Business Intelligence in SharePoint 2013 here: https://www.slideshare.net/jasonhimmelstein/business-intelligence-in-sharepoint-2013-24452549

Next up for me is running #SPSRI this coming weekend with Joshua Cliff & Chris McNulty!

Leave a comment

SharePoint Intersections wrap up

We just closed out the first SharePoint Intersections show in Las Vegas and I am enroute to SPSDFW but wanted to share my decks from the show:

Business Intelligence in SharePoint 2013

SharePoint 2013 Admin in the Hybrid World

This was a very enjoyable show during which I got to sit in on a recording of Andrew Connell (@andrewconnell) & Chris Johnson’s (@LoungeFlyZ) new podcast “MICROSOFT CLOUD SHOW“. I’m not sure when our episode will drop, but it will be worth a listen. Most of the speakers from the show stopped by and we had a bit of fun with the AC & CJ during the show.

1 Comment

New in Office 365: Power View in HTML5 Preview

During my final session of SharePoint Fest Chicago on Wednesday I was doing a demo of Power View using my Office 365 E3 tenant & came across something new, that I had only previously seen in Power BI. The new feature in question is the Power View using HTML5.

Here is what we saw:


Naturally this caused some immediate excitement, referred to by one in attendance as a nerdgasm, as this feature had been promised to us since PASS last year. Here is what we found as we walked through the preview…

First, I hovered over the icon the following tool tip showed up:


Once clicked, we flipped over to the new HTML5 preview and the following announcement showed up in the lower left hand corner of the screen:


The “More Info” link here takes you over to a support article on the Microsoft site that contains a list of what is and is not supported under the preview as well as some great FAQs, the highlights I will list at the close of this article.

The first thing that happened when I clicked into the new HTML5 preview was that I got a failure message. Currently the preview does not support hierarchies or drilldown, both of which were present in the Power View that I was attempting to demo.


I switched to a different Power View to demo that was simply a line graph with some slicers and this is what I got:


It looked pretty great to me at first, until I stopped and looked at the slicers. I flipped out of the HTML5 preview to validate that my Power View was built correctly and it was.


The fields that were represented incorrectly in the slicers were text fields, not numeric fields. Specifically what is supposed to show here is the text of month & day of the week names. Intestingly, the “Quarter” field is a concatenated field using the DAX equation of =Concatenate(“Q”,[QuarterofYear]). Not yet sure why this is happening, but as we are dealing with a preview here there is an expectation of bugs.

Here are a couple of important things from the Microsoft Support FAQ regarding the Power View for HTML5 Preview:

1.) Currently only IE 10 & higher are supported. Other browsers may work, but are not supported at this time.
2.) The preview is only available in English today.
3.) The only way to make the HTML5 Preview the default view for Power View is to uninstall Silverlight
4.) There is still not support for embedding a Power View into an app or page, though they state they know this is a big one and are considering it for a future release.

The bottom line here is that this is a preview, not the final product. Regardless, I am über excited that it is finally here.

Leave a comment

DevConnections 2013 Recap

DevConnections 2013 was an amazing conference, as it has in all years past. The attendees are always hyper-engaged and come with tons of questions. As a presenter, nothing makes me happier than helping people understand the concepts I am covering better than when they walked into my sessions.  Thanks to Scot Hillier for being an amazing track chair and moderating the panel on Tuesday afternoon.

During DevConnections I did 3 sessions (2 of which were recorded) and a panel session (also recorded).  SharePoint Pro Magazine is selling access to all 60 hours of recorded content from the show.  You can find details about this at http://windowsitpro.com/itdev-connections

I have been hearing from folks that my slides are not accessible on the site, so if you are looking for my content please look no further:

PowerShell for the Anxious ITPro

SharePoint Performance – Best Practices from the Field

Business Intelligence in SharePoint 2013

Time for the second half of my crazy SharePoint road trip… See you at SharePoint Fest Chicago!

Leave a comment

#SPSNH Call for Speakers Update

We are now less than a week from closing the Call for Speakers, Wednesday August 7th at 6pm Eastern Time, and we are still looking for speakers to submit.

Many people have watched the message that I posted about the video we are asking speakers to submit and I have gotten some feedback that this requires some clarification:

The video is NOT a requirement. We are asking speakers to do it and think that it will make things a ton more fun, but it is absolutely not required.

Personally, I think that is a quick easy thing to do that any speaker should be able to do in no more than 3 takes using their smart phone or the camera feature in Windows 8 (that’s how I did my video, with a bit of overlay thanks to Camtasia).

If the video is keeping you from submitting to speak, just submit the form.  You can get the forms on our SPSEvents site.