DB Geek Girl

Storing time in databases seems like a daunting task to many. The general principle with storing time in databases is - ALWAYS STORE TIME ...

I ran into this error recently, and wanted to share a quick fix. This is what the problem looks like - mysql> show slave status \G ...

Why LDAP? LDAP stands for Lightweight Directory Access Protocol. It is based on a client server model. A client queries LDAP server, whi...

In the DBA operations world there are always challenges with passwords. How do you use the password for login, automation and operation scr...

 As applications mature, tables tend to grow infinitely, specially the time series ones. They have tens of millions of rows and run up t...

In the last post we saw how the log is written during the operation of a database system. In this post we will go over the actual recovery...