Best practices clinic

If you were the DBA for the SQLServerCentral.com and Simple-talk.com databases, what changes would you make?

There is an interesting experiment happening over at SQLServerCentral.com. The databases for SSC and Simple-talk.com can be monitored by anyone (SQL Monitor was installed and the interface made public at monitor.red-gate.com). So you’re invited to take a look at them, and then suggest changes to the configuration based on what you see.

Brad McGehee is writing a series of articles, with each article focusing on a specific topic, and readers are invited to send in their suggestions. In Part 1 the focus is simply on the property settings, because as Brad says, this is “what I do when I first check out a SQL Server that I have never seen before”. Brad, along with Grant Fritchey, Steve Jones and Simon Lye, will comment on the suggestions and then write a follow up. Gradually the articles will dive deeper into the environment and build a picture of best practices as recommended by the community.

Here’s an example of how it’s working:

Best practices pt1

Read Brad’s opening article, SQLServerCentral Best Practices Clinic: Part 1 for all the info.

This entry was posted in Uncategorized. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

Post a Comment

Required fields are marked *

Add an Image

*
*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>