Download SQL SERVER 2012

SQL Server 2012 will provide Mission Critical Confidence with greater uptime, blazing-fast performance and enhanced security features for mission critical workloads; Breakthrough Insight with managed self-service data exploration and stunning interactive data visualizations capabilities; Cloud On Your Own Terms by enabling the creation and extension of solutions across on-premises and public cloud. SQL Server 2012 will be available in three main editions:

§  Enterprise

§  Business Intelligence

§  Standard

Discover the Power of SQL Server 2012

http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx

SQL Server Data Tools

http://msdn.microsoft.com/en-us/data/hh297027

SQL Server 2012 Express

http://www.microsoft.com/en-us/download/details.aspx?id=29062

Windows Azure SQL Database Trial Offer

http://www.microsoft.com/en-us/SQLAzure/offers/default.aspx

SQL Server 2012 SP1 CTP3

http://www.microsoft.com/en-us/download/details.aspx?id=30375

Download Microsoft SharePoint Server 2013 Preview

http://technet.microsoft.com/en-US/evalcenter/hh973397.aspx?wt.mc_id=TEC_121_1_33

Download Office 2013 Preview

http://www.microsoft.com/office/preview/en?WT.mc_id=MSCOM_EN_US_DLC_FEATURE_131L1ENUS21367

 

MICROSOFT SQL SERVER 2012 SERVICE PACK 1

http://www.microsoft.com/en-us/download/details.aspx?id=30375

Top Features of SQL Server 2012

Always On Availability Groups -This feature takes database mirroring to a whole new level. With Always On, users will be able to fail over multiple databases in groups instead of individually.

Windows Server Core Support -If you don't know what Windows Server Core is, you may want to come up to speed before Windows 8 (MS is making a push back to the command line for server products). Core is the GUI-fewer versions of Windows that uses DOS and Power Shell for user interaction. It has a much lower footprint (50% less memory and disk space utilization), requires fewer patches, and is more secure than the full install. Starting with SQL 2012, it is supported for SQL Server.

SQL Azure Enhancements -These don't really go directly with the release of SQL 2012, but Microsoft is making some key enhancements to SQL Azure. Reporting Services for Azure will be available, along with backup to the Windows Azure data store, which is a huge enhancement. The maximum size of an Azure database is now up to 150G. Also Azure data sync allows a better hybrid model of cloud and on-premise solutions

Big Data Support -I saved the biggest for last, introduced at the PASS (Professional Association for SQL Server) conference last year, Microsoft announced a partnership with Hadoop provider Cloudera. One part of this involves MS releasing a ODBC driver for SQL Server that will run on a Linux platform. Additionally, Microsoft is building connectors for Hadoop, which is an extremely popular NoSQL platform. With this announcement, Microsoft has made a clear move into this very rapidly growing space.

This file cannot be saved because some properties are missing or invalid. Use the Document Information Panel to provide the correct property values. Errors for required properties are marked with a red asterisk, and errors for invalid properties are marked with a red dashed border.

User has raised an incident ticket by mentioning that he is not able to save the word document and getting the below mentioned error message:

This file cannot be saved because some properties are missing or invalid. Use the Document Information Panel to provide the correct property values. Errors for required properties are marked with a red asterisk, and errors for invalid properties are marked with a red dashed border.

Configuration: SharePoint 2010, Word 2010, IE7.0, Windows 7 OS.

While researching on the same, I found one Microsoft KB which clearly states that this is a known issue and multiple workaround can be used to fixed the same. Here is the article based on the same:

http://support.microsoft.com/kb/981688

100% credit to this Microsoft KB which resolves our issue but I continued my RnD on the same and successfully reproduced the issue at my end also.

What also we can do apart from Microsoft KB?

§  Open the same document library which has the problem

§  Settings

§  Library settings

§  Content types

§  Hidden fields in the content types

§  Make the necessary fields options and check the results

