Reference Guide for Sitecore database

Sitecore Database

Sitecore database is one of the least explored area in Sitecore world. Even you will not get enough Sitecore database material on its official website. Knowledge of SQL server and its trick can make Sitecore developers life easy.

I started an articles series that covers all possible database operations that leads and architect have to do.

Here I combined all those tricks and mold into an eBook.

Below are the key topics that this eBook covers

• It’s not all about items, it’s all about data
• Sitecore Databases
• Access items and field values from Database
• Changing data from database
• Sitecore Database Backup Script
• Restore database script
• Creating Sitecore database backup job
• Sitecore SQL Server database Maintenance Plans
• Cleanup Sitecore Database Tables
• SQL server recommended configuration for hosting Sitecore website
• Page for testing Sitecore Databases performance
• Page for getting all Sitecore Databases connections

I tried my best to include all the cases that are associated with Sitecore Databases.

You can read and download this reference guide from here:

Please leave your comments or share this reference guide if it’s useful for you.

Content migration guide for Sitecore

Content migration is itself a project within a project and luckily I was extensively involved on different projects where content migration is one of the most important story of the project.

In one of the Sitecore project, I developed lots of scripts to migrate over 500,000 records from different sources to Sitecore.

During these migration, I come across with different situations and found some most suitable way to deal with.

I tried to cover all such technics in this guide. Below are the key topics that I want to emphasized

• Introduction
• Questions for client
• Data Mapping
• Data Representation and Mapping
• Source of Data
• Data Migration Map
• Why SQL Server
• Guidelines for content migration resources and team
• Images and Media
• SITECORE ITEMS
• Sitecore Fields
• Migration Code
• Log Files
• Code Technique
• Testing

I tried my best to include all the scenarios that are associated with content migration.

You can read and download this white paper from here:

Please leave your comments or share this guide if it’s useful for you.

In just 1 hour - Implement Organization’s Password Policies in Sitecore

Today is very special day for me for three reasons

1.    I am celebrating 70^th Independence Day of India.

2.    This is my 250^th blog post

3.    I got new domain name for my blog as http://www.sitecorelessons.com/

  

On this special occasion, I am going to publish my second eBook which is available FREE to download. 

This eBook is about implementing password policy in Sitecore. 

In almost all the web application developers need to implement password policies. This guide covers all possible policies and their implementation technics with code in Sitecore. This guide covers implementation of below policies

•              Minimum Password Length

•              Consecutive Unsuccessful Login Attempts

•              Password Complexity

•              Forgot Password

•              Password Expiration

•              Change Password

After going through this guide, one should able to implement all these policies in less than 1 hour.
 
I tried my best to include all the scenarios that are associated with password policies management.

You can read and freely download this developer’s guide:

Please leave your comments or share this guide if it’s useful for you.

Whitepaper : All about customizing workflow in Sitecore

In almost all the Sitecore projects, developers have to create, sometimes customize and need to apply workflow to items. This guide covers all the possible scenarios and customization technics with code used for workflow. This whitepaper covers 

1.    What is workflow

2.    Create Editor and Reviewer Roles

3.    Assign permissions on items to roles

4.    Create editor and reviewer users

5.    Map users with roles

6.    Create individual/group reviewer items in content tree

7.    Create Custom comment window

8.    Apply validation rules on comment windows field

9.    Create Custom workflow

10. Apply custom workflow on items

11. Customizing workbox

12. Sorting items in Awaiting Approval section in Workbox

13. Show items associated to particular editor in draft section

14. Complete code for customizing workbox

15. Customizing items comments in Awaiting Approval section

16. Test all the scenarios

I tried my best to include all the scenarios that are associated with Sitecore Workflow.

You can download this guide from here.

You can read this white paper from here:

All About Customizing Workflow in Sitecore by surendra sharma on Scribd

Please leave your comments or share this guide if it’s useful for you.