Windows IT Pro is the authoritative and independent resource for windows nt, windows 2000, windows 2003, windows xp. Features a collection of resources and magazines for windows IT professionals.
  
  
  Advanced Search 


November 01, 2005

Tech Tidbits: R2 and SQL Server 2005/Visual Studio 2005

RSS
Subscribe to Windows IT Pro | See More Products / Software Articles Here | Reprints | Or get the Monthly Online Pass—only $5.95 a month!

The tech world has been busy lately, so this week, I want to present two different topics, rather than let either one sit on the back burner for another week. Let's get started.

Windows Server 2003 R2 Hits Final Milestone, Ushers in VM Era Last week, Windows Server 2003 R2 ("release 2") entered its final phase of development with the release of its second, and final, release candidate (RC) build, RC1 (the first was called RC0). I've discussed R2 a lot in Windows IT Pro Update already, and Microsoft hasn't added any new features in this final public release (see the URL below for download details). What has changed, however, is that R2 will usher in a new era of virtual machine (VM) licensing from Microsoft. Customers who purchase R2 Enterprise Edition will be able to install that copy of R2 into as many as five VMs--in Microsoft's Virtual Server or VMware's server products--on the same machine. This clarification of VM licensing will save customers money, and, I believe, take VM technology mainstream.

Why is that, you ask? Today, most corporations use VM technology for testing purposes. Developers can test new applications, Web services, and Web applications against known configurations to see how they behave. Administrators can test network and server configuration changes in tightly controlled test environments. And Help desks can maintain a library of VMs to use as a reference when calls come in. Microsoft and VMware, however, see a big future for VM technology. And with R2 Enterprise Edition, I think we're going to see more and more VMs rolled out in production environments. Increasingly, VMs are the perfect environment for legacy OS installations and applications and for systems that are needed only at certain times, such as during peak holiday sales traffic.

In the past, maintaining new OS installations in VMs was expensive because you had to pay for a normal license for each installation, regardless of whether you used it regularly or not. R2 will change that, at least for Enterprise Edition. And when Longhorn Server ships in 2007, the Datacenter Edition of that product will also support unlimited VM installations. That, I believe, will make Longhorn Server Datacenter the ultimate hosting environment for production VMs. There's more--Microsoft is now supporting the use of Microsoft Exchange Server in a VM, for example--but that's a story for another day. In the meantime, if you're looking for an inexpensive way to virtualize your operations, give R2 a look.

Windows Server 2003 R2 Release Candidate 1 (RC1) Software http://www.microsoft.com/windowsserver2003/R2/trial/default.mspx

SQL Server 2005 and Visual Studio 2005 Completed Microsoft long ago scheduled a big launch event for SQL Server 2005 and Visual Studio 2005 (and BizTalk 2006) on November 7 in San Francisco. But late last week, the company finalized both SQL Server 2005 and Visual Studio 2005 and released the products to Microsoft Developer Network (MSDN) Subscriber Downloads. If you have an MSDN membership and want early access to the final code, your time has come.

Both products have been delayed umpteen times and are years late, but developers looking for better performance and productivity would be wise to investigate both products. Visual Studio 2005 is the best version of the development suite yet, although its confusing array of product editions will be sure to frighten more people than a vintage Stephen King book. The basic gist is this: Microsoft has significantly expanded the Visual Studio product line at both the low end and the high end. The company's Express Editions ($49 each) are low-cost versions of the individual Visual Studio products (Visual Basic, Visual C#, and so on), whereas the Team Studio editions are aimed at teams of corporate developers who need to collaborate regularly on enterprise-class solutions. In the middle of all this are the more typical standard and professional editions.

SQL Server 2005 is impressive in its scope. Microsoft has completely rethought the entire three-tier architecture that developers have followed for the past decade and made it possible to run Windows .NET code from directly within SQL Server. This functionality has a few major ramifications, all positive. First, developers can write stored procedures in native .NET languages such as C# or Visual Basic (VB), giving them access to those language's advanced features. (Naturally, T-SQL is still supported as well, and is more appropriate for certain uses.) Second, because SQL Server 2005 natively hosts .NET code, remote data access is less performance-challenged than before.

SQL Server 2005, of course, offers much more than that, including high availability capabilities and data mirroring (in beta form now). But that, too, is a discussion for another day. In the meantime, head over to MSDN if you have a subscription, and take a look at these products. You might be surprised by how much has changed.

End of Article



Reader Comments

You must log on before posting a comment.

If you don't have a username & password, please register now.




Top Viewed ArticlesView all articles
Friday at PASS Europe 2006

Kevin talks about the closing day of the event and shares a funny Microsoft film. ...

Windows Mobile: What Went Wrong?

Paul discusses the evolution of Windows Mobile and why he thinks the platform is probably doomed. ...

More fun TechEd 2005 Resources

Kevin points out some more TechEd resources ...


Windows OSs Whitepapers Why SaaS is the Right Solution for Log Management

Are You Satisfied?

A Preliminary Look at Deployment Plans for Microsoft Windows Vista

Related Events Check out our list of Free Email Newsletters!

Windows OSs eBooks Understanding and Leveraging Code Signing Technologies

A Guide to Windows Certification and Public Keys

SQL Server Administration for Oracle DBAs

Related Windows OSs Resources Become a VIP member of the Windows IT Pro community!
Get it all with the VIP CD and VIP access. A $500+ value for only $279!

Subscribe to Windows IT Pro!
Solve your toughest technical problems with our experts and access 10,000 + articles online. 30% off

Monthly Online Pass - Only $5.95!
Get instant access to 10,000+ articles from Windows IT Pro Magazine!

TechNet Virtual Labs
Evaluate and test Microsoft's newest products.

Job Openings in IT


ADS BY GOOGLE SPONSORED LINKS FEATURED LINKS

Microsoft Exchange & Windows Connections event returns to Las Vegas Nov 10 - 13
Connections returns to Las Vegas for this exciting event where each attendee will receive SQL Server 2008 standard with 1 CAL. Co-located with Microsoft ASP.NET, SQL Server, and SharePoint Connections with over 250 in-depth sessions.

Free Online Event! Virtualization:Get the Facts!
Register now and attend this free, live in-depth online conference on November 13 and 20, 2008, produced by Windows IT Pro. All registrants are eligible to receive a complimentary one-year digital subscription to Windows IT Pro (a $49.95 value)!

Check Out Hyper-V Video on ITTV
Watch Karen Forster's interview on Hyper-V's performance on ITTV.net.

Ease Your Scripting Pains with the Flexibility of PowerShell!
Join MVP Paul Robichaux on December 11, 2008 at 11:00 AM EDT as he equips you with PowerShell basics in 3 introductory lessons, each followed by a live Q&A session—all on your own computer!

PASS Community Summit 2008 in Seattle on Nov 18-21
The don’t-miss event for Microsoft SQL Server Professionals. Register now and you’ll enjoy top-notch Microsoft and Community speakers and more.



Solving PST Management Problems
In this white paper, read about the top PST issues and how to administer local/network PST Files.

Get Protected -- Data Protection Manager 2007
Protect your virtualized environment with Data Protection Manager

Order Your SQL Fundamentals CD Today!
Learn how to use SQL Server, understand Office integration techniques and dive into the essentials of SQL Express and Visual Basic with this free SQL Fundamentals CD.
Windows IT Pro Home Register FAQ for Windows WinInfo News
Europe Edition About Us Contact Us/Customer Service Media Kit Affiliates / Licensing  
SQL Server Magazine Office & SharePoint Pro Windows Dev Pro IT Job Hound ITTV
IT Library Technology Resource Directory Connected Home Windows Excavator Windows SuperSite 
 
 Windows IT Pro is a Division of Penton Media Inc.
 Copyright © 2008 Penton Media, Inc., All rights reserved. Terms and Use | Privacy Statement | Reprints and Licensing