Exceptional PowerShell DBA Pt 3 - Collation and Fragmentation

Posted on Simple Talk See other posts from Simple Talk
Published on 11 February 2010 Indexed on 2010/03/16 17:01 UTC
Read the original article Hit count: 300

In this final look into his everyday essentials, Laerte Junior provides some useful scripts for the DBA that use an alternative way of error-logging. He shows how to use a PowerShell script to check and, if necessary, to defragment your indexes, write data to a SQL Server table, and change the collation for a table. Being an exceptional DBA just got a little easier.

© Simple Talk or respective owner

Related posts about Database Administration