Tech Tips and Tricks
As there is no split function in excel, you can create a UDF to gain the same functionality as available in languages such as Java, PHP, etc Create a module and add a function as below: Function STR_SPLIT(str, sep, n) Continue reading String split in excel
In case you need to download a file from URL, something similar to wget, you can use Powershell in Windows: Invoke-WebRequest -OutFile sample.pdf http://mywebsite.com/sample.pdf
In case you are using Windows 8.1 and are not able to open PC Settings, try to do the following: Launch command prompt window and enter the following command powershell -ExecutionPolicy Unrestricted Add-AppxPackage -DisableDevelopmentMode -Register $Env:SystemRoot\ImmersiveControlPanel\AppxManifest.xml
If you are using a 64-bit OS, please follow the steps below: Install Microsoft Access Database Engine 2010 Redistributable from here. Restart (just in case) your machine and see if that works for you. If not, you also need to install 2007 Continue reading ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine error
For shutting down… C:\Windows\System32\shutdown.exe -s -t 20 -c “Bye” -f -d p:0:0 For rebooting… C:\Windows\System32\shutdown.exe -r -t 20 -c “Restarting” -f -d p:0:0
I had Windows 8 and wanted to try Ubuntu Linux. I installed Ubuntu and enabled it through dual boot. For some reason after couple of days I decided to remove Ubuntu Linux. To retrieve the space back, I booted to Continue reading Boot back to Windows from grub-rescue prompt
Use regedit to edit the following registry key: HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Explorer\User Shell Folders Find the value name called “Desktop” and set its data to the desired location for your desktop.
Once transaction log is full, I was unable to shrink it. All searches in Google did not help. Finally I found a script which clears the transaction log if and only if the transaction log is not full yet. I Continue reading Shrink transaction log SQL 2008 r2
Run the following SQL statements to fix the issue: EXEC sp_resetstatus ‘yourDBname’; ALTER DATABASE yourDBname SET EMERGENCY DBCC checkdb(’yourDBname’) ALTER DATABASE yourDBname SET SINGLE_USER WITH ROLLBACK IMMEDIATE DBCC CheckDB (’yourDBname’, REPAIR_ALLOW_DATA_LOSS) ALTER DATABASE yourDBname SET MULTI_USER Please see here Continue reading SQL Server 2008 R2 (Suspect) mode – how to repair?
Follow these steps a) Right click on local code repo b) Go to TortoiseSVN > Settings c) Go to “Network” d) Browse for SSH Client and use following “C:\Program Files\TortoiseSVN\bin\TortoisePlink.exe” – Can be found in TortoiseSVN installation folder d) Append Continue reading How to save password in TortoiseSVN