SQL SERVER 2012 CERTIFICATIONS

Get Started with a SQL Server Certification

The data explosion is happening at every level of the business—across devices, applications, and individual roles. Become certified on Microsoft SQL Server and prove your knowledge and skills in designing, building, and maintaining the next wave of cloud-ready database and information solutions.
Two MCSE certifications are available for SQL Server 2012: Data Platform and Business Intelligence. Earn an MCSE: Data Platform certification to demonstrate your indispensable expertise to build enterprise-scale data solutions on-premises or in the cloud. Showcase your skills in developing and deploying visually rich business intelligence solutions and reports by earning an

Select a tile below for more information

 

MCSA: SQL Server 2012

Acquire essential skills and knowledge to develop, run, and maintain the next wave of advanced database and information solutions.

Step 1	Step 2	Step 3	Step 4
Course 10774 Querying Microsoft SQL Server 2012	Course 10775 Administering Microsoft SQL Server 2012 Databases	Course 10777 Implementing a Data Warehouse with Microsoft SQL Server 2012	MCSA: SQL Server
Exam 461 Querying Microsoft SQL Server 2012	Exam 462 Administering Microsoft SQL Server 2012 Databases	Exam 463 Implementing a Data Warehouse with Microsoft SQL Server 2012

Office 2013

Microsoft Office 2013 (also called Office 2013 and codenamed Office 15) is a group of office productivity software programs for the Microsoft Windows operating system and the successor to Microsoft Office 2010. Office 2013 will be available as part of Windows RT for ARM processors, and separately for the IA-32 and x86-64 versions of Windows

Download office 2013 free: http://www.microsoft.com/en-in/office365/get-office365.aspx

Office 2013 Customer Preview: http://www.microsoft.com/office/preview/en

Microsoft Office 2013 Preview AppV packages: http://www.microsoft.com/en-in/download/details.aspx?id=30423  

Microsoft Office 2013 - FREE Full Download - How to install:

www.youtube.com/watch?v=z1JMFRmdSxg

Microsoft Office Customer Preview – Official Site:

www.microsoft.com/office/preview

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.

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.

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.

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 horizontally 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.

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.

Would like to highlight some nice contribution from Amol Ghuge on auditing configuration: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:

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

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

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

Option2:

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

§  Site Actions

§  Site settings 

§  On Site collection administration section

§  click on Site Collection Features 

§  Search for the Reporting feature 

§  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

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

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 know 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.