Skip to main content

Posts

Showing posts from December, 2016

Work 9 to 6 for Salary and 6 to 9 for Career

How much time one must spend in office, the subject line of the Post is something I have heard from a client several years back and believe the best of all choices. She was in executive rank and was highly successful in both office & home fronts.................................................................... She said following “Souvik, you get a salary to do 40 hours of work per week. You must come on time at 9 am and work efficiently to plan & finish it by 6 pm. Whatever you are doing during this time, you must try to do it in the best possible way. You should plan so that you do not sign up for more work than what you can deliver. Also manage your priorities & timing to avoid work fluctuations as much as practically possible.”  I nodded head as what she said is something everybody knows. She continued. “However, 9-6 work will only help you “earn” your salary. It will not be good enough to offer a sustained growth, especially in later part of your career. If you really w…

How to Restore Projects in Project Server Web App

In this article, I will show you How to restore the project items by Project Web App. To achieve this task, Open central administration, refer to below screenshot to know how to open
Central administration site.



There is another way to open Central Administration Directly through URL. That is, htttp://yoururl:8888, this is the standard port number for SharePoint central administration site.
This is the landing page for Central administration, left side in quick launch you can multiple options such as Application management, System settings, etc..,



Here we need to look for Manage service applications options under Application Management.



Below is the Service application page, where you can see list of all services running in sharepoint. From the list look for Project Server Service Application option, that contains Project Web App instances including staging and Production which you want to access to perform restore action.


Refer to below screenshot to identify Project Server Service …

How to get column values in one comma separated value SQL Query

select  STUFF((SELECT distinct ', ' + (TaskName+':'+ cast([TaskFinishDate] as nvarchar(11))) from dbo.Tasks where ProjectUID='977F3EDD-27C4-E611-935A-5CAC4CC8EE9D'
            FOR XML PATH(''), TYPE
            ).value('.', 'NVARCHAR(MAX)')
        ,1,2,'')

select TOP 3 * from  dbo.Tasks where ProjectUID='977F3EDD-27C4-E611-935A-5CAC4CC8EE9D'

ERROR: Cannot resolve the collation conflict between SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS_KS_WS in the equal to operation

ERROR: Cannot resolve the collation conflict between SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS_KS_WS in the equal to operation
dont get panic if u get the following error while in your joinings, there is a simple way to solve this.
it is because of collation settings on two columns we are doing joinings. it is because of collation settings on two columns we are doing joinings
First step is to figure out what are two colaltion that cause for conflicts. Let us assume that collation has not been set at the column level and instead at db level, then we have to execute two simple statements as below.

Statements: Select DATABASEPROPERTYYEX('DB1',N'Collation') Select DATABASEPROPERTYYEX('DB2',N'Collation')
One more thing, make a note that if you are on sharepoint you will get error as below
Latin_General_CI_AS_KS_WS. if you are on most any other database and use the dafault settings you may get this SQL_Latin_General_CP1_CI_AS.
Now we have to do some…