If you don’t want to install and configure your test server and would like to take a snapshot of existing server to create a snapshot of your server for creating a test / staging server; please follow these steps. 1.
How to replace part of String (SQL Server)
You can simply use Replace in order to replace partial text in SQL Server data table. SELECT REPLACE(YOUR_COLUMN, ‘string_to_replace’, ‘new_string’ * FROM YOUR_Table in order to update the database table. UPDATEYOUR_TABLE SET YOUR_COLUMN = REPLACE(YOUR_COLUMN, ‘string_to_replace’, ‘new_string’) WHERE YOUR_CONDITION Keep smiling and
How to fix “windows could not start the apache tomcat 8.0 on local computer”
Open Run and Navigate to your Tomcat Folder 1. YOUR_TOMCAT_FOLDER\Tomcat\bin\tomcat7w.exe 2. Make sure JVM is selected in your startup tab by following this step. “Startup” tab -> “Mode” choose “jvm” 3. Navigate to Java Tab and update your Java Virtual
How to reset / restart IIS using a batch file
In order to reset IIS using batch file, please follow the below steps. 1. Create a text file, RestartIIS.bat 2. modify the text file and add this script to it. @echo on c:\windows\System32\iisreset.exe pause 3. save the batch file, and
How to Limit Transaction Log file in SQL Server
There are two ways you can limit the size of your transaction log files. 1. Using SSMS (SQL Server Management Studio) 2. By writing a manual script. Below are the steps to limit transaction log files. Open your Microsoft SQL
How to modify field size for an attribute in SDE db using ArcCatalog
In order to modify a field size for a geo spatial attribute field. Please follow the below instructions. Open ArcCatalog, expand your file geo database and find the feature class you want to edit the field. Right click on the
How to delete a database with In Recovery mode (SQL Server)
There are situations where sometimes a database is stuck in recovery mode. 1. During the Restore process without running this command – RESTORE DATABASE mydatabase WITH RECOVERY 2. when the drive space is not sufficient and the transaction log size
Configure, Commit and Push code with AWS Code Commit, Source Tree – Part II
In my previous post, I have provided a detailed instructions of how to create IAM users and generate passwords. In this post, we can follow the below steps to setup the AWS local repository on a developer machine. There are
Configure, Commit and Push code with AWS Code Commit, Source Tree (Administrators Only) – Part I
Please follow the below steps to configure, commit and push your code to AWS Codecommit repository. This article is written both for AWS administrators and developers. For AWS Codecommit – simple steps to create IAM users, repositories and provide the
How to remove GeoProcessing History (ArcToolBox History)
Recently, I have discovered that one of the shared machine that we use for GeoProcessing was running out of space very fast. So, I tried to resolve the issue by looking at each folder and see where is the space