Architecture Questions - What's Your Opinion?

Kevin raises several questions from the audience at his London, Amsterdam, and Copenhagen seminars. What is your opinion?

Kevin Kline, SolarWinds

September 22, 2008

2 Min Read
ITPro Today logo in a gray background | ITPro Today

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 - http://www.youtube.com/watch?v=cagxPlVqrtM&feature=related.  But if you're looking for some real resources, here are some others that are useful:

So what do you think about these questions?

Best regards,

-Kevin

Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.

You May Also Like