-
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…
-
Assign SELECT results into variables
I mentioned here that SELECT INTO in Sql Server is functionally similar to CREATE TABLE AS in Oracle. Oracle also has SELECT INTO, but it is used for assigning query results to a variable. Here is a PL/SQL code snippet: declare MyVariable varchar2(20); Begin select ColumnName into MyVariable from MyTable where MyID = SomeInteger; dbms_output.put_line(‘Hello…