Technology tips: April 2014

Tuesday, April 15, 2014

sql server developer edition

If you want to cut the cost of IT in terms of licensing so one thing is highly recommended which is you can consider purchasing sql server 2012 developer edition license for your test environment.
Actually SQL server 2012 developer version is full feature version by Microsoft for development and testing purpose only, this release is not for production. And eventually you are cutting cost in terms of licensing otherwise you have to buy all licenses for development and test environment but please note this- databases can't be deployed on production, - let’s say you have developed application based on SQL server and you want to test it so you can consider buying development version. Whereas Express edition is basic model of free version people has been using it but you can consider developer edition for such kind of need.
 SQL Server Developer version will help you learning sql server or ideal for sql server training – having  full feature without paying any cost and build full fledge database driven business application test it once you are confident with the result then you can invest in licensing.
What developer version includes or sql server developer edition limitations are - let me elaborate,  it includes sql server management studio, sql profiler etc, whereas SQL Express edition does not include such tools, Microsoft has released Express version because people thinks that it’s a replacement of MSDE.
Whereas SQL express edition is coming with limited functionality for example high availability is not found in express edition anyways. 
There is a difference between express edition and sql server developer edition ,  it only can be used with production environment whereas Developer edition cannot be used in inside production.

For example feature wise, SQL Server 2012 developer edition has same feature as SQL server 2012 enterprise server has.

You can buy SQL Server developer edition from Microsoft site easily, it also supported with sharepoint this means if you have SharePoint farm with sharepoint 2013 and sql server 2012 so can do this by adding a sql server developer edition into your development environment and make a farm for testing purpose.

Sql Server Developer version has analysis services, integration services, and other feature as you find them in sql server 2012 full version or the enterprise version.

If you think you can deploy it on production and take full advantages because it’s more like you are working with toy.

Only thing which is important to understand you cannot deploy databases in your production farms using sql server developer edition.

Saturday, April 5, 2014

SharePoint Custom Survey Views

If you come across with customized views in SharePoint so they can help you to design different views for users to view SharePoint data differently.
But when it comes to survey and that survey should be like SharePoint custom survey views so you probably face some difficulty in that because as standard functionality you won’t be able to find survey views in the specified section as you find it standard list.
How you can customize the survey as different view. This means that you probably want to display survey data differently to your users.
Here are simple to procedure if you follow so you can customize survey views for your users in SharePoint. We have designed these views in SharePoint 2007.

Procedure for SharePoint Custom Survey Views:

Procedure is very simple and straight forward to create a custom view for SharePoint survey list as mention  given below.

How to find Survey List ID:
First step to know the survey List id, and to get the survey list id is simple there are different ways to do that what we have done was that – just inside the survey tap Action menu and tap View RSS Feed, if you look at the URL you will find Survey ID similar to the following.
Here is sample survey list id:
List=%7BF5348760%2D133A%2D400B%2D81CE%2D9ED16FD81C3E%7D





How to display customize column for survey views:
Second thing you need to change the URL as the following with the list ID, just add the question mark as mention in the example below and past your survey id after that. So final url would similar to the following:

http : //sharepointURLwithport/_layouts/ViewType.aspx? List=%7BF5348760%2D133A%2D400B%2D81CE%2D9ED16FD81C3E%7D

Then you will see the screen will change to SharePoint customize survey view . From there you can select other fields to be added in your custom survey views like group by so users can view survey as group by and as other fields.
You need to enter name of the custom views survey in this step.

I hope this has resolved your issue related to custom survey list according to your need please let us know if you need any help from us.