Category Archives: SMO
Posted over on sqlblog.com about my speaking at the SQL Saturday. Hope to see you there.
This T-SQL Tuesday is about PowerShell and how I use it with SQL Server. There are many more posts to come about PowerShell and SQL Server but I thought I would cut my teeth on this T-SQL Tuesday since it … Continue reading
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
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