THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Richard Hundhausen: The DBAgilist

This is a mirror of Richard Hundhausen's (aka The DBAgilist) blog "Tales from the Doghouse."

June 2007 - Posts

  • VSTS "How To" videos have gone live

    Bookmark this page. For the next several weeks, Scott Golightly (Microsoft Regional Director from Utah) and I will be publishing several instructional videos around Team System.

    Currently, there are two videos posted:

    • How Do I: Customize TeamPlain?
    • How Do I: Create Custom Work Items in Team Foundation Server?

    More coming each week. Stay tuned ...

  • Cool DBA Automation Jobs

    I saw a demo of these at Tech-Ed, and thought I would share with my friends.

    Essentially, the Database Operations team at Microsoft uses a suite of jobs on all their servers for performing backups, automated database maintenance, improve performance , and improving disaster recovery. I'm sure every SQL Server expert/consultant out there has his or her own bag of tricks, but Microsoft is finally sharing theirs.


    These SQL maintenance jobs provide automated tasks such as database or transaction logs backup, performing database optimization like Index defrag or update statistics, cleaning MSDB backup history and recycling the SQL error log. Each of these jobs runs stored procedures that are installed when the jobs are created.


    The following are the jobs get installed with this package.

    • SQLBackupAll
    • SQLBackupDiffAll
    • SQLBackupTranAll
    • SQLBackupChecker
    • SQLDBCCAll
    • SQLIndexDefragAll
    • SQLUpdateStatistics
    • SQLCleanupMsdbBackupHistory
    • SQLCycleErrorLog

    Download the automation jobs here, and then refer to the Word document inside.

  • Project Server 2007 VSTS Connector released

    This week Microsoft released the Visual Studio Team Foundation Server – Project Server 2007 connector as a CodePlex project. The project has been up for a few weeks, but is now being broadly advertised.


    The TFS-PS2007 connector is designed to integrate the project management capabilities of TFS with Project Server 2007. It's been developed by the Visual Studio Team System Rangers in response to significant customer demand for a connector solution. Future versions of Team System will have native integration with Project Server, in the meantime this Connector solution is the best way to integrate the two Microsoft products. This solution builds on the previous PS2003 VSTS Connector, published on GotDotNet.

This Blog


Privacy Statement