SharePoint 2010 Dev: Reduce DB File Size

IN DEV, NOT PROD:

Reduce Database Log File Size:
USE [DatabaseName]
ALTER DATABASE [DatabaseName] SET RECOVERY SIMPLE WITH NO_WAIT
DBCC SHRINKFILE(LogFileName, 1)
ALTER DATABASE [DatabaseName] SET RECOVERY FULL WITH NO_WAIT

Reset User Profile synchronization:
http://technet.microsoft.com/en-us/library/ff681014(v=office.14).aspx


Resources:
http://troyvssharepoint.blogspot.co.uk/2012/10/sharepoint-user-profile-sync-database.html
http://technet.microsoft.com/en-us/library/cc262731(v=office.14).aspx

FIX: SharePoint 2010 Ribbon and IE10 - Screen goes white.

<!-- Fix for ie10 bug where SharePoint Ribbon dropdown causes screen to go white -->
<style type="text/css">
.ms-cui-modalDiv-ie,.ms-cui-glass-ie
{
background-color:transparent !important;
}
</style>


Reference: http://davemcmahon81.wordpress.com/2012/12/11/sharepoint-2010-ribbon-and-ie10-screen-goes-white/

Page Layout: This Control is Currently Disabled

Issue:

Page Layout: This Control is Currently Disabled.

Work around:

Make sure the page is checked out and editable

Click on the Save & Close Drop down arrow button

Click Save and Keep Editing

This will refresh the page and now you should be able to click on the page layout drop down.

Reference:
http://erikswenson.blogspot.com/2011/05/page-layout-this-control-is-currently.html

Scan a Document Directly into Word 2010

Alt > i > p > s.

CAML - AssignedTo [Me]

"<Where><Eq><FieldRef Name=\"AssignedTo\" /><Value Type=\"Integer\"><UserID Type=\"Integer\" /></Value></Eq></Where>"


Reference:
http://blogs.syrinx.com/blogs/sharepoint/archive/2008/08/07/caml-query-to-select-items-assigned-to-current-user.aspx

Access Denied for Site Collection Administrator

Make sure the Cache Super User has Full Control in the Web Application User Policy.
Make sure the Cache Super Reader has Full Read in the Web Application User Policy.

Delete Line Numbers

Maybe there's a better way to do this, but if you copy and paste code that includes line numbers, you can easily remove them by selecting columns of text in Visual Studio:

To select columns of text:
Hold down SHIFT + ALT while dragging the mouse pointer over a block of text.

Reference:
http://joelabrahamsson.com/select-columns-of-text-in-visual-studio/