October 2013 Internet Rollup: SharePoint & IIS

News – SharePoint Technologies

Event Receiver Doesn’t Work in Sandboxed Solution

SharePoint Conference 2012 sessions now available on Channel 9

SharePoint Conference registration is now open!

  • This is what you’ve been waiting for. Registration for SharePoint Conference 2014 is now open to the public through the Registration page of the SharePoint Conference website. Don’t miss out as the biggest SharePoint Conference on the planet takes over the Venetian Hotel and Resort in Las Vegas, Nevada from March 3-6th. This is your chance to get an all-access pass to everything that the conference has to offer, from the best sessions to the latest and greatest technology, to unbeatable access to Microsoft pros and industry experts, and much, much more. http://blogs.office.com/b/sharepoint/archive/2013/09/18/sharepoint-conference-registration-is-now-open.aspx

Start working social with Yammer

New languages, stores, and offerings for Office and SharePoint apps

Create SharePoint 2013 development environments quickly on Azure

NEWS – Microsoft Internet Information Server

New features in ARR (Application Request Routing) 3.0

Application Request Routing (ARR) is a proxy-based routing module that uses HTTP headers, server variables, and load balance algorithms to determine how to forward HTTP requests to content servers. The release of ARR 3.0 in July 2013 contains a few new features, as well as bug fixes. The following information describes the new features and how to use them, as well as general information about ARR 3.0 http://blogs.iis.net/erez/archive/2013/09/16/new-features-in-arr-application-request-routing-3-0.aspx

Microsoft Premier Support UK – Site Home – TechNet Blogs

Documents – SharePoint Technologies

eDiscovery Flow Across SharePoint, Exchange, Lync, and File Shares

Test Lab Guide: Configure an Integrated Exchange, Lync, and SharePoint Test Lab

Social feature support for SharePoint Server 2013

Discover SharePoint

Design Sample: Corporate Portal with Host-named Sites for SharePoint Server 2013

Enterprise search architectures for SharePoint Server 2013

NEWS – Microsoft Internet Information Server

Prepending www to 2nd level domain names

Updating my HTML Application for Configuring your WebDAV Redirector Settings

Let’s fix production troubleshooting

How to Create a Blind Drop WebDAV Share

Require Client Certificates in IIS 7.5

Certificates on the rebound

Downloads – SharePoint Technologies

Security Update for Microsoft SharePoint Enterprise Server 2013 (KB2817315)

Security Update for Microsoft SharePoint Foundation 2010 (KB2810067)

Security Update for Microsoft Office SharePoint Server 2007 (KB2760589) 64-Bit Edition

Security Update for Microsoft Office SharePoint Server 2007 (KB2760589) 32-Bit Edition

Downloads – Microsoft Internet Information Server


  • This is your single source for finding Microsoft Internet Information Services tools, samples, extensions, filters and modules created by Microsoft and the IIS community. http://www.iis.net/downloads




SharePoint 2013 Migrations with metalogix verse MetaVis

One of the larger disappointments I have had this summer is the number of crashes using the new Content matrix from metalogix seems to deliver when moving simple WebApps and Site Collections from SharePoint 2007 to SharePoint 2013. I mean simple like having a single Custom Site definition, a few Custom WebParts, with lots of ECM using Choice Site Columns and Custom Content types and all Branding is already deployed

Its almost embarrassing except that I designed and deployed all of the hardware from the SAN Configuration to the F5 Load Balancers and all hardware in between. In addition, I scripted the entire build for DEV, UAT, and PRD and luckily we rocked during the last two migrations one using of all tools Bulk List migrator from Bamboo Solutions and the last time using metelagix SSMM.

I guess my concern is: though metalogix is now one of the dominant players in SharePoint the quality of the migration tools from them seem diminished. I have multiple crashes per day, failure to move simple pieces of content like list items and documents, where it will now take three iterations per job in order to finally get it right.

As much as I dislike having to learn additional tools as there is never enough time I will begin testing MetaViz this weekend and I am greatly saddened that I would have to do so. But on with the show, I realize it makes sense to have a common interface for all of the metelogix products, I would only beg them to not do so at the cost of the value of the products in their own right.. I will let you know how this all works out in the next few weeks. As we have an end date of March 2013…

This project also includes building a One World taxonomy  and is takes getting a lot of people together to mostly agree on the majority of the terms your business will be using. We did a great Job in 2008 with the Global Communications Group in charge of technical Publications, Translation and more, now we just have to do the same for the rest of the company and support multiple languages with follow the sun data centers. So its all kinds of fun and march is not very far off.

I am sure I will be sending out another Blog or two this week but just in case you don’t have a chance to read those have a Very Happy Halloween



