In This Issue:
Oracle’s acquisition of Hyperion Solutions could be the first in a series of aggressive acquisitions in the BI and applications markets. Will the outcome look like the final round of "Survivor?" If so, who will be the last vendor voted off the island?

New Instant Poll: Time for Daylight Saving
"Is your organization ready for the early shift to daylight saving time (DST) this weekend?" Go to the SQL Server Magazine home page and submit your vote for:

  • Yep, we’ve applied the updates we need and we’re all set.
  • Almost--we’re applying the updates now.
  • We just found out about the updates, but we’ll be ready.
  • No way--we can’t get all the updates done in time.
  • What? It’s DST already???

To ensure that future email messages you receive from SQL Server Magazine UPDATE aren't mistakenly blocked by antispam software, be sure to add SQLServerMag_UPDATE@lists.sqlmag.com to your list of allowed senders and contacts.

Our Sponsors, Who Help Support the Free Delivery Of This Newsletter:


March 1, 2007

1. Perspectives

  • Oracle’s Hyperion Acquisition: First of Many Consolidations?

2. SQL Server Watch

  • Product Watch: ComponentOne and TulaSoft

3. Hot Articles

  • Q&A: Building Dynamic IN Lists
  • SELECT TOP(X): Connection Problems
  • In a Nutshell: Oracle Buys Hyperion for $3.3B
  • Hot Threads: Help MrRobot learn how to reset performance statistics data on reports in the PTO forum, and help Berggy figure out how to edit packages in SSIS.

4. Events and Resources

  • SQL Server Magazine Connections
  • Windows + UNIX/Linux = You Need TechX World!
  • Keep Your Users Continuously Connected

5. Featured White Paper

  • Manage Email Content

6. Announcements

  • Introducing a Unique Security Resource
  • Grab Your Share of the Spotlight!

7. Web Community

  • http://www.sqlmag.com

Sponsor: Double-Take Software
Enhance SQL Server Reporting Services with Double-Take

SQL Server Reporting Services is an exciting way for organizations to gain access and insight into their important business data stored in SQL Server. Get an overview of how to increase your production server's performance by offloading Reporting Services to a secondary server. Download your free copy today!


1. Perspectives

Oracle’s Hyperion Acquisition: First of Many Consolidations? by Brian Moran, brian@solidqualitylearning.com

On March 1, Oracle acquired Hyperion Solutions in a deal valued at approximately $3.3 billion. The deal is expected to close in April 2007, assuming all the regulatory hurdles are surmounted. In response, we might expect other large vendors to pursue an aggressive acquisitions strategy, leading to even more consolidation in the business intelligence (BI) and applications market. What effect might this move have on the applications market in general, and particularly on the ERP and performance-management spaces?

Read the full article at:
http://www.sqlmag.com/Article/ArticleID/95412/sql_server_95412.html


Sponsor: AppDev
Learn SQL Server 2005 Analysis Services--Free CD or Download
Get started with SQL Server 2005 Business Intelligence with 3 FREE hours of award-winning AppDev learning for Analysis Services. Includes step-by-step instruction, hands-on labs, sample code, printable courseware (a $115 value).


2. SQL Server Watch

Product Watch
by Blake Eno, products@sqlmag.com

Build Outlook 2007-Style Scheduling Applications
ComponentOne released ComponentOne Studio Enterprise 2007, a suite of components for developing Windows, Web, mobile, and Asynchronous JavaScript and XML (AJAX)-enabled applications. To help you use minimal coding to build Microsoft Office Outlook 2007-style scheduling applications, the software features four new components: Schedule for .NET, Calendar for .NET, WebSchedule for ASP.NET, and WebCalendar for ASP.NET. Studio Enterprise 2007 also features ASP.NET AJAX 1.0 support. New WebGrid for ASP.NET features are also available, which includes banded headers and virtual scrolling. ComponentOne Studio Enterprise 2007 costs $999.99. For more information, contact ComponentOne at 412-681-4343 or 800-858-2739.
http://www.componentone.com

Compare the Schema and Data Between Two SQL Server Databases
TulaSoft announced SQL Examiner Suite 1.2, software that includes SQL Data Examiner 1.2 and SQL Examiner 1.6, which when used together, let you compare and synchronize the schema and data between two SQL Server 2005, 2000, or 7.0 databases. SQL Examiner Suite's newest feature lets you use backups as a source database when two databases are compared. This new capability provides a quicker comparison of a backed-up database with a working one and makes it easier to find the data you need because you don't need to restore old copies of data. You can also roll back data changes for several tables. Pricing for SQL Examiner Suite starts at $299.95.
http://www.sqlaccessories.com


