The Ji Village News

Category: Technology

  • Set sqlcmd initialization file

    By now you probably can tell that I am a big fan of sqlcmd;) Here is one more nugget on sqlcmd that I can throw at you: You can set a variable so that sqlcmd would run a query whenever you launch it from the command line interactively. For example, you can let it run…

  • Customize Oracle sqlplus editor

    In Oracle sqlplus, if you type ed or edit at the command prompt, sqlplus will put the last command into an editor buffer for easy editing. In Windows, the default editor is Notepad. In Unix / Linux, the default editor is usually vi. I have changed the default sqlplus editor on my Windows machine to…

  • sqlcmd presentation at next Chicago Sql Server User Group meeting

    I will do a talk on sqlcmd basics in the next Chicago Sql Server User group meeting. The meeting will be held at Microsoft’s downtown Chicago office on 12/06/2005 from 5:30pm to 8:00pm. More details at here. I will post scripts and slides here when I am done editing. Hope to see you there.

  • Sql Server 2005 Named Instance Stops Default Sql Server 2000 Default Instance

    Last night I did some testing and installation of Sql Server 2005 and Sql Server 2000. I installed the RTM version of Sql Server 2000 as the default instance first. I then installed RTM version of Sql Server 2005. Afterwards, I noticed that I couldn’t connect to my Sql Server 2000 instance any more. I…

  • Find out uptime of server and MySql database

    This site had been unstable for the last couple of weeks, due to my hosting company’s issues with servers. My Apache and MySql database have both been moved to a different server. Hopefully things will be stable from now on. During the troubleshooting time, I used a few commands to find out the uptime of…