Playing a Role in SQL Server's BI Future
      by Brian Moran, brian@solidqualitylearning.com

It sounds a bit weird to be talking about "future generations" of SQL Server when SQL Server 2005 is so new and many of you are still using SQL Server 2000. However, Microsoft developers are already hard at work designing and planning the next version of SQL Server, code-named Katmai, and the business intelligence (BI) team is already looking for end users to provide feedback and insight for SQL Server 2005 that will help shape future versions of SQL Server.

Microsoft recently sent out a survey to some people in the BI community asking for feedback. When I received the survey, I contacted Microsoft and asked if it would be interested in hearing from SQL Server Magazine UPDATE readers. Of course, Microsoft was thrilled with the idea.

The Microsoft SQL Server Design and Usability team is actively seeking BI users to participate in several user-research activities centered on the BI capabilities of SQL Server. The activities are designed to help the team better understand the responsibilities, pain points, and needs of BI users and shape the direction of future releases of SQL Server. Microsoft is looking for feedback from a broad subset of BI users who are interested in the following topics:

  • Data Warehouse Design
  • Data Warehouse Management/Administration
  • Analytics
  • Report design, etc.
  • Data Mining
  • ETL Design/Management

    It would be much too easy for me to comment on the fact that the Microsoft SQL Server team is collecting feedback in a non-structured, data-entry format with no domain checking of data fields to ensure data integrity; so I won’t. Instead, I encourage you to copy the survey form below into an email message, include "SQL Server BI Survey" as the Subject of the email, and send your responses to Lisa Mueller, who is managing this process at Microsoft, at
          lmueller@microsoft.com

    If you work with SQL Server BI features and are interested in participating in the research activities, please fill out the following brief questionnaire to help us get a better sense of your role, interaction with the product, and availability. The data you provide to our team will be extremely valuable in helping them design better products and help users like you be more productive.

    Name:

    Title:

    Company:

    Location:

    Email Address:

    Phone (optional):

    Years of Experience with SQL Server:

    SQL Server Tools used:

    Upcoming Activities

    Type an X next to the activities you would be most interested in.

  • Survey (Ongoing)
  • Benchmark Usability Study (After March 15th)
  • Additional Concept testing (TBD)

    Please indicate which venue would work better for you.

  • Microsoft Redmond, WA Campus
  • Your company site
  • Remote via LiveMeeting (or similar tool)


    New & Improved


          by Blake Eno, products@sqlmag.com

    Monitor and Analyze Backup and Recovery Operations

    Idera announced SQLsafe 3.0, a backup and recovery solution for SQL Server 2005 and 2000 databases. This release provides a Web console so that +you can monitor and analyze backup and recovery operations and view historical information. SQLsafe also features new encryption algorithms to speed your backup and recovery operations. In addition, SQLsafe supports SQL Server 2005 (34-bit and 64-bit) databases that run Intel Itanium 2 Processors and x64-based servers. Idera SQLsafe 3.0 starts at $995 per SQL Server instance. For more information, contact Idera at 713-533-5144 or 877-464-3372.
          http://www.idera.com

    Report On Your SQL Server Infrastructure

    Pearl Knowledge Solutions released SQLCentric 2.0, monitoring and alerting software for your SQL Servers. SQLCentric features new status counters that monitor the performance and logged events for your SQL Servers and report on CPU load status, buffer cache hit ratio, and blocked processes. The product also lets you use SQL or Windows authentication to monitor SQL Servers in non-trusted domains, demilitarized zones (DMZs), or firewalls. A free 30-day trial is available. For more information, contact Pearl Knowledge Solutions at rsp05@pearlknows.com, techsupport@pearlknows.com, or 917-499-7622.
          http://www.pearlknows.com