Know Your Database Statistics?

Its very important to know your database stats while planning for some architectural update or database migration. The beforehand information would always add a plus to mitigate any risk and proactively take actions. Below is SQL Server script that provides information about database stats which include list of all tables, there respective record count, allocated …

Reverse Data Synchronization

Synchronization of data from Production to Development environment is merely a task of taking backup of Production DB, restoring it to Development environment and running to cleanup scripts to hide/overwrite user-specific critical information. This is pretty straight forward and does not even require domain knowledge. However, reverse is tricky, risky & surely need good insight …