Milind Lele - Demo of using new SQL Server from Visual Studio | TheChannel9Team

JamesProud

Sweet! Milind, the first Microsoft guy I ever met. Great guy, and a great interview too.

ChrisHaas

i'm glad someone finally explained when you would want to use managed code versus straight TSQL. good video.

one question, does anything need to be done on the SQL Server to enable debugging?

MilindL

Thanks Chris. The connection node in server explorer has a context menu command "Enable SQLCLR debugging". You can check that to enable this. Also when you create a SQLCLR project you are prompted for a connection to use as the target for your assembly. If this is not enabled for this connection, you will be prompted to.

ZippyV
Fired Up

I noticed that Lele is using SqlTypes (SqlDouble). Why can't we just use the .net framework variabletypes?

PeterR

nice video

could someone tell me where i can get the background Lele has on his machine?

Aayush Puri

Had read a couple of articles about the integration of CLR with Yukon but the concept was never so clear as was after watching this video.
Anyone noticed the ";" that Milind had put after a VB line of code!!! I (and may be others too) tend to do the same mistake after writing code in C# (or JAVA) for months Wink

-Aayush

Minh
WOOH! WOOH!

Very informative. Milind, could you detail the code paths of executing a native SPROC vs. a CLR SPROC? I'm mostly interested in performance issue. Whether or how much of a performance penalty a CLR SPROC may cause.

dantheman82

Did anyone else notice that VS .NET 2005 was running rather slow on his system? I've seen this on my computer as well, and would really like to see a speed improvement.

Dan

wacko

I have never had an issue, what I did notice is he was running beta two LOL One can hope that is not to far off. I find that VS 2005 runs pretty quick.