The Ji Village News

Category: Technology

  • A few handy Sql Server tips

    Here are a few handy tips I learned lately: 1. When using sp_configure, you don’t need to type the whole parameter string. You just need to type enough of it for Sql Server to be uniquely identify it. For example, sp_configure ‘show ad’ will resolve to sp_configure ‘show advanced’ 2. In Query Analyzer or Management…

  • Monitoring error logs in Oracle and Sql Server

    In Oracle, there are 3 places that I know of that are important for monitoring: the bdump, where background process error is stored; udump, where user trace error is dumped; and cdump, the core dump, where Oracle internal error is dumped. cdump is in the binary format, you can use “strings -a” to look at…

  • MySQL and Daylight Savings Time change

    In a previous post I mentioned about patches needed to accomadate the new DST changes for Sql Server. (I know, this is one of Dannyman’s favorite subjects ;)) For MySQL, obviously you need to patch the host server first. Then you need to find out if MySQL needs separate work. Here is a note I…

  • The Times They Are a-Changin’

    Below is a piece I wrote for last week’s Sql Server PASS newsletter. The editor adjusted the title to The Times, They Are Changin’. I thought that change lost the humor I try to convey 🙂 Also, it is amazing how close Brian and I think on this one. We didn’t talk to each other,…

  • Enable File and Printer Sharing for Microsoft Networks for cluster install

    I talked about one issue when setting up Sql cluster here. Recently I came across another problem while setting up a Sql Server 2000 cluster on a 2-node Windows 2003 cluster. The error occurred at the step where you were asked to provide a login that can get into the remote node(s), server(s) where install…