SQL Server Shrink Log File

SELECT name,recovery_model_desc FROM sys.databases
GO 

 Step 1
ALTER DATABASE <Your Database Name> SET RECOVERY SIMPLE; 
ALTER DATABASE WSS_Proposal_Content SET RECOVERY SIMPLE;

Step 2
DBCC SHRINKFILE (<Your Database Name>_log, 5); 
DBCC SHRINKFILE (WSS_Proposal_Content_log, 5);

Step3
ALTER DATABASE <Your Database Name> SET RECOVERY FULL; 
ALTER DATABASE WSS_Proposal_Content SET RECOVERY FULL;


Database 1
Alter database SharePoint_Config set Recovery simple
GO

USE [SharePoint_Config]
GO

DBCC SHRINKFILE (N'SharePoint_Config_log' , 50)
go

Alter database SharePoint_Config set Recovery full
GO


Database 2
Alter database WSS_SESProposal_Content set Recovery simple
GO

USE [WSS_SESProposal_Content]
GO
DBCC SHRINKFILE (N'WSS_SESProposal_Content_log',50)
go

Alter database WSS_SESProposal_Content set Recovery full
GO


Database 3
Alter database WSS_Search_Content set Recovery simple
GO

USE [WSS_Search_Content]
GO
DBCC SHRINKFILE (N'WSS_Search_Content_log',50)
go

Alter database WSS_Search_Content set Recovery full
GO

Find Logical File Name
Declare @LogFileLogicalName sysname
select @LogFileLogicalName=Name from sys.database_files where Type=1
print @LogFileLogicalName

MS Dynamics CRM Solutions

CRM Customizations - Customize through a web-based interface without any programming expertise or use the MS Dynamics CRM software development kit (SDK) to programmatically alter the metadata. Two default security roles associated with system customization privileges: System Administrator and System Customizer

Solutions are packages of customizations and metadata that allow system administrators and software developers to create, transport, and maintain business applications or functionality that run on the Microsoft Dynamics CRM framework.

Settings area -> Click Customizations ->  Click Customize the System to open the solution.

CRM Form

Dynamics CRM Form  - 2 types  -> Main Form  & Mobile Form

Main Form
CRM will allow to create multiple form for same entity. Each form  - body, header, footer, and navigation pane.

CRM Metadata

Metadata is defined as data about data. MS Dynamics CRM uses a metadata driven architecture to provide the flexibility to create custom entities and additional system entity attributes.
MS Dynamics CRM retrieves the record data from the metadata (entities, attributes, relationships, and option sets.), which in turn retrieves information from the underlying system data. MS Dynamics CRM stores its underlying system data in a relational database using Microsoft SQL Server.

MS Dynamics User Interface  ->  Metadata ->  Underlying System Data (SQL Server)

The entity metadata controls the grid and form layout, and how navigation options are presented. The metadata makes heavy use of MS Dynamics CRM Web services and XML data formats.

Make changes directly to CRM database in Microsoft SQL Server, risk of damaging the metadata and creating errors in your system.

Deploying SSIS Packages in SQL Server 2008/2012

1) Create the SSIS Package and Execute it.

2) After executing the solution, the deployment utility is created in the default location if the build is completed successfully. Navigate to the (default location) deployment folder, C:\SSIS\Packages\Import\ExcelFile\bin\Deployment in our case and we will find the deployment files i.e. the integration services project deployment file (ExcelFile.ispac).

3) Copy the Deployment file(local machine)  to the SQL Server Server (Target Server).

Get CRM PickList & Global OptionSet using c#

using System.ServiceModel.Description;
using Microsoft.Xrm.Sdk;
using Microsoft.Xrm.Sdk.Client;
using Microsoft.Xrm.Sdk.Query;
using Microsoft.Xrm.Sdk.Messages;
using Microsoft.Xrm.Sdk.Metadata;

Uri OrganizationUri = new Uri(System.Configuration.ConfigurationManager.AppSettings["CRM_Organization_URI"].ToString());
Uri HomeRealmUri = null;
Dictionary<String, String> dicState = new Dictionary<String, String>();
Dictionary<String, String> dicSuffix = new Dictionary<String, String>();

MS Dynamics Entity Relationship

An entity relationship in Microsoft Dynamics CRM defines how two entities interact with each other.
Microsoft Dynamics CRM uses three types of data relationships, which we review in more detail in the following sections:
Hierarchical Relationships - 1:N and N:1

One-to-many (1:N) - relationship between two entities in which a single entity can possess multiple (many) related entities. For Example, Each Account can have many Contacts, but you can assign only one Account to each Contact.

Many-to-one (N:1)

MS Dynamics CRM Web Resources

Web resources are virtual files that are stored in the CRM database and that you can retrieve by using a unique URL address. Solution -> Entities -> Web Resource

Limitations of Web Resources
Web resource does not supports ASP.NET(.aspx or asmx) page to execute code on the server. Web resources are either static files or files with code that is processed client-side by the browser.

Web resources are only available by using the CRM web application security context. Only licensed CRM users who have the necessary privileges can access them.

Size Limitations - The maximum size of files that can be uploaded is determined by the Organization.MaxUploadFileSize property.
Settings -> System -> Administration -> System Settings -> E-mail tab -> Maximum file size (default 5 mb). This setting limits the size of files that can be attached to email messages, notes, and web resources.
Web Resource Properties - Name, Display Name, Description, Type, Language

Microsoft Dynamics CRM 2011 Security Model

Microsoft Dynamics CRM 4.0 Security Model

• Supports a licensing model for users.
• Provides users with access only to the information that they require to do their jobs
• Categorizes types of users by role and restrict access based on those roles.
• Prevents users from accessing objects that they do not own or share.
• Supports data sharing by providing the ability to grant users with access to objects that they do not own to participate in a specified collaborative effort.

Download Security Model

Create a rough model of your company’s current operational structure. For each section of your organizational layout, you should identify the approximate number of users and the types of business functions those users perform. This rough organizational map to start planning how you want to set up and configure security in your Dynamics CRM deployment.

E-Mail Templates in Microsoft Dynamcis CRM 2011

E-Mail Templates are per-formatted email messages, can use in the different ways:

• Insert Single or multiple templates into the email body of the messages
• Send direct email feature by using E-mail templates to send the same message to multiple records (like 1000 contacts).
• Reference E-mail templates in workflow processes
• Use E-mail templates in quick campaigns and campaign activities

Dynamics CRM contains more than 20 E-mail templates, like  order, thank you letter, etc.

Organization E-Mail Templates, Click 'Settings' -> Under Business, click 'Templates' -> Click 'E-mail Templates' -> a grid will display all of the E-mail templates ans their types -> Select to view/modify a E-mail template or Create new one.