SQL Know How

Using .Net inside SQL Server

Simon Sabin

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,

  1. Why do I need to use .Net?
  2. Doesn’t it make my system unstable?
  3. Doesn’t TSQL perform better?
  4. How do I support it?
  5. How secure is it?
  6. 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.

During the seminar we will cover the following,

  1. How CLR is hosted in SQL Server
  2. Creating CLR objects using a .Net language
  3. Comparing the performance with TSQL and other options
  4. Providing guidance on when to use CLR objects and when not to
  5. 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.

This seminar is part of the SQLBits Cubed Training Day program, held on Friday 12th September before the SQLBits conference on the Saturday.

Course Length & Type

One day instructor led seminar.

Location

1st - 3rd September 2008 de Havilland, Hatfield

de Havilland Conference, Hatfield Hertfordshire. Directions map PDF, and Vistor Information leaflet.

Timetable

09:00Arrive
09:00 - 09:15Tea and Coffee
09:15 - 11:00Seminar
11:00 - 11:15Tea and Coffee
11:15 - 13:00Seminar
13:00 - 13:30Lunch
13:30 - 15:00Seminar
15:00 - 15:15Tea and Coffee
15:15 - 16:45Seminar
16:45Close

Simon Sabin

Simon is Director of his own data consultancy company Onarc Consulting that specialises in data related systems. He is also a Developer Skills Partner with SQLSkills. He has a particular expertise in the world of search, distributed architectures, business intelligence and application development. He has worked with SQL Server since 1998 and has always focused on high performance reliable systems. Simon was awarded as an MVP in 2006. He founded the first free SQL Server conference in the UK SQLBits in 2007 along with other MVPs in the UK. He is a regular speaker at SQL Server events as well as writing his blog and writing for SQLServerCentral and Simple-Talk.com. He is married with children and lives in the UK.

Events

Training Courses

SQL Server Integration Services (SSIS) Deep Dive - 4 Day Training Course