How to get Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server

Many a times we may need to get the Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server. In this article we will see how we can get these parts of the DateTime in Sql Server. You may like to read the other popular articles on Date and Time: How to get… Continue reading How to get Time, Hour, Minute, Second and Millisecond Part from DateTime in Sql Server

How to Shrink LDF File Size using SQL Management Studio

If the transaction log file (.ldf) in Microsoft SQL is too big, it can cause performance issues, eat up valuable disk space and consume resources when you back up. Therefore it’s imperative to periodically maintain the database to keep the .ldf file under control. To reduce the .ldf file, you must do threethings: Backup the… Continue reading How to Shrink LDF File Size using SQL Management Studio

Migrating Service Applications from SharePoint 2010 to 2013

Migrating and upgrading our service applications and web applications to SharePoint 2013 is to restore the databases from the SharePoint 2010 environment to our SharePoint 2013 environment. This can be accomplished with the SQL Server Management Studio using the UI tools or a SQL query. To restore a database with the UI tools: Right-click Databases… Continue reading Migrating Service Applications from SharePoint 2010 to 2013

Migration SharePoint 2010 to 2013 with RBS content database

1.     Live SharePoint 2010 environment with SQL 2008 R2 a.    Take back up from 2010 live server. i.      Open management studio on SQL server. ii.      Take back up of content database of live application. 2.    QA SharePoint 2010 environment with SQL 2008 R2 a.    Restore SQL backup i.      Open management studio on SQL… Continue reading Migration SharePoint 2010 to 2013 with RBS content database