SharePoint 2007, 2010, 2013 Property Promotion and Demotion

Property Promotion and Demotion

Over the next couple of weeks I will be building a SharePoint 2007, SharePoint 2010, and SharePoint 2013 VMs.. Then using Office 2010 and Office 2013, moving documents between the three SharePoint Environments while using 2 separate content types with several site columns on all 3 environments. I will be making video logs and posting them on Youtube.

The only reason I am doing so is because I see so many people on the forums still have a very difficult time of getting there metadata to either promote top SharePoint or Demote into the documents correctly and I have not had an issue with this since SharePoint 2007 and Office 2003. The funny part is when I ask a forums guest if they have downloaded the 250 files he receives from his employees with the correct metadata embedded in the properties of the document the only reply I receive is it used to work in SharePoint 2007. the first video should be out no later than the end of the week with the second to quickly follow. At the end I am going to break property promotion and demotion on purpose, just for fun…




SharePoint Confernce 2014 March 3-6 Las Vegas NV #SPC14

Connect with us


SharePoint Conference 2014
Save the Date!

Mark your calendars for March 3-6 as SharePoint Conference 2014 heads to Las Vegas, Nevada. Check out the new website at www.sharepointconference.com to find out what awaits you at the world famous Venetian Hotel and Resort.


This year’s conference will be better than ever, with powerful content designed for Office & SharePoint IT Professionals, Developers, and Executives.

Immerse yourself in tracks covering topics from Deployment, Security, Architecture, Enterprise Social, Enterprise Content Management, Internet, Business Intelligence, Search, Office 365 and much more!

Registration for SharePoint Conference will open next month.

In the meantime, get a glimpse of what awaits you at www.sharepointconference.com.


Follow us on Twitter. Stay in the conversation with the official #SPC14 hashtag. Not on Twitter? Connect with us at facebook.com/wwspc.

Microsoft SharePoint Conference 2014 Team | spc@microsoft.com

You are receiving this message as a result of submitting your email at
www.sharepointconference.com. You can un-subscribe or update your profile at any time.

Just received this email and I thought you would like to know


SharePoint 2013 Power View Multidimensional Models SQL 2012 SP1 CU4

Hi All,

This is a post is a compilation of posts from Microsoft The reason I am created the compilation along with providing the link for everyone is the SQL Product Group has been doing an amazing job of pushing the envelope and providing us more & more features in the BI Space for use use with SharePoint 2013 Scorecards and Dashboards.

With this release, multidimensional models support analysis and visualization by using Power View in SharePoint mode. No special configuration of your multidimensional models is necessary. There are however some differences in how multidimensional model objects are displayed in Power View compared to other client tools such as Microsoft Excel and Microsoft Performance Point. This release does not support analysis and visualization of multidimensional models by using Power View in Excel 2013.

SQL Server 2012 Service Pack 1 Cumulative Update 4, released May 31st, provides the ability for customers to create Power View reports against their existing multidimensional models (a.k.a. cubes). SQL Server 2012 Service Pack 1 Cumulative Update 4 contains a few additional enhancements to the “Power View for Multidimensional Models — Preview” that was previously released November 29 2012 and based on customer feedback.  This functionality helps customers maximize their existing BI investments by enabling their use with the latest BI end-user tools and adds greater modeling flexibility to the BI Semantic Model. Customers need to upgrade their Analysis Services instance and the Reporting Services add-in for Microsoft SharePoint Server (2010 or 2013) with this Cumulative Update to create Power View reports against their existing cubes.

As everyone knows Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012. Power View reports are presentation-ready at all times because they are always connected to your data. Users can quickly create a variety of visualizations, from tables and matrices to bubble charts and sets of small multiple charts. Power View operates on a BI Semantic Model that resides in Analysis Services databases or PowerPivot workbooks.

With the SQL Server 2012 SP1 CU 4, Power View can consume data from multidimensional models. Now Power View users can connect to both the tabular and multidimensional formats of the BI Semantic Model. This is achieved through native support for Data Analysis Expressions (DAX) in Analysis Services multidimensional models, ensuring optimal performance and functionality.


Understanding Power View for Multidimensional Models


clip_image001 clip_image002 clip_image003 clip_image004 clip_image006 clip_image008


Microsoft Press Business Intelligence in SharePoint 2013

I just received my copies of Business Intelligence in SharePoint 2013. I will be signing the books and giving them away at the next SharePoint Saturday 2013 in Redmond where I am speaking.

Being an Author and writing a book is very time consuming and can be difficult since you are working with software that is going to change many time’s prior to release and you are typically the first to be writing opn the new features being released.

