Question of the Month - Category Archive
The following is a list of all entries from the Question of the Month category.
June Question: How Do You Monitor Your SQL Servers?
Question of the Month | June 1, 2011 | 12:30 amAs DBAs, one of our biggest responsibilities is to monitor our SQL Servers to ensure they are performing as expected. So, for this month’s question, “How do you monitor your SQL Servers?”, please share with us how your monitor your SQL Servers. For example, do you monitor them manually using SSMS, use custom-designed T-SQL or ...read more
May Question: What’s Your Backup Strategy?
Question of the Month | May 1, 2011 | 2:00 pmAs DBAs, one of our biggest responsibilities is to protect our data with backups. So, for this month’s question, “What’s your backup strategy?”, please share with us how your approach your backup process. For example, do you take full backups daily and trasaction log backups hourly? Or do you perform full backups weekly, differential backups ...read more
April Question: Which high availability option(s) do you employ for SQL Server instances, and why did you choose them?
Question of the Month | April 1, 2011 | 1:53 pmAs DBAs, we are responsible for the protection of our organization’s data, and we have many different options to protect it. So for this month’s question, “Which high availability option(s) do you employ for your SQL Server instances, and why did you choose them?”, share with us which ones you use, and explain why you made ...read more
March Question: What’s Your Biggest SQL Server Performance Headache?
Question of the Month | March 1, 2011 | 1:18 amAs DBAs, we have all received a phone call from a database user, asking why the database is so slow. Based on most DBA’s experience, performance is the number one problem users complain about. So for this month’s question, “What’s your biggest SQL Server Performance headache?”, share with us the biggest performance issue you currently face, ...read more
February Question: Share with us your “best” restore disaster stories.
Question of the Month | February 1, 2011 | 11:12 amAs DBAs, making backups and restoring data is one of the foundational skills we all must master. But sometimes things go wrong, very, very wrong. And it is from these mistakes that we often learn important lessons. This month, the Question of the Month is, “Share with us your ‘best’ restore disaster stories.” Tell us ...read more
January Question: As a DBA, how do you manage your disk space?
Question of the Month | January 1, 2011 | 8:00 amManaging disk space is an important resposibility of the DBA, and there are many ways to perform this task. In this month’s question, I am asking you, “As a DBA, how do manage your disk space?” In other words: Where do you store your MDF, LDF, and backup files? How do you allocate disk space ...read more
December Question: What does it mean to be a Proactive DBA?
Question of the Month | December 1, 2010 | 4:59 pmOne of the things I promote in all my presentations is the importance of being a proactive DBA. Unfortunately, the term “proactive” is open to many different interpretations. So, this month’s question is, “What does it mean to be a Proactive DBA”? In other words, what tasks does a DBA take in order to be ...read more
November Question: What steps do you include in your database maintenance?
Question of the Month | November 1, 2010 | 1:00 amDatabase maintenance is a critical task for every DBA. For this month’s question, list the typical steps that you use to perform your database maintenance. Please be as specific as possible, including what steps you perform, in what order, and how often you typically perform them. By sharing your database maintenance procedures, we can all ...read more
Twitter
Linked In