Question of the Month - Category Archive

The following is a list of all entries from the Question of the Month category.

January Question: What feature(s) of SQL Server would you like to learn more about?

Although SQL Server 2012 coming out this year, I think some of us are still trying to catch up with all the new features introduced in SQL Server 2008. SQL Server has become so feature-laden, I think it is becoming harder and harder to keep up. With this in mind, this month’s qustion is “What ...read more


December Question: When reflecting on this year, what has gone well, and what would you do differently?

December is the last month of the year, and is often a good time to reflect on the past year and think about the upcoming year. So, for this month’s question, “When reflecting on this year, what has gone well, and what would you do differently?”, tell us what went well for you, and why; ...read more


November Question: What is your favorite, and not so favorite hardware to run SQL Server on?

Selecting which hardware to run SQL Server on is often discussed among DBAs. So, for this month’s question, “What is your favorite, and not so favorite hardware to run SQL Server on?”, tell us about the hardware you love, the hardware you hate, and why. Also, get your free copy of Glenn Berry’s eBook on ...read more


October Question: What one thing do you feel has the greatest impact on SQL Server’s performance?

When it comes to databases, many DBAs obsess over performance, and for good reason, as when user’s begain to complain about slow performance, it is the DBA who is often blamed. So, for this month’s question, “Tell us what one thing do you feel has the greatest impact on SQL Server’s performance?” Post your responses ...read more


September Question: Tell us about your DBA interview experiences: good and bad.

I have only interviewed for a handful DBA jobs over the years, but they have ranged all the way from very easy (I got the job with no problem); to horrible, where I was faced down by three DBAs who did their best to embarass me in front of them. I actually walked out of ...read more


August Question: How Do You Manage Your Transact-SQL Scripts?

Whether it is Transact-SQL for applications you are developing, or just for routine administrative tasks, managing Transact-SQL has never been easy. Some people use some version of source control software, while others use folders in the file system, and so on. So, for this month’s question, “How do you manage your Transact-SQL scripts?”, tell us ...read more


July Question: What Do You Think are the Most Common DBA Pain Points?

While being a DBA is challenging and often rewarding, we often experience a lot of pain points that we wish would go away. So, for this month’s question, “What do you think are the most common DBA pain points?”, please share with us areas in your job where you experience the most pain. If you ...read more


June Question: How Do You Monitor Your SQL Servers?

As 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


Copyright 2009-2011 Brad M McGehee