Skip to main content

Posts

How to Configure the Master Data Service in SQL Server 2008 R2

Introduction Master Data Services (MDS) is a new SQL 2008 R2 component that will help your organization effectively manage master data in a centralized location. Master Data Services uses business rules to create basic workflow solutions. You can automatically update and validate data and have e-mail notifications sent based on conditions you specify. Business rules in Master Data Services are intended to manage the most common workflow scenarios. If your workflow needs require more complex event processing, such as multi-tiered approvals or complex decision trees, you can configure Master Data Services(MDS) to send data to a custom assembly that you create, or to SharePoint to start a SharePoint workflow.  Each time you apply the start Workflow business rule to your entity, records that meet the business rule conditions are passed to the Service Broker queue of the Master Data Services database(MDS). At regular intervals, the SQL Server MDS Workflow Integrati...

How to configure the Remote BLOB Storage(RBS) on Sharepoint Web application

Remote BLOB Storage (RBS) is an add-on feature pack for Microsoft SQL Server 2008. RBS is designed to move the storage of binary large objects (BLOBs) from database servers to commodity storage solutions. If the content databases in Microsoft SharePoint Server 2010 are 4 gigabytes (GB) or larger, consider using RBS as part of your data storage solution. We are able to enable the RBS ( Remote blob storage) for the SharePoint. How to enable RBS on SharePoint web application. Server Instance level settings. 1.       Open SQL configuration tool-> Start-> All Programs-> Microsoft SQL Server 2008 R2-> Configuration Too-> SQL Server Configuration Manager In the SQL Server Configuration Manager snap right click on the SQL instance where you want to enable FILE STREAM. 1.        Click on Properties and select FILE STREAM tab Select all check boxes and press ok. Da...

Why Sharepoint is better than Interwoven, DNN, Alfresco and Drupal?

SrNo.   Features Interwoven SharePoint DNN Alfresco Drupal 1      Adoption user adoption  is miserable can be easily adopted easily adopted better than interwoven easily adopted 2     Shell Access Yes Yes Yes No No 3  Setup and Deployment Very difficult  Easy Easy difficult difficult 4  Documentation very poorly documented Good documentation average rated documentation average rated documentation Good documentation 5  Implementation Poor Implementation Good Implementation Good Implementation Good Implementation Good Implementation 6 Product Development Very Slow Rapid Medium Medium Medium 7 Cost Estimation works on per user fees license based server license based server license based server license based server 8 Blog No In-Built Extra Cost(Add-on) In-Built In-Built 9 Chat No Free Add-on No Free Add-on Free Add-on 10 Classifieds No Free Add-on In-Built In-Built Free Add-on 11 Contact Management No In-Built In-Buil...

How to Compare The Two data table Columns in C sharp

Q)I have one issue , my issue is 1)i want to compare the two data table columns in C sharp 2) if columns in first datatable matches with columns in second datatable 3) i want to copy those matched column data to another datatable please help me how to do it. By using  your code we can compare but  if the column matches with other i want to copy entire column data to another datatable . eg; datatable 1                                                  datatable 2 col1   col2   col3                                       ...

Default Databases Created in SQL Server After Sharepoint 2010 Installation

These are the databases that are created after sharepoint 2010 installation.

Content Query WebPart (CQWP) in SharePoint 2010

The Content Query Web Part is a tool that site designers can use to aggregate interesting and relevant slices of information on web page by letting you build queries through an easy to use UI and then display that content in unique, configurable ways. The CQWP is designed to return roll-up content over several different scopes, anywhere from a single a list or library, to all lists or libraries across an entire Site Collection.  In SharePoint 2010, the CQWP single list query is also optimized to work over large single libraries, taking advantage of smart indices and other tools designed to improve query performance over large document libraries. Content Query WebPart comes first in MOSS 2007, but in SharePoint 2010 there are some new features introduced.Content Query Web Part (CQWP) is used to show information from sites in the current site collection by querying, filtering, and sorting the content. Also CQWP you can show information from list as well as from publishi...

Passing value from popup window to parent form's TextBox Using JavaScript

Passing values from a popup window back to the parent page is an often asked question. Especially when there is a GridView type control in the popup. In the following example we will be using two forms. The parent form will be parent.aspx and the popup will be popup.aspx. Also note that the parent.aspx form is derived from some MasterPage. Code is provided both in VB.Net and C#.Net. --- .aspx of parent form --- <script type="text/javascript"> function OpenPopup() {     window.open("popup.aspx","List","scrollbars=no,resizable=no,width=400,height=280");     return false; } </script> .       . .       <asp:TextBox ID="txtPopupValue" runat="server" Width="327px"></asp:TextBox> <asp:Button ID="Button1" runat="server" Text="Show List" /> --- .vb of parent.aspx if vb.net is the language --- If Not IsPostBack Then     Me.Butt...

To Prevent Browser BACK button click after SignOut Using JavaScript

There are so many threads open related to this issue. After sign out when the user press BACK button on the browser, it gets him to the members page. Logicaly, it's done on the client side and we cannot do much from the code-behind. So, in order to prevent Browser BACK button click after SignOut, we have to use some javascript. The first and easiest approach to acomplish this is by using the following javascript code: <body onload="javascript:window.history.forward(1);">  This code should be placed on the <body> tag of the Members page where Log out button appears. The problem is that this code will work perfectly on IE (Internet Explorer) but won't work at all for Mozilla Firefox 3.x versions. So, in order to make this work on Mozilla Firefox, I've prepared Javascript function which is: <script type="text/javascript" language="javascript">   function disableBackButton() { window.history.forward() }  d...