PowerShell

Exceptional PowerShell DBA Pt 3 - Collation and Fragmentation

  • Article

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.

2010-02-26

2,552 reads

Blogs

ASF 034: Alex Yates interview (part 1)

By

Introduction Alex is a Data Platform MVP who loves DevOps. He’s has been helping...

Blog .NET for Apache Spark UDFs Missing Shared State

By

The Problem When you use a UDF in .NET for Apache Spark, something like...

Migrating SQL Server container images to the Github Container Registry

By

A couple of months ago Docker announced that they would be implementing a 6...

Read the latest Blogs

Forums

How to improve the performance of insert?delete?update sql statement

By 892717952

as it was said in the title, which we should pay attention to when...

TDE Drama

By Brandie Tarvin

My workplace uses a 3rd party key management system as an encryption provider for...

The Best Query

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Best Query

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The Best Query

See possible answers