I am pretty much confident that by using the above mentioned steps, we will be in a position to resolve the issue without any problems.

If you still face the same problem then please let me know so that we can troubleshoot and resolves the issue as soon as possible. Thank you.

How to create a Lync 2010 Dial Plan?

How to create a Lync 2010 Dial Plan?

Hello Friends,

We always motivate user to use telephonic or click to call functionality, however before start for using Remote call Control or Click to call we have to create separate Dial Plan in Lync 2010,  Here i will show you, how to create Dial plan –

To Create a Dial Plan:

1. Log on to computer as a member of the RTCUniversalServerAdmins group, or as a member of the CsVoiceAdministrator, CsServerAdministrator, or CsAdministrator role. Open a browser window, and enter Admin URL to open Lync Control Panel.

2. In left navigation bar, click Voice Routing and click Dial Plan.

3. On Dial Plan page, click New and select a scope for dial plan:

·        Site dial plan applies to an entire site, except any users or groups that are assigned to a user dial plan. If you select Site for a dial plan’s scope, you must choose the site from the Select a Site dialog box. If a dial plan has already been created for a site, the site does not appear in the Select a Site dialog box.

·        Pool dial plan can apply to a public switched telephone network (PSTN) gateway or a Registrar. If you select Pool for a dial plan’s scope, choose the PSTN gateway or Registrar from the Select a Service dialog box. Service does not appear in the list if dial plan already has been created for a service (PSTN gateway or Registrar).

·        User dial plan can be applied to specified users or groups.

4. If you create a user dial plan, enter a name in Name field on New Dial Plan dialog box. The name cannot be changed after it is saved.

5. The Simple name field is filled in with the same name that appears in the Name field. To edit this field is optional to give a more descriptive name that reflects the site, service, or user.

6. In the Description field, you can type additional descriptive information about dial plan (optional).

7. If you want to use this dial plan as a region for dial-in access numbers, specify a Dial-in conferencing region. If you do not want to use this dial plan for dial-in access numbers, leave this field empty. (Optional)

8. In the External access prefix field, specify a value only if users need to dial one or more additional leading digits (for example, 9) to get an external line. You can type in a prefix value of up to four characters (#, *, and 0-9). (Optional)

9. Associate and configure normalization rules for the dial plan:

·        To choose one or more rules from a list of all normalization rules available in your Enterprise Voice deployment, click Select. In Select Normalization Rules, highlight the rules you want to associate with the dial plan and then click OK.

·        To define a new normalization rule and associate it with the dial plan, click New.

·        To edit a normalization rule that is already associated with the dial plan, highlight the rule name and click Show details.

·        To copy an existing normalization rule to use as a starting point for defining a new rule, highlight the rule name and click Copy, and then click Paste.

·        To remove a normalization rule from the dial plan, highlight the rule name and click Remove.

10. Verify that the dial plan’s normalization rules are arranged in the correct order. Highlight the rule name and then click the up or down arrow to change a rule’s position in the list.

11. Enter a number to test the dial plan and then click Go. The test results are displayed under Enter a number to test. (Optional)

12. Click OK.

13. On the Dial Plan page, click Commit, and then click Commit all.

Thank you.

The specified web does not contain a reporting metadata list

When you view Audit log reports on a Microsoft Office SharePoint site, you receive the following error message:

The specified Web does not contain a reporting metadata list.

Guys- one of our clients has opened an incident ticket by mentioning that he is getting the above mentioned error message. If we notice the error message carefully then you will come to know that it’s clarifying something in the direction of site template.

I have started my troubleshooting to find out that if its works properly in Team site template then which are those templates are having these problems. Let me tell you that this troubleshooting took 2-3 hours to test each and every template to find out the correct resolution.

Finally I have successfully resolved this issue and here is my analysis:

This issue may occur if any of the following templates were used to create the default site:

1.   Document Workspace

2.   Wiki

3.   Blog

4.   Records Center

Note: To view Audit log reports, click Audit log reports  on the Site Actions/ Site Settings  menu.

Resolution:

To resolve this issue, run the following STSADM command on the SharePoint server for each affected site collection:

stsadm -o activatefeature -name Reporting -url http://yourssitecollectionurl/ -force

Please check and let me know in case of any further queries/questions, Thank you. Happy SharePoint to all of you :) :)

