Yukon, Our New Possibility
(Page 1 of 4 )
I consider Yukon a new way of supporting Microsoft.NET. In fact, when I heard about Yukon I began asking myself many questions like "How will Yukon support .NET?", "What will make me choose Yukon?" and "What are Yukon’s features?" After doing some research on my own I found the answers and I'd like to share with you.
"Yukon will change the world of database development", is what Professor Prakhar Deva told me before the release of .NET. Now I believe him.
Yukon will give developers the power of integrating the .NET Framework into SQL Server, and I think it needs some further explanation.
Imagine that you can use your favorite .NET language (like VB.NET or C#) to write database objects (triggers, stored procedures, functions and more) without using T-SQL statements.
Now you can use your .NET Class Library (more than 5500 classes) to write your Yukon objects. It's great that the Common Language Runtime has been integrated in Yukon. The .NET integration with Yukon provides developers with many benefits which decrease the development time, thus making the final results better than ever.
Benefits
The first of these benefits is a more powerful programming model, which means that using .NET languages to write your SQL Server objects is more powerful than with the traditional T-SQL statements (Even though T-SQL is the primary language and will continue to be the primary language of SQL Server). A safer and more robust environment for databases has been considered in Yukon, now that SQL objects will run in the CLR environment; that means it will be more secure than the traditional stored procedure that runs on the server. Also, Microsoft has added 2 more objects in Yukon; User Defined Types and Aggregates, which give developers more querying capabilities.
The really good thing that makes our team (and actually all developers around the world) happy is that Microsoft will integrate database development tools into Visual Studio.NET's future versions. So you will use only one Visual Studio to develop and debug your database objects, scripts, as well as also writing your client-side code or middle tier. That is, you will use Visual Studio.NET to develop the entire application. Microsoft will release a version of Visual Studio.NET, code-named "Whidbey", with these capabilities.
Next: Stability and Code >>
More MS SQL Server Articles
More By Michael Youssef
/ 39 
