The noblest pleasure is the joy of understanding

Server: Linux, version SUSE 12 To run dotnet code on Linux, the first and foremost task is to "Install Mono package on linux". Note: Mono is an open implementation of Microsoft's .Net framework, including compilers. It uses the same development libraries on Linux which are being used on Windows. Therefore, if you code and compiled some mono code on Linux,  it will work for Windows as well.       zypper is a package installation tool which is used in this scenario. If zypper is not available, check which package manager tool is installed on server. Furthermore, to verify if zypper is installed or not, type zypper on command line which will show all options if zypper is available on server else it will show 'command not found'. zypper ar -r http://download.opensuse.org/repositories/Mono/SLE_11_SP2/Mono.repo The above command will download from mentioned URL in a new repository. Here 'ar' stands for 'add repo'. After adding it to repos...

Working on projects, it can happen that 'sa' account gets locked. If it is on local machine OR development boxes, onus would be on you to fix it. If scripts and SQL steps are not working, this might help you fixing the issue. Steps to unlock 'sa' account and resetting the password. 1. Open SQL Server Configuration Manager 2. Select SQL Server Services -> 'SQL Server' service. 3. Right click on 'SQL Server' service and click on "Startup Parameters". For 2008, server "Startup Parameters" are inside Advanced tab.   4. Add '-m' in startup parameters as shown above and click on 'Add'. This will put SQL server into 'Single User Mode' and local admin will have 'Super User' rights. For 2008, server you have to add ':-m' in the last of the existing query. 5. Save the settings and Restart the service. 6. Now open the SQL Server Management Studio and connect to database using 'Windows A...

Apart from creating website & app-pool in IIS, there are several steps which need to be performed when setting a new website on server. Setup Web Server There are few activities which you have to perform on Web Server: 1. Install Web Deploy [ Download ] 2. Install URL Rewrite [ Download ] 3. Make Sure .Net Framework feature is ON in Windows features 4. Create a standard user which could be used to deploy files to web server after successful build 5. Open "services.msc" and check that 'Web Deployment Agent Service' is running with the standard user credentials created in Step 4. 6. Run App pool and website with same standard user which is created in Step 4 7. Reset IIS Server Continuous Integration There are several tools which are being used for continuous integration but they perform same functions when we discuss about build and deployment. In this example, we are referring Jenkins [ Download ]. If msdeploy or any relevant command is be...

Working on different templates and Sitecore items, its very common requirement to know how many items are created with a specific template how many template are inheriting a base template or another template Sitecore provide this feature out of box however you need to write query to fetch the required items. Open Sitecore IDE (http://localhost/sitecore/shell/default.aspx?xmlcontrol=IDE) Goto Tools -> XPath Builder Write XPath Expression: /sitecore/templates//*[contains(@__Base template,'{1FE1328B-375B-4548-A53E-344FA61ACC90}')] In result section, it should show all templates which are inheriting base template with ID {1FE1328B-375B-4548-A53E-344FA61ACC90}. Similarly, query  /sitecore/content//*[@@templatename='Promotional Page'] should show all pages (under content) created with 'Promotional Page' template. On top of results, it shows the count of items and time taken to fetch the items. We can use fast query as well inste...

In most of the cases, generally you create items in master database and publish to web/production data. However, sometimes few items are in web database and not in master. Reason can be anything, like you might have deleted it in master but did not publish the parent item or due to some other reason. If you are thinking, you will create package from web and deploy it in master, that will not work. :-) When you create package from master, it installs the items in master only and same is the case with web. Right and easy way to do is Transfer the item. Yes, you read it right. There is a provision in Sitecore to transfer the items from one database to another. Select the item which you want to transfer from one database to another. Right click on it and then select Copying. Click on Transfer. see screenshot Once you click on Transfer, it opens up a popup box. Click 'Next'. see screenshot After clicking on next, you have to choose the database where you wou...

Deleting duplicate records is very common requirement therefore multiple options are available to delete duplicate records. However this article provides the solution to delete the duplicate records using single statement. Delete from <TABLE_NAME> where <ID> not in ( select max(<ID>) from TABLE_NAME> group by <DUPLICATE_COLUMN>) For example: Employee table EmpId EmpFullName EmpSalary EmpTitle 1 Sumit Bajaj 5000 Dev 2 Amit 10000 SDev 3 Sumit Bajaj 5000 Dev 4 Priyanka 50000 Mgr 5 Umesh 10000 SDev 6 Umesh 10000 SDev 7 Amit 10000 SDev 8 Geetika 5000 Dev where few records are duplicate and need to be removed. For this table, delete query would be  Delete from Employee where EmpId not in (select max(EmpId) from Employee group...

After spending enough time on installing Oracle SQL Developer and respective issues, I thought of writing few easy steps to install it. Hope it would help and save your time. Steps to install Oracle SQL Developer(for windows): Download SQL Developer from Oracle site. Download Download JDK if it is not installed on your machine. Download Install JDK and then unzip SQL Developer Click on sqldeveloper.exe, it will ask for java.exe path Open the path where JDK is installed. It would be something like "C:\Program Files\Java\jdk1.7.0_40\jre\bin" depeneding upon which version you install. If it is giving any exception, remove the entry [SetJavaHome] from sqldeveolper.conf file from "..\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf" and give the correct path of java.exe file. Please provide your feedback if you like the post.