SQL Server Magazine UPDATE, November 4, 2004--Extra Hour of Sleep

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.

This Issue Sponsored By

Just Released - Altova MapForce 2005

Free SQL Server 2000 Training!

Take Control of Your SQL Code with DB Ghost

November 4, 2004

1. Perspectives

  • SQL Server Agent Got an Extra Hour of Sleep, Too
  • 2. News and Views

  • Microsoft Fixes Reporting Services Trace Log File Growth Problem
  • Brussels SQL Server Day Draws 1007 Attendees
  • Results of Previous Instant Poll: SQL Server 2005 Webcasts
  • New Instant Poll: IT Employment Outlook
  • 3. Announcements

  • Now Is the Time to Subscribe to SQL Server Magazine
  • SQLMag.com Has What DBAs Need!
  • 4. Peer to Peer

  • Hot Tip: Remotely Installing a SQL Server Hotfix
  • Hot Article: XP SP2 and SQL Server
  • Hot Threads
  • 5. Events Central

  • SmartDBA Recovery Management Webinar
  • 6. New and Improved

  • Deliver Reporting Services Reports in Excel and Word
  • Reduce Recovery Time
  • Build Reports from Multiple Data Sources
  • Sponsor: Just Released - Altova MapForce 2005
    MapForce 2005 is the definitive tool for data integration and information leverage. Map any combination of XML, DB, flat file, and EDI data into XML, DBs and/or flat files. Connect to a DB & import/export data based on DB schemas. Generate code in XSLT 1.0/2.0, XQuery, Java, C++, and C#. Give your data direction...Download a FREE trial now!

    1. Perspectives

  • SQL Server Agent Got an Extra Hour of Sleep, Too

  •      by Brian Moran, [email protected]

    If you live in the United States, you likely had to remember to set your clocks back 1 hour last Sunday at 2 a.m. (except for those lucky folks in Arizona, most of Indiana, and Hawaii). By now, you've probably managed to change all your clocks—except that pesky one in your car dashboard—and enjoyed your extra hour of sleep. But did you know that SQL Server Agent also got an extra hour of sleep?

    SQL Server MVP Ron Talmage shared with me an interesting tidbit about how the change from Daylight Saving Time (DST) affects SQL Server Agent on servers that have the DST switch set on. By Sunday at 2:01 a.m. Pacific Standard Time (ST), Ron had spent the past hour verifying that no SQL Server Agent jobs scheduled to run at 2 a.m.—none on his local server, none on his remote servers—had run. The reason is that at 1:59:59.999 DST, all remaining scheduled jobs had Next Run Dates and Times of 2 a.m. or greater. So when the server time changed from 2 a.m. to 1 a.m., no scheduled jobs ran for 1 hour. This break happens in the Northern Hemisphere only and will recur this spring in the Southern Hemisphere.

    So, across the Northern Hemisphere, in time zones that "fell back" from DST to ST on October 31 and for SQL Servers whose server time is set to observe DST, all scheduled SQL Server Agent jobs stopped running for 1 hour Sunday. Put another way, in the United States, time zone by time zone Sunday, there was one time zone that had no scheduled SQL Server Agent jobs running during the hour starting at 2 a.m. DST. As 2 a.m. DST changed to 1 a.m. ST, in a sliding time scale from East Coast to West Coast, SQL Server Agent on DST servers didn't execute any scheduled jobs for an hour.

    For fun, Ron stayed up late and manually forced a job run during the repeated hour. Although the run shows up in the job history, the execution of the job didn't change the Next Run Date/Time.

    Did the time change affect any of your scheduled jobs? If so, you might have figured out the reason by now. And just to be safe, if you run jobs of any kind during the weekend, you might want to double-check that SQL Server Agent's extra hour of sleep didn't cause any problems, such as a missed backup, in your environment.

    2. News & Views

  • Microsoft Fixes Reporting Services Trace Log File Growth Problem
  • Microsoft has released a hotfix for a problem that affects SQL Server 2000 Reporting Services' trace log file. On a computer that's running Reporting Services, the size of the Reporting Services trace log file for the Report Server Windows service and the Web service might increase unexpectedly. The system might write hundreds or thousands of messages related to dbcleanup in the Reporting Services trace log file per second, quickly filling up your disk space. To learn more about this problem and the supported hotfix, read the Microsoft article "FIX: The Reporting Services trace log file size may increase unexpectedly" at

    Brussels SQL Server Day Draws 1007 Attendees
    Brussels SQL Server Day, an event produced by SQL Server Magazine and the Windows IT Pro Custom Events Group, drew 1007 attendees from 20 countries to the Kinepolis cinema complex in Brussels last week. Microsoft, Hewlett-Packard (HP), and Intel were the main sponsors, and 12 additional vendors participated in the on-site Solutions Expo. Attendees packed two theaters in separate tracks for developers and DBAs. Keynote speakers were SQL Server Magazine contributing editor Itzik Ben-Gan and Microsoft MVP William Vaughn. Ben-Gan, Vaughn, and other Microsoft, HP, and Intel speakers addressed developing Reporting Services applications, troubleshooting SQL Server resource bottlenecks, deploying 64-bit SQL Server machines, and manipulating XML data in SQL Server 2000.

    The day ended with cocktails, a question-and-answer panel led by Gert Drapers of the Microsoft SQL Server development group, and prize giveaways from various sponsors, including two Xboxes with games and copies of SQL Server 2000 with Reporting Services.

    Free SQL Server 2000 Training!
    Become a more efficient, effective developer with AppDev's award-winning self-study SQL Server training! See AppDev quality for yourself—download 3 hours of training immediately or request a CD-ROM by mail (each a $95 value) FREE! Click the link below for your FREE SQL 2000 Training!

  • Results of Previous Poll: SQL Server 2005 Webcasts

  • "Will you attend any of Microsoft's new SQL Server 2005 Webcasts?" Here are the results from the 108 votes (deviations from 100 are due to a rounding error):

  • 10%   Yes, I will attend all 15
  • 44%   Yes, I will attend some
  • 24%   I don't know yet if I will attend
  • 21%   No, I don't plan to attend any
  • New Instant Poll: IT Employment Outlook
    "What's the employment outlook for IT pros at your company in the coming year?" Go to the SQL Server Magazine home page ( http://lists.sqlmag.com/cgi-bin3/DM/y/eiCM0FgQMn0BRZ0KQO0Ao ) and submit your vote for

  • My company plans to add IT jobs
  • My company plans to maintain the number of IT jobs
  • My company plans to cut the number of IT jobs
  • My company has no IT jobs
  • 3. Announcements

  • Now Is the Time to Subscribe to SQL Server Magazine

  • Order SQL Server Magazine today and get 30% off the cover price! Along with these great savings, you'll receive free access to the online article archive (over 5 years of tips, tricks, and how-to instructions) and get the Microsoft SQL Server 2000 System Table Map Poster free! Subscribe now to take advantage of this limited time offer:

  • SQLMag.com Has What DBAs Need!

  • Visit the SQL Server Magazine Web site today and access a resource full of useful SQL Server content. Choose from thousands of tips, savvy solutions, up-to-date news, active forums, and endless how-to articles giving you answers you can use today to make your SQL Server systems run better and faster. Click here:

    4. Peer to Peer

    Hot Tip: Remotely Installing a SQL Server Hotfix
        by Microsoft's SQL Server Development Team, [email protected]

    Q. Can I install a SQL Server hotfix via a remote desktop session from a Windows XP workstation, or do I need to be on the SQL Server system to install the hotfix?

    Read the answer to this question today at

  • Hot Article: XP SP2 and SQL Server

  • Windows XP Service Pack 2 (SP2) solves some serious security problems but carries with it some connectivity issues for SQL Server users. XP SP2 is more than a set of bug fixes or a rollup of Microsoft's latest security patches. XP SP2 also adds many new features to XP and changes some of the system's default security settings. In his November editorial, "XP SP2 and SQL Server," Michael Otey walks through XP SP2's new features and their effects on SQL Server. Read this article today at

    Hot Threads: Check out the following hot threads, and see other discussions in our 30 SQL Server forums.

    Debugging .NET Code in a Compiled Assembly
    Reporting Services Reports Inaccessible from Internet
    Counting Query Cost
    User Access to the Master Database
    Testing for Fractions
    DTS: Importing from Excel

    Hot Spot

  • Take Control of Your SQL Code with DB Ghost

  • DB Ghost is the ONLY true database change manager for SQL Server on the market and makes one database the same as another every time, not just sometimes, but every single time. VSJ Magazine's review concluded that DB Ghost "...goes further than any rival software." Get your free evaluation copy:

    5. Events Central

  • SmartDBA Recovery Management Webinar

  • Can you meet your backup and recovery SLAs? Learn how in less than 30 minutes! In this brief, complimentary webinar, you'll find out how BMC Software SmartDBA Recovery Management helps you ensure system availability and lower IT costs. View it now!

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

    6. New & Improved

        by Dawn Cyr, [email protected]

  • Deliver Reporting Services Reports in Excel and Word

  • SoftArtisans announced the SQL Server 2000 Reporting Services Edition of OfficeWriter, software that lets end users design, publish, and deliver Reporting Services and ASP.NET reports directly from Microsoft Excel and Microsoft Word. OfficeWriter creates RDL files, but unlike Reporting Services' default Excel output, Excel-based reports from OfficeWriter retain all Excel features including pivot tables, Visual Basic for Applications (VBA) code, macros, advanced formulas, and charts. And without OfficeWriter, Reporting Services can't deliver reports in Word format. OfficeWriter-rendered documents preserve all of the Word features that the user's Word template contains. Through an integrated toolbar, users access a data source and insert data or text through merge fields and repeat blocks. Users can then save, preview, edit, and publish their reports to the Reporting Services server for distribution. The Reporting Services Edition of OfficeWriter is packaged with the Enterprise Edition of OfficeWriter 2.5, or you can purchase the product separately. Pricing for the product is per server CPU. For pricing details and other information, contact SoftArtisans at 877-763-8278.

  • Reduce Recovery Time

  • Idera announced SQLsafe 1.1, backup-and-restore software designed for enterprise-scale SQL Server implementations. The product provides compressed, encrypted backup; automated multiserver backup management; a central repository of backup and restore information; and rapid enterprisewide deployment. SQLsafe includes advanced compression, disk writing, and multithreading technologies that increase backup speeds and SQL Server availability. The variable-compression technology reduces the size of backup output files by as much as 95 percent, resulting in reduced storage costs and simplified backup-and-recovery strategies for very large databases (VLDBs). And an enterprise console interface and DynamicDeployment technology lets you start your restore operation in seconds, eliminating time wasted hunting for backup files, restore software CD-ROMs, and license codes. SQLsafe costs $995 per SQL Server instance and is available alone or as part of Idera's SQLsuite Advanced Edition. For more information, contact Idera at 713-523-4433 or 877-464-3372.

  • Build Reports from Multiple Data Sources

  • Metamatica Software announced MetaReport 2.0 for Windows, a report-building tool that lets you use multiple data sources to create reports. Users who work in heterogeneous environments can access data in SQL Server, Microsoft Access, Oracle, dBase, Paradox, InterBase, and other database platforms for reporting purposes. And users can deliver reports in a variety of formats, including text, comma separated value (CSV) files, XLS files, HTML, and PDF. This flexibility means you can build a report with MetaReport and process it later in Excel or another application, put it on the Internet, email it to a colleague, or make it part of a presentation. You can save report templates and even lock them to prevent anyone else from altering them. A single copy of MetaReport costs $99.95, and a free evaluation copy is available on the company's Web site. For more information, contact Metamatica Software.

    Contact Us

  • About the newsletter—[email protected]
  • About technical questions—http://www.sqlmag.com/forums
  • About product news—[email protected]
  • About your subscription—[email protected]
  • About sponsoring SQL Server Magazine UPDATE—Kate Silvertooth, [email protected]
  • 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.

    Manage Your Account You are subscribed as xxxxx. To unsubscribe from this email newsletter, click here mailto:[email protected]

    To make other changes to your email account such as changing your email address, updating your profile, and subscribing or unsubscribing to any of our email newsletters, simply log on to our Email Preference Center.

    View the SQL Server Magazine Privacy Policy.

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

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

    Hide comments


    • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

    Plain text

    • No HTML tags allowed.
    • Web page addresses and e-mail addresses turn into links automatically.
    • Lines and paragraphs break automatically.