Articles about European Sharepoint Hosting Service
Posts tagged europe sharepoint 2013
European SharePoint 2013 Hosting :: SharePoint 2013 Content Databases and the AllUserData Table
Jul 19th
I believe that some of you never realize that something’s changed of the content database in SharePoint 2013. Is that correct? As you know, AllUserData table has changed. See this:
First of all, what’s happened to columns [nvarchar1], [nvarchar2] (skip a few) [nvarchar64]? How about [int1] to [int16]?
They’ve all been combined into a fragment of Xml, and stored in a single column [tp_ColumnSet].
Let’s zoom in and have a look at one of those Column Sets:
That’s interesting.
Wide List Issues
Firstly, this means “wide lists” are going to be potentially faster than under 2010. A “wide list” in SharePoint 2010 was one that had so many columns that it would cause an INSERT or UPDATE statement to affect more than 8000 bytes of row data.
To work around the problem, when SP2010 works out the column you’re about to add to a list could cause more than 8000 bytes to be written, it would instead create an additional row to hold the new columns. SharePoint used the [tp_RowOrdinal] column to number each of the rows accordingly for a wide list.
We expect SQL Server to start table locking the AllUserData table as the number of row locks approaches 5000. Wide list behaviour would potentially cause SQL Server to have locky behaviour at one-half as many rows (or one-third, or one-quarter – depending upon how many list columns and therefore SQL rows).
Now it’s all stored in one big column, that particular problem is going to go away.
However, the [tp_RowOrdinal] column still exists in the SharePoint 2013 content database, and I’m not sure why.
SharePoint 2013 Content Databases and Sparse Columns
SQL 2008, 2008R2 and SQL 2012 all support “sparse columns” and “column sets“. These are SQL technologies that allows a row to grow beyond the usual 8K-per-row limit (up to 2GB of data when expressed as Xml). Under the hood, the AllUserData table still has [nvarchar1] through to [nvarchar64] and beyond! In fact there are 262 nvarchars, 1000 bits, 550 datetimes, 550 floats, 750 ints, 262 ntexts, 262 sql_variants, 350 uniqueidentifiers and 2 geographies (in a pear tree). (Thank you to Lior Gal for pointing me in the right direction!)
See the MSDN reference article on SharePoint 2013 AllUserData table design here: http://msdn.microsoft.com/en-us/library/hh625524.aspx.
But why didn’t these show up in SQL Management Studio? This is behaviour by designer to prevent poor performance when selecting form wide tables.
AllUserData Performance Issues in SharePoint 2013
Three general observations:
- For list sizes below 5000 SQL rows, lists that don’t use SharePoint indexed columns will probably be slower.
- For lists greater than 5000 SQL rows, unless we’re using SharePoint column indices in our query, SharePoint list throttling should kick in, and terminate the query before it gets started.
- For most list use cases, it is still massively important to use SharePoint column indices. But if you do decide to switch off throttling for a list, performance should be faster than under SharePoint 2007.
So, in summary: even in SharePoint 2013, make sure you have suitable indexed columns.
European SharePoint 2013 Hosting :: Add DataView WebPart SharePoint 2013
Mar 25th
As in previous versions of SharePoint In SharePoint 2013, you can still add Dataview webparts to your pages using SharePoint designer 2013 but with a an exception that you no longer see a Design View in SharePoint Designer 2013.
Adding DataView with Source is still not very clear. I saw a bug when I tried to add a Dataview but it would only show empty data view and not the List\Library list. However, I found a workaround that and was finally able to add a XSLTListView WebPart on a page.
In this post we will see the Step-by-Step Tutorial on how to add a DataView in a SharePoint 2013 site page which will be viewed in Browser.
1. Open your site in SharePoint designer 2013.
2. Next, Create a WebPart Page.
Give your Webpart Page a name and click ok.
3. Next Edit file to Open.
4. Click on “CODE VIEW TOOLS” tab and then click on Parse HTML
5. Next click in of WebPartZone and then click on Insert Tab and then DataView.
If you don’t see this and just sees the “Empty Data View” Option select that and then again click in the WebPartZone and then Data View again. Then you will see the datassource Options. The earlier (empty data view) will add a DataFormWebPart that you can delete that if you want.
This might be a Bug in SharePoint 2013 beta Designer.
Once you add a DataView for a List\Library you will see a new XsltListViewWebPart added.
6. Click on XsltListViewWebPart and you will see the DataView’s tab appear.
Here you can Add\Columns,Set Paging,View Data Source details and rules and can do pretty much everything you use to do with your OLD dataview.
If you want to edit the XSLT of this webpart you can navigate to “DESIGN” tab and click on “Customize Entire View”.
7. Preview Changes – Even though the Design View is missing you can still preview the changes with “Preview in Browser”.
8. Once done Save the Page and Check in.
European SharePoint 2013 Hosting :: Add\Edit Links in Quick Launch or Left Navigation
Feb 20th
This is a Step-by-Step article on how to add Links to the Quick Launch or Left Navigation of a SharePoint 2013 site.
With the Introduction of New look and feel for SharePoint 2013, the procedure for Adding\Editing Navigation links has Changed.The New Quick Launch can now be edited from “Edit Links” option which is available in the quick launch itself.Lets look at the detailed Steps-
1. New UI –
2. When you click on “Edit Links” it Opens the quick launch in Edit mode.You can either drag and drop any link to the edit area or simply click on “link” button.
3. When you Click on the Link you can add the URL where your link would go to and the Text to display.Click OK Once done.
4. This will add “Create Lists” link in the Quick Launch.
5. Save the Quick Launch to Save the settings.
Other Features –
Edit the Quick Launch Links – Simply click on the added “Create Lists” link to edit the URL and Text.
Order Quick Launch Links – For Ordering the links simply drag and drop the links and Save the settings.
Please note : The old “Navigation” option in Site Settings still exists for editing Quick Launch and Global Navigation.The Feature is available Only for sites with Publishing feature turned on.
5 FAQs about SharePoint in the Cloud Environment – HostForLIFE.eu
Dec 26th
Whether you call it hosted SharePoint or SharePoint in the cloud, you need to be aware of this growing trend in the SharePoint arena. HostForLIFE.eu, as the premier European ASP.NET and Windows SharePoint Hosting provider, has offered SharePoint Service on a Cloud Server.
HostForLIFE.eu is Microsoft No #1 Recommended Windows and ASP.NET Hosting in European Continent. Our service is ranked the highest top #1 spot in several European countries, such as: Germany, Italy, Netherlands, France, Belgium, United Kingdom, Sweden, Finland, Switzerland and many top European countries. Click here for more information
Here are some FAQs to get you started.
1. What is the cloud?
“The cloud” is a trendy catch phrase that means different things to different people. Wikipedia’s basic definition is useful: “Cloud computing is Internet-based computing, whereby shared resources, software, and information are provided to computers and other devices on demand, like the electricity grid.” DevPro Connections magazine author Tim Huckaby further demystifies the cloud: “It’s an economic model in its infancy.”
2. What is the payment model?
One model involves paying for what you used (i.e., a utility). Another model involves paying for what you say you’ll use (i.e., a subscription).
3. How is Microsoft involved in hosted SharePoint?
Business Productivity Online Services (BPOS) is a suite of Microsoft products delivered as a subscription service. Within that suite is SharePoint Online. You can get it as a dedicated solution, where you’re the sole party using the service, or you can get it as a multi-tenant solution, where you share the SharePoint service with many other companies.
4. Who is looking at a hosted strategy?
EMC analyst Matthew Roberts says small and medium-sized businesses: “They just don’t have the budget to deploy and manage SharePoint because they might need a developer skill set, an admin skill set—plus there are issues of upkeep, archiving, replication.” Although large companies are exploring the space, he says, many are choosing a hybrid approach, “putting commodity teams to SharePoint Online, but the apps and data associated with them are on-premises.”
BPOS in particular has proven attractive to large organizations, according to Rob Koplowitz, principal analyst in content and collaboration with Forrester Research. He cites large, multi-national pharmaceutical companies that have been early adopters.
5. What are the pros and cons of hosted SharePoint?
For every concern voiced about hosted SharePoint, such as security, someone else can offer a counter argument, from cost savings to easier management to business continuity in the face of outages or disasters. Ultimately it depends, as most decisions in IT do, on the needs and particular situation of an organization. As food for thought, here are what some industry experts told us:
Pros: “I actually like it because it forces you to build very clean applications by the rules,” says Dave Chennault, an MCTS in SharePoint and BPA. (See his article in the November issue of SharePointPro Connections magazine, coming out the last week in October, “POV: IT Pro,” about hosted SharePoint considerations.) BPOS “is supportable by anyone who knows SharePoint and frees you from custom code and being shackled to the developer who wrote the custom code.”
“A lot of organizations are still fairly early in deployment of SharePoint so you can start with that dynamic of ‘can someone else do this for me?’ In that regard, it might be more simple to move to the cloud,” says Rob Koplowitz.
Cons: “There are a few reasons why you might not want to use a ‘cloud’—some technical (like BPOS does not allow you to easily add third-party applications to your SharePoint environment) but most around governance, security, and compliance,” says Kevin Laahs, a strategist with HP. “You are basically handing over your service to someone else—are you sure they will take as good care of your service as you would yourself?”
About HostForLIFE.eu
HostForLIFE.eu was established to cater to an under-served market in the hosting industry; web hosting for customers who want excellent service. This is why HostForLIFE continues to prosper throughout the web hosting industry’s maturation process.
HostForLIFE.eu is Microsoft No #1 Recommended Windows and ASP.NET Hosting in European Continent. Our service is ranked the highest top #1 spot in several European countries, such as: Germany, Italy, Netherlands, France, Belgium, United Kingdom, Sweden, Finland, Switzerland and many top European countries.
As a leading small to mid-sized business web hosting provider, we strive to offer the most technologically advanced hosting solutions available to our customers across the world. Security, reliability, and performance are at the core of our hosting operations to ensure each site and/or application hosted on our servers is highly secured and performs at optimum level. Unlike other web hosting companies, we do not overload our servers.
We believe in our customers — customers are at the core of what we do! And as such, all of our R&D efforts are done with voice of the customer in mind; our support team is courteous and friendly and will do whatever it takes to assist and resolve your support tickets
European SharePoint 2013 Hosting :: Integrating Twitter in SharePoint
Dec 20th
This is only brief tutorial and hope you enjoy it.
First you’ll need an account created in twitter.
After logging in, add a couple of entries (so when you integrate Twitter into SharePoint, you can see some updates)
Scroll down to the bottom of the page, and click on Apps
Click on Widgets
Click Continue >> at the bottom right
Select the Interactive Widget, and click Continue >>
Select the preferred style and size, then copy the code
Paste it into Content Editor Webpart on your SharePoint page
Done!… Easy and simple. 🙂
European SharePoint 2013 Hosting :: SharePoint 2013 Mobile Features
Dec 10th
The below list comprises some of the notable, new features Microsoft has developed for SharePoint 2013. This isn’t really a list for any particular type of user; it’s just a general overview of how Microsoft is adding to the feature set. The list is ranked based on my opinion of relevance and value to the organization.
1. Contemporary View
The first feature that will grab everyone’s eye is the new HTML5 view that is best suited for mobile devices. Think of it as a mix between the boring and lifeless classic view from SharePoint 2010 and the new metro look and feel for SharePoint 2013.
What you get is a clean and highly compatible UI that should work on just about any device supporting HTML5. A new site feature handles whether or not mobile devices are automatically routed to this view or not, so it couldn’t be easier to deploy for IT pros.
2. Better Office Web Apps UX with Touch Support on Tablets
Working with Office Web Apps on a mobile device in SharePoint 2010 left a lot to be desired. Editing documents was not really possible on many devices and browsers (without a hack), which left users with the ability to basically view only.
Flash forward three years, and the dominance of information workers working on the go has caused Microsoft to revamp their offerings. Unless you were living under a rock, you should already be familiar with the big push Microsoft is making for the new web-based versions of the popular Office apps.
The new UI sports bigger buttons, gesture support, context menus (rejoice!), support for touch, mouse and keyboard input, and many more cool features. I don’t expect the experience to be any different coupled with SharePoint 2013, so you can test drive the experience now with SkyDrive or Office 365.
3. Push Notification Support for Mobile Applications
Push notifications have become staple features for mobile applications and the devices that support them, so it’s not shocking that Microsoft is now supporting this with SharePoint 2013. This feature requires adoption though from 3rd party developers or internal custom development.
The end result is that your device will be able to receive notifications from SharePoint lists and sites. For instance, a new document is uploaded in a library that you’re following, and the notification service sends your device a notification. Simple, yet necessary for today’s mobile devices.
4. Device Channels
Here’s a gem for site managers and devs. You now have the ability to render content for the appropriate device without having to duplicate the content itself. This functionality lets you serve up the same content with multiple master pages, page layouts and style sheets. If all goes well, you should be able to support most of the mobile devices in your firm with a lot less overhead than with 2010. The current list of compatible mobile browsers is available on the Microsoft Technet site.
5. Geolocation Field Type Support
Although this is another “under the hood” feature of SharePoint 2013, it should have an interesting effect on using SharePoint with mobile devices in the future. Microsoft has added native support to geolocation fields which can be exposed through Visual Studio. By adding a geolocation field to a list, you can embed coordinates, which can then be rendered with Bing Maps. The obvious benefit here is the ability to use your GPS-enabled mobile device to plot your location in a SharePoint list.
6. Support for PerformancePoint & Excel Services Reports on iPads
This is probably the least impressive new feature, because Microsoft only suggests that “certain kinds” of reports will be viewable on mobile devices. Since we don’t have an RTM build yet, I can’t say really what those reports will be. To further limit the exposure of this new feature, it’s apparently only available for iOS 5 iPads. To even further confuse you, Microsoft says on another page that “PerformancePoint dashboards can now be viewed and interacted with on iPad devices using the Safari web browser.” That seems to suggest that all PP dashboards can be viewed in Safari.
Regardless of what functionality actually makes it to RTM and beyond, it’s nice to know that we should be able to start interacting with dashboards, scorecards and maybe even some Excel BI/PowerPivot data on our iPads.
