What can I say, excellent hint from SQL Server Goddess aka 'Kalen Delaney' to achieve an execution of a batch multiple times with a simple 1 word statement. I feel I was late to share this tip within my community, so here it is RunABatchMultipleTimes...(read more)

This sounds like a joke that ''How many DBAs you need to change a light bulb?''. I have come across this less technical question from SSP forum asking for recommended practices. They wanted to have information that How many servers should be managed by a DBA or how many DBAs you need to manage a 400+ SQL Servers within their environment. I believe ...

Say which is better, having multiple transaction log backups files or single transaction log backup file during a recovery point of time. In my experience both of them doesn't make any difference and if you are performing further backup to tape then ensure to test them by restoring on to the standby server. This is a best practices than assuming ...