Unexpected Error when trying to view Audit Log Reports

Guys-from last few months I am trying my best to dig in SharePoint auditing and trying to explore so many things. While exploring, I am trying to create the error message so that it will be easy for me to know the root cause and resolution too. I would like to share my research and thorough findings so that it will be helpful for everybody to minimize the headache that we experienced while troubleshooting the issue.

If you receive an Unexpected Error trying to view the Audit Log Reports on their Site Collection:

·         Access the Site Collection. 

·         Go to Site Actions >Site Settings. 

·         Select Audit Log Reports. 

Error message:

Unexpected Error returned.

Resolution:

Please use the following steps to resolve this issue:

1.   Visit <SiteURL> /_layouts/ManageFeatures.aspx?Scope=Site

Example: https:// spsites.sharepoint.com/sites/amolsp2010 /_layouts/ManageFeatures.aspx?Scope=Site

2.   Deactivate the feature: Reporting. 

3.   Activate the feature Reporting. 

4.   Visit /_layouts/AuditSettings.aspx page and verify the Audit settings. 

5.   After some time, validate the reports are working as expected.

Please let me know in case of any queries/questions regarding the above mentioned information. Thank you.

Reference:

Cannot view audit log reports on site collection: http://sharepointknowledgebase.blogspot.in/2012/07/sharepoint-2010-cannot-view-audit-log.html

How to configure auditing: http://sharepointknowledgebase.blogspot.in/2010/09/sharepoint2010-site-collection-auditing.html

SharePoint 2010-Cannot view audit log reports on site collection

Auditing-Knowing who is taking what action on which content in your site collection can be critical in helping your organization fulfill its requirements, such as meeting regulatory compliance and records management. You save an audit log report as a Microsoft Excel 2010 workbook to a library in the site collection that you specify.

Few months before, I have already written an article on auditing configuration and I really wanted to thank you for your kind responses: http://sharepointknowledgebase.blogspot.in/2010/09/sharepoint2010-site-collection-auditing.html

But now in this article, I am trying to concentrate on one of the incident which has been faced by the local team members.

The issue was: After being enabled the Audit log reports, the link to "Audit log reports” remains unavailable (does not appear) on site collection settings

See, it was very easy to troubleshoot this issue so I request you to follow the below mentioned steps and I am pretty much confident that your issue will be resolved.

Resolution:

I am providing you two options here so you can use anyone as per your flexibility.

Note: in both the options, you must be site collection administrator for the site collection.

Option1:

1.   Open command prompt ( Start-> Run and type cmd ) 

2.   Change to the SharePoint 2010 path (\programfiles\Common files\Microsoft Shared\web server extensions\14\bin) 

3.   Run STSADM.EXE -o activatefeature -name Reporting -url http://sitecollectionurl -force (this may take a while on finishing) 

Option2:

1.   On the site that the Audit log reports are going t be activated

2.   Site Actions

3.   Site settings 

4.   On Site collection administration section

5.   click on Site Collection Features 

6.   Search for the Reporting feature 

7.   Click on Activate button 

Go back to Site Actions->Site Settings and on Site Collection administration section and verify that the link is available now

Please let me know in case of any queries/questions regarding the above mentioned information. I would be more than happy to help you as well as resolves your issues J J

How to organize files in SharePoint

The following are some of the ways that you can view and manage files in the same library:

• Add columns to help your group to identify the data that is most important and to view the data in different ways, you can add columns (column: X named selection of data in a list, library, or content type, such as Title or Due Date. Columns are displayed horizantally in most views and are displayed as fields in forms.) to your library. Columns appear at the top of the library page as headings, such as department name or due date. You can use the column headings to sort and filter the files in a library.

