Monthly Archives: May 2008

Oracle Sysdate formatting

Posted on 23. May 2008 by Bennett

You can use the PL-SQL to_char function to format the output of SYSDATE like this: select to_char(sysdate,’DD/MM/YYYY HH24:MI:SS’) from dual;

Posted in SQL | Comments Off on Oracle Sysdate formatting

The Good Books

Posted on 7. May 2008 by Bennett

I used several books to study for the ICCP DBA exam including: Modern Database Management, 8th Edition by Hoffer, Prescott and McFadden Database Systems: Design, Implementation & Management 6th Edition by Rob and Coronel Database Administration: The complete Guide to … Continue reading →

Posted in T-SQL | Comments Off on The Good Books

Remote Reboot

Posted on 4. May 2008 by Bennett

Today while applying patches to a couple of mission-critical servers, I was reminded of something:  reboots issued through the terminal services client are not always successful.  The server can get stuck in an odd state where it is running but … Continue reading →

Posted in Windows OS | Comments Off on Remote Reboot