SQL Server 2005 introduced the Common Language Runtime (CLR) to the SQL world with the ability to create stored procedures, triggers etc using a number of .Net languages and have it run inside the database server.
Most people ask the following questions,
- Why do I need to use .Net?
- Doesn’t it make my system unstable?
- Doesn’t TSQL perform better?
- How do I support it?
- How secure is it?
- When should I use CLR over TSQL?
We will answer these questions by looking at real world uses of the CLR in your database.
We will see how the code you write can be simpler than TSQL and perform better than TSQL, whilst not impacting on the stability of your system. We will also look at scenarios that aren’t possible using TSQL and how we can solve easily them using CLR objects.
TopicsDuring the seminar we will cover the following,
- How CLR is hosted in SQL Server
- Creating CLR objects using a .Net language
- Comparing the performance with TSQL and other options
- Providing guidance on when to use CLR objects and when not to
- Getting the best performance from your CLR objects
Getting the most out of any situation is all about understanding which tool is best suited to what situation.
If you want to get the most out of your database then you need to understand how and when you CLR objects are the best tools for the job.
Simon Sabin is an independant consultant and trainer. He has worked with SQL Server since SQL Server 6.5, on many large scale systems built using the Microsoft architecture. He was awarded the Most Valuable Professional award in 2006 and is a leader in the SQL Server community in the UK. He has written and delivered the developer track of the SQL Server 2008 Jumpstart training for Microsoft alongside Bob Beauchemin. Alongside Allan Mitchell, Darren Green and Tony Rogerson he has setup SQL Know How, a company for providing SQL Server Consultancy and training based on real world experience.