3. Hot Articles

Q&A: Building Dynamic IN Lists
by Microsoft’s SQL Server Development Team

Q. When I execute the query

SELECT TOP 10 * FROM claim
    WHERE status IN ('paid, 'denied')

I get 10 rows. However, when I try to use a variable to specify the IN list, as in the following query, I receive no rows:

DECLARE @status varchar(20)
    SET @status='paid' +','+'denied'
    PRINT @status
    SELECT TOP 10 * FROM claim
    WHERE status IN (@status)

Why doesn't the second query return the same results as the first one?

Read the answer to this question today at
http://www.sqlmag.com/Articles/ArticleID/44939/44939.html

SELECT TOP(X): Connection Problems
You’ve got SQL Server connection problems--or you will, at some point. And of course the error message that you get says something unhelpful. As you troubleshoot, keep in mind these seven symptoms and solutions. Read this article today and post your comments at
http://www.sqlmag.com/Articles/ArticleID/94194/94194.html

In a Nutshell: Oracle Buys Hyperion for $3.3B
Kevin Kline takes a skeptical look at an article about the Oracle/Hyperion deal. Read the link and let Kevin know your opinion today at
http://www.sqlmag.com/article/articleid/95340/sql_server_blog_95340.html

Hot Threads:
Lend your expertise and find interesting tips from other users in our online forums at http://sqlforums.windowsitpro.com/web/forum/default.aspx?forumid=10.

New this week:


4. Events and Resources

SQL Server Magazine Connections
March 25-28, 2007, Orlando World Center Marriott. Dive into SQL Server 2005 and train with Microsoft architects and world-renowned developers and DBAs. Choose from 40 in-depth, no-hype sessions. Register early to save $100 and attend sessions of the co-located Visual Studio Connections and Microsoft ASP.NET Connections for FREE. For details, call 800-438-6720 or 203-268-3204.
http://www.sqlconnections.com

Windows + UNIX/Linux = You Need TechX World!
If you work in an environment that includes Windows plus UNIX or Linux, TechX World is the place to go for practical strategies and resources to add to your toolkit. This one-day technical training event will teach you how to make the most of open-source tools on Windows and how to manage and sync multiple directories. Register today! http://www.techxworld.com/registration/?code=epromo

Every business faces risk. Have you properly assessed your company's risk and put a focus on business continuity? Attend this free, on-demand Web seminar to learn how you can ensure seamless recovery of your key systems and keep your users continuously connected.
http://www.windowsitpro.com/go/seminars/neverfail/managingrisk/?partnerref=0305e&r

See the complete Windows IT Pro Network guide to Web and live events.


5. Featured White Paper

Do you want to block unwanted or undesirable email? Download this free white paper to learn how to manage the content of messages traveling your network.
http://www.windowsitpro.com/go/whitepapers/stbernard/cleanup/?code=0305featwp


Hot Spot: PolyServe
The Database Utility for SQL Server: A Highly Available, Flexible, Simple Approach to SQL Server Consolidation
Match your SQL Server database needs to your capacity and provide high availability without adding complexity and cost. Learn more about this unique approach to virtualization tailored to meet the demands of your mission-critical applications.


6. Announcements

Introducing a Unique Security Resource
Security Pro VIP is an online information center that delivers new articles every week on topics such as perimeter security, authentication, and system patches. Subscribers also receive tips, cautionary advice, direct access to our editors, and a host of other benefits! Order now at an exclusive charter rate and save up to $50!
https://store.pentontech.com/index.cfm?s=1&promocode=eu2572us

Grab Your Share of the Spotlight!
Nominate yourself or a peer to become IT Pro of the Month. This is your chance to get the recognition you deserve! Winners will receive over $600 in IT resources and be featured in Windows IT Pro. It's easy to enter--we're accepting April nominations now, but only for a limited time! Submit your nomination today.
http://www.windowsitpro.com/go/itpromonth


 

7. Web Community

 


Contact Us

SQL Server Magazine 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!

SQL Server Magazine is a division of Penton Media, Inc.
221 East 29th Street, Loveland, CO 80538
Attention: Customer Service Department

Copyright 2007, Penton Media, Inc. All Rights Reserved.