However, I was lucky enough to work with a few authors (listed below) who are all some of the best folks I have had the pleasure of working with, and I learned a lot about how much my writing needed to improve.

Norm Warren, Mariano Teixeira, Stacia Misner, and Scott Helmers

Our book was listed last week on the Microsoft Press Blog Site


Dive into the business intelligence features in SharePoint 2013—and use the right combination of tools to deliver compelling solutions. Take control of business intelligence (BI) with the tools offered by SharePoint 2013 and Microsoft SQL Server® 2012. Led by a group of BI and SharePoint experts, you’ll get step-by-step instructions for understanding how to use these technologies best in specific BI scenarios—whether you’re a SharePoint administrator, SQL Server developer, or business analyst.

Manage the entire BI lifecycle, from determining key performance indicators to building dashboards Use web-based Microsoft Excel® services and publish workbooks on a SharePoint Server. Mash up data from multiple sources and create Data Analysis Expressions (DAX) using PowerPivot
Create data-driven diagrams that provide interactive processes and context with Microsoft Visio® Services

Use dashboards, scorecards, reports, and key performance indicators to monitor and analyze your business
Use SharePoint to view BI reports side by side, no matter which tools were used to produced them

I would also like to thank all of the wonderful people at O’Reilly and Microsoft Press for being there when we needed you….


Thank you all !!!




SharePoint 2013 Demo – Content Packs on Codeplex

Hi All,

For everyone who wanted the Self-Service Business Intelligence Demo Builds and those of you that don’t. I have tried to make it easy to install and configure a Windows Server 2012 DC with DNS, SQL Server 2012 with the 3 AS Roles (Tabular, PowerPivot, and Multi-Dimensional).. So that any Business User can  complete the installation and have fully functional PowerView, PowerPivot, PerformancePoint Dashboards for use as demonstrations

You can download the first five Content Packs from the Codeplex Links below:

Active Directory https://sharepointdemobuilds.codeplex.com/releases/view/101068

SQL Server 2012 SP1 https://sharepointdemobuilds.codeplex.com/releases/view/101069

SharePoint 2013 Demo Build https://sharepointdemobuilds.codeplex.com/releases/view/101610

Self-Service Business Intelligence https://sharepointdemobuilds.codeplex.com/releases/view/101187

PeoplePack – UserProfile Provisioning https://sharepointdemobuilds.codeplex.com/releases/view/101674

You can also check out the Videos on How to install Hyper-V on Windows 8 and Create your first Hyper-V Virtual Machine, Add The Content Packs for Active Directory and SQL Server 2012 SP1 with the videos and SharePoint 2013, Self-Service Business Intelligence, PeoplePack – UserProvisioning and more coming soon..

I have included a couple of the Videos below, but they are also available on the Codeplex download pages listed above for each Content Pack that has been completed

SQL Server 2012 SP1 Demo – http://www.screencast.com/t/l9Xr4of9M

PeoplePack – UserProfile Provisioning http://www.screencast.com/t/OD9Uoi0SO


Have fun. I hope the videos help…




PASS Business Analytics Conference 2013 – Return on Investment

