Subscribe to SQL Server Magazine: http://lists.sqlmag.com/t?ctl=1F11E:285886


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.

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 SQL Server Magazine UPDATE.

Idera
http://lists.sqlmag.com/t?ctl=1F120:285886

AppDev Products
http://lists.sqlmag.com/t?ctl=1F123:285886

Symantec Corporation
http://lists.sqlmag.com/t?ctl=1F116:285886


January 26, 2006

1. Perspectives

  • December Books Online: Refreshed? Or not...
  • 2. SQL Server 2005 Watch

  • Ensure Counter-Data Logging for SQL Server 2005 Analysis Services
  • 3. News & Views

  • Microsoft Provides Proxy Server Setup for SQL Server 2000
  • Results of Previous Instant Poll: Wanna Read a Wiki?
  • New Instant Poll: Using Analysis Services
  • 4. Events and Resources

  • Take the Pop Quiz
  • Gather Compliance Evidence Across Multiple Systems
  • Optimize Windows Server
  • Extend Backup and Restore for SQL Server 2005
  • 5. Featured White Paper

  • Learn About Real-Time Information Management
  • 6. Peer to Peer

  • Hot Tip: SANs: Always Better Than DAS?
  • Hot Article: TOP Troubles
  • In a Nutshell: JDBC Driver Update
  • Hot Threads
  • 7. Announcements

  • Get Full Online Access to SQL Server Magazine
  • Celebrate the New Year with Windows IT Pro
  • 8. New & Improved

  • Identify Web-Application Vulnerabilities
  • Extend the Functionality of Visual Studio 2005 Controls
  • Sponsor: Idera
    Free SQL Server Performance Monitor from Idera

    SQL Server performance dragging? Idera's free SQLcheck software will monitor the performance of your SQL Server database, the hardware, and the operating system. Monitor performance any time--all from a convenient and attractive "dashboard" or screensaver. Put critical SQL diagnostic info at your fingertips today! Download Idera's FREE SQLcheck now!
    http://lists.sqlmag.com/t?ctl=1F120:285886

    1. Perspectives


  • December Books Online: Refreshed? Or not...

  • by Brian Moran, brian@solidqualitylearning.com

    Two weeks ago, I wrote about the December 2005 SQL Server 2005 Books Online (BOL) refresh, emphatically recommending that you upgrade ASAP and check out the large amount of new information it contains. I also commented on the great job the SQL Server User Education team (which brings us BOL) did in including new tags to ensure that it's easy and practical to quickly find information that's been modified or is brand new. But then a weird thing happened: I started getting emails from readers saying, "Sounds great, but where the heck is the info?" Multiple readers confirmed that they had downloaded the latest and greatest version, but that the new version seemed to be exactly the same as the old version. Weird.

    I checked a new machine that I had just built and saw the problem. Digging a bit more, I saw that the digital signature timestamp on the "new" version had the same value as the RTM version of BOL. Hmmm. The mystery deepened.

    Now to be honest, it would be a bit embarrassing for a SQL Server expert and columnist (me) to not even be able to figure out how to upgrade BOL, so I have to admit that I was a bit hesitant to ask too many people at Microsoft. I eventually convinced myself that I was in fact smart enough to install BOL and that it simply wasn't working. Here's what seems to have happened. The December version of BOL had the same file name as the original RTM version of BOL, which led to a problem in which some of the ISPs responsible for managing Microsoft downloads were caching the wrong file. This mistake created an "eenie-meenie-miney-moe" situation in which most folks were getting the correct version but a small percentage of people were getting the incorrect version.

    Checking the title bar of the BOL menu is the easiest way to confirm whether you have the new version or the old; the new version clearly says "December 2005" in parentheses. If your title bar doesn't say December, you have the original version.

    Another way to determine which version you have is to simply look for some of the missing content. For example, the December BOL has "New and Updated Books Online Topics" as the first topic under the "What's New in SQL Server" heading. Don't have that topic? Well then, you don't have the latest version.

    The MSDN online version of BOL is the updated version. Microsoft has fixed the download anomaly, so you can reliably download the correct version from http://lists.sqlmag.com/t?ctl=1F118:285886 . If you think you downloaded the December refresh, you might want to check to make sure that you have the "real" new version. It's possible that you downloaded the new version and installed it properly, but ended up with the original RTM verbage.


    Sponsor: AppDev Products
    Learn SQL Server 2005 Now--Get a FREE Training CD!

    Start learning SQL Server 2005 today with cutting edge training from AppDev. Get a FREE SQL 2005 training CD from our new course (a $115 value). Click the link below for your FREE SQL Server 2005 training.
    http://lists.sqlmag.com/t?ctl=1F123:285886


    2. SQL Server 2005 Watch


    Ensure Counter-Data Logging for SQL Server 2005 Analysis Services
    Imagine that you're working on a Windows XP-based computer and you use Performance Monitor to collect data from SQL Server 2005 Analysis Services performance counters. You try to log the counter data by using the performance logs and alerts. However, when you start to collect data, you notice that the counter data isn't logged and one or more events in the event log inform you that an error has occurred. This problem occurs because the Performance Logs and Alerts service (Smlogsvc.exe) doesn't have sufficient permissions to access the performance counter DLL for SQL Server 2005 Analysis Services. The Microsoft article "Event ID: 1023 occurs, and counter data is not logged when you use Performance Monitor to collect data from SQL Server 2005 Analysis Services performance counters" explains how to resolve this problem by granting the Read and Execute permission to the Network Service account on the performance counter DLL for SQL Server 2005 Analysis Services. Read the entire article at
    http://lists.sqlmag.com/t?ctl=1F121:285886


    Sponsor: Symantec Corporation
    Learn the commonalities across multiple compliance regulations and standards to optimize your environment and save time and money.
    http://lists.sqlmag.com/t?ctl=1F116:285886


    3. News & Views


    Microsoft Provides Proxy Server Setup for SQL Server 2000
    SQL Server can operate transparently with Proxy Server to prevent unauthorized access to your internal network. When you use this configuration, you don't have to connect the computer running SQL Server directly to the Internet. Thus, the packet-filtering features of Proxy Server protect SQL Server. You can configure Proxy Server to permit or deny inbound SQL Server access to specific users, services, ports, and IP domains. Microsoft provides the steps for setting up this configuration in the article "How to Set Up SQL Server with Proxy Server." You can read the complete article at
    http://lists.sqlmag.com/t?ctl=1F12B:285886

    Results of Previous Instant Poll: Wanna Read a Wiki?
    "Do you use one or more wikis as a primary research tool?" Here are the results from the 74 votes:

  • 8 % Yes, I refer to wikis regularly.
  • 4 % Yes, and I also contribute to wikis.
  • 23 % Yes, but only occasionally.
  • 27 % No, I don't use wikis.
  • 38 % No, I don't know what a wiki is.
  • New Instant Poll: Using Analysis Services
    "Are you using Analysis Services?" Go to the SQL Server Magazine home page ( http://lists.sqlmag.com/t?ctl=1F12A:285886 ) and submit your vote for

  • Yes, we've been using it for years
  • Yes, we've been using it for a few months
  • Yes, we've just gotten started with it
  • No, but we plan to use it in the future
  • No, and we have no plans to use it
  • 4. Events and Resources


  • Put your SQL clustering skills to the test for a chance to win an iPod Nano. Take the pop quiz today!

  • http://lists.sqlmag.com/t?ctl=1F124:285886

  • WEB SEMINAR: Learn to gather evidence of compliance across multiple systems and link the data to regulatory and framework control objectives.

  • http://lists.sqlmag.com/t?ctl=1F111:285886

  • WHITE PAPER: Optimize your existing Windows Server infrastructure with the addition of server and storage consolidation software and techniques.

  • http://lists.sqlmag.com/t?ctl=1F112:285886

  • WEB SEMINAR: Learn how to leverage new features in SQL Server 2005 to greatly extend your existing backup and restore capabilities.

  • http://lists.sqlmag.com/t?ctl=1F117:285886

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

  • http://lists.sqlmag.com/t?ctl=1F126:285886


    5. Featured White Paper


  • Evaluate the costs of losing information and learn what real-time information management means and how to accomplish it in your business.

  • http://lists.sqlmag.com/t?ctl=1F113:285886


    6. Peer to Peer


  • Hot Tip: SANs: Always Better Than DAS?

  • by Brian Moran, brian@solidqualitylearning.com

    Contrary to popular belief, SANs aren't necessarily the best solution for a SQL Server system that must support high-end I/O on a budget. It's true that SANs offer advanced features for I/O and storage management, and they can be configured to offer extremely high levels of availability and performance. But it's generally harder to configure a SAN correctly than it is to use DAS. And usually, the cost of a direct-attached I/O solution is much less than the cost of buying a SAN that has the same number of disks that offer comparable cache and performance levels. This means that you can often end up with more spindles for the same price by using DAS rather than a SAN. Read this tip today at
    http://lists.sqlmag.com/t?ctl=1F114:285886

  • Hot Article: TOP Troubles

  • Although the T-SQL TOP option in SQL Server 2005 doesn't conform to the ANSI SQL standard, it nonetheless meets some important practical needs of SQL Server users; In his January T-SQL 2005 column, Itzik Ben-Gan kicks off a series in which he explores TOP's limitations; suggests an alternative, more robust and complete implementation of TOP; and discusses options available in SQL Server 2005 that address TOP's shortcomings. Read this article today and post your comments at
    http://lists.sqlmag.com/t?ctl=1F115:285886

  • In a Nutshell: JDBC Driver Update

  • Many people in the database field work with some pretty strange combinations, such as Java against SQL Server or .NET against Oracle. In this week's blog "JDBC Driver Update," Kevin Kline lets you know how to get the latest release of Microsoft's SQL Server 2005 JDBC Driver, a tool that can be helpful for shops that need interoperability. Read about the new driver release and let Kevin know your opinion of its potential today at
    http://lists.sqlmag.com/t?ctl=1F11A:285886

    Hot Threads: Check out the following hot threads, and see other discussions in our 30 SQL Server forums.
    http://lists.sqlmag.com/t?ctl=1F11F:285886

    SQL Server 2005 General Discussion: Migrating from Beta 2
    http://lists.sqlmag.com/t?ctl=1F10D:285886
    T-SQL: Conditional Cursor Fetch
    http://lists.sqlmag.com/t?ctl=1F110:285886
    Performance: Testing Execution Time Increases During WHILE Loop
    http://lists.sqlmag.com/t?ctl=1F10F:285886
    OLAP/Data Warehousing: OLAP Environment Best Practice
    http://lists.sqlmag.com/t?ctl=1F10E:285886

    Hot Spot


  • Business Communications Trends: 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://lists.sqlmag.com/t?ctl=1F119:285886

    7. Announcements


  • Get Full Online Access to SQL Server Magazine

  • Order a Monthly Online Pass now and get INSTANT access to all articles, tools, and helpful resources published on SQLMag.com, including exclusive Web content. You'll have 24 x 7 online access to the SQL Server Magazine article database (which includes more than 2300 articles) and get the latest digital issue of SQL Server Magazine delivered to your inbox. Order now for just $5.95 per month:
    http://lists.sqlmag.com/t?ctl=1F11B:285886

  • Celebrate the New Year with Windows IT Pro

  • You won't want to miss any of Windows IT Pro's upcoming 2006 issues! Subscribe now and discover the best ways to plan for Longhorn, the need-to-knows of VBScript, ways to make sense of SQL Server 2005, the 10 Security Tools You Can't Live Without, Vista launch essentials, and much more. You'll save $40 off the full cover price and gain exclusive access to the entire Windows IT Pro online article database FREE. Subscribe today:
    http://lists.sqlmag.com/t?ctl=1F11C:285886

    8. New & Improved


    by Blake Eno, products@sqlmag.com

    Identify Web-Application Vulnerabilities
    SPI Dynamics released WebInspect 5.8, a Web-application security-assessment product that now supports Asynchronous JavaScript and XML (AJAX) software-development technology. SPI Dynamics also released Assessment Management Platform (AMP) 2.0, a solution for managing, tracking, and measuring Web-application security risk throughout a distributed environment. AMP integrates directly with WebInspect and extends its ability. WebInspect users can consolidate assessment information and risk management into a single database. In addition, AMP provides WebInspect users with centralized control and oversight of the application risk-assessment process. For more information about WebInspect 5.8 or AMP 2.0, contact SPI Dynamics at sales@spidynamics.com, 678-781-4800, or 866-774-2700.
    http://lists.sqlmag.com/t?ctl=1F129:285886

    Extend the Functionality of Visual Studio 2005 Controls
    Infragistics announced NetAdvantage 2005 3.0 for Visual Studio 2005, a presentation-layer toolset for your Windows Forms, ASP.NET, and Tablet PC applications. This release extends the functionality of Visual Studio 2005 by including WinEditors that extend the columns in the Windows Forms grid to give you improved data-input capabilities. NetAdvantage is also Extensible HyperText Markup Language (XHTML) compliant and will simplify deployment of your ASP.NET applications. In addition, new DataBinding, ASP.NET Theming, and Smart Tags provide tighter integration with Visual Studio 2005. For more information, contact Infragistics at sales@infragistics.com or 800-231-8588.
    http://lists.sqlmag.com/t?ctl=1F128:285886

    Contact Us


  • About the newsletter--letters@sqlmag.com
  • About SQL Server Perspectives--brian@solidqualitylearning.com
  • About technical questions--http://www.sqlmag.com/forums
  • About product news--products@sqlmag.com
  • About your subscription--sqlupdate@sqlmag.com
  • About sponsoring SQL Server Magazine UPDATE--Richard Resnick, rresnick@sqlmag.com or Lisa Kling, lkling@sqlmag.com
  • 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.
    http://www.windowsitpro.com/rd.cfm?s=9&code=eu215xsL

    View the SQL Server Magazine Privacy Policy.
    http://www.windowsitpro.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.