SQL Server: A More Flexible xp_ReadErrorLog That Reads All Error Logs Including Archives

I am sure that all of you are already familiar with the extended stored procedure xp_ReadErrorLog and its less flexible and published equivalent sp_ReadErrorLog (which takes less parameters) for reading the SQL Server Error Log. xp_ReadErrorLog - To read current error log: The extended stored procedure xp_ReadErrorLog is very useful. It helps with reading the …

Advertisement

Oracle – Easy Date Strings (and NOT)

Whenever I type in a date strings in Oracle, I convert the strings to Date data type in my code as well as my queries without relying on the session setting for date format. I will explain why. Session date format setting: Session date format settings govern how date strings should be converted into dates (the …

Oracle – Data Visualization Of DateTime Stamps – The Big Picture 24-hour View By Date Using PIVOT

One of the interesting aspects of working with data is how every person can look at the same thing and come to different conclusions. No one is right or wrong but a good visualization will lead to good decision-making. One of the leading data visualization patterns is pivoting and pivoting is everyone’s first choice when …

Oracle nasty dates finder for the .Net folks – Fix “Year, Month, and Day parameters describe an un-representable DateTime.”

If you are querying Oracle from .Net and you get this error: Exception calling "Fill" with "1" argument(s): "Year, Month, and Day parameters describe an un-representable DateTime." ---> System.ArgumentOutOfRangeException: Year, Month, and Day parameters describe an un-representable DateTime. It is most likely because of DateTime column(s) having a value of 00000000 00:00:00 or because the …