Power View error: There are no addresses available for this application

Whilst doing a demo, I noted that running Power View on SharePoint gave the following error message:
Microsoft.SharePoint.SPEndpointAddressNotFoundException: There are no addresses available for this application.
There are two steps to resolving this issue:
1. Using the Central Admin on Sharepoint, check the services running on the server.
Go to Central Admin > Application Management > Manage Services on Server
Check if your services have stopped, particularly the ‘SQL Server Reporting Services Service’. Also, take a look at the ‘Managed Metadata’ or ‘User Profile’ services. 
2. Once you’ve reviewed the services, you might need to do perform an IISReset command
I hope that helps!

IP address query selection for High Availability Listener

One of my customers contacted me; they had set up High Availability but had a concern. They couldn’t ping all of the IP addresses associated with each of their listeners.

I gave it a go, and sure enough, I could see one of the IP addresses, but not the ‘sleeping’ one, which was on a different subnet. The listener had two IP addresses, one for each subnet.
Then it suddenly made sense that this is ‘by design’. The IP addresses are not online at the same time, since the server can’t host an IP address that’s not in its subnet, so you can only have one ‘up’ at a time.
When the cluster group is owned by one of the nodes, one IP address is up. The other is down, sleeping but ‘healthy’.  When the cluster group is owned by the other node, the original ‘sleeping’ IP Address is up, and the original IP address is down.
This was easy enough to show. I induced failover, and then bringing it back up again. It is possible to see the swapover of the IP addresses, and the original ‘awake’ IP address going offline whilst the other comes up. 
It is still there; just not accessible since the server can’t host an IP address which is not part of its subnet.

MSDN UK Team Blog Pointer: Writing Better SQL with your head in the Clouds?

I’ve started to write more for MSDN UK in addition to my own blog. Here is a recent article that I wrote for MSDN, which points people at Itzik Ben-Gan’s series on Writing Better SQL. I liked Itzik’s series very much, so I decided to write the blog in order to point MSDN readers to it.

In the article, I point out the benefit of Itzik’s series, which I see as follows;

– it helps novices to write better SQL
– it helps more practices SQL crafters to write SQL for SQL Azure.

If you’d like to take a look, head over and I strongly recommend Itzik’s series for everyone.

My TechEd Videos and Slides, plus my favourite session!

Thanks to all who attended my #MSTechEd session! The video and slides are now at the Channel9 site and you can see them here.

The TechEd material is fantastic and there are lots of good sessions to choose from. I’d like to point you in the direction of the Business Intelligence track at TechEd, and here is a sample of the great content to view:

The 12 Reasons to Love Microsoft SQL Server 2012 with Dandy Weyn, Sean Boon and Thomas La Rock
The Dirty Dozen: Windows PowerShell Scripts for the Busy DBA by Aaron Nelson
Building Self-Service BI Applications Using PowerPivot by Julie Strauss
and my personal favourite:
BISM: Multidimensional vs. Tabular with Marco Russo and Alberto Ferrari

There are too many to list here, so please head over to Channel 9 and take a look!

Precons: What we learn by listening

When words are scarce, they are seldom spent in vain. (Shakespeare, Richard II, Act 2, Scene 1)

This quotation, from Shakespeare’s Richard II, sums up a lot of my thinking about Business Intelligence generally. It’s always about people. As a consultant, presenter, speaker or panellist, I’m there to listen as well as talk. I have posted my Data Visualisation and Business Intelligence pdf notes here. If you cannot access it, please let me know at jen.stirrup [at] copperblueconsulting dot com.
I used the slides as the basis of my Precon in Poland at the Poland SQLDay event. The precon is mainly demo, and trying to solve delegates’ business problems on the day. I like to try and find suggest a few common business problems, and demonstrate different ways I’ve solved them. 
As a Data Visualisation practitioner, I believe in visualisation – but I also believe in listening, too. I do not like to PowerPoint people to death.  I like to do end-to-end – so I start from the ground up. In other words, I set out with the business problem, and then walk through to the end result. Sometimes these business problems are issues which delegates didn’t know that they had, until they’ve thought about it whilst attending the precon! I like to try and do useful things that people can apply to their own environments when they get home. I always have my own ideas about things that I’d like to show people, but I welcome attendees to bring their own thoughts and issues about their current and future business problems. After all, Business Intelligence is about people.
Since I do a lot of the demo work pitched at the audience needs, I don’t have that many slides. I can produce more if I need to do so, but I always try and get a balance between demo and slides. 
In this way, although I’m talking a lot during the day to the delegates, I am also listening to the delegates as well.  I believe that this is vital to the success of the day. If I can help with a specific business problem that the other delegates are interested in, then this is a good day for me since I’ve made a difference somewhere.
People often ask me: how can you get up on stage, and speak in front of so many people?  I don’t hold with the ‘I talk, you applaud’ school of presentation at all. Here is my answer:

Courage is what it takes to stand up and speak; courage is also what it takes to sit down and listen. Winston Churchill

Sometimes I get questions that I don’t know the answer. In SQL Server, I now think that it covers such a wide arena of users, that it is no longer possible to know everything about it unless you actually work for Microsoft (and I don’t).  
Fundamentally, however, I have to agree with Hemingway: to listen, you’ve got to want to hear the message. I always respect my delegates. Even if they’re not the ones talking, they live, breathe and sleep SQL Server and related technologies all day, every day. They deserve our respect and in order to serve them best, it is up to me to listen. So my slide deck isn’t fulsome; but I hope that the attendees got something out of the day, and it was my pleasure to work with them. 

I like to listen. I have learned a great deal from listening carefully. Most people never listen. Ernest Hemingway. 


Data Visualisation Sample Slide Deck

If you attended the fantastic SQL Saturday 105 in Dublin, you might be interested in these slides.

We’ve presented on Data Visualisation in the UK, Europe and in the US. Here is a sample slide deck. As always, these are subject to change as we develop our presentations in response to community requests for a different perspective, or in response to an update in technology, for example.

Here is an example of one of my Data Visualisation presentations: