It has been a while we have seen a puzzle on this blog and I keep on receiving emails and comments that you all would love to see one more puzzle. Let us see a new puzzle “Incorrect Results with Decimal”.
Just the other day I received an email from a MySQL user who has been struggling to set up his password due to the current policy requirements in MySQL. Let us see how we can identify what is his root cause and how to fix the issue with password security.
Question: What is Copy Only Backup in SQL Server?
Answer: This is another interesting question I received the other day. The question was in the image form and I am re-producing the image again here.
I recently stumbled upon an interesting tool – Dataedo, quite powerful database documentation tool. It enables describing each table and column (data dictionary), procedure and function, create ER diagrams from existing schema and generate a pretty HTML, PDF or Excel documents.