Use PowerShell Format-table With Test-SPContentDatabase

The output from Test-SPContentDatabase is pretty much unreadable IMHO, so as a quick top just use Format-table to control the formatting of standard output to get something actually readable!


PS C:\Users\[Your User]> Test-SPContentDatabase -Name [Name] -WebApplication [URL] | ft

it comes out much nicer!



SharePoint 2010 Service Application Design Best Practices

Through SharePoint 2010, there is an improvement of the services infrastructure that was previously introduced in an earlier version. This infrastructure also hosts services for the SharePoint Foundation 2010. The configuration of services offered is very flexible. This allows the individual services to be configured independent of each other. It also makes it possible for 3rd party companies to be able to add services to that platform. The configuration of services aren’t exclusive to SharePoint Server. The services aren’t restricted to Shared Services Providers.

When service applications are deployed from a farm there are a couple of different methods that can be used.
They include the use of Windows PowerShell, adding services one at a time through the Manage Service Applications page, and choosing services for running the SharePoint Products Configuration Wizard.

The infrastructure of the services has been updated so that there is more control over the types of services that have been deployed. There is also control over the types of service applications that have been shared. Only the service applications that are necessary for a farm can be deployed. The various web applications can be configured so that they only use certain service applications. This is better than them using all of the various services that have been deployed. Service applications can be shared across various web applications that are within the same farm. All of the service applications that are included in a default group will remain unless you change them. There are settings for service applications that can be created. You can add or remove service applications in that default group any time you want to.

The creation of web applications allow you to select the default group you want or to create one that is customized. If you want to customize your service applications you can do by selecting those that you want to be part of the web application. When custom groups are created in Central Administration, they can’t be used for all of your web applications. When you select custom to create a web application you will limit them to only that specific web application you happen to be using. Each of the service applications has a single Internet Information Services website. This is the default setting and you won’t be able to change it. However, you do have the option of customizing how it is configured for various application groups.

There are several characteristics of a farm that you need to be familiar with. Web applications will connect to the default group or a custom group of service applications. All of the service applications will be found within the same Internet Information Services website. Service applications are in a group as defaults or customized. However, not all of the service applications have to be placed into one of those groups. They can be used by a single web application if you wish.

It is possible for service applications to be deployed to different applications pools. This results in process isolation occurring. If you want to optimize how your farm performs then it is recommended that you deploy service applications to only one application pool. In order for that isolation to occur with a service application, you need to create a new application for the pool service application.

While creating a service application there is a connection for the service application that is being created at the same time. There is a connection that is a virtual entity for connecting to web applications. With Windows PowerShell these connections are known as proxies. A proxy will be at the end of the type description for a connection which is through the Manage Service Application in Central Administration. Some of these connections may include settings that you can modify. This includes the Managed Metadata service application, Term Store Administrators, and Default Language.

When you directly manage service applications in Central Administration you can manage and monitor them from a remote location. They can also be managed and scripted through Windows PowerShell. There are some service applications that are shared among many farms. Others though can only be shared in a singular fashion with a given farm server.

Computing intense service applications that operate within a central farm. This is done to minimize the overhead costs relating to administration. This is also to help keep everything operating efficiently, even as the requirements of the farm grow. If you use service applications to support sharing across farms, they should be controlled by a central farm. Then they can be consumed from that core location. For each of the web applications that will be configured, use service applications from different farms.


Excel Services Security Best Practices – Overview Of Excel Services Security

The when designing security strategies for Excel Services it involves learning about holistic SharePoint security, user authentication, communication for servers, and the authentication of external data. All of these areas must be covered before implementation so you can make well informed decisions. There is a great deal more to consider with Excel Services than just security however. When it comes to deploying SharePoint 2010 and its associated features, you need to take many different considerations and evaluate them. One of the many elements that can be of benefit to you is the Excel Services Application. It is one of the platforms that is part of SharePoint 2010. The function of Excel Services works with SharePoint Server 2010 to offer security, control, and management for the various Excel workbooks that are part of that enterprise. This type of application is a server that allows for performance and security to be key issues addressed. It can be deployed within workbooks or work with them so that the various components such as PivotTable reports and charts can be used for dashboards within any organization. This allows a user to take advantage of calculations that are associated with a server side Excel spreadsheet.

From there custom applications can be determined. Users have the option of locking workbooks so that they can have more security over their private data and property. This makes it possible for the data in a workbook to be protected at a higher level while they are on a server. It also allows for the data to be refreshed and recalculated through the Excel Services Application.

There is no denying that security is very important for any such component. There are several elements that you need to consider when it comes to the planning for your environment. You want it be one that has high security for the workbooks that will be placed on a server. When designing the Excel service security a plan should be developed to manage the security of the workbooks and the security of server that they are placed on. With the help of Excel Services Application you will be able to have complete control over the process and how everything is displayed for the Excel workbooks. You get to control how the workbooks will be opened on the server. You get to control who will be authorized to open them and what elements that they get access to from those workbooks. Understanding the security and the authentication settings you can choose from with Excel Services Application is very important.

You will need to consider all of this information before you move forward with deployment. The guidance offered here in these materials will ensure you get the most benefit from Excel Services Applications. At the same time it will ensure that your workbooks are very secure on the server.The security model is based on the concept of ensuring the data is in quality form, that the administrator is able to centrally manage the resources being shared, and that the intellectual property of the workbooks is maintained. In order for this to happen you will need to specify something things in Excel Services. Trusted data connection libraries are SharePoint document libraries with .odc files. Those files are used to offer a centrally managed connection with external data sources. Rather than allowing for the connections to be embedded, they can be configured through Excel Calculation Services for all data connections with those .odc files. The .odc files are stored and the connection must have trust before the workbooks can be accessed through Excel Calculation Services. Trusted data providers are the external database where the Excel Calculation Services can be configured. They have to be able to trust so that the data being processed is able to successfully connect to the workbooks. The connection will only be attempted by Excel Calculation Services when there is a trusted data provider in place. Trusted file locations are document libraries in SharePoint are the trusted file locations. They have to be trusted before the Excel Calculation Services will be able to access them. It is important to understand that Excel Calculation Services is only able to open workbooks that are stored in trusted files.

The default setting for a cross domain workbook and data connection isn’t allowed to occur. If you want to have the workbooks in trusted file locations that can be accessed across the web part domains you have to run the Windows PowerShell. The web pages that are requested and the workbooks have to be on the same farm. When you open up a workbook in Excel Calculation Services, there will be a temporary file stored in the %TEMP% folder. This will be located on the application server where the Excel Calculation Services is running.