Tag Archives: sql

  1. Crystal Reports Formula for MSDB Dates and Times

    3

    September 10, 2009 by Mike Hillwig

    As a DBA, I find myself spelunking through data and often having to present it in a somewhat human-friendly format. …
    Continue reading

  2. Backing Up for my Primary/Secondary Environments

    8

    September 8, 2009 by Mike Hillwig

    Every environment is different, and that means everyone does backups differently. I thought I’d talk about how I do it …
    Continue reading

  3. Using sysjobhistory to Find What’s Running Longer than Usual

    3

    September 8, 2009 by Mike Hillwig

    We all have SQL Agent jobs that run periodically. Wouldn’t it be nice to know that something ran longer than …
    Continue reading

  4. An Object by Any Other Name

    Leave a comment

    September 8, 2009 by Mike Hillwig

    In my career, I’ve seen a lot of database objects. And I’ve seen a lot of names, both good and …
    Continue reading

  5. Giving Microsoft Access a Seat at the Table

    2

    September 2, 2009 by Mike Hillwig

    Ask any DBA what they think of Microsoft Access, and you’ll rarely see a smile. Perhaps you’ll get a laugh, …
    Continue reading