Click here to monitor SSC

Author Profile

Dan Sullivan

Dan is an independent consultant, book and course author, speaker, and instructor. His areas of interest are Windows .NET, XML, and SQL Server. He does consulting through his company, Danal Technology Inc. He does training through Pluralsight.com. Dan has spoken at user groups and industry events such as WinDev. He and Bob Beauchemin are the authors of "A Developer's Guide to SQL Server 2005" published by Addison-Wesley.

PowerSMO at Work Part 2

In part 3 of Dan Sullivan's in-depth exploration of PowerSMO, the versatile command line utility for managing SQL Server databases, he describes how to control the identity that SMO uses to login to SQL Server, how to set up Server activity monitoring, and how to create standalone PowerSMO scripts, suitable for use in a production environment. Read more...

PowerSMO At Work Part I: DBA Scripts and Functions

Dan Sullivan delves deeper into PowerSMO, the versatile command line utility for managing SQL Server databases. Using a certificate strategy, he provides a step-by-step guide to creating and deploying secure, signed DBA scripts. He then describes how to use PowerSMO functions to manage the extended properties of SQL Server objects. Read more...

Managing SQL Server using PowerSMO

Most DBAs don't have time to perform routine processes manually. Everything has to be scripted, automated and scheduled. Here, Dan Sullivan describes how a combination of PowerShell and SMO ("PowerSMO") can provide a familiar but powerful command line tool for managing common SQL Server tasks. Read more...

Why Join

Over 400,000 Microsoft professionals subscribe to the Simple-Talk technical journal. Join today, it's fast, simple, free and secure.