Tag Archives: PowerShell

Get SQL Server Service Accounts with WMI

Posted on September 25, 2012 by DBAduck 1 Comment

Today I was tasked with retrieving the SQL Server Service accounts to validate them in Active Directory.  I wanted a simple way to get them and show the account names for each SQL Server service.  I knew that you could … Continue reading →

Powershell, SMO, SQL Server , ,

SMO and Index Fragmentation

Posted on July 7, 2012 by DBAduck Leave a comment

When working with SMO and Indexes there are times that you want to get the fragmentation of this particular index.  In SMO there is a method on the Index called EnumFragmentation.  When you call this method, there is a bug … Continue reading →

Powershell, SMO , , ,