Yukon, Our New Possibility - Server Management Objects
(Page 4 of 4 )
Using .NET, you will be able to program Yukon's new management language, which is called Server Management Objects (SMO), a replacement of SQL DMO. SMO is very easy to use and don't forget that you can use .NET to program in SMO too!
As you know indexing is one area that Administrators need more power over, with Yukon you can create and maintain indexes online without taking the server offline. This will be done using the T-SQL index option create index with online. Dropping and altering indexes will be performed online as well.
Yukon includes native XML data-types for improving management, storage and retrieval of XML data. Yukon supports XQuery for retrieving XML data and XML Schema Definition (XSD). Web Services have been improved and how you can create them in the database-tier making SQL Server an HTTP Listener. This will provide us a new way of accessing the data. In Yukon you can use HTTP to access SQL Server directly without the need for a middle-tier listener such as Microsoft Internet Information Services (IIS) Server. SQL Server exposes a Web service interface to allow execution of SQL statements and invocation of functions and procedures. Query results are returned in XML format and can leverage the Web Services infrastructure of Visual Studio.
Using SQL Server, code-named "Yukon", and Microsoft Visual Studio.NET, code-named "Whidbey", Microsoft takes us many steps forward in the way of Global Digital Systems with .NET GDS.NET.
| DISCLAIMER: The content provided in this article is not warranted or guaranteed by Developer Shed, Inc. The content provided is intended for entertainment and/or educational purposes in order to introduce to the reader key ideas, concepts, and/or product reviews. As such it is incumbent upon the reader to employ real-world tactics for security and implementation of best practices. We are not liable for any negative consequences that may result from implementing any information covered in our articles or tutorials. If this is a hardware review, it is not recommended to open and/or modify your hardware. |
/ 39 
