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."

  • Speed up your Team Builds

    Over the past few years, a few of my clients have deployed Team Foundation Server Proxy to improve the performance of their remote/distributed teams. It boosts network performance by caching copies of source control files in a remote location, local to the developer needing the files but away from the main source control location. In short, the proxy helps each user avoid a costly download of the files to their workspace across the slower connection.

    So why wouldn't this work for Team Build?

    In today's VSTS chat, I asked if anyone had done this. I should have expected that Buck Hodges would have, and even blogged about it.

  • View the latest VSTS customer evidence from Microsoft

    Still trying to decide if Team System is right for you and if you can afford it. I would say you can't afford *not* to have it. Check out this list of case studies from other companies and teams who agree with me.

    Thanks to Rob Caron, for putting together this consolidated list of the "top" Visual Studio Team System case studies. They support a wide range of propositions by showcasing real customers who have gone through the adoption process and have great stories to tell.

  • Visual Studio Team System Web Access Power Tool - Available for Download!

    Microsoft just released their Team System Web Access Power Tool (formerly known as TeamPlain). This is a Web interface to Team Foundation Server.

    If you have team members that don't want Visual Studio/Team Explorer installed on their desktop, but they still want to participate with the project lifecycle, this is a great, web-based approach to getting everyone connected quickly/easily. Here are some of the features:

    • Add new work items or edit existing ones
    • Work with any type of work item, including custom ones
    • Add new work item queries or edit existing ones
    • View, download, upload, check-in and check-out documents on SharePoint team portal
    • View reports, export as PDF or Excel
    • Browse source control repositories, download files, view changesets, diffs, histories, and annotated views
    • View build results, start or stop builds
    • Search for keywords in work items
    • Authentication Modes: Integrated Windows Authentication or Forms Based Authentication (Recommended to use with SSL)

    Read more about it in Brian Harry's blog posting.

  • Come chat with the Visual Studio Team System product team - today!

    Join members of the Visual Studio Team System product group to discuss features available in Visual Studio Team Foundation Server, Architecture Edition, Development Edition, Database Edition, and Test Edition. In addition, discuss what's new in Visual Studio 2008 Beta 2.


    Microsoft will be holding two sessions:

    • Join the chat on Wednesday, August 1st, 2007 from 10:00am - 11:00am Pacific Time. Add to Calendar
    • Join the chat on Wednesday, August 1st, 2007 from 4:00pm - 5:00pm Pacific Time. Add to Calendar
  • Removing pingback, trackback, and comment spam from dasBlog

    Ok, I finally got fed up with all of the spam in my historical dasBlog postings. It's really embarrassing to send a link to a a colleague, only to have them snicker at all of the spam comments and trackbacks.

    For those of you who don't know what a trackback is, it's basically an acknowledgement that enables authors to keep track of who is linking to, or referring to their articles. When used properly, trackbacks form a communication link between the two blogs, so that new comments on one blog can basically ping the other, allowing readers to easily follow discussions on both. The problem is that spammers have abused this mechanism and bloggers end up with trackbacks and pingbacks to various gambling, herbal medication, and adult sites.

    Earlier this year I joined the ranks, and disabled my trackback and pingback services in dasBlog. I then followed Scott Hanselman's advice on using Akismet spam blocking service.

    The big effort was then how to cleanup the <Comment> and <Trackback> elements that were spam, so, like others before me, I built a tool to assist with this.

    1. Download or to your hard drive
    2. Edit the blacklist.txt to include your own blacklisted URLs *
    3. Backup your existing feedback files: \content\*.dayentry.xml
    4. Run the ScrubDasBlog utility, specifying the path to your \content folder and the path to your blacklist.txt file, for example:

    scrubdasblog c:\inetpub\wwwroot\mydasblog\content c:\scrubdasblog\blacklist.txt

    * If you have predominately more SPAM comments and trackbacks in your dasBlog history, then you can generate a starter blacklist by going into your \content sub-folder and typing the following:

    type *.xml | find "AuthorHomepage" > blacklist.txt

    After you generate the blacklist.txt file, you should remove any good sites and remove any duplicates, before running the ScrubDasBlog utility.

    I would recommend downloading the Source code version and reading through my code. Please comment on any improvements you might make.

  • VSTS &quot;How To&quot; 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.

  • Transcript from today's VSTS Chat

    Today's chat was well attended, with many experts and well over a hundred guests. The quests came fast and furious, with some great answers given by the experts. It seems people are really anticipating Orcas (and Rosario) for those features that didn't make it into v1.

    I have captured the entire transcript (both expert and guest chats) in this PDF document.

    Note: this is the raw content, copied and pasted from the chat, so you are getting it "as is".

  • Transcript from today's VSTS Chats

    Today's chats were well attended, with many experts and well over a hundred guests. The quests came fast and furious, with some great answers given by the experts. It seems people are really anticipating Orcas (and Rosario) for those features that didn't make it into v1.

    I have captured the entire transcripts (both expert and guest chats) in this PDF document (for the 10am PST chat) and this PDF document (for the 4pm PST chat).

    Note: this is the raw content, copied and pasted from each chat, so you are getting it "as is".

  • Visual Studio Team System Chat – This Friday

    Join members of the Visual Studio Team System product group to discuss features available in Visual Studio Team Foundation Server, Team Editions for Architects, Developers, Database Pros, and Testers. In addition, discuss what's new in the in the Visual Studio code name “Orcas” Beta 1 releases for Team Suite and Team Foundation Server.

    Join the chat on Friday, April 27th, 2007 from 10:00am - 11:00am Pacific Time | Add to Calendar | Additional Time Zones


  • Visual Studio "Orcas" Beta 1 is out

    Yesterday, Microsoft's Developer Division (DevDiv) released beta 1 of Visual Studio "Orcas", which corresponds with the Connected Systems Division’s beta 1 release of the .NET Framework 3.5. Soma blogged this yesterday morning. Visual Studio "Orcas" enables developers and development teams to rapidly create Software + Services on the latest platforms, including the Web, Windows Vista, the 2007 Office System, and Windows Server "Longhorn".

    As usualy, one of the most common questions about Orcas is, "When will it ship?". Well, here's Microsoft's official/public timeline:

  • Orcas Beta 1 will ship "Before TechEd Orlando in early June." - done! (see below)
  • Orcas Beta 2 will ship "In the North American summer."
  • Orcas RTM will ship "Before the end of the year."

    BTW you can download the ready-to-go VPC images here (Team Suite) and here (TFS) of Orcas.

  • New, simpler AdventureWorks sample database

    Trainers and presenters have been wanting a sample database that is less complex than AdventureWorks, but more interesting than Northwind. Thanks to my friends at SolidQ for letting me know about AdventureWorksLT (Light) ...

    (Click to see a larger view)

    You can download AdventureWorksLT from CodePlex or Microsoft.

  • Integrating Team Foundation Server with Windows Sharepoint Services (WSS) 3.0

    Just to catch you up, Microsoft's Team Foundation Server v1.0 (released March 2006) only works with WSS 2.0. WSS 2.0 is the old version. WSS 3.0 is the new version, and launched with Microsoft Office 2007. It's full of great new features, but alas TFS won't integrate with it naturally. Even installing TFS SP1 won't get you there.

    Thanks to Brian Keller, a Technical Evangelist for Team System, who has published a document on how to integrate TFS with WSS 3.0. As Brian explains, keep in mind that this is a "release candidate" of guidance that will eventually be posted to MSDN.

    Now I've heard of a lot of things, but an RC of a guidance document?

  • Any SQL Injectors out there?

    SQL Injection attacks are a well know exploit of insecure database systems. If you don't know about SQL Injection, you can change that by visiting Wikipedia.

    If you feel like injecting some SQL into your site, you should visit the SQL Injection Cheat Sheet page for all of the approaches. As the author mentions, only MySQL, Microsoft SQL Server, (some) ORACLE, and (some) PostgreSQL are supported and that most of the samples are not correct for every situation.

    Happy hacking!

This Blog


Privacy Statement