Category Archives: Best Practices

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

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

Recipe for Disaster

Happy New year to everyone. With a new year, here I start the year with a blog post talking about a common recipe for disaster waiting to happen with your SQL Servers. By default, SQL Server’s databases are installed on … Continue reading

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

Troubleshoot Your SQL Server

Hi Everyone. I wanted to ask a question before I begin my post today. And the question is: When you’re trying to troubleshoot SQL Server, Where do you start looking? This is one of the most hardest question to answer … Continue reading

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

You’re a DBA, you should know these

How many databases are you responsible for? How many different version do you support? How much data have we handled this month? How much capacity will we need next year? What new IT techniques will help you get there? These … Continue reading

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

Better…..Faster….SQL Server Backups

Ever since I phased out the legacy backup system in one of my recent projects with a centralized SQL Server backup solution, I have been asked by many people regarding the results that I got from the transition. To put … Continue reading

Posted in backup, Best Practices, ms sql | Tagged , , , , , , , | 1 Comment