Monthly Archives: August 2012

  1. Exporting a Procedure for Backup

    Leave a comment

    August 31, 2012 by Mike Hillwig

    Working in my environment, I’ll get the occasional odd requirement pop up.  Frequently, clients will write a new version of …
    Continue reading

  2. Cranky Series: Database Servers are that and that alone

    3

    August 31, 2012 by Mike Hillwig

    Welcome to the last post in my How Not to be a Cranky DBA series. This has been a lot …
    Continue reading

  3. Cranky Series: Limit Access to the SA and Service Account Passwords

    6

    August 30, 2012 by Mike Hillwig

    I swear that some developers have no clue when it comes to security. At my former employer, we had a …
    Continue reading

  4. Cranky Series: Reserved Words are just that, Reserved.

    1

    August 29, 2012 by Mike Hillwig

    In the environment where I work today, we have a database called SECURITY. This makes me want to physically harm …
    Continue reading

  5. Cranky Series: Test Restores. Frequently.

    8

    August 28, 2012 by Mike Hillwig

    I’m a firm believer that while backups are important, restores are absolutely essential. Any DBA will be able to tell …
    Continue reading

  6. Motivating a Staff

    2

    August 27, 2012 by Mike Hillwig

    I’ve been in my current job for about 13 months now. They brought me in as a contractor in July …
    Continue reading

  7. Cranky Series: Set your File Growth Increments

    Leave a comment

    August 27, 2012 by Mike Hillwig

    One of the things that drives me nuts about working with Oracle DBAs is that they think installing and configuring …
    Continue reading

  8. Cranky Series: Your Server is NOT a Workstation

    1

    August 24, 2012 by Mike Hillwig

    Welcome to the Friday edition of my How Not to be a Cranky DBA series. It’s been a rough week, …
    Continue reading

  9. Cranky Series: Document. Document. Document.

    4

    August 23, 2012 by Mike Hillwig

    I used to hate writing documentation. Now I see it as a necessary evil of my job. But I also …
    Continue reading

  10. Cranky Series: Set Min and Max RAM

    2

    August 22, 2012 by Mike Hillwig

    Thank you, Brent Ozar. This is something I learned from Brent when he was talking about running SQL Server in …
    Continue reading