Developer .NET UPDATE--Exciting Changes Integrated Into Reporting Services 2005--December 2, 2005

This Issue Sponsored By
This email newsletter comes to you free and is supported by the following advertisers, who offer products and services that might interest you. Please take a moment to visit these advertisers' Web sites and show your support for Developer .NET UPDATE.

Quest Software - Make SQL run fast...
http://ads.quest.com/SQLSerMagDeveloperNLTopSQLOptimizerforVisual120205

Protect and Ensure Your Data's Integrity
http://www.windowsitpro.com/go/whitepapers/NSI/dataintegrity?code=devmid122

Dashboard Development and Deployment - A Methodology for Success
http://www.windowsitpro.com/go/whitepapers/noetix/dashboard?code=devwatch12

Provide Secure Remote Access
http://www.windowsitpro.com/go/whitepapers/panda/mobileandwireless?code=devhot122

1. Developer .NET Perspectives

2. Events and Resources

3. Featured White Paper

4. Announcements

5. New and Improved

Sponsor: Quest Software - Make SQL run fast...
...Really, really fast. With SQL Optimizer for Visual Studio. Delivering high performing applications on time is a constant struggle. But it doesn't have to be. SQL Optimizer from Quest Software automatically identifies, rewrites and validates SQL statements to ensure SQL runs as fast as possible for immediate deployment. All with a tool that fully integrates with Visual Studio.

Easy to install and easy to use, SQL Optimizer improves your productivity, shortens application delivery time and improves end user and customer satisfaction. Download a free trial now:
http://ads.quest.com/SQLSerMagDeveloperNLTopSQLOptimizerforVisual120205

1. Developer .NET Perspectives

by Bill Sheldon, [email protected]

Exciting Changes Integrated Into Reporting Services 2005
In my last column "Leverage Reporting Services 2005 Independent of Your Database" (http://www.windowsitpro.com/articles/articleid/48629/48629.html), I discussed how Microsoft SQL Server 2005 provides a greatly enhanced version of SQL Server Reporting Services (which I'll refer to as Reporting Services 2005). As part of that discussion, I focused on the new Report Builder and how it can be configured to allow your end users to create the custom reports they want within a schema you define. However, as I noted, many of the more exciting changes in Reporting Services 2005 are associated with integration.

At its core, Report Services 2005's purpose is to let you integrate your SQL Server data with your application in the form of reports. To achieve this end, Reporting Services 2005 has been better integrated with Microsoft Visual Studio 2005. In particular, there's a Report Viewer in Visual Studio 2005 Professional Edition that you can freely redistribute with your Web and smart client applications. This is a very impressive move oriented more toward the smart client market. Because of this integration, you can even embed reports into your application in such a way that you don't need access to a Report Server. So, if your application is running on a laptop that doesn't have Internet access but does have local data or even objects, you can use these items to display a report on the client's machine.

However, the integration goes beyond the developer tools. Reporting Services 2005 integrates with other SQL Server 2005 components, such as SQL Server 2005 Analysis Services. As I noted in my "Get'em While They're Hot" column (http://www.windowsitpro.com/article/articleid/48370/48370.html), Microsoft has significantly enhanced Analysis Services. Reporting Services 2005 now supports accessing the Multidimensional Expression (MDX) queries used by Analysis Services. This extension is important to both Reporting Services 2005 and Analysis Services because it provides end users with a common interface for addressing both transaction and warehouse data.

Reporting Services 2005 is also integrated with Integration Services, another member of what I would call the SQL Server 2005 family of products. (A good diagram showing the relationships between SQL Server 2005's main components is available at http://msdn2.microsoft.com/en-us/library/ms141026(en-US,SQL.90).aspx.) But before I tell you about Integration Services, let me first be upfront by noting that SQL Server 2000 has DTS. DTS lets you transfer data at the most basic level between a SQL Server database and another database, which doesn't need to be a SQL Server database. From a programmatic standpoint, it's then possible to create a package that automates transfers, such as transfers of data between a transaction database and a data warehouse. Realistically, however, the capabilities of DTS are limited, and the packages are difficult to customize and keep running.

With SQL Server 2005, DTS got a makeover and a new name: Integration Services. The makeover includes many changes. For example, with DTS, there's a single area under Enterprise Manager in which you attempt to create, schedule, and run packages. Each package is supposed to not only move data but also control the conditions under which that data should move. More important, there is no good way to debug packages. With Integration Services, these tasks get broken into separate components, the first of which is a dedicated data flow engine.

The data flow engine lets you define one of three basic categories of objects: source, transformation, or destination. You can then build data flows that indicate how data should be translated during a move from the source to the destination. For more information about the data flow engine, check out the Data Flow Elements Web page at http://msdn2.microsoft.com/en-us/library/ms140080.aspx. When you read this Web page, you'll notice that it doesn't talk about how to program a set of tasks around the flow of data--that process is under the control of the second main component of Integration Services: the runtime and design environment.

The runtime and design environment lets you select one or more of the data flows you have defined, combine that data flow with control logic, and test run that package. This setup separates the definition of the data being moved and the transformation of that data from the conditions surrounding that data's move. In addition, this environment provides you with the ability to debug the package. For more information about the elements that you work with in this runtime environment, read the Control Flow Elements Web page at http://msdn2.microsoft.com/en-us/library/ms137681.aspx.

In my next column, I want to wrap up the year with a discussion of some of the many other features that SQL Server 2005 provides. The good news is that although it took almost 5 years to get here, this updated version of SQL Server has new features in every area, including the core database, T-SQL, Reporting Services, Analysis Services, Integration Services, Replication, Notification Services, and the Service Broker.

Sponsor: Protect and Ensure Your Data's Integrity
With the heightened awareness around national security and protecting important human and physical assets, having solutions that also protect your data's integrity is extremely critical. In this free white paper you'll learn the important ways you can ensure the integrity of your application's data, particularly with intradependent field like SQL Server and Oracle.
http://www.windowsitpro.com/go/whitepapers/NSI/dataintegrity?code=devmid122

2. Events and Resources

(brought to you by SQL Server Magazine)

Get the Facts About Deploying SQL Server 2005!
SQL Server experts will present real-world information about administration, development, and business intelligence to help you put SQL Server 2005 into practice and how to use its new capabilities to improve your database-computing environment. Receive a one-year membership to PASS and one-year subscription to SQL Server Magazine. Register now at:
http://www.windowsitpro.com/roadshows/sqlservereurope/index.cfm?code=1130emailannc

Scripting Doesn't Have To Be Boring
Subscribe today to Scripting Central and get a down-and-dirty technical, yet lighthearted look at scripts and the people who write them. You'll also get tools for and tips on how to write scripts for a variety of Windows applications, such as Exchange Server and SQL Server. Sign up today!
http://www.windowsitpro.com/email

Are You Really Prepared for Disaster Recovery?
Join industry guru Liam Colvin in this free Web seminar and get the tips you need to validate your disaster recovery data. You'll learn if your backup and restore data is worth staking your career on, what type of geo-clustering is right for you, which response to use in crisis situations, and more!
http://www.windowsitpro.com/go/seminars/disasterrecovery/?partnerref=1130emailannc

Upgrade to Analysis Services 2005
Get the tips and tricks you'll need to upgrade to Analysis Services 2005, including possible upgrade and migration scenarios, pre-planning steps, running the new Analysis Services migration wizard, and more. Plus discover what steps need to be completed after the migration process is complete and explore some of the new features of Analysis Services 2005.
http://www.windowsitpro.com/go/seminars/analysisservices/?partnerref=1130emailannc

Plan and Implement Highly Available Exchange Systems
Learn about the concepts behind high availability Exchange server planning. Plus, discover how to properly assess the business drivers that affect how you craft your Service Level Agreements. You'll get the tips you need to understand the various options available to you for planning and implementing highly available Exchange systems including: Fault Tolerant design, clustering and what uptime really means! Register today at:
http://www.windowsitpro.com/go/seminars/exchange/?partnerref=1130emailannc

3. Featured White Paper

Integrating Fax Servers in MFP Environments
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=1130emailannc

2005 Watch: Dashboard Development and Deployment - A Methodology for Success
Business information carries little value unless it reaches the right person at the right time. This free white paper tells you what you need to know to remain competitive while improving the speed and quality of decision-making. Learn how a well-designed dashboard can provide critical information to decision makers, enable them to monitor the health of your organization and bring immediate ROI to your business.
http://www.windowsitpro.com/go/whitepapers/noetix/dashboard?code=devwatch122

4. Announcements

(brought to you by SQL Server Magazine)

Want to Become a VIP Subscriber?
Become a VIP subscriber and get continuous, inside access to ALL of the online resources published in Windows IT Pro magazine, SQL Server Magazine, Exchange and Outlook Administrator newsletter, Windows Scripting Solutions newsletter, and Windows IT Security newsletter - that's over 26,000 articles at your fingertips. You will also get a valuable one-year print subscription to Windows IT Pro and two VIP CDs (includes the entire article database on CD, delivered twice per year). Don't miss out ... sign up now:
https://store.pentontech.com/index.cfm?s=1&promocode=eu275cuv

SQL Server Magazine Monthly Online Pass = Quick Answers
Sign up for a Monthly Online Pass and get online access to ALL the authors, articles, tools, and helpful resources published in SQL Server Magazine, including exclusive subscriber-only content. You'll have 24/7 access to a database of more than 2300 SQL Server articles that will give you all the answers you need, when you need them. BONUS--Includes the latest digital issue of SQL Server Magazine. Sign up now for just US$5.95 per month:
https://store.pentontech.com/index.cfm?s=9&promocode=eu215bus

5. New and Improved

(by Karen Bemowski, [email protected])

Software Extends Reporting Services 2005's Capabilities
Dundas Software released Dundas Chart for Reporting Services, an extension for SQL Server 2005 Reporting Services. Based on the Dundas Chart for .NET engine, Dundas Chart for Reporting Services gives IT professionals working with Reporting Services access to many new chart types, such as funnel, pyramid, range, Gantt, doughnut, radar, polar, Pareto, and histogram charts. Dundas Chart for Reporting Services is integrated directly within the Visual Studio Toolbox and has interfaces that are familiar and easy to navigate, making the learning curve minimal. You can write Visual Basic .NET or C# code against the charts object model for advanced customization, such as custom painting, extending data analysis, and appearance customizations. For more information, contact Dundas Software at 416-467-5100, 800-463-1492, or [email protected].
http://www.dundas.com

Development Tools Integrate with Visual Studio 2005
Compuware released new versions of two DevPartner products: DevPartner Studio 8.0 and DevPartner Fault Simulator 1.5. These new releases offer full integration with Microsoft Visual Studio 2005. In addition, DevPartner Studio 8.0 offers several new tools, including Performance Expert (provides a holistic view of application performance), DevPartner Fault Simulator SE (provides fault simulation capabilities), a system comparison utility (compares an application's system-level settings over time to pinpoint defects due to settings), and a data-export tool (lets users save data in XML format). DevPartner Fault Simulator 1.5 lets developers quickly locate software defects in error handling code by simulating errors and monitoring the response in both Windows .NET Framework-based and native Windows applications. For more information, contact Compuware at 313-227-7300 or 800-521-9353.
http://www.compuware.com

Hot Spot: Provide Secure Remote Access

It may be tempting to deploy a WiFi wireless access point or offer PDAs or laptops to your roaming employees so they can work from virtually anywhere. In this free white paper you'll get the important security implications you should consider before you do so.
http://www.windowsitpro.com/go/whitepapers/panda/mobileandwireless?code=devhot122

Contact Us

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

View the SQL Server Magazine Privacy Policy
http://www.winnetmag.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 2005, Penton Media, Inc. All Rights Reserved.