Tag Archives : powershell


Better Living Thru Powershell: Update Statistics in Parallel

As part of a project I’m currently involved with, we’re migrating a database to SQL Server 2008 and performing some internal updates to the schema and data. Once the database portion of the upgrade is complete, we’d like to update all database statistics before continuing. On a large database, updating all statistics with a full […]

powershell

But I don't want to point and click...

Using Powershell to Deploy Performance Monitor

As good little DBAs, we should be gathering baseline statistics for our database servers. These stats can give us insight into what’s changed when performance is suddenly in the toilet. They can also provide a basis for determining what systems can be consolidated, downsized, or virtualized, which has become quite the topic of discussion with […]


Do you have enough disk space?

So, as I’ve mentioned in the past, I have an inventory database where I store information on our various SQL Server installations.  It has instance data (versions, editions, patch levels, collation settings, etc), database information (compatibility level, creation date, collation, recovery model, the backup location, etc.), and more.  I also use it to track database […]

growth3

breakup

Dear SSIS

Dear SSIS, You and I have had this relationship for a little while now. This arrangement. We see each other only occasionally, usually when one of us needs something. On the surface, it seems to work perfectly, but if we’re honest with ourselves and each other, we’d admit there are some problems we simply can’t […]