|
Q&A with Adam Machanic - Who's Afraid of SQLCLR by Jonathan Kehayias
You could almost hear the gasps of horror when Microsoft integrated the .NET Common Language Runtime (CLR) into SQL Server 2005. Run C# or VB.NET code inside SQL Server? For many database developers and administrators, it was like an alien had just burst through SQL Server’s midsection.
But SQL Server MVP Adam Machanic says that more and more developers and DBAs are discovering that far from destroying SQL Server performance and security, SQLCLR is actually a powerful ally in solving complex business and technical problems.
Read More on the PASS website.. |
SQLCLR String Splitting Part 2: Even Faster, Even More Scalable by Site Administrator
SQL Server MVP Adam Machanic shows a new way of parsing strings in SQL Server using SQLCLR that outperforms all conventional TSQL methods, as well as the most common SQLCLR implemenations, using a custom split function that allows streaming of the results. |
Trading in xp_cmdshell for SQLCLR (Part 1) - List Directory Contents by Jonathan Kehayias
Learn how to use SQLCLR to get file system information instead of using xp_cmdshell on your SQL Servers. |
|