Rename PerformancePoint Service database in SharePoint 2010

PerformancePoint Service database created by default contains GUID as suffix in name. But what if we dont want GUID in name and want to provide name with proper naming convention. I faced this issue in my project , then I came to know how it can be done. I will take you through a number of steps following which we can rename database .

1.) Start SharePoint 2010 Central Administration -> System Settings -> Manage Services on Server.
2.) Locate PerformancePoint Service and click Stop.
3.) Start SQL Server Management Studio , backup PerformancePoint Service database .
4.) In left pane of Management Studio , right click Databases and select 'Restore Database'.
5.) Provide new database name for 'To Database' textbox, select 'From Device' option  and browse to the backup of old PerformancePoint database. Select Ok.
6.) Now Go to Start -> All Programs -> Microsoft SharePoint 2010 Products -> SharePoint 2010 Management PowerShell.
7.) Type below command to get all information about PerformancePoint Service Application:
        
     Get-SPPerformancePointServiceApplication "PerformancePoint Service Application"

8.) Declare a new variable and assign new database name to that variable :
   
     $newdatabasename = "<New Database Name>"          (Name without angle brackets)

9.) Assign new database to PerformancePoint Service :
 
     Set-SPPerformancePointServiceApplication -Identity "PerformancePoint Service Application"   -SettingsDatabase $newdatabasename

10.)We are done with SharePoint 2010 Management Powershell.
11.) Navigate to 'Manage Services on Server ' and start the PerformancePoint service , if not started.
12.) Last step is to delete Old PerformancePoint Service database from SQL Server.

Rename Central Admin Database in SharePoint 2010 using Sharepoint PowerShell

In SharePoint , databases created by default have GUIDs as suffix. But sometimes , requirement is such that we do not want GUIDs in database names. In one of my project also , there was a requirement to rename Central Administration database. There is a step-by-step solution for this :-

1.) Start SharePoint 2010 Management PowerShell.

2.) Type below command to get information about content database being used  by Central Admin
   
     Get -spcontentdatabase  -webapplication <Central Admin Url>

     This command show content database id, name, web application, database server  and count.

     Mark the id of this content database.
 
3.) Now we have to create a new content database to attach with Central Admin, for that type the below command

     New -spcontentdatabase  -name <Database Name>  -webapplication <Central Admin Url>

4.) Again run powershell command mentioned in Step 2, this time it will show two content database information, old and new content database.

     Mark the id of new COntent database.

5.) To move the site collection from old content database to new content database , type below command in powershell

     Move -SPSite -ContentDatabase <old Content DB id> | Move -SPSite -DestinationDatabase  <new Content DB id>

6.) If you run the command in Step2 , you will see the new content database is attached to Central Admin. Now you can delete the content database from SQL Server Manegement Studio.

7.) Start SQL Server Management Studio, select the database, right click and select delete. But before pressing OK, select checkbox "Close Existing Connections" and we are done.

     Now we have Central Admin content database name as per our requirement.But if you again run command mentioned in Step2 , you will still find two content database.

     To get rid of this, we have to perform few more steps :-

8.) Start Central Admin -> Application Management -> Manage Content Database.

9.) On Manage Content Database page , select Central Admin Webapplication. It will show you two content databases, one with GUID (old) and one without GUID (new).

10.) Click on old Content Database to detach, it will open Manage Content Database Settings page. Select Remove Content Database and click OK

11.) Again if you run powershell command in Step2 , now you will get only one Content database  i.e. new Content database with custom name.
     
      Hope this is helpful for SharePoint 2010 users.

Schedule Email through Outlook 2003 and 2007

Many of us use Microsoft Outlook to access our Internet Email , Microsoft Exchange Server etc . What if  we wish to send email later at some other time and we dont want to wait till that time to send email ?

So here's the solution , just few simple steps and we are done :-

1.) Start Microsoft Outlook and compose your mail but wait do not send.
2.) Select Options tab from toolbar of composed email  window.
3.) Select delivery options , a new window will open up.
4.) Enable "Do not Deliver Before" check box , here you can set date and time to schedule the email. (If already enabled , then just set the date and time) .Check the highlighted part. 

5.) Now we're done and ready to send email.

Happy mailing :)

Disable IE Esc for Windows Server 2008

In Windows Server 2008 , IE Esc (Internet Explorer Enhanced Security Configuration) is enabled by default . When Internet Explorer is started , a message is displayed that " Microsoft Internet Explorer Enhanced Security Configuration is enabled on your Server ".  This reduces exposure from unsecure Web based content atacks . But this imposes restriction on Web pages and Applications that uses the browser , basically reduces their functionality and display is also not proper .

To disable th IE Esc , follow the steps :-

1.) Click Start -> Administrative Tools , select Server Manager.
2.) Two panes should be visible right and left .
3.) From left pane , select root directory.
4.) From right pane , select Configure IE Esc link under Security Configuration.
5.) Select Off radio button for Administrators to disable IE Esc.
6.) Select Off radio button fro Users to disable IE Esc.

Developer Tool in IE8

Microsoft provided built-in feature of developer tool in IE8 and later versions proved very useful for developers .
UI changes can be done with the help of developer tool . Open a site in IE8 and press F12 , developer tool window will open up . Click on the arrow icon in window or press Ctrl+B and then select any element on page . Styles applied to that element will be visible to you . You can also view the .css file associated with the element. Style of parent being overwritten by child control can be seen by strikeouts.
Check dis out ........:)