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.

Follow Dan Sullivan via

Dan Sullivan 12 March 2007

PowerSMO at Work Part 2

Database Administration

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

Database Administration

Dan Sullivan 19 February 2007

PowerSMO At Work Part I: DBA Scripts and Functions

Database Administration

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

Database Administration

Dan Sullivan 31 January 2007

Managing SQL Server using PowerSMO

Database Administration

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

Database Administration