Manage By Delegation


Powershell might be a great skill if you need to manage lots of instances.

More and more SQL Server instances are being deployed all the time. In fact, with the ease with which we can build a new virtual machine (VM) through snapshotting and cloning, it seems that many administrators are finding that the number of servers for which they are responsible might be doubling or tripling.

Even moving to the cloud doesn’t completely remove the need for some administration of your data and databases, though it does require you to rework the type of administration that you perform. I foresee more hybrid solutions over time, which will require DBAs to not only manage data, but help analyze the financial impacts of moving data (and analysis) to, or back from, the cloud.

In SQL Server 2008 we had the chance to begin managing our servers through a set of declared rules with  Policy Based Management (PBM). I haven’t seen that feature take off, and it seems relatively few people are using PBM to manage their servers. I think it’s a great platform for ensuring that your instances are conforming to certain rules, though I think there is a bit of creativity needed to ensure that this system works well for you.

Powershell is becoming integrated into all Microsoft products. Virtually everything in SQL Server, perhaps even every thing by now, can be managed through Powershell scripts that access the SMO objects. I hear various people say that Powershell is a critical skill for DBAs of the future. I’m not sure of that, but I do think it will be used more and more if you have the need to perform repeated actions on multiple servers. Whether you use it now or not, it doesn’t hurt to learn how it works and what it can do for you.

It just might be the tool to make your job easier as you get more and more instances to manage, something that seems to happen more and more.

Steve Jones

The Voice of the DBA Podcasts

We publish three versions of the podcast each day for you to enjoy.

About way0utwest

Editor, SQLServerCentral
This entry was posted in Uncategorized and tagged , , . Bookmark the permalink.

1 Response to Manage By Delegation

  1. Chris Yates says:

    Steve, interesting enough you touched on two topics that hit close to home with me. VM spin-ups and PBM. We have recently initiated PBM company wide with over 66 servers and 1200 DB’s. It’s a nice way for me to get a dashboard report in the AM of a set of policies such as last good backups etc.

    VM’s seem to be coming up all around me. I’ve started doing some research on tuning aspects of a VM and SQL. If you have any advice it would be greatly appreciated.


Comments are closed.