Category Archives: ms sql

SQL Server 2016 : A New Beginning

A look into the all new version of a database management solution from Microsoft Continue reading

Posted in ms sql, Uncategorized | Tagged , , , , | Leave a comment

Wait Statistics……What to worry for?

Answering the message “Hi, yeah, the server is slow. Thanks. Bye.” Continue reading

Posted in ms sql, Performance Tuning, Troubleshooting, Uncategorized | Tagged , , , , , , , , | 1 Comment

Q&A Backup_001

Common questions regarding SQL Server backups Continue reading

Posted in backup, ms sql, Performance Tuning, Uncategorized | Tagged , , , , , , | Leave a comment

A Guide To SQL Server Maintenance Plans

General guidelines towards the best approach in creating a maintenance plan for your SQL Server Continue reading

Posted in backup, Best Practices, configuration, ms sql, Performance Tuning, Troubleshooting | Tagged , , , , , , , , , | Leave a comment

Transaction Tracking Continued

Second part in two part series blog regarding transaction tracking through logs and point in time restore Continue reading

Posted in Best Practices, ms sql, Troubleshooting, Uncategorized | Tagged , , , , , , , | Leave a comment

Finding a Transaction in the log for a particular user

As a DBA, this is a frequently asked question from the developers “When was a certain insert/update/delete performed on a specific table?” Or, It is simply required to know the time of the particular transaction so that it can be … Continue reading

Posted in ms sql, Troubleshooting, Uncategorized | Tagged , , , , , , , | Leave a comment

SHRINK – The Evil Doctor

Every DBA faces the day to day challenge of making best use of the available resources. And on this note, it’s very obvious that storage is the one aspect that is quite tough to handle at times. Now there are … Continue reading

Posted in Best Practices, configuration, ms sql | Tagged , , , , , , , , | Leave a comment