Fazlul's Information and Communication Technology Blog

In general, relational algebra expressions and query trees could be equivalent; that is, they may correspond to the same query. But, the performance or cost of query may vary depending on the query technique that we apply. An optimization technique helps reduce the query execution time as well as the cost by re-formatting the query. We applied heuristic optimization in our queries and could reduce the execution time to a greater extent and thus reduced the cost quite a bit. Figure 1: Initial Query If we write this query in SQL we get: Select Name from E, J, P where E.EID=J.EID and PCode=Code and P.Name='GreenLife' and E.BDate>'31-12-1967' Which is basically the cross product of E, J and P Outline of a Heuristic Algebraic Optimization Algorithm: Break up any select operations with conjunctive conditions into a cascade of select operations. Move each select operation as far down the query tree as is permitted by the attributes involved in the select condition. Rearrang...

Hi Selcuk: Yes, I have successfully implement this tool in our Enterprize and could transform 30GB VSS Document Store to SharePoint list by keeping all the previous VSS versions. This application runs on SharePoint API rather that SharePoint Web Services. So, you may have to have the following environment to run this tool. 1. Windows Server 2003 or Recent 2. WSS 3.0 or MOSS 2007 3. Visual Source Safe 2005 4. .NET Framework 2.0 Thanks. Fazlul From: Selcuk OZDOGAN <selcuk.ozdogan@gmail.com> Sent: September 30, 2009 6:59 AM To: Fazlul.Chowdhury@gmail.com Subject: About VSSImporter Hello Md. Fazlul Alam Chowdhury, I was looking for any helpful tool that imports vss documents to sharepoint, then i came across with your project. I immediately, download and gave a try. But unfortunately, i could not execute the tool succesfully. Firstly i want to ask you, if you have ever tried your tool on windows server 2003 operating system? My main problem is that, if i run the program on my local p...

I have created a nice little tool to export OutLook Public folder contacts to CSV file. It basically exports the Master/Detail contact list from OutLook to CSV File Format. Then, we may import the list to SharePoint or Other Third Party Applications. In Outlook, the Details Tab Information [Key Contacts] are basically stored as individual user defined fields for each contact. So, to get the value of User Defined fields we may have to use the following syntax: ctc.UserProperties["MyCompanyAlbertaRelationshipHolder"] instead of: ctc.FullName.ToString(); The following Public Folder Path I used in this example: \\Public Folders\All Public Folders\MyCompany\MyCompanyAB\Customer Information Folders\All Public Folders\MyCompany\MyCompanyAB\Customer Information and List Name is: Customer Information. So, to get the items of Customer Information we may have to create the instance of the MAPI Folders using following methods: Microsoft.Office.Interop.Outlook._Application olApp = new Mic...

DocMaster is a handy tool to sync SharePoint Document Libraries Between Sites/Servers. I have used SharePoint Copy Web Service to perform this task. So, it will work on any PC with .NET Framework 2.0 installed. But, you may have to configure the config file according to your SharePoint resources.   Config File Settings:   <? xml version = " 1.0 " encoding = " utf-8 " ?> < configuration > < configSections > < sectionGroup name = " applicationSettings " type = " System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 " > < section name = " DocMaster.Properties.Settings " type = " System.Configuration.ClientSettingsSection, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 " requirePermission = " false " /> </ sectionGroup > </ configSections > < appSettin...

CruiseCradle is a great handy tool to automatically download SharePoint Documents into your USB Stick. You insert your USB Stick into your PC and Done!!!! It is a handy tool to download the SharePoint Files into your USB Key. Just copy autorun.ico, Autorun.inf, CruiseCradle.exe.config, CruiseCardleConfig.csv files into USB Stick. Then Configure CruiseCradle.exe.config, CruiseCardleConfig.csv files according to your own settings: 1. CruiseCardleConfig.csv => Add your Document Libraries in each Row 2. CruiseCradle.exe.config => Specify your SharePoint Web Services Location in the config file Shown Below <?xml version="1.0" encoding="utf-8" ?> <configuration> <configSections> <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" > <section name="CruiseCradle.Properties.Settings" type="Syst...

After you configure the external FBA site [ http://fbasp.codeplex.com/ or http://fazlulchowdhury.blogspot.com/2009/03/configuring-mixed-authentication-in.html ]. You will need to manage the users for the external site. You may need following pages to make it complete. 1. Customized Login Page with Links to Register New User and Forgot Password 2. New User Registration Page 3. Forgot Password Page 4. Change Password Page You may want to download the Community Kit for SharePoint [http://cks.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=5134] and install [Deploy.cmd http://dcftsd1:1111] in to SharePoint Site before configuring FBA User Management. Then do the following stuff one by one: 1. Add requiresQuestionAndAnswer="false" in the web.config of the SharePoint site <add connectionStringName="SqlProviderConnection" name="AspNetSqlMembershipProvider" applicationName="/" type="System.Web.Security.SqlMembershipProvider, System.Web, Vers...