This Issue Sponsored By

Windward Reports
http://www.windwardreports.com/root.htm?source=dev.netupdate&id=1

XOSoft
http://www.windowsitpro.com/go/essential/xosoft/sqlserverha/?code=DEVMid0804

Sunbelt Software
http://www.windowsitpro.com/go/download/sunbelt/counterspy/?code=DEVHot080


In This Issue

Developer Perspectives

  • Coming Attraction
  • eLibrary Short Takes

  • Take the SQL Server Magazine Salary Survey
  • SQL Server Magazine Is Searching for Innovators
  • Secure Your Online Data Transfer with SSL
  • Tech Talk

  • Glad You Asked: Paradigm Shift Isn't About the Client Environment
  • For 'um Developers
  • Letters to the Editor
  • Info to Go


    Sponsor: Windward Reports

    Advanced Java/.NET Report Generation Tool Use MS Word as a report writer and generate PDF, HTML, RTF, TXT and XLS fast! Now completely enabled with charts and graphs. There's a way to save developers from the time consuming task of trying to design report templates that satisfy business owners and managers. Windward Reports enables any user to design their own reports using easy-to-use word processing programs. Windward Reports utilizes Microsoft Word, the word processing software that virtually everyone knows. Developers, free up your time. Download a demo today. http://www.windwardreports.com/root.htm?source=dev.netupdate&id=1


    Developer Perspectives


    by Bill Sheldon, bills@interknowlogy.com

    Coming Attraction
    Visual Studio 2005 Service Pack 1 (SP1) is coming to a Microsoft download center near you! You can expect this service pack to debut next month. However, to the best of my knowledge, Microsoft hasn't announced the complete contents of SP1. In fact, there hasn't been much discussion of Visual Studio 2005 SP1 at all. So, I thought I would mention a couple of the items that SP1 will include.

    The first item that I want to tell you about is the feature that actually triggered my search for more information about SP1. Back in May, Microsoft's ASP.NET team released a Visual Studio 2005 update that added a "new" ASP.NET project type: Web Application Projects. However, this project type isn't actually new in the sense that it's based on the Web Application model in the Microsoft .NET Framework 1.1, which Visual Studio .NET 2003 uses. The Web Application Project is a major departure from the Web Site Project type that ships with Visual Studio 2005. In a Web Application Project, a Web application is compiled as a single large executable. In a Web Site Project, a Web application consists of individual components are kept as separate components. This setup has a major advantage: You can easily update one component without needing to recompile and reship your entire Web application.

    In some ways, the Web Application Project will make migrating from .NET 1.1 to .NET 2.0 easier. Plus, the underlying implementation of the Web Application Project is essentially the same as that in Visual Studio .NET 2003, so this implementation will feel familiar to developers. However, despite these benefits, I'm not certain that a throwback to Visual Studio .NET 2003's Web application behavior (i.e., having the entire code base compiled into one binary file) is really a step forward. Breaking items into separate components that you can independently update is a major maintenance advantage.

    If you prefer having a Web application compiled into a single executable, you'll be glad to know that Visual Studio 2005 SP1 will automatically integrate the Web Application Project into your development environment. If you don't want to wait for SP1, you can download the update now at http://msdn.microsoft.com/asp.net/reference/infrastructure/wap/default.aspx. All the Visual Studio 2005 editions, except Visual Web Developer 2005 Express Edition, support the Web Application Project. For more information about the Web Application Project, check out Scott Guthrie's Web page at http://webproject.scottgu.com/Default.aspx.

    Scott runs the ASP.NET team in addition to several other .NET tools teams.

    The second SP1 item that I want to tell you about is Microsoft SQL Server 2005 Everywhere Edition (SQL Server Everywhere). In the article "An Introduction to SQL Server 2005 Everywhere Edition Community Technology Preview" (http://support.microsoft.com/?kbid=920700), Microsoft describes this item. This article is also where Microsoft announced in a roundabout way that Visual Studio 2005 SP1 will ship in September.

    SQL Server Everywhere is the rebranding of the intuitively named Microsoft SQL Server 2005 Mobile Edition (SQL Server Mobile). However, as the article notes, it's not just a rebranding; SQL Server Everywhere includes some new features. For starters, Microsoft removed the dependency on SQL Server 2005 or SQL Server 2005 Express Edition for desktop installations. More important, you'll be able to create a ClickOnce deployment package that includes a SQL Server Everywhere database. (For information about ClickOnce, see my column "Software Sector Is Seeing Another Paradigm Shift," http://www.sqlmag.com/articles/index.cfm?articleid=93041&.)

    The Microsoft article clearly notes that SQL Server Everywhere will be included in not only Visual Studio 2005 SP1 but also SQL Server 2005 SP2. Didn't know about SQL Server 2005 SP2? Join the club.


    Sponsor: XOSoft

    Learn the essentials of high availability for SQL Server 2005 - including cluster services, replication and log shipping.
    http://www.windowsitpro.com/go/essential/xosoft/sqlserverha/?code=DEVMid0804


    eLibrary Short Takes

    Take the SQL Server Magazine Salary Survey
    We need your help! SQL Server Magazine is launching its third SQL Server Magazine Industry Salary Survey, and we want to find out all about you and what makes you a satisfied database professional. When you complete the survey (about 10 minutes of your time), you'll be entered in a drawing for one of five $100 American Express gift certificates. Look for the survey results--and see how you stack up against your peers--in our December issue. To take the survey, go to
    https://websurveyor.net/wsb.dll/12237/SQLSalarySurvey06.htm

    SQL Server Magazine Is Searching for Innovators
    If you've developed a resourceful solution that uses SQL Server technology to solve a business problem, you qualify to enter the 2006 SQL Server Magazine Innovators Contest. Grand-prize winners will receive airfare and a conference pass to SQL Server Magazine Connections in Las Vegas, November 6-9, 2006, plus more great prizes and a feature article about the winning solutions in the January 2007 issue of SQL Server Magazine. The contest runs through September 1, 2006, so enter today.
    http://www.sqlmag.com/awards/?type=innovator

    Secure Your Online Data Transfer with SSL
    Increase your customers' confidence and your business by securely collecting sensitive information online. In this free white paper, you'll learn about the various applications of SSL certificates and their appropriate deployment, along with details of how to test SSL on your Web server.
    http://www.windowsitpro.com/go/whitepapers/thawte/ssl?code=0802featnl

    Tech Talk


    Glad You Asked
    by Bill Sheldon, bills@interknowlogy.com

    Paradigm Shift Isn't About the Client Environment
    Q: In your "Software Sector Is Seeing Another Paradigm Shift" column (http://www.sqlmag.com/articles/index.cfm?articleid=93041&), you mention that you see a new era emerging. I don't see this happening unless users become less sophisticated or the industry forces PCs with less processing power and less functionality on the unwary consumer. The fact that companies find it cheaper to support and deliver their products online doesn't necessarily mean the mainstream of society is going to want to be harnessed to the Internet and led by application service providers (ASPs) or ISPs. I do see a shift in the computing paradigm to products that install and function equally well on all platforms as the convergence of hardware and software continue. I also expect that mainstream users are going to become more jaded with the Internet and less inclined to spend time on the Web looking for services, patches, and information, which I suspect will reduce the amount of clutter we habitually encounter when trying to use the Internet. Serious providers are going to find that seasoned users return to Web sites more for ease of use and reliability than for fluff. Serious providers will also find that all the flash being served actually reduces the number of seasoned users who browse on their Web sites. Your thoughts?

    A: In part, I think you missed my point. I agree this paradigm shift isn't about the client environment. The desktop computer will be a permanent fixture in the foreseeable future. However, what I do see changing is the server environment. I see business executives becoming more jaded in regard to maintaining their own custom servers for such resources as corporate intranets and extranets. In other words, in the coming shift, fewer companies will try to maintain their own corporate data center. This shift will occur not only because of the cost of hardware and software licensing but also because of the challenges in keeping their private network secure and meeting legal requirements.

    Instead, I see business executives shifting responsibility for maintaining those resources to third parties. This is where Office Live will succeed in drawing its customer base. In the big picture, centrally managed applications actually fit the same pattern that you see with MySpace.com. MySpace.com doesn't replace the desktop computer used by tens of thousands of people. However, it does provide a third party that hosts and secures a central server that these users can use. And MySpace.com isn't alone. Sites such as Blogs.MSDN.com, TypePad.com, and Blogger.com also provide a central hosted environment with a generic framework that allows minimal customization. The result is that customers can essentially rent space instead of attempting to create and maintain their own custom Web server and site. Customers can even skip the server and work with a hosting provider for a custom Web site.

    To a certain extent, Microsoft makes it sound like Office Live is for consumers, but in all honesty, consumers aren't looking for the equivalent of hosted Microsoft SharePoint Portal Server. However, businesses have found SharePoint's sweet spot: a functional intranet/extranet appliance. Being able to have someone else maintain SharePoint Portal Server makes it that much more of an appliance, and paying the equivalent of about $3 per employee for that service is cheap. Let's face it--the environment costs less per employee than Internet service or, more important, a single IT staff member to maintain your own bought and paid for servers and software (which requires a new license every couple years). Therein lies the reason for the big shift.

    In regard to what consumers want, I think it differs from what companies want. Consider that Microsoft recently started charging consumers to download a copy of the beta version of Office 2007. Don't believe me? Check out the Download 2007 Microsoft Office System Beta 2 Web site at http://www.microsoft.com/office/preview/beta/download/en/default.mspx. According to this Web site, Microsoft is now in a "cost recovery" mode for future downloads. However, you can still take a free test drive, which doesn't require you to download or install any products. I can't imagine that it's cheaper to provide a server to run the test drive environment than to download beta copies, yet Microsoft is charging consumers to download beta software, warts and all. I think Microsoft would like to see consumers take on products like Office in a hosted environment, but I agree with you in that I don't think that it's a viable market. We might soon find out.

    For 'um Developers

    New Blog by T-SQL Guru Itzik Ben-Gan
    If you use T-SQL in your development projects, you'll want to check out Itzik Ben-Gan's new "Puzzled by T-SQL" blog. Currently, Itzik has posted the three-part blog titled "Quaere Verum - Clustered Index Scans." Besides covering technical topics, Itzik plans to include his famous puzzles as well as personal insights. You can find his blog at
    http://www.sqlmag.com/blog/index.cfm?action=blogindex&DepartmentID=1016

    Letters to the Editor
    What's on your mind? Let us know at kbemowski@windowsitpro.com.


    Info to Go

    Cross-Platform Data Roadshow
    Oracle professionals will cover key concepts about Oracle and SQL Server in enterprise database computing. This event provides invaluable information about the benefits of 64-bit computing on the Windows platform, SQL Server BI for Oracle, high-availability proof points for SQL and Oracle, and much more.
    http://www.windowsitpro.com/roadshows/sqloracle/?code=0802emailannc

    Did you know that wasteful processes can drive the cost of document management and output to as high as 10-15% of your company's annual revenues? Download this free white paper today and find out how you can use fax solutions to achieve cost control, security and compliance, increased workflow, and more.
    http://www.windowsitpro.com/go/whitepapers/Faxback/faxing?code=0802emailannc

    Learn how to gather evidence of compliance across multiple systems and link the data to regulatory and framework control objectives. View this on-demand Web seminar today!
    http://www.windowsitpro.com/go/seminars/bindview/multiregcompliance/?partnerref=0802emailannc

    Total Cost of Ownership--TCO. It's every executive's favorite buzzword, but what does it really mean, and how does it affect you? In this podcast, Ben Smith explains how your organization can use virtualization technology to measurably improve the TCO for servers and clients.
    http://www.windowsitpro.com/go/podcast/hp/virtualization/?code=0802emailannc

    Uncover Essential Windows Knowledge Through Excavator
    Try out the ultimate vertical search tool--Windows Excavator. Windows Excavator gives you fast and thorough third-party information while filtering out unwanted content. Visit http://www.winexcavator.com today!

    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

    Are you protected company-wide against spyware, keyloggers, adware, and backdoor Trojans? Test the state of the art scanning engine that uses threat signatures from multiple sources to track down the culprits that antivirus solutions alone can't protect you against. Download your free 30 day trial of CounterSpy Enterprise today!
    http://www.windowsitpro.com/go/download/sunbelt/counterspy/?code=DEVHot0804


    Contact Us


  • About Developer .NET Perspectives -- bills@interknowlogy.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
  • Developer .NET 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

    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.