Michael Smith: This time we are talking with Jeremy Kadlec about his CFUNITED-07 talk "SQL Server Development Short Takes". So why should a developer come to your session Jeremy?
Jeremy Kadlec: The content and format for my session, I believe is going to be very beneficial to all of the attendees. It is a very different approach to information delivery.
Michael Smith: How is your session going to be so different?
Jeremy Kadlec: Base on our consulting work with ColdFusion community, I am taking 10 common SQL Server issues that we have faced and formatting the session as the problem, solution, demo and next steps.
Michael Smith: Wow that is a much different approach.
Jeremy Kadlec: Yes - The session is going to be fast paced to cover the material, but the attendees are going to reap benefits from each issue and resolution that is addressed.
Michael Smith: So when the attendees leave they are really going to be able to take the information back with them and improve there SQL Servers?
Jeremy Kadlec: Absolutely! That is the goal of the session.
Michael Smith: Can you give us a preview of some of the topics that are going to be covered?
Jeremy Kadlec: I do not want to give away too much, but I will let you know that the session will start off with information on SQL Server Express.
Michael Smith: Isn't that the free version of SQL Server?
Jeremy Kadlec: Yes it is. I am going to cover the product highlights very quickly to show the value of SQL Server from the free version to the enterprise edition, meaning that SQL Server can really meet all of your database needs from the small applications to the enterprise, for the most demanding Cold Fusion applications.
Michael Smith: I know you said 10 topics. So what's after that?
Jeremy Kadlec: We are going to jump into some data modeling techniques because I think that is a key tenet that all Cold Fusion developers should know about. I will also touch on indexing and how to improve your application performance which is typically a major concern for the Cold Fusion developers because good database performance typically means a good experience on the web site.
Michael Smith: Agreed. Can you let anything else out of the bag?
Jeremy Kadlec: Well - One key issue I have seen time and time again is paging through large record sets on your web site. I will show you how SQL Server can handle this in an efficient manner via one of the new functions in SQL Server 2005.
Michael Smith: Since you are on a roll, what else can we look forward to during your session?
Jeremy Kadlec: Well, error handling has historically been a problem with SQL Server 2000. I am going to work through an example of how to standardize, simplify and centralized error handling in your SQL Server code.
Jeremy Kadlec: I have another 5 or so tricks up my sleeve for the session that should be of great value to all of the attendees. They just need to pencil me in their schedule to learn about these features and more during the session.
Michael Smith: I know your company focuses on SQL Server, what if CFUNITED attendees have more questions?
Jeremy Kadlec: They can stop me after the session and I am more than willing to answer any and all SQL Server questions. They can also stop over to our booth as well. If they are looking for valuable SQL Server information on a daily basis they can check out www.MSSQLTips.com for our daily SQL Server newsletter.
Michael Smith: Well thank you for your time today Jeremy.
Jeremy Kadlec: Absolutely! I am really looking forward to CFUNITED. I have to admit I really enjoy the conference and think it is an awesome place to learn about ColdFusion and the related technologies that developers rely on daily.