margin-left: 0in;
margin-right: 0in;
margin-top: 0in;
{border-top:solid #4f81bd 1.0pt;
border-bottom:solid #4f81bd 1.0pt;
border-left-style: none;
border-left-color: inherit;
border-left-width: medium;
border-right-style: none;
border-right-color: inherit;
border-right-width: medium;


Need help justifying your attendance at the PASS Business Analytics Conference?

I’m looking to…  

How the PASS Business Analytics Conference delivers:

Learn best practices and how to get the most out of Business Analytics

Join top industry and Microsoft experts for over 60 sessions offering exceptional learning guided by real-world solutions, thought leadership, and prescriptive technical guidance to capture the value of business analytics for your organization.  

Upskill to broaden my knowledge and career opportunities

Five comprehensive tracks will cover: Data Analytics and Visualization; Advanced Analytics and Insights; Information Delivery and Collaboration; Big Data Innovations and Integration; Strategy and Architecture.

Develop a deeper understanding of Business Analytics

Deep dive with a track dedicated to sentiment analysis, predictive analysis techniques using algorithms, data mining, statistic modeling, and advanced visualization.

Build valuable contacts

Join in our special networking and evening events and take advantage of group breakfasts and lunches to engage with a dynamic Business Analytics community and immerse yourself in innovative learning experiences with peers and industry leaders.

Stay ahead of the game

Learn about the latest advances, roadmaps, and strategic vision for the Microsoft Business Analytics platform. Get up-to-date on what’s important now and going forward.

Gain information on key BA platform

The exhibit hall brings together the top Business Analytics tools and services under one roof. Get hands-on demos and information without having to do all the research yourself.

Increase the knowledge and skills of my entire team

Take advantage of our group discount rate: Register as a group of 5 and save.

Be inspired

The PASS BA Conference is all about meeting and talking with people, sharing issues and solutions, and gaining knowledge that will make you a better Business Analytics professional. You’ll find new ideas everywhere for improving your business.



SharePoint 2013 Databases Documented on Codeplex

A client requested recently that I document each of the SharePoint 2013 Databases and Compare them to the SharePoint 2010 Databases. I used ApexSQL Doc 2012 to document the databases and ApexSQL Diff 2012 to compare the differences . Apex is great I think its the only tool that is works with SQL 2012 at this time. I started with the ContenDbs. Below are screenshots fro the Admin ContentDb. Be sure to check out the Apex SQL Tools when you have the time..

All of the SharePoint 2013 Databases are documented on Codeplex at http://sharepoint2013dbdocs.codeplex.com. I have included a few screenshots below for folks who may not be familiar with database documentation tools like Apex and what they provide..

The first screen shot below is the DB Object Index


The next we will jump down to the datatypes


An just to keep drilling through we find the details of tContentTypeId that start with the properties of the datatype, the  lists all of the locations where the column is defined, all of the dependencies and this page lists where the columns are defined and all of the dependencies from tables, procs, and functions with every column, tables, procs, and functions rendered as links that will then provide you with the detail of the property you click on


For instance lets take a table we use quite often the AdminContentDB.dbo.AllDocs table and the first information you will see is the table properties


Next you will see the creation Options and all of the columns that are make up the AdminContentDB.DBO.AllDocs Table along with the detail of each column like Data Type, Max Length, Nullable, Default, isGUID and Sparse


If you would like to understand more about how SharePoint uses the databases to store information and the relationship between stored procedures, triggers, functions and the object model you should check out the SharePoint 2013 Databases Documented on Codeplex, I have included a few of the links for direct downloads below:

Documentation SQL 2012 AS PowerPivot Database Documentation

Documentation SharePoint 2013 Social Database Documentation

Documentation SharePoint Content Database Documentation

Documentation SharePoint 2013 Metadata Service Database Documentation

Documentation SharePoint 2013 Profile Database Documentation

Documentation SharePoint 2013 Secure Store Database Documentation

Documentation SharePoint 2013 All Search Related Database Documentation

Documentation SharePoint 2013 Configuration Database Documentation

Documentation SharePoint 2013 Application Management Database Documentation

But don’t stop, If you think this is pretty cool and even if you Don’t, you should read everything on SharePoint Protocols, I have included a link as reference below:




PASS Business Analytics Conference – Quick Facts


Key Dates


April 10

Welcome Reception

April 10 (evening)

Day 1 Keynote: Microsoft

April 11

Appreciation Event

April 11

Day 2 Keynote: Steven Levitt

April 12

General Sessions

April 11-12


  • § 60 + technical sessions presented by Microsoft and Community Speakers
  • § Steven Levitt Keynote – Bestselling co-Author of Freakonomics and Super Freakonomics
  • § 5 session tracks including:
  •    ▫ Data Analytics and Visualization
  •    ▫ Advanced Analytics and Insights
  •    ▫ Information Delivery and Collaboration
  •    ▫ Big Data Innovations and Integration
  •    ▫ Strategy and Architecture

imageWhy Attend?

  • § Top community speakers including big data ZDNet blogger Andrew J. Brust; BI experts Alberto Ferrari, Stacia Misner, Peter Myers, Marco Russo and Chris Webb; data mining and predictive analytics gurus Mark Tabladillo and Cristian Vava; data science expert Mark Whitehorn; and Decision Sciences professor, Mathletics expert, and two-time Jeopardy! champion Wayne Winston.
  • § Hear from the Microsoft experts: Kamal Hathi, Director of the BI Group for Microsoft SQL Server; Ashvini Sharma, Group Program Manager in the Office Data Experiences team; and Tim Mallalieu, Principal Group Program Manager for Microsoft HDInsight.
  • § Connect with us for real-word insights, prescriptive guidance, best practices, and strategic vision
  • § Expand your ability to analyze, manage, and share information to predict business performance
  • § Walk away with the tools and connections for maximum impact within your organization
  • § Dig deeper into Microsoft’s collaborative BA platform – Excel, SharePoint, Azure, Hadoop,
  • Parallel Data Warehouse, and SQL Server.

Connect with us: clip_image001 clip_image002 clip_image003[7]



« Previous PageNext Page »