-
Seeking mobile communication advice
I am going through some changes, dear reader: I have decided to quit my corporate day job and start my own consulting/training business, starting on April 9th, 2007. I could use your help here: I’d appreciate it greatly if you could offer me leads on Sql Server, Oracle, and MySQL consulting and training gigs. I…
-
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…
-
美国太子党
Todd Stroger, son of former Cook County Board President John Stroger, was elected to his father’s position recently. John had to resign due to a stroke last year, after serving tirelessly and heroically for 12 years, on behalf of good ‘ol tax-paying residents of Cook County, yours truly included. He left with 500 million dollars…
-
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…