What we'll do
The Common Language Runtime (SQLCLR) has been available in SQL Server since version SQL Server 2005. However it I easily one of the most under-utilized technologies deployed in database solutions. It's correct usage can deliver substantially faster and more powerful functionality compared to traditional Transact-SQL (T-SQL) solutions.
This session will examine the SQLCLR extensions within SQL Server. It is targeted predominantly towards database developers and DBAs. Some familiarity with C# would be beneficial. As we as a basic understanding of .NET and have some experience building projects in Visual Studio. However team leaders and solution architects would also benefit from seeing what the technology can deliver.
We'll cover the basic architecture of SQLCLR, discuss good code patterns with demonstrations and display a few pitfalls of bad design. In particular we will focus on where SQLCLR "shines", especially where a T-SQL based solution would be "too tricky" or even impossible to accomplish.
By utilizing the SQLCLR wisely one can achieve noticeable performance improvements in certain cases where nothing else can help. With plenty of examples and demonstrations make sure you attend this informative, practical session!
• 12:00 - 12:10: Networking / "Gossip"
• 12:10 - 12:20: Vendor session
• 12:20 - 14:00: Main session
Speaker: Stanislav Smoltis
Stan is a SQL Server Developer with experience of building and administering enterprise-scale data solutions on both cloud and on-premise environments. He is currently responsible for development and query tuning for a high-performance, 24x7 OLTP database solution. He has worked with SQL Server since 2004 and spent the last 3 years as a consulting engineer advising various companies on SQL Server infrastructure design and performance aspects.