Click a question to view the answer
(best viewed in Windows Media Player 9 series)

Questions

  1. This is Paul Ballard editor for the TheServerSide.net and we're here today with Kimberly L. Tripp. Kimberly tell us a little bit about who you are and what do you do with SQL Server?
  2. Tell us what you're doing here at VSLive?
  3. In a nutshell can you condense down the two hours of best practices to here are my three bullet points for indexes?
  4. You mentioned that you learned a lot from the students in your training. What kind of problems do you see people are having with SQL Server implementations?
  5. As developers we have a relatively narrow view into SQL Server. We're really talking about how to create our store procedures or how do we execute our queries and there are a couple of other things that are involved with that, but one of the things that's been a pretty hotly debated topical lately is, from a performance standpoint or from a design standpoint, is it better to use stored procedures or parameterized queries? What is the debate on that and what is your take on that?
  6. Looking at this again from the relatively narrow view of the developer, I wanted to start this question by saying what can we do to improve performance, but I think it may be more along the lines of what can we do to keep from destroying performance in SQL Server as we build our applications and build either the stored procedures or queries that we're gonna execute?
  7. Lets talk about SQL Server 2005, and a subject that I know is near and dear to your heart, which is availability. What are we going to see now that we'll be capable of with availability and what are some of the best practices that you are speaking to about availability in SQL Server 2005?
  8. Looking again from a developer's point of view, one of the biggest thing that we have seen or that is being talked about a lot is the CLR and the SQL Server. We know this question is going to be coming, so tell us about how, we have certainly seen some guidance on where to use SQL Server, T-SQL and where to use the CLR. How big of an improvement do you really see including the CLR on the server being?
  9. One of the other features that I have seen and would like to get your opinion on is the ability to click on a stored procedure and express it as a web service? HTTP endpoints and expressing those, how do see those being used or how do you see them being misused in SQL Server 2005?