Query to Identify Database Settings for SharePoint in SQL Server.

The above query will help you to find the Database Size in your SharePoint Environment.

New Features in SharePoint 2013 Preview

If you've not had time yet to work with SharePoint 2013 Preview, here's a look at what's new so far. Your assessment of the value of said new features will vary, depending on your mileage and usage.

Authentication

Microsoft says that SharePoint 2013 Preview has been improved to make claims-based authentication easier to use. It extends support for application authentication via Open Authorization 2.0 (OAuth) as well as for server-to-server authentication.

                             SharePoint 2013 Sample Authentication Architecture Fragment

Users can grant apps in the SharePoint store and catalog access to certain resources and data. Server-to-server security tokens that contain user identity claims enable cross-server authenticated access between, say, SharePoint 2013 Preview and Exchange 2013 Preview. (See also Microsoft's architecture posters website for the one labeled  "Extranet with Dedicated Zones for Authentication" and to see full views of the image excerpts below.)

Business Connectivity Services

Microsoft added a bunch of new features to BCS in SharePoint.

                                                  SharePoint 2013 BCS Architecture

You might like these: Support for OData Business Data Connectivity (BDC) connections, in addition to connections for WCF, SQL Server, and .NET assemblies. Automatic generation via Visual Studio 2010 of BDC models for OData data sources. An event listener with an event subscriber on the SharePoint 2013 Preview side, to enable SharePoint users to receive notifications of changes to the external system. Self-contained apps for SharePoint.

But wait--there's more: Enhancements to external lists that bring them to functional parity with other SharePoint lists. The exposure of the REST APIs for web and mobile app developers to use. Six new Windows PowerShell cmdlets specifically for OData. And the ability, via Business Connectivity Services Client Runtime, to have side-by-side installations of Office 2010 and Office 2013 Preview on the same client computer.

eDiscovery

Showing SharePoint's increasing presence in the world of litigation, eDiscovery improvements have been added that, unfortunately, are probably sorely needed. They include a new site template, the eDiscovery Center, which creates a portal for managing cases—you can access cases to search, hold content, and export content.

Microsoft has added improvements to in-place holds, including site-level preservation; the ability for users to work with content that's preserved; and the ability to define the scope of preservation via a query filter.

You can also now take the results of your eDiscovery search—including documents, wiki pages, Exchange email messages and tasks-- and export them into a review tool.

Mobile devices

Optimized viewing for mobile device users was a no-brainer addition to SharePoint Server 2013 Preview—it had to be done.

Other new features include the following: The ability to render a single SharePoint published site in multiple formats for different devices. The ability to enable a push notification service on a SharePoint site to send device updates to a Windows Phone device.

We're not done yet: A new geolocation field type for use in mobile app development. The ability for some devices to display PerformancePoint Web Parts, Excel Services reports, and SQL Server Reporting Services reports. And finally, enhanced viewing of Office Web apps (Word, Excel, and PowerPoint) via mobile browsers.

Records management and compliance

Reflecting perhaps not a dearth of added features, but the distance SharePoint 2010's records management features had improved from SharePoint 2007's, you'll find that SharePoint 2013 Preview has enhanced compliance simply by extending retention policies to SharePoint sites.

This also applies to any Exchange Server 2013 Preview team mailboxes associated with those sites.

Business intelligence

SharePoint 2013 Preview adds tons of new features, including the following: New features in Excel for business intelligence (BI): In-Memory BI Engine (IMBI) for near-instant analysis of millions of rows of data; Power View Add-in for Excel, which offers visualizations, animations, and smart querying to enable users to visualize modeled data; decoupled PivotChart and PivotTable reports allowing for the creation of PivotChart reports without having to add a PivotTable report on the same page; and the ability to do trend analysis from cells in PivotTable reports that use OLAP data.

It also adds Excel service enhancements such as an updated Business Intelligence Center site template, and improved timeline controls.

Visio Services improvements include the ability for users to add comments to a Visio drawing on the web via Visio Services.

And PerformancePoint improvements include the ability for users to copy dashboards and dependencies to other users or site collections; an enhanced UI; support for Analysis Services Effective User feature, which eliminates the need for Kerberos delegation for per-user authentication; and support for PerformancePoint on the Apple iPad.

Social computing

It's no surprise that Microsoft wanted to beef up the social computing features in SharePoint, and with SharePoint 2013 Preview, it's on track for doing so. Basically, it's enhanced the administration and user experience, and added ways for enterprise users to collaborate more fully and naturally using social media features.

One way is by enhancing the ability create discussions—via two new templates called Community Site and Community Portal. Microsoft also redesigned the UI for MySites, and added Microblog and Newsfeeds features, and improved features users need around saving, synchronization, sharing, and moving content.

Because of the new MySites features, you'll also find Microsoft made several changes to the User Profile service application settings in Central Administration around configuring permissions, privacy, micro-blogging and newsfeeds, and more.

Web content management

Microsoft improved the video upload process for content authors, and improved image display and performance of a site with its image renditions feature, which reduces the size of an image file that is downloaded to the client.

It added an integrated translation service that gives content authors or managers the ability to choose which content will be exported for human translation and which for translation by machine.

And cross-site publishing does just as it says, giving you the ability to display content in one or more publishing site collections. You can also designate any library or list as a catalog, enabling content to be reused on publishing site collections.

It added managed navigation, which lets you use term sets to define and maintain navigation on a site. And it added the ability to create more user-friendly URLs.

In the area of branding, Microsoft made it less mysterious, and now designers use such tools as Adobe Dreamweaver, Microsoft Expression Web, or another HTML editor, rather than having to use SharePoint Designer or Visual Studio 2013 to brand a SharePoint site.

And it added the ability for designers to design sites for display on different devices, such as tablets, smartphones, and desktops. Additional features enhance search, authoring, and publishing.

Workflow

Microsoft made architectural changes in SharePoint Workflow. If you want to have the nearly identical experience of building workflows in SharePoint 2013 Preview as you do in SharePoint 2010, you simply install SharePoint Server 2013 Preview.

But if you want the SharePoint 2013 workflow platform, you need to install and configure Windows Azure Workflow to communicate with your Preview farm. SharePoint Designer 2013 Preview includes new functionality designed specifically for Windows Azure Workflow, and called the SharePoint 2013 Workflow platform.

These new features include a visual workflow that uses a Visio 2013 Preview add-in, the ability to enable no-code web service calls from inside a workflow, new actions for the task process, the ability to start a workflow built on SharePoint 2010 from a workflow built on SharePoint 2013, and new workflow building blocks called Stage, Loop, and App Step.

Note that to manage and monitor the Windows Azure Workflow in SharePoint 2013, you must use Windows PowerShell. (To get a head start on working with PowerShell, consult our latest SharePoint and PowerShell article "Exploring and Inventorying SharePoint Using Windows PowerShell.

Reference: www.sharepointpromag.com by Caroline Marwitz

We cannot locate a server to load the workbook Data Model.

Problem Description:

Assume that you use an Analysis Services source to create a PivotTable in Microsoft Excel 2013. You upload the Excel Workbook to a Microsoft SharePoint site.

When you try to either refresh the PivotTable or filter the data in the PivotTable, you receive the following error message:

We cannot locate a server to load the workbook Data Model.

Probable cause:

This issue occurs because the Analysis Services instance has not been configured in the Central Administration site.

Workaround/Resolution:

1.    To work around this issue, configure the Excel Services service application on the SharePoint server. To do this, follow these steps:

2.    In the Application Management section of the Central Administration home page, click Manage service applications.

3.    On the Manage Service Applications page, click the Excel Services service application that you want to configure.

4.    On the Manage Excel Services page, click Data Model.

5.    Click Add Server.

6.    In the Server Name box, type the name of the Analysis Services instance that you want to add.

7.    Click Ok.

If you have any queries/questions regarding the above mentioned information then please let me know. I would be more than happy to help you as well as resolves your issues J

SharePoint 2013 free ebooks

Thanks allot to Mr. Jeremy Taylor as he states

There are a lot of resources (blog posts / worksheets / scripts / screenshots on random SharePoint things) on the internet on SharePoint 2013 which could be classified as an ‘ebook’ if you print it to pdf. However, I am interested in capturing “ebooks” that are in pdf, doc or xps format, with a table of contents and some thought to its presentation. The reason for this post is something you can download, print or save and read when you are offline. I will check for its source too and ensure its from an authoritative & well known source.

Here is a list of SharePoint 2013 free ebooks available on the internet:
Microsoft: Explore SharePoint 2013
Microsoft: Deployment guide for SharePoint 2013
Microsoft: IT Professional Reviewer’s Guide for SharePoint Server 2013
Microsoft: Plan and use the Distributed Cache service in SharePoint Server 2013

Happy New Year 2013.

It’s my pleasure to wish my all reader and viewers a very happy new year 2013….!

May GOD fulfill this year with all the happiness, warmth, and prosperity and keep you family and near being in a wealth state.  

I hope, I can bring you more of SharePoint learning from my experience and experience of experts across the world.

Happy Reading……!