• Create views: (view: A set of columns on a Web page that displays items in a list or document library. The view can display sorted or filtered items, a selection of columns, or a custom layout.) if the people in your group frequently need to see the data in a certain way. In views, columns are used to sort, group, filter, and display the data.

• Create folders for many files that can be grouped in a particular way, folders are an option. Folders can help people to scan and manage files in a familiar way. Windows SharePoint Services 3.0 provides a tree view that people can use to navigate sites and folders, similar to the way that they work with folders on a hard disk.

• Set up multiple templates if multiple content types are set up in a library, you can create different types of default templates — such as sales contracts, marketing presentations, and budget worksheets — within the same library. Content types add flexibility and consistency across multiple libraries.

Please let me know in case of any queries/questions, Thank you.

How to assign a User-specific voice policy?

How to assign a User-specific voice policy?

Hello Guys,

Many times we have to create multiple voice policies for different purpose. After creating voice policies we have assign the same to specific user, as per requirements.

This article will help to assign the voice policies to specific user. You need to assign either a global voice policy or per-user voice policy to all user accounts that are enabled for Enterprise Voice. User accounts can use the global voice policy by default when you do not assign an existing voice policy that you created for specific users or groups of users.

Assign a user-specific voice policy:

1. from a user account that is assigned to the CsUserAdministrator role or the CsAdministrator role, log on to any computer in your internal deployment.

2. Start Lync Management Shell: Click Start, click All Programs, click MS Lync 2010, and then click Lync Management Shell.

3. To assign an existing voice policy you created for specific users or groups of users, run the following at the command prompt:

Grant-CsVoicePolicy-Identity <UserIdParameter>-PolicyName<String>

For example: Grant-CsDialPlan -Identity "Balu Ilag" -PolicyNameVoicePolicyIndia

In this example, the user with the display name Balu Ilag is assigned the voice policy with the name VoicePolicyIndia.

Thank you.

Failed to start the User Profile Synchronization service

The User Profile service application stores information about users in a central location. Social computing features use this information to facilitate productive interactions which enable users to collaborate efficiently. In order to provision My Sites, enable social computing features such as social tagging and newsfeeds, and create and distribute profiles across multiple sites and farms, you must enable the User Profile service application.

In the 'Central Administration--Services on the Server page, the User Profile Synchronization Service is in 'Stopped' state. 

Also when you check the ULS log after the entry ILM configuration: Configuring Registry keys, you can see several entries similar to the next:  

"Unable to load Assembly for LCID"

In the Synchronization DB on the SQL server, the User account assigned to the "User Profile Synchronization Service" was not mapped to the login account as 'dbo' in the 'User' and 'Default schema' columns.

Resolution:

1.   Open the Microsoft SQL Server Management Studio from Start - All Programs menu

2.   Under Security, expand logins and select the user account assigned to the user profile synchronization service.

3.   Right click Properties > User mapping > on the right panel, scroll down until you find the User Profile Service Application synchronization DB.

4.   Make sure that it is checked and change the value for the 'User' and 'Default schema' columns to 'dbo.

If you get an error while performing the previous operations, then you should make the changes in the Synchronization DB. Expand the Synchronization DB node > Security > Roles > Database roles and select the 'FIM_SynchronizationService', 'persistencesUsers' and 'state_persistence_users' values.

Delete the FIM certificates and restart the user profile synchronization Service.

Please let me know in case of any further queries/questions. I would be more than happy to help you as well as resolves your issues, Thank you.

contacts management template sharepoint 2007

Guys-Today we came across one issue wherein the user was using the contacts management template for his site. Normally the Members in the contact management web part are not displayed. We need to search with their first or last name to get all the details of the user.

The Contacts Management application template for Microsoft Windows SharePoint Services 3.0 helps teams manage contact information that needs to be shared among team members.

The application template allows teams to enter contact information through a Web-based interface or through Microsoft Office Outlook 2007. When used in conjunction with Office Outlook 2007, team members can 'subscribe' to receive updated contract information whenever other users make changes to a contact.

We found by default the web part returns all names beginning with the letter R.

After researching we found that this issue can be fixed by modifying the results.aspx page.

You need to open the site using Sharepoint Designer (SPD2007)http://Mysharepointsite/contacts/Results.aspx

The list of contacts is provided by a data view web part which contains the following line:

<ParameterBinding Name="SearchQS" Location="QueryString(Search)" DefaultValue="r"/>

Remove the letter ‘r’ and refresh your page, now no contacts will show up by default.

If you have any queries/questions regarding the above mentioned information then please let me know. Thank you.

SharePoint 2013

SharePoint 2013 Preview sites provide secure environments that administrators can configure to provide personalized access to documents and other information.

Download SharePoint Foundation 2013:

http://www.microsoft.com/en-us/download/details.aspx?id=30345

The current model is actually quite good. It helps make the development and deployment process much easier, as the entire solution can be packaged within a solution file. The solution can be upgraded quite easily, and sandboxed solutions are a great way to pilot new code or deliver unique experiences in a multi-tenant environment, like Office 365.

Microsoft has already published a very detailed documentation on this and here are those which can be useful for your reference:

Downloadable content for SharePoint 2013

http://technet.microsoft.com/en-us/library/cc262788(v=office.15)

Video demos and training for SharePoint 2013 Preview

http://technet.microsoft.com/en-us/library/cc262880(v=office.15)

Technical diagrams for SharePoint 2013 Preview

http://technet.microsoft.com/en-us/library/cc263199(v=office.15)

Explore SharePoint 2013 Preview

http://technet.microsoft.com/en-us/library/cc261970(v=office.15)

Plan for SharePoint 2013 Preview

http://technet.microsoft.com/en-us/library/cc261834(v=office.15)

Develop for SharePoint 2013 Preview

http://technet.microsoft.com/en-us/library/cc262356(v=office.15)

Install and configure SharePoint 2013 Preview

http://technet.microsoft.com/en-us/library/cc262957(v=office.15)

Use SharePoint 2013 Preview

http://technet.microsoft.com/en-us/library/fp123457(v=office.15)

Troubleshooting SharePoint 2013 Preview

http://technet.microsoft.com/en-us/library/gg609831(v=office.15)

Technical reference for SharePoint 2013 Preview

http://technet.microsoft.com/en-us/library/cc262798(v=office.15)

Scenarios and solutions for the real world in SharePoint Server 2013 Preview

http://technet.microsoft.com/en-us/library/ff872147(v=office.15)

The list or library contains a large number of items. Learn about managing a large list or library and ensuring that items display quickly.

Today we have received one incident ticket in which the user was facing the below mentioned error message:

The list or library contains a large number of items. Learn about managing a large list or library and ensuring that items display quickly.

Hmm…Pretty much enough to understand that the library or list consist of so many items and now it’s affecting the performance. If you wanna see the performance criteria which have been defined by Microsoft then please refer this link:

http://office.microsoft.com/en-us/windows-sharepoint-services-help/manage-lists-and-libraries-with-many-items-HA010173667.aspx

Microsoft has given a very detailed description regarding the performance criteria:

Once you’ve exceeded the 2000 item limit, you may see this message on the list settings page (red exclamation point):

The list or library contains a large number of items.

Please keep one more msdn article handy with you to make the clear understanding of this point: http://blogs.msdn.com/b/ecm/archive/2010/04/05/it-looks-like-you-re-building-a-large-library-would-you-like-help.aspx

If you still has any queries/questions then please let me know. I would be more than happy to discuss the problem and helps you to resolves your issues as soon as possible. Thank you.