PASS Community Summit 2009: Pre-Conference Sessions (Database & Application Development)
Return to Session Listings
SQLCLR from Beginner to Expert
Adam Machanic (SQLblog.com)
The integration of the Common Language Runtime (CLR) into SQL Server 2005 provides SQL Server developers with a vast new toolset for solving complex business and technical problems. This full-day workshop is designed for SQL Server developers who know some .NET or .NET developers with a strong interest in databases and will take the attendee from SQLCLR beginner to expert. You will learn all the ins and outs of working with SQLCLR routines, including best practices for leveraging them in real-world scenarios. The day starts with an introduction to SQLCLR: what it can do for you and why it was added to SQL Server. Next, you will learn about the basic SQLCLR modules: user-defined functions and stored procedures. Your knowledge of the basics will be extended with insights into some of the SQLCLR internals--particularly, the security model--and you will learn how to create robust, secure, and high-performance frameworks. The afternoon session goes even deeper, taking a look into user-defined types and aggregates, before finishing with a review of how to deploy and manage your solutions in production environments. All along the way, performance, scalability, and maintainability will be stressed.
Watch 24 Hours of PASS Session Recording
Q&A with Adam
Q: Considering those who are using SQLCLR, what are the biggest or most common problems? What do developers need to watch out for?
A: SQLCLR should not be looked at as a panacea. It's not going to solve all of your problems, but when properly applied, it will solve many of them. Developers like to jump on a new technology and ride it—for better or for worse—as far as it will take them, and the SQLCLR world is no different. I've heard horror stories about developers rewriting an entire application worth of stored procedures using SQLCLR, causing memory problems and severely limiting scalability. This is not the correct use case for the technology; just like with any other tool, it should be used in moderation, in situations in which it’s appropriate.
Read the rest of Adam's conversation with PASS here.
About the Speaker
Adam Machanic is a Boston-based independent database consultant, writer, and speaker. He has been involved in dozens of SQL Server implementations for both high-availability OLTP and large-scale data warehouse applications, and has optimized data access layer performance for several data-intensive applications. Adam has written for numerous Web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including SQL Server 2008 Internals (Microsoft Press 2009) and Expert SQL Server 2005 Development (Apress, 2007). Adam regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, Microsoft Certified IT Professional (MCITP), and a member of the INETA North American Speakers Bureau.
See the other sessions Adam is presenting at PASS Summit Unite 2009 here.
Register now for PASS Summit 2009!