HIde List Tab from Ribbion for List

HI All,
          After very long time I am posting the issue on SP 2013 .One of my follower mailed me few times for the solution to hide the List Tab from the SP Ribbon.

Step-1
 Insert the Script Editor Web-part in the List or Document Library
Step-2
   Insert the below snippet

<style type="text/css"> #Ribbon\.List-title{ DISPLAY: none !important } </style>
Step-3
     Check Hidden Option the Layout option ->ok

Setup is unable to proceed due to following error(s)

Hi All,
          Few days back when I am installing Sp 2013 I faced the below issue

Setup is unable to proceed due to following error(s)
The Producr requires Windows Server 2008 Server Pack 2 or above.
Correct the issue(s) listed above and run setup

Solution:
Download the below exe files and run with command prompt
.NET Framework 3.5 SP1
Windows PowerShell 2.0
Windows Installer 4.5 Redistributable
 

browser id="Safari2" parentID="Safari1Plus"

When you open a file with SharePoint Designer, it creates all kind of FrontPage Server Extension functionality in your web application. One thing it does it that it creates a _vti_cnf folder in every folder you have in your web application. If you remove all these folders you fix your problem.

I don't know of a handy DOS command to delete all these folders recursively, but with some PowerShell I solved the problem.

Open a PowerShell prompt, set the current directory to the folder hosting your web application and execute the following command to see the "damage":

PS C:\Inetpub\wwwroot\wss\VirtualDirectories\wss3dev> get-childitem -path . -name _vti_cnf -recurse
_vti_cnf
App_Browsers\_vti_cnf
App_GlobalResources\_vti_cnf
aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\CSs\_vti_cnf
aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\html\_vti_cnf
aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\ToolBar\_vti_cnf
aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\Images\Tree\_vti_cnf
aspnet_client\system_web\2_0_50727\CrystalReportWebFormViewer3\JS\_vti_cnf
wpresources\_vti_cnf
_app_bin\_vti_cnf

Now execute the following PowerShell command to kill all these folders and become a happy camper again:

PS C:\Inetpub\wwwroot\wss\VirtualDirectories\wss3dev> get-childitem -path . -name _vti_cnf -recurse | % { remove-item -Path $_ -recurse }

User Profile Synchronization Service Stuck at "Starting"

Hi All,
              These days while working on "Enterprise Search" .I faced an error and when I went to User Profile Synchronization Service  which is in(Central admin->Application Management->Service Application->Manage Services on Server) it is in "Starting mode" . I binged in for this solution and many url's suggested to create new user profile and blah blah blah . Then I had a look on my Timer service and it too is fine, And  I remembered a time in the past where deploying updates jacked up the Timer service, making it appear as it was running when it really wasn't. I opened Powershell

1.$farm=Get-SPFarm
2.$farm.TimerService.Instances

After running second line I go ID of Timer Server and used it in below command

1.$timer=$farm.TimerService.Instances | where {$_.ID -like "4824-2425-2132-2442*"} 
2.$timer.Status = [Microsoft.SharePoint.Administration.SPObjectStatus]::Online
3.$timer.update()
  When I look back Manage Services on Server  which is in(Central admin->Application Management->Service Application->Manage Services on Server) it is in "Start" Mode.

 

Sql query to Restore Database

Hi All,
          These days i had come to a situation where i need  to restore large amount of DB .When I try restore Sql Sever GUI it is taking long time.Then with the help of below restore query it had almost saved lot if time


Restore DATABASE WSS_Content_ecdb178dc5434f4299f516abc83e48ed  From Disk = 'D:\sqldb.bak' With REPLACE
Go

SharePoint 2010 - HTTP Error 503 Service Unavailable

Hi All,
          503 errors are usually due to a temporary overloading or maintenance of the server.

 Check the application pool. If it is disabled it caused due to crashes a couple of times You need to manually re-enable the application pool in IIS Manager - that should resolves the problem.

Sql Procedure to Migrate Sql Database to higer version

Respected All,
               -> I have work to Migrate Sql server 2000 data base to Sql Server 2008 r2 .I had taken  backup of Sql Database from Sql Server 2000 and  restored  the backup  Database into Sql Server 2008 R2.

            ->After restoring i had used Count(*) query in Sql Server 2000 to find the total number of records in the table "Department" and it showed me total number of records in table "Department" as 96.

           ->I used same Count(*) query to find  total number of records in the table "Department" in Sql Server 2008 R2  and it showed me total number of records in table "Department" as 82 .

          ->Like this in all tables I am loosing records and in some tables it shows more records in Sql Server 2008 R2 when compared to Sql Server 2000. I had done R&D but i don't find any solution to i.e Suddenly i  had used  the below procedure in Sql Server 2008 r2 after restoring  and it executed and solved the problem .



   Syntax: 
             

USE DatabaseName;
GO
DBCC UPDATEUSAGE (DatabaseName)
GO

     example                       

USE DBC;
GO
DBCC UPDATEUSAGE (DBC)
GO