Tag Archives: administration

T-SQL Tuesday #62 – Healthy SQL

Posted on January 13, 2015 by way0utwest

The invitation for T-SQL Tuesday this month comes from Robert Pearl. It’s called HealthySQL and it’s a topic I like. I’ve spent a lot of time in my career being proactive with SQL Server databases, and keeping them healthy is … Continue reading →

Posted in Blog | Tagged , , | 1 Comment

Selling Automation to Ops

Posted on January 12, 2015 by way0utwest

The DevOps movement isn’t new in some companies. It’s the same coordination and teamwork that has existed for a long time between the development and operations staffs. Developers take advantage of the skills in Operations to get standardized environments for their work, … Continue reading →

Posted in Editorial | Tagged , , , , | 1 Comment

Multiple Backup Files

Posted on January 9, 2015 by way0utwest

I’ve been writing a little PowerShell lately that will back up databases, move files, and restore them. I’m often testing things, and having scripts to quickly and easily move files is very handy. After one of my posts recently, a … Continue reading →

Posted in Editorial | Tagged , , | 2 Comments

Test Your Situation

Posted on January 7, 2015 by way0utwest

I gave a talk on Transparent Data Encryption (TDE) recently and a number of people in the audience were using the feature. However when I asked how many of them had restored a TDE database, not all hands remained up. … Continue reading →

Posted in Editorial | Tagged , , , | Comments Off on Test Your Situation