Yukon, Our New Possibility - For Database Administrators
(Page 3 of 4 )
An important question that you may ask is, "Now that Yukon can understand .NET code and T-SQL, where do I put the data and where do I put the functionality?" In fact, it's up to you and up to the business logic. However, if you put the data and the functionality on the server you risk the chance of decreasing the server’s performance, especially if the functionality takes a lot of processor time. You can, however, solve this by placing the data on the server and the functionality on the client.
Microsoft has done a good job of improving the database engine, XML and ADO.NET Support and Database Administrator tools.
For Database Administrators, Microsoft has folks working hard to improve the entire administration process. Most of the administration tasks can now be done without taking Yukon offline. Recovery is now much faster than SQL Server 2000 and they’ve done a good job of improving server security, availability and reliability. They’ve also added new functionality to the server, such as dedicated administrator connection. I can't even begin to tell you how many features Microsoft has added to Yukon for Administrators. Another example is that the Administrator can now depend on Yukon's self-tuning capability without worrying about all the details.
Replication and SQL Profiler have also been improved with Yukon; but the most important feature that I can talk about is the replacement of the Server-Side Enterprise Manager tool with the new Client-Side Management console (code-named SQL Workbench). SQL Server Administrators will have great control on the Client-Side with this new tool. Yukon's Workbench is an integrated environment which will help Administrators and developers do many things. Microsoft has integrated the Workbench with Analysis Services and Reporting Services. And you will use it to develop XML and T-SQL code. Workbench will be integrated with Visual Studio.NET (AKA 'Whidbey') so it will have many features, such as IntelliSense. Also, SQL Server Administrators and Developers will find great toolset for almost everything related to databases from designing databases to debugging and deployment.
Next: Server Management Objects >>
More MS SQL Server Articles
More By Michael Youssef
/ 39 
