Tuesday, April 23, 2013

SQL Server Backup and Recovery Mode Information

The bellow queries help you to get information about backup and recovery mode in your server.
--When the last time  my databases are backed up

Monday, April 22, 2013

Naming Convention Saves your Time

Naming Convention:
As a database administrator, database developer and software developer or any technical person you always works in project that may consist of many participants and even if

Thursday, March 28, 2013

SQL Server Backup and Restore

SQL Server Backup and Restore
Backup is the most important process to protect your database from unintentional/intentional users behavior – user may delete all data from a table accidentally or update it – if one of your

Sunday, February 17, 2013

SQL Server Batch Update

Always we should take care of database server performance but sometimes you need to perform a huge update on your table/tables this will affect performance for concurrent users and they will complain about it.