Skip navigation

Architecture Questions - What's Your Opinion?

I had a great time speaking with the large communities of SQL Server users as I traveled about Europe last week and much of this week.  I'm always impressed by the skill, intelligence, and creativity of these professionals.

And sometimes they raise questions that I think are worth sharing with everyone because they too might've heard the question before or asked it themselves.  Here are a few examples.  What are your thoughts on these questions?

1. To what extent does compatibility mode effect the behavior of SQL Server?  For example, direct catalog updates aren't supported in SQL Server 2005. If we're running in SQL Server 2000 compatibility-mode, can we still access the SYS schema?

2. There are strong architectural reasons why SQL Server doesn't support multiple log readers, right?  Let's discuss.  (I have my own ideas about why you wouldn't want to enable it.)  However, the potential for improving the performance of replication by the use of multiple Log Reader agents is very strong because you could have more data flowing from one server to another.  Imagine for example, if you could have one log reader pumping data for the "customer" table and another pumping data for the "orders" table.  How can we build a solution that offers us those benefits?

3. Error messages?  Yes, error messages.  Is there any way we can find out what error messages are most commonly encountered across the SQL Server universe?  Maybe someone on the PSS team can help us out here?

4. How do I give a good presentation?  Well, there's a hilarious YouTube video that covers all the bases -  But if you're looking for some real resources, here are some others that are useful:

Good web sites from Garr Reynolds and his associated  book:

Guy Kawasaki web site:

How to Give a Steve Jobs Caliber Keynote Presentation:

So what do you think about these questions?

Best regards,


Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.