Archive for March, 2011
Creating Three-state workflow in SharePoint 2010
The Three-state workflow tracks the 3 states in a list to manage the business processes. Example Three states for Issue List could be Open, Resolved and Closed. Three state workflow supports to track the list item or issue through states.
| The workflow assigns a task to a person and sends an email to that person. When workflow is completed it updates the status of the item or issue. By default Three-state workflow works with the Issue Tracking list template. |
Related Posts:
1 commentBrowsing Flash (.swf) files in SharePoint 2010
| By default SharePoint 2010 does not allow you to browse the Flash (.swf) files. In order to browse the flash files in SharePoint 2010 configure the below steps in SharePoint 2010 Central Admin. |
Note: By Default flash files render in SharePoint 2007 and these steps require in SharePoint2010
1. Go to SharePoint Central Admin then click on Manage web applications link
2. Select the web application where you want to show the flash files
3. Select General Settings on the ribbon and set the Browser File Handling property to Permissive
Related Posts:
2 commentsCreating status indicators in SharePoint 2010
| Status Indicator is a report type, where it shows and compares the actual performance of particular measure with goal value. Without doing any calculations, you can know the performance of a measure with good status indicator. You can know whether measure results are on target or off target. This post explains how to create a status indicator in SharePoint 2010. |
Status Indicator shows name, results and icon. It provides a quick information, green icon indicates good performance, Red icons flags the problem areas and yellow icons warn of potential problems. The typical status indicator looks as follows
Related Posts:
2 commentsCreating Maintenance Plans in SQL Server 2008 R2
| One of the repetitive task that DBA need to perform is create maintenance plan for database. Maintenance plans enables you to automate maintenance activities for a database, backups, db integrity checks and index maintenance tasks. We can easily create a maintenance plan using a wizard in sql server 2008 R2. |
You can use the following steps to create a maintenance plan
1. Select the Maintenance Plan Wizard from the context menu as shown below
Related Posts:
No commentsCreating Maintenance Plans in SQL Server 2008 R2
| One of the repetitive task that DBA need to perform is create maintenance plan for database. Maintenance plans enables you to automate maintenance activities for a database, backups, db integrity checks and index maintenance tasks. We can easily create a maintenance plan using a wizard in sql server 2008 R2. |
You can use the following steps to create a maintenance plan
1. Select the Maintenance Plan Wizard from the context menu as shown below
Related Posts:
4 commentsWho are you?
Today I read an interesting article about personality of a man based on his bag. I am an easy rider, who are you? check here
Related Posts:
No commentsMonitoring running processes in SQL Server 2008 R2
|
You can view the current connections and processes that running on a sql server instance in two ways
|
Monitoring Process in Activity Monitor
To open the Activity Monitor in SQL Server Management Studio Right click the server then select the Activity Monitor option as shown below
Related Posts:
No commentsSQL Server Reporting with Analysis Services
| SQL Server Analysis Services is used to present the aggregated data to support analysis, ad-hoc reporting and decision making process. Technically CUBE is used in Analysis Services to build the aggregated data. Once it is build then you can easily navigate and produce reports for business analysis. This post discusses using analysis services in SQL Server Reporting with MDX query builder. |
To download and configure the AW analysis services database read my previous post.
Create a Data Source
1. Create a data source for the AW20082 Analysis Services database in Report Builder 3.0 and select the SQL Server Analysis Services data provider from the drop down list.
Related Posts:
1 comment



