This issue of Developer Update is sponsored by
Application Health Monitoring and Modeling http://www.windowsitpro.com/go/whitepapers/avicode/apphealth/?code=DEVTop0901
Enhance SQL Reporting and Increase Server Performance: Revolutionize the Way You Work with Data http://www.sqlmag.com/go/whitepapers/doubletake/reportingservices/?code=DEVMid0901
SQL Server Guide to Clustering Alternatives http://www.sqlmag.com/go//whitepaper/neverfail/sqlclustering/?code=DEVHot0901
~~~~ In This Issue ~~~~
Developer Perspectives - .NET Now Positioned to Replace COM
eLibrary Short Takes - Confused by SQL Server 2005's Many Editions? Help Has Arrived - White Paper Describes How SMBs Can Protect Their Information
Tech Talk - Glad You Asked: Two Sides of the Same Coin - Tech Tips Show on the Road Again - Letters to the Editor
Info to Go
New and Improved - Software Lets You Manage the Architecture of .NET Projects
~~~~ Sponsor: AVIcode ~~~~
Application Health Monitoring and Modeling Ensure successful application deployment, monitoring, and management when you share architectural and operational requirements. Learn how to use application models, use MOM to monitor the health of business applications, and explore a practical example of health modeling and monitoring application deployment. Download the free whitepaper now! http://www.windowsitpro.com/go/whitepapers/avicode/apphealth/?code=DEVTop0901
~~~~ Developer Perspectives ~~~~
.NET Now Positioned to Replace COM by Bill Sheldon, bills@interknowlogy.com
Several years ago when Microsoft introduced its .NET technology, there were many discussions about whether this was a sign of the end of COM. After all, .NET isn't based on COM but instead on a runtime environment and byte code. At the time, most everyone, including Microsoft officials, concluded that .NET isn't the end for COM. But the world of technology keeps changing. As we prepare to take another step forward, so does the likelihood that COM is, in fact, reaching its end of life for most business applications. Don't get me wrong--I'm not saying that Microsoft's product support for COM or COM's use as a standard (and one used by key Microsoft products) is coming to an end. However, we're fast approaching a point at which most business applications won't be implemented with COM. This distinction is important. Simply put, Microsoft isn't ending its support for COM but rather the market is bringing about the effective end of COM. In this case, it comes down to the demand for applications that have more memory and faster processors. If you've been developing applications for more than a couple years, you might recall the last big jump: the migration from Windows 3.1 to Windows 95, which is better known in the technical world as the transition from 16-bit to 32-bit OSs. I don't know of a single developer who found this transition to be a pleasant experience. Perhaps it was profitable for some consultants, but nevertheless it wasn't pleasant, even for them. We're now approaching the next big jump: the migration from 32-bit to 64- bit OSs. When people hear "64-bit," they often think of servers. After all, it was the overburdened database servers of companies' Web-based applications that first showed the strain on 32-bit OSs. However, as we continue to move forward, we're seeing that high-end users (e.g., developers who develop for 64-bit platforms, gamers who want more memory to make games run faster) are eyeing the move to 64 bits. Although 64 bits might not be a priority on the average Web server yet, as more servers are used to host multiple sites, even Web servers will eventually look for 64-bit processing. The result is a challenge for COM in that COM is a binary protocol. COM- based applications base their communications on data contained and formatted in their compiled state. Thus, when you compile your code to run on a 32-bit OS, the code implements the protocol based on a 32-bit environment. The problem is that an object that worked well in a 32-bit environment might not work as well in a 64-bit world. Microsoft and many hardware manufacturers are making their 64-bit products compatible with existing 32-bit applications. However, compatibility is a far cry from having a platform that runs 32-bit and 64-bit applications equally well. The Windows .NET Framework is such a platform. More important, Microsoft made the .NET Framework available several years ago, which means that the transition from 32-bit to 64-bit OSs will be far less painful than the transition from 16-bit to 32-bit OSs. Although there will still be companies that use COM-based interfaces to build applications, these companies will be the exception rather than the rule in the not-too-distant future. Most companies will use .NET 2.0 and the upcoming .NET 3.0 to build code so that their applications can be effortlessly ported to the new 64-bit world.
~~~~ Sponsor: Double-Take Software ~~~~
Enhance SQL Reporting and Increase Server Performance: Revolutionize the Way You Work with Data Increase your SQL production server's performance by offloading Reporting Services to a secondary server. Gain additional insight into your important business data quickly and effectively. Download the whitepaper today! http://www.sqlmag.com/go/whitepapers/doubletake/reportingservices/?code=DEVMid0901
~~~~ eLibrary Short Takes ~~~~
Confused by SQL Server 2005's Many Editions? Help Has Arrived Although differences in SQL Server 2000 editions can be confusing, implementing a production database boils down to three choices: the Enterprise Edition, the Standard Edition, and Microsoft SQL Server Desktop Engine (MSDE). With SQL Server 2005, the implementation choices have grown substantially more complicated. More so than in any previous release, the different SQL Server 2005 editions have a clear delineation of features that address the needs of distinct customers. However, new customers need to be careful to get the right version. Learn about the available editions and how to choose the one that will best meet your needs in the article "Making Sense of the Editions" in the September issue of SQL Server Magazine. You can read this article at http://www.sqlmag.com/Article/ArticleID/92800/sql_server_92800.html .
White Paper Describes How SMBs Can Protect Their Information Help your small or midsized business protect one of its most valuable assets--business information. Easily store, manage, protect, and share information by using hardware designed with the needs of your business in mind. Manage IT without the large staff and extensive training--learn how today! http://www.windowsitpro.com/go/whitepapers/emc/smbs/?code=0830featwp
~~~~ Tech Talk ~~~~
Glad You Asked: Two Sides of the Same Coin by Bill Sheldon, bills@interknowlogy.com
Q: Earlier this year, you wrote the article "Source Control Basics: Shelving, Branching, and Merging" ( http://www.sqlmag.com/Article/ArticleID/50216/sql_server_50216.html ) in which you made it clear that you weren't a fan of merging changes in source control. I agree. I recently installed Team Foundation Server (TFS) and set it up to be our corporate source-control library. Soon thereafter we found that multiple developers could, by default, access the same source file at the same time. Then at check-in, they were suddenly presented with a requirement to merge these changes. In some cases, the merge was relatively painless. In other cases, the merge was painful and has introduced errors. How do we disable this default?
A: I received several email messages about the "Source Control Basics: Shelving, Branching, and Merging" article. Another reader had wrote and said, "In your article 'Source Control Basics: Shelving, Branching, and Merging,' you claim that merging is bad. I completely disagree. My organization couldn't function effectively if multiple people weren't working on the same source files." As you can tell, these two readers' merging experiences and opinions are diametrically opposed. The good news for the first reader is that you can avoid the situation entirely. When you install TFS, the default is to allow for shared check-out of code files. This means that if developer Andrew has started editing a file on his local machine, then developer Betty also starts independently editing the same file on her machine, TFS, by default, lets them. Andrew and Betty might be completely unaware that someone else is editing the file because TFS doesn't tell them when a file is already checked out. However, one of the developers will become aware of the situation during check-in. Suppose that Betty finishes editing the file first. She checks in her code with no problem. But when Andrew goes to check in his code, TFS will stop the check-in process and ask him to merge the changes. At this point, he'll generally have a couple options related to merging. The first option is to allow TFS to automatically merge the changes. When this option appears, it means that the developers who had simultaneously checked out the source file had changed different lines of code. From TFS's standpoint, this type of merging is easy, but selecting this option isn't risk free. For example, Andrew and Betty might have both added the same line of code, but Andrew put his line of code at the top of a function whereas Betty put her line of code at the bottom of the function. Because they put the same line of code at different locations, TFS will include two copies of that line of code, which is an error waiting to happen. The second option is to use the Merge Tool to manually merge changes. The bad news is that one developer (Andrew in this case) gets stuck with extra work. The good news is that the Merge Tool is fairly powerful. The tool highlights those changes it feels incapable of merging so that the person merging the code can select the change he or she wants to apply. That person can actually edit the resulting choice. In theory, being able to manually merge changes sounds great. In the real world, however, I've found that manually merging changes can result in new errors and lost changes. In one instance, a client started experiencing problems after a mere 40 hours of development time. The problems started within the first day or two, but reached a head on the day of software cutoff. We had to spend so much time merging one developer's changes that the cost of making those changes to the application doubled. Some developers also claimed their changes were lost because of merging. The net result was chaos at a time when we were trying to manage what should have been a simple software cutoff scenario. Because of this experience and similar experiences with other clients, our policy as of last week is to always turn off shared check-out. Here's how to disable shared check-out: Within Team Explorer (aka Visual Studio 2005) go to the Team menu. (You'll have this menu only if you've installed Team Explorer and are connected to a TFS server.) Select Team Foundation Server Settings, then the Source Control File Types option. A dialog box listing a variety of file types will appear. This dialog box has three columns, the first two of which contain the name of the file type (e.g., VB Files) and file extensions associated with that type of file (e.g., .vb). In the third column, which is labeled File Merging, you can specify whether you want to allow shared check-outs for that file type. To change the value in this column, click the Edit button. In the dialog box that appears, clear the "Enable file merging and multiple check out" check box. That's it. You've now prevented multiple check-outs for files of that type. Even if a developer specifically requests a shared check-out, TFS won't let it happen.
Tech Tips Show on the Road Again Cross-platform experts from Scalability Experts and Solid Quality Learning will present interoperability tips to DBAs and IT professionals who work with SQL Server or Oracle or in a one-day roadshow that kicks off September 7 in Washington, D.C. Sponsored by Oracle Magazine, Windows IT Pro, HP, Intel, and Microsoft, the show will feature information about the Windows 64-bit platform for database computing, an under-the-hood tour of SQL Server and Oracle, an overview of deploying highly available SQL Server and Oracle databases, guidelines for using SQL Server business intelligence on the Oracle platform, and a research-based session about how IT professionals can prepare for the changing database job market. The roadshow will visit 12 cities between September 7 and October 24: Washington, D.C.; Boston; Columbus, Ohio; Chicago; St. Louis; Houston; Irvine, Calif.; San Francisco; Phoenix; New York; Atlanta; and Seattle. For complete agenda and speaker information, go to http://www.windowsitpro.com/roadshows/sqloracle/
Letters to the Editor What's on your mind? Let us know at kbemowski@windowsitpro.com.
~~~~ Info to Go ~~~~
Microsoft Tech-Ed: Developers Four days will take you months ahead of the game! Get deep-dive technical training, information, and community resources that focus on building software solutions with Microsoft development tools. Visit the Website for more information, and register before the Early Bird deadline of 29 September 2006 to save 300 euros. 7 - 10 November 2006, Barcelona, Spain http://www.microsoft.com/europe/teched-developers/
Gear up for TechX World Roadshow Hear first-hand from leading interoperability experts, vendors, and peers at this exclusive one-day event. You'll learn about managing OS interoperability, directory migration, data interoperability, and much more. This event provides in-depth information on how Windows and other systems cooperate with each other. http://www.techxworld.com/?code=0830emailannc
Does your company have $500,000 to spend on one email discovery request? Join us for this free Web seminar to learn how you can implement an email archiving solution to optimize email management and proactively take control of e-discovery--and save the IT search party for when you really need it! Live Event: Tuesday, September 12 http://www.windowsitpro.com/go/seminars/symantec/itsearchparty/?partnerref=0830emailannc
You know you need to manage your email data; how do you do it? What steps are you taking? What additional measures should you enact? What shouldn't you do? Learn the answers to these questions and get control of your vital messaging data. Download the free eBook today! http://www.windowsitpro.com/go/ebooks/ilumin/discovery/?code=0830emailannc
Dramatically simplify Exchange troubleshooting with an in-depth look at built-in troubleshooting tools and third-party applications. Join us as we analyze a typical troubleshooting process, address the problems with using standard tools, and learn how automated troubleshooting can solve these challenges. Live Event: Thursday, September 14 http://www.windowsitpro.com/go/seminars/zenprise/simplifyexchange/?partnerref=0830emailannc
Invitation for VIP Access For only $29.95 per month, you'll get instant VIP online access to ALL articles published in Windows IT Pro, SQL Server Magazine, and the Exchange and Outlook Administrator, Windows Scripting Solutions, and Windows IT Security newsletters--that's more than 26,000 articles at your fingertips. Sign up now: https://store.pentontech.com/index.cfm?s=1&promocode=eu2768um
Save $40 off SQL Server Magazine Subscribe to SQL Server Magazine today and SAVE up to $40! Along with your 12 issues, you'll get FREE access to the entire SQL Server Magazine online article archive, which houses more than 2,300 helpful SQL Server articles. This is a limited-time offer, so order now: https://store.pentontech.com/index.cfm?s=9&promocode=eu2168us
~~~~ Hot Spot ~~~~
SQL Server Guide to Clustering Alternatives Want the convenience of a server cluster without the expense? Learn about server cluster alternatives that provide high availability, preventative maintenance, and fallover capabilities at pricing that fits your budget. http://www.sqlmag.com/go//whitepaper/neverfail/sqlclustering/?code=DEVHot0901
~~~~ New and Improved ~~~~ Send information about your developer-related products to products@sqlmag.com
Software Lets You Manage the Architecture of .NET Projects Lattix announced the release of Lattix LDM for .NET, software that uses a Lightweight Dependency Model (LDM) approach to formalize, communicate, and control the architecture of .NET projects. With the LDM approach, you can analyze the architecture in detail, edit the structure to create what-if scenarios, and specify design rules to formalize and communicate that architecture to the entire development organization. The software lets you map architecture to actual code as well as test architecture and detect architectural violations while coding. The software also offers refactor architecture. Lattix LDM for .NET starts at $495 for the Professional Edition. A free evaluation license is available. For more information, contact Lattix at 978-474-5022 or sales@lattix.com http://www.lattix.com
~~~~ Contact Us ~~~~
About Developer .NET Perspectives -- bills@interknowlogy.com About the newsletter -- letters@sqlmag.com About technical questions -- http://www.sqlmag.com/forums About product news -- products@sqlmag.com About your subscription -- Developer_dot_NET_update@sqlmag.com About sponsoring an UPDATE -- contact Richard Resnick, rresnick@sqlmag.com, or Lisa Kling, lkling@sqlmag.com
To ensure that future email messages you receive from Developer UPDATE aren't mistakenly blocked by antispam software, be sure to add Developer_dotNET_UPDATE@lists.sqlmag.com to your list of allowed senders and contacts.
Developer UPDATE is brought to you by SQL Server Magazine, the only magazine devoted to helping developers and DBAs master new and emerging SQL Server technologies and issues. Subscribe today. https://store.pentontech.com/index.cfm?s=9&promocode=eu215xdb
Manage Your Account You are subscribed as %%$email%%
You are receiving this email message because you subscribed to this newsletter on our Web site. To unsubscribe, click the unsubscribe link: %%UNSUB_HREF%%
You can manage your SQL Server Magazine email newsletter subscriptions by going to http://www.sqlmag.com/email .
You can view the SQL Server Magazine Privacy Policy at http://www.sqlmag.com/aboutus/index.cfm?action=privacy .
SQL Server Magazine is a division of Penton Media, Inc. 221 East 29th Street, Loveland, CO 80538, Attention: Customer Service Department
Copyright 2006, Penton Media, Inc. All Rights Reserved.