Sharepoint: Efficient way of handling User Pemissions

1. All the users should be added to distribution group in AD and then from there we should add the specific AD groups to Sharepoint group rather than one by one adding users in Sharepoint Group
2. Infopath email recipients should be AD distribution

Reduce Log size during Reindexing

USE [Customer]
GO

SELECT *
FROM sysfiles
WHERE name LIKE '%LOG%'
GO

DBCC SHRINKFILE (Customer_Log, 1)
GO

BACKUP LOG Customer WITH NO_LOG
GO

DBCC SHRINKFILE (Customer_Log, 1)
GO

BACKUP LOG Customer WITH TRUNCATE_ONLY
go

DBCC SHRINKFILE (Customer_Log, 1)
GO

Saving BLOB columns to Folder Directory

If you are migrating the data from a table with a BLOB type data (Excel,Doc,XML,PDF) and you save them separately on the folder, you can use SSIS Export Column transform

Go SSIS!!!

SSIS: Execute SQL Task - IsQueryStoredProcedure

The property "IsQueryStoredProcedure" under "Execute SQL Task" will be available for settings only if you are using ADO.Net connection type. Otherwise it will be greyed out.

MS Dynamic CRM: Useful Error Links

Unauthorized 401 Error

http://nishantrana.wordpress.com/2008/11/06/the-request-failed-with-http-status-401-unauthorized-mandatory-updates-for-microsoft-dynamics-crm-could-not-be-applied-successfully/

CRMDiscoveryService.asmx is not available.

Do Not type the Org name in url.
http://social.microsoft.com/Forums/en-US/crmdeployment/thread/b6ddd9eb-6609-4297-8c35-1537068972e6?prof=required

MS Dynamic CRM: Reports Fix

1. Enable the SQL Server from Deployment Manager
2. Re-Publish the reports

Thigs to be considered before big import.

** Do Import process off times.
• Pass the values directly from source . Don't create any GUID or any column value in the import process.
• Increase the size of the CRM database to big enough to avoid the size increments
• Stop the backup jobs on the server
• Try to put the Data files, Log files and Backup up files on different drives
• Rebuild the indexes and Pad them up to 50% (Because it's a write operation)
• Disable all the organizations
• Put the batch size of 50000 in the SSIS