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.
Rapid Database Restoration Using LiteSpeed
http://ads.quest.com/SQLServerMagDeveloperNLTopLiteSpeedSS110405
Give Users a Web UI for Access Databases: Better Security and Manageability Will Follow
http://www.windowsitpro.com/whitepapers/oracle/htmlaccess/index.cfm?code=devmid1104
Increase Administration Efficiency by Consolidating SQL Server Infrastructure
http://www.windowsitpro.com/whitepapers/polyserve/dataclustering/index.cfm?code=DEVhot1104
1. Developer .NET Perspectives
2. Events and Resources
3. Featured White Paper
4. Announcements
5. New and Improved
Sponsor: Rapid Database Restoration Using LiteSpeed
LiteSpeed for SQL Server with Object Level Recovery (OLR) enables you to
rapidly recover only the specific database objects that you want, without
having to generate native SQL Server commands. From stored procedures and
users to indexes and primary and foreign keys, retrieve only the objects you
need. Now you can eliminate entire database restores through rapid, Object
Level Recovery of single stored procedures. Only from LiteSpeed and Quest
Software.
Download your free trial today
http://ads.quest.com/SQLServerMagDeveloperNLTopLiteSpeedSS110405
1. Developer .NET Perspectives
by Bill Sheldon, [email protected]
Get'em While They're Hot
Last week Microsoft unofficially announced that it had released Visual Studio 2005 and SQL Server 2005 (http://blogs.msdn.com/somasegar/archive/2005/10/27/485665.aspx). At that point, we all got to see the scalability of the Microsoft Developer Network (MSDN) download site as tens of thousands of developers all sought to download the products. (As a quick aside, don't forget to also download your free refactoring tools for Visual Basic .NET 2005 at http://www.devexpress.com/vbrefactor. Although Biztalk Server 2006 is sharing the November 7 launch with Visual Studio 2005 and SQL Server 2005, Microsoft hasn't yet released Biztalk Server 2006 on MSDN.)
Then, on Tuesday, November 1, MSDN essentially went offline for many subscribers as Microsoft started the process of transitioning to the new subscription models. I'm sure many of you will be affected by the new subscription models. For those of you still trying to decide which Visual Studio 2005 Team Edition you want to transition to, I stand by the recommendations I made in my June 3 column, "Which Team Edition Is Right for You?" (http://www.windowsitpro.com/article/articleid/46594/46594.html).
The good news is that the various versions of Visual Studio 2005 are definitely release quality. Thus far, I installed the Professional version without any of the Team System features. One nice surprise for me in transitioning one of my Visual Studio .NET 2003 projects is that Microsoft has provided a conversion wizard for the project files so the transition to the new version was almost completely painless.
SQL Server 2005 has a similar story. In addition to the updates to the core database and the inclusion of the Common Language Runtime (CLR), many of the products that build on SQL Server are going through major enhancements with this release. One such product is SQL Server 2005 Analysis Services. Analysis Services started to be a viable tool with SQL Server 2000. The 2005 release is starting to make this product available to an even larger customer base.
The basic idea behind Analysis Services is that as transaction data accumulates, it's possible to query for summary data. In some cases, the query is fairly straightforward. For example, a query for the total value of all sales for each month for the past 6 months is straightforward. Other queries can be more complex. An example of a complex query would be asking how many customers who purchased books also purchased music. What these types of queries have in common is that they're either time-consuming or difficult to ask with traditional SQL.
This is where Analysis Services comes in. Analysis Services are built around data warehouses called cubes. The cube provides data that has already been aggregated and associated with the original data. You can set up a cube based on one or more criteria that reference your transactional data. That way, when a user asks for data based on the past 6 months, the cube can retrieve precompiled answers for the first 5 months and even information for the current month. This might fully answer the query or there might be more data that has been added in your transaction database that hasn't yet been compiled into the cube. However, as new sales data for the current month is entered, Analysis Services has the ability to retrieve the updated data from your transactional database on the fly. For more information about the concepts underlying Analysis Services, I suggest starting with this page: http://www.microsoft.com/sql/analysis/overview.mspx.
Because Analysis Services uses precompiled summary data to speed complex queries, you can move down through the top-most summary level to lower levels. Continuing with my original example of 6 months' data, you could start with a view that showed sales per quarter, delve into the performance on a monthly basis, and from there go directly to the performance at a weekly, daily, or even hourly level. Eventually you might even go to the discrete transaction level, but that might be more appropriate if you're using a cube that includes a sales-by-location dimension. In that case, you might look at the sales for store A versus store B for a given month.
This ability to delve down into your business data is referred to as business intelligence. BI has two roles in an organization. Its first role is to help people understand what happened in the past. Its second role is to help people prepare for the future (e.g., help people set expected future sales) based on the historical information gathered. The people who need to carry out these BI tasks aren't really developers. They're business analysts who in the past would use a series of printed reports, then analyze that data and ask for details. With the release of SQL Server 2005, what we are seeing are ongoing improvements in the automation of this business analysis. A good example is the Microsoft Office Business Scorecard Manager 2005, a product that the Microsoft Office team is creating to leverage the power of Analysis Services. Still in the prerelease phase, you can get more information about the Business Scorecard Manager at http://office.microsoft.com/en-us/assistance/ha012225141033.aspx.
The key takeaway here is don't be blinded by low-level tools changes. Yes, there are numerous new features in Visual Studio 2005 and SQL Server 2005, but keep in mind that these new features are also going to let you build new classes of applications. If you're a database developer, now is the time to start thinking beyond the transactional database. By the way, one final aside: When installing SQL Server 2005, remember to use the Advanced button during the feature selection process so that you can get access to the new Adventure Works sample database and Data Warehouse.
Sponsor: Give Users a Web UI for Access Databases: Better Security and Manageability Will Follow
Controlling which users can concurrently work with your Access
data, not to mention tracking usage, can be a nightmare. You
don't have time to develop complex code to address the problem,
and you don't want users to install another application. Oracle
HTML DB lets you convert Access applications into Web
applications that can be used by multiple users concurrently.
Download this free white paper now to find out how!
http://www.windowsitpro.com/whitepapers/oracle/htmlaccess/index.cfm?code=devmid1104
2. Events and Resources
(brought to you by SQL Server Magazine)
The Main Event: CLR vs. T-SQL
The .NET Common Language Runtime (CLR) is bringing some very cool new
capabilities to SQL Server 2005, and T-SQL is stronger than ever. This free
Web seminar compares T-SQL and the CLR, including new features, pros and cons,
performance tests, and risks, along with some guidance concerning when to use
them. Register today to see Visual Studio in action and witness the staying
power of T-SQL.
http://www.windowsitpro.com/go/seminars/tsql/?partnerref=1102emailannc
Get Ready for the SQL Server 2005 Roadshow in Europe - Get the Facts About Migrating to SQL Server 2005!
SQL Server experts will present real-world information about
administration, development, and business intelligence to help you
implement a best-practices migration to SQL Server 2005 and improve your
database-computing environment. Receive a one-year membership to PASS and
one-year subscription to SQL Server Magazine. Register now.
http://www.windowsitpro.com/roadshows/sqlservereurope/index.cfm?code=1102emailannc
Microsoft IT Forum 2005, November 15-17, Barcelona, Spain
Microsoft's European conference for IT professionals on planning,
deploying, and managing the secure connected enterprise. Three days of
learning, one year of solutions. With a choice of 325+ Technical Learning
Sessions, increase your productivity and support your business with new
opportunities and ideas. See the Web site for registration information
http://www.microsoft.com/europe/msitforum
XML 2005: The reliable source for everything XML!
XML 2005, produced by IDEAlliance, where IT professionals gather to review
the latest in XML-related technologies and applications. Hear in-depth talks
from industry leaders. Visit the expo floor for the most advanced products
being offered today. Complimentary expo pass offered until 11/7!
http://www.xmlconference.org
All High Availability Solutions Are Not Created Equal--How Does Yours Measure Up?
In this free, on-demand Web seminar, you'll get the tools you need to
ensure your systems don't go down. You'll learn what solutions help you take
preemptive, corrective action without resorting to a full system failover,
that perform a non-disruptive, automatic switchover to a secondary server in
extreme cases.
http://www.windowsitpro.com/seminars/truehighavailability/index.cfm?code=1026emailannc
What Does It Mean to Be Compliant?
We've all heard about legal and regulatory requirements, but there are
other types of compliance that might also affect you--specifically email
compliance. In this free Web seminar, you'll get insights into compliance and
policy issues that you need to know about, as well as suggestions on what to
look for when implementing your compliance strategy, and more. Register
today!
http://www.windowsitpro.com/go/seminars/compliance/?partnerref=1102emailannc
3. Featured White Paper
Microsoft SQL Server 2005 Analysis Services Migration
Microsoft SQL Server 2005 Analysis Services offers many performance
improvements and benefits for existing SQL Server 2000 Analysis Services
users. If you are planning a migration to Analysis Services 2005, you can't
afford to ignore this paper! Download your free copy now and get all the tips
and real-world examples you need to make migration faster and easier.
http://www.windowsitpro.com/go/whitepapers/proclarity/sqlserver2005?code=1102emailannc
4. Announcements
(brought to you by SQL Server Magazine)
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 over 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
The Windows Scripting Solutions Newsletter
The Windows Scripting Solutions newsletter is a "must have." Subscribe
today and get a 12-issue resource loaded with expert-reviewed downloadable
code and scripting techniques, as well as hundreds of tips on automating
repetitive tasks. You'll also get online access to the entire newsletter
archive (more than 500 scripting articles), including access to our popular
"Shell Scripting 101" series. This resource will help to save you time and
money. Order now:
https://store.pentontech.com/index.cfm?s=1&promocode=eu265aus
5. New and Improved
(by Karen Bemowski, [email protected])
ASP.NET Book Updated
O'Reilly released the third edition of Programming ASP.NET, by Jesse
Liberty and Dan Hurwitz. The updated book provides detailed chapters on
ASP.NET 2.0's new and improved controls, events, life cycle, and Web pages.
There's also a hands-on tour of Visual Studio 2005 and its Rapid Application
Development (RAD) techniques. Other topics new to "Programming ASP.NET 2.0"
include understanding the concepts fundamental to using Windows .NET
Framework 2.0; creating a consistent look and feel with master pages; adding
site navigation, including site maps and bread crumbs; and simplifying the
configuration and deployment of applications. The book costs $49.95. For more
information, contact O'Reilly at 707-827-7000, 800-998-9938, or
[email protected].
http://www.oreilly.com
Hot Spot: Increase Administration Efficiency by Consolidating
SQL Server Infrastructure
Consolidate Your SQL Server Infrastructure
Shared data clustering is the breakthrough consolidation solution for
Microsoft Windows servers. In this free white paper learn how shared data
clustering technology can reduce capital expenditures by at least 50 percent,
improve management efficiency, reduce operational expense, ensure high
availability across all SQL Server instances and more! Find out how you can
reduce the overall Total Cost of Ownership (TCO) for SQL Server cluster
deployments by as much as 60 percent over three years! Download your free
copy now.
http://www.windowsitpro.com/whitepapers/polyserve/dataclustering/index.cfm?code=DEVhot1104
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.
