Background

Very recent in one of our project we came to a need to manage custom stored procedures in entity framework in a convenient way so that we do not manage them manually for any modification. Moreover, we wanted to reduce the deployment hassle. We were using the code first approach and our intention was to deploy them automatically using the entity framework Migration. Here are my findings after google search and study.

CiviCRM default installation comes with a Standard CKEditor toolbar. It does not have the advanced formatting plugins. Even there is no UI in CiviCRM to enable the advanced formatting toolbar. If we need the advanced formatting toolbar then we will have to do the followings:

CKEditor Source Formatting:

In many of our Drupal 7 projects, we use CKEditor as default text-editor for textarea field. CKeditor has many useful features. But one feature many of us do not know is that it has a built-in source formatting option. By default in most of our projects it is turned off. If turned of source view of CKEditor will look like this:

Sometimes we need to know the table structure information of a database. We need to know the information like columns name, data type, length etc. There are multiple options to find the information. Some of them are

sp_columns: You can execute sp_columns and get the columns information of the table.
Example: exec sp_columns ‘Table Name’

sp_help: You can execute sp_help and get the all the necessary information of the table.
Example: exec sp_help ‘Table Name’