THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Adam Machanic

Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.

James Hamilton on SQL CLR: " can write in any language now."

Tom Rizzo pointed out the other day that he and James Hamilton were featured on The .NET Show, discussing SQL Server 2005.

This was a pretty interesting show, and I recommend that readers interested in SQL 2005 features watch the webcast.

However, one quote in particular annoyed me. From James Hamilton, about CLR stored procedures:

"You're no longer forced to use T-SQL. T-SQL's absolutely still supported. Works as well as ever. But you can write in any language now."

I'm utterly sick of hearing this absolutely baseless claim repeated over and over by people both inside and outside of Microsoft! I'd originally heard it from a certain MS evangelist (name withheld to protect the guilty!) over two years ago, and believed it until I first cracked open the SQL Server 2005 Books Online.

The bottom line is, at least as of the current beta -- and according to everything I've read about the SQL CLR integration -- you MUST USE T-SQL TO ACCESS DATA. When coding a CLR stored procedure, the only way to get data from the database is to use a context connection back and execute a T-SQL query. There is no replacement for T-SQL. And you certainly cannot code data access in "any language".

I don't know why this claim keeps getting repeated. I just want to set the record straight, at least for readers of this blog. Unless MS has a huge secret change lined up that hasn't hit the beta yet, this is just how it is. So please, MS and others, stop making this claim! To me it feels like little more than a sad marketing tactic that's gone way too far.

Published Wednesday, July 12, 2006 10:38 PM by Adam Machanic
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Adam Machanic said:

More fun CLR conversation , this time from SQL advocate Joe Celko. Surprise, surprise, Celko is not a

January 25, 2009 2:56 PM

Leave a Comment


About Adam Machanic

Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "SQL Server 2008 Internals" (Microsoft Press, 2009) and "Expert SQL Server 2005 Development" (Apress, 2007). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.

This Blog


Privacy Statement