Just come back after the New Year and was posed with an interesting problem.
SharePoint 2010, SSRS in integration mode but under the manage subscriptions link within a report, the Add Data Driven Subscription button was missing from the screen.
So after some googling / binging around, I found that the answer was because we were using SQL Server 2008 Standard and Data Driver Subscriptions require the Enterprise version of SQL Server.
Anyway, just a quick post in case I forget in future. Useful links below:
- SSRS Feature Support – Integration Mode: http://msdn.microsoft.com/en-us/library/bb326290(v=sql.100).aspx
- How to use Data Driven Subscriptions within SharePoint: http://blogs.devhorizon.com/reza/2008/10/26/ssrsdata-driven-subscriptions-in-integrated-mode-part-1/
- Required versions for Data Driven Subscription support: http://msdn.microsoft.com/en-us/library/ms159150(v=sql.100).aspx
Although in this scenario I am talking about SQL Server 2008, the same is true of SQL Server 2008 R2. In SQL Server 2012, Enterprise or Business Intelligence editions are required:
So I am here in Amsterdam having completed day one of TechEd Europe 2012 and once again, the conference is an awesome experience. There is one major difference however…
Now I actually know some people from the last conference I went to (MSPC12). So I am catching up with some colleagues (Alex Burton – Nintex and Ben Howard – Applepark) as well as getting to know new colleagues (Robin Kruithof – CXS and Mike Wϋbbold – SolutionTime).
The focus of the conference is very much about the cloud:
- Innovations in Windows Server 2012 to support private and public clouds
- Windows Azure advances with websites, Hyper-V, SSRS to truly support private and public cloud infrastructure in anyway you can imagine.
- And of course Office 365 incorporating SharePoint Online, Exchange Online and Lync Online
Day One Keynote
The keynote was an impressive site with equally bold statements on how Microsoft are not only in the cloud, but mature in the cloud with innovation on how it should be done!!!
Very bold statements indeed but with one difference… evidence!
Discussions on how Microsoft have achieved the scalability of Azure through the use of automation technologies such as PowerShell.
How Microsoft have worked with storage and network vendors to ensure optimum throughput on the Windows Server 2012 platform.
Copying a 10GB file is seconds across the network in seconds! I couldn’t take a picture fast enough…
And lastly, how Hyper-V has come of age as a true competitor to VMWare in the virtualisation market with IOPS stats they can only dream of…
That’s 1,026,020.31 IOPS and only limited by current hardware, not the software!
Azure Reporting Services
Moving on from this and after catching up with colleagues. I moved into Azure SSRS which was launched at the North America TechEd event at the beginning of June.
SQL Server Reporting Services is now available in the cloud and we can finally say that Business Intelligence is starting to become available in a public cloud environment.
Some key things to note:
The API interfaces of SSRS are available:
However, some restrictions to the current launch do apply:
These are some serious limitations, but we are assured that this is being worked on and we will see improvement in future.
No word or official comment on integration with Office 365 but it wouldn’t surprise me if SharePoint Online integration is not coming down the line.
Staffing the Microsoft Project – Technical Learning Centre (TLC)
To gain attendance to one of the biggest Microsoft conferences, some of us have to pay our way in kind. 🙂
This humble bloggers approach is through presentations (more on that tomorrow…) and staffing the Microsoft Project booth at TechEd to help customers understand how Microsoft Project 2010 and Microsoft Project Server 2010 fit into the Office Server eco-system with SharePoint and other products.
We also provide help to anyone who would like to pose us with problems… almost like a live MSDN forum answer session.
It is also a good opportunity to catch up fellow colleagues in the EPM space and discuss approaches to client implementations etc…:
Ben, Mike, Robin and me
As part of the TLC Office stand some other cool and geeky items:
The Azure datacentre in Lego.
A cool Office 365 Lego giveaway…
and the most elaborate Microsoft Flight Simulator you will ever see…
And towards the end of the day I caught up with the Nintex crew to discuss Nintex Workflow for Project Server.
Thanks for the catch up guys.
So that just about wraps up day one. Presentations and flights home tomorrow… till the next post – Good evening – Goedenavond