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.
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
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
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