Having been sitting on the fence for a while, I’m finally leaping off, and presenting at some community events. Following a false start with SQLBits (I submitted, but wasn’t voted in, and given the number of attendees I’m a little relieved about that!), I’ll be presenting at the following events over the next couple of months.
Hope to see you there!
24th April (Tues) – SQL Server in the Evening (6:30-6:50) – First Timers Slot (http://sqlserverfaq.com/events/392/Sessions-including-SQL-Server-Parallel-Data-Warehouse-at-the-sixth-SQL-Server-community-event-615pm-April-24th-Reading-Berkshire.aspx)
I’ll talk about using the CLR within SQL Server, why and when it should be used and then how.
25th April (Weds) – DevEvening (http://www.devevening.co.uk/)
26th May (Sat)– DDD Southwest (http://dddsouthwest.com/)
NOTE: This session isn’t confirmed yet, and is still reliant on being voted in. You can vote by going to the DDD Southwest site, linked above! )
Both DevEvening and DDD Southwest will be the same session, summarised below:
Going Native with SQL Server 2012 and C++
I’ll be going through the delights of creating a module to interact with SQL Server 2012, a function in T-SQL (briefly), then using C# to create a SQL CLR module, and then looking into the performance gains by making a C++ application querying the SQL Native Client (ODBC). All three sections will do the same job, and we’ll cover the advantages and disadvantages of each.
We’ll cover the following:
- T-SQL, SQL CLR (C#)
- SQL Server Native Client
- Advantages and Disadvantages
- Performance Opportunities
- How to use it to connect to SQL Server from C++
- How to query a database
- Comparison between T-SQL, SQL CLR & C++ solutions
Slides and follow-up articles will be coming soon.