Category Archives: SQL Server

Posts on Microsoft SQL Server.

Collecting Current Performance Monitor Data on Remote Servers with PowerShell

As an admin of systems, people will come to me on a regular basis an ask me “so and so server is slow, what’s wrong with it??”, as if expecting me to have that information right in front of me. … Continue reading

Posted in Powershell, SQL Server | Tagged , , | 1 Comment

Beware the unmanaged VM snapshots

So, it happened. After 3 years and 4¬†months in my current position, we have corruption! Every DBAs nightmare, right? Now, before I go any further, good planning won the day, and no data was harmed during the making of this … Continue reading

Posted in SQL Server | Tagged , , , | Leave a comment

Keep up to date with CMS and registered servers, using PowerShell

Introduction Working for a large company with multiple SQL instances can be a lot of fun, a challenge, overwhelming, a headache, a great motivator for automation. You choose. For me automation is the best answer here, working with hundreds of … Continue reading

Posted in Powershell, SQL Server | Tagged , , | Leave a comment

Automating SQL Backup verification testing with PowerShell

Introduction Talk to any person responsible for a database, no matter what platform, and ask them what is their most important responsibility, I would hope that all of them would list backups at the top of their list. Managing these … Continue reading

Posted in Powershell, SQL Server | Tagged , , , , , , | Leave a comment

Analyzing SQL Agent job activity using PowerShell

From time to time, it is up to DBAs and sysadmin’s to prove themselves innocent of charges that ‘they’ are killing the entire [insert core infrastructure system here] with “their” system activity. Recently, we have had some serious problems on … Continue reading

Posted in Powershell, SQL Server | Tagged , , , , | 2 Comments

Making life easy with PowerShell Functions

In my last blog, I showed you how to quickly update the Log retention for SQL server, and made it look even easier by using a Profile loaded function that gets me an instance of a SQL server SMO object … Continue reading

Posted in SQL Server | Tagged , , , , | Leave a comment

Changing Log file retention using PowerShell

I love SQL Server. No matter how long you play with it, there is always a little setting here and there that I did not know about, or had forgotten over the years. This morning Mr Denny clued me into … Continue reading

Posted in SQL Server | 2 Comments