Monthly Archives: August 2014

3 Ways to Log In Through Sqlplus as ‘sysdba’

1.If you are a member of DBA group on the Linux/Unix OS level: sqlplus ‘/ as sysdba’ 2.Or you can first log on as ‘nolog’ sqlplus /nolog And then SQL>connect / as sysdba 3. Directly connect to Oracle instance as sysdba sqlplus ‘sys as … Continue reading

Posted in Oracle | Leave a comment

How to Type Escape Key while Using Bluetooth Keyboard Connected with Android System

Well, every user’s situation is unique, so I’ll just present mine here for starter: Phone: Galaxy S2 Andorid Version:4.0.3 Keyboard: B.O.W hb086 (it is a cheap Chinese knockoff, but probably your own high-end couterpart is using the same set of … Continue reading

Posted in Linux | Tagged , , , | Leave a comment

Best Way to Set up a Server Side Trace

Accidentally bumped into this tutorial about setting up server side trace. By using SQL profile and scripting our the trace definition, you’d save a lot of work by defining various events that you’d like to trace. I am taking a … Continue reading

Posted in SQL Server, T-SQL Script | Tagged | Leave a comment

T-SQL Function to Get the Default Backup Folder

Again, DBA’s are often faced with adhoc backup tasks that shall dump relevant data or log to the existing backup location for all other data/log dumps. Quick way to do so will invovling concatenating dynamic sql commands with the default … Continue reading

Posted in SQL Server, T-SQL Script, User Defined Function | Tagged , | Leave a comment

T-SQL Function to Return Current Timestamp as String

Sometimes, a DBA will have to make adhoc backups and it is ideal that these backup files are named with proper timestamp info. The below function returns current date and time as a string fomartted in ‘yyymmdd_hhmmss’ style:

Posted in SQL Server | Tagged , | Leave a comment