Obtain Service Pack 1 for SQL Server 2012

Microsoft Announced Service Pack 1 for SQL Server 2012 on November 2013 and here is the full list of Fixes/Improvements included with it – http://support.microsoft.com/kb/2674319/en-us

Improvements of SQL 2012 SP1 in SharePoint Perspective 

One of the major reason to Obtain SQL 2012 Service Pack 1 in SharePoint Environments is that you cannot enable SQL Server Reporting Instance without having SP1 which was the reason for me to obtain this. when you trying to enable SQL Server Reporting for SharePoint, You may get the issue in SharePoint Management Shell saying "The term ‘Install-SPRSService’ is not recognized as the name of the cmdlet".

clip_image001

Installing SP 1 for SQL 2012 resolved the above issue for me.

Take below steps to Obtain the SQL Service pack 1.

Note:

  1. Make sure that you test this in a Staging environment before update your production SQL.
  2. Also there is an mandatory KB (Non Security Update for SQL Server 2012 SP1 [KB2793634]) which needs to be Installed after SP1 Installation. This KB will fix "windows Installer Starts repeatedly" issue. Get in here to know more about known issues on SP 1 – http://blogs.msdn.com/b/psssql/archive/2013/07/31/after-applying-service-pack-1-for-sql-server-2012-you-may-encounter-a-known-issue-details-inside.aspx

1. Download SP 1 for SQL 2012 here – http://www.microsoft.com/en-us/download/details.aspx?id=35575. And run it on your Server

clip_image002

2. Accept the license Terms

clip_image003

3. Select the Features that you need to Update and hit next

clip_image004

4. Give it a moment

clip_image005

5. Hit "Update" to Install

clip_image006

6. It will take a while and make sure that your users are not using any services related to SQL.

clip_image007

7. If everything went well, you will get the below green lights on each feature.

clip_image008

8. Go ahead and now install the KB mentioned above

9. Restart the Server and you are done with the update !

Advertisements

Use Chart Webpart in SharePoint 2013

SharePoint 2013 has discontinued (not really) some of it early version’s features and Chart webpart is one of them. It seems that Microsoft has discontinued this feature to bring up Excel Services in to better place where you can leverage the product you purchased and do more with it.

However this doesn’t mean that you cannot use Chart Web Part in 2013. if you still prefer to use Chart Web Part instead of Excel Services you can simply download the webpart and use in your Site.

Using Excel Services would leverage your knowledge very much on BI but Still this Chart web part is a very good feature that you can simply customize.

Refer here if you need to dig more in what Microsoft has Discontinued with their latest SharePoint – http://office.microsoft.com/en-001/sharepoint-help/discontinued-features-and-modified-functionality-in-microsoft-sharepoint-2013-HA102892827.aspx

Well Let’s see how we can use Chart Web Part in SharePoint 2013. follow these few steps to get it done.

  1. Download the Web Part in Zipped file here – http://1drv.ms/1cP2bQX
  2. Unzip it and upload it to your SharePoint Site Webpart Gallery (Site Actions –> Site Settings –>WebParts)

Figure: 01 Webpart Gallery

clip_image001

It will take in to the Gallery. Go ahead and simply upload the MOSSChart Web Part in to it.

clip_image002

It will appear there as below once you uploaded

clip_image003

Go ahead and try to insert a webpart by editing a Page (Edit Page –> Insert –>Webpart). You should be able to see the Web Part under Default Category (if you have chosen Default Category when you upload it)

clip_image004

Go ahead and Add it to your Page

clip_image005

Here we got the little master in our page now. Play with it and enjoy your SharePoint life folks !!

I’ll be further keep posting on how to configure and customize this webpart.