• I started working with the SMO as a object in C# years back and found it very useful. The things you can do with it in the programming world are great, so there is no suprise at all that PowerShell using the SMO has taken hold and has a prominent place.

    As to many instances and few DBA's there is a coming problem. Because there are applications or servers that use databases that require little or no maintenance except for an install script and infrequent update scripts or procedures, some in management feel that all databases are or should be that easy. Their expectation is that one DBA can juggle an unlimited number of servers. However when a DBA or a business reaches that tipping point and mindlessly runs past, the problem becomes real.

    Yes we will be called to manage more, and more diverse installs and platforms. But the number of objects juggled is limited. Not in the mind of some but in reality there is a limit.

    Not all gray hairs are Dinosaurs!