Why Become a PowerShell DBA
If you find this article valuable and you decide that you want to get your learn on with PowerShell and SQL Server, there is a
February 20, 2019
© 2020 All rights reserved
Designed by PaperswordB2B
Category: SMO
PowerShell month in May with DBAduck
I am excited for this month. SQLSkills Training Event 1 for this month revolving around PowerShell is May 8-10 at SQLskills.com training in Chicago. I
May 1, 2017
Speaking at SQL Saturday 220 Atlanta #SQLSATATL
Posted over on sqlblog.com about my speaking at the SQL Saturday. Hope to see you there.
May 11, 2013
T-SQL Tuesday #39: More Efficient SMO with Server.SetDefaultInitFields
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
February 12, 2013
Get SQL Server Service Accounts with WMI
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
September 25, 2012
SMO and Index Fragmentation
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
July 7, 2012
Powershell, SMO and Database Files
In response to some questions about renaming a physical file for a database, I have 2 versions of Powershell scripts that do this for you,
February 14, 2011