Yukon, Our New Possibility - Stability and Code
(Page 2 of 4 )
Stability was one of the most important issues that Microsoft wanted to optimize in Yukon, and, in my opinion, the folks at Microsoft have done a great job. As you may already know, Managed Code uses Code Access Security (CAS) to prevent assemblies from performing certain operations, and because Yukon integrates with the CLR, Yukon now uses CAS which optimizes the performance of Microsoft SQL Server and the Operating System at the same time. Also, the performance optimization comes from the fact that the CLR provides many services and functions (like memory management, strong data-types, advanced handling mechanism through Try-Catch blocks and Threading) which improves the performance and stability of the server.
You now have the ability to write complex database code with .NET languages such as C#, and that's because of the CLR’s integration with Yukon. Don't forget that you can use the Object Oriented Programming model in your databases as well, because .NET languages provide you with this model. For example, you can use assemblies and namespaces to organize your database code, which will help with large-scale complex databases. Remember, that your .NET code is far more powerful than T-SQL. You can use threading, text manipulation capabilities, type safety, thousands of ready-to-use classes that can be easily accessed from any stored procedure, trigger or User Defined Function that provide you with almost all you need to deliver the best applications ever.
Choosing between .NET languages or T-SQL when writing your SQL Server objects is a question that you will ask yourself each time you develop Yukon databases. And I can tell you that you will come to know the answer with experience. Let me tell you a little about this choosing issue.
I think that T-SQL is very appropriate when you want code that will only perform data access, such as using an INSERT statement to insert records into a database. You will need to use .NET Languages when you want the code to manipulate complex business logic that needs the power of the .NET Framework Class Library.
Next: For Database Administrators >>
More MS SQL Server Articles
More By Michael Youssef
/ 39 
