Tag Archives: administration

T-SQL Tuesday #44–Second Chances

Posted on July 9, 2013 by way0utwest

It’s T-SQL Tuesday time again. This is the monthly blog party, started by Adam Machanic. If you’d like to participate, write a post on the topic and publish it on the second Tuesday of the month. If you’d like to … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

SQL Server Should Work for Us

Posted on June 19, 2013 by way0utwest

I ran across a post the other day from someone that was trying to find out why their maintenance plan failed. This person had received a failure notice from SQL Agent, which is good. We should all be aware of … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on SQL Server Should Work for Us

Losing Data

Posted on June 17, 2013 by way0utwest

Most of us that work as data professionals hate the idea of losing data. When the developer calls and says his test database is gone and backups were never set up, we may shrug our shoulders and offer to help … Continue reading →

Posted in Editorial | Tagged , , | Comments Off on Losing Data

Quickly Copy Data

Posted on June 6, 2013 by way0utwest

There’s no magic solution for many of the problems we face in SQL Server. Whether we are trying to maintain concurrency under high write loads, restore databases quicker, or ensure extremely high availability we need to make trade-offs. Sometimes those … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Quickly Copy Data