Amol Vijay Shirke

  VISUAL CODE remote development. Configuring remote development extension:  Refer:  Remote development over SSH The steps are straight forward but for error like:  "Could not establish connection to "host alias name": The process tried to write to a nonexistent pipe." "Load key "key.pem": Permission denied ubuntu@hostname: Permission denied (publickey)." VSCODE uses CMD for executing SSH commands.  The command it uses are: ssh -T -D 53592 -F "C:\Users\<username>\.ssh\config" "host alias name" bash                                  OR "C:\Program Files\Git\usr\bin\ssh.exe" -T -D 53745 -F "C:\Users\<username>\.ssh\config" "host alias name" bash ( if you set remote.ssh path in extension settings) under the hood it executes:  ssh ubuntu@ec2-host.compute.amazonaws.com -i "path_to_key.pem" Surprisingly the SSH connection will work via git-bash and putty.  Here th...

Mysql exception:dbname.ISNULL function does not exist. This error actually srewed me a lot. I did lot of google but the search result were not help full. I manage to solve this error. Below is my findings that may helpfull. I have store procedure where I used ISNULL very often and even other procedures. But only one procedure was showing this Error. For this first check in procedure if there is "Enter" immediate after ISNULL then remove it. If function is used in the procedure check the same in function too. This will resolve the issue :)

1)To get server information about original installation Date etc... Type below command in command line for windows systeminfo find /i "install date" looks like below in cmd ----------------------------------------------------------------------------- 2) If you are not able to access other machines in domain, even though they are visible in the net work and trying accessing the same machine from other if you get below message like. %"This server's clock " is not synchronized with the primary domain controller's clock" Do the following log off the machine which is not accessible and login with domain administrator and in command line type NET TIME /DOMAIN:%userdomain% /SET and press enter . Now log off and login with your user name and check. 3) To view or change the network configuration of your local computer or a remote computer. You can manually run Netsh commands or you can create batch files or scripts to automate the process. Not only can you ru...

When getting error like Object reference not set to an instance of object or system null reference as in below image. For this check application web config if any key declaration is remain. Because this is the cause for such error most of the time.