http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=Database+Administration,SMO,User+Group+Meetings&orTags=0Search results matching tags 'Database Administration', 'SMO', and 'User Group Meetings'en-USCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/allen_white/archive/2010/08/19/pass-powershell-sql-server-precon.aspxThu, 19 Aug 2010 19:17:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:28067AllenMWhite<p>PowerShell is an amazing tool to help you automate your administrative processes. There are a lot of books and online sources to help you learn PowerShell, but how do you learn how to use it with SQL Server? Simple, just sign up for my PASS PreCon session. Here's the outline:</p> <p><a>Use PowerShell to Get the Most out of SQL Server</a></p> <ul> <li>Module 1: Introduction to PowerShell</li> <ul> <li>Cmdlets</li> <li>Aliases</li> <li>The Pipeline</li> <li>Variables</li> <li>Objects</li> <li>Control Flow</li> <li>Functions</li> <li>Modules</li> <li>Error Handling</li> <li>Command-line Arguments</li> </ul> <li>Module 2: Introduction to SMO</li> <ul> <li>Introduction to the SMO Library</li> <li>SQLPS.exe - The SQL Server Mini-Shell</li> <li>The SMO Object Model</li> </ul> <li>Module 3: Backup and Recovery</li> <ul> <li>Backup</li> <li>Restore</li> </ul> <li>Module 4: Automating &amp; Maintaining Databases</li> <ul> <li>Automating Index Maintenance</li> <li>Automating DBCC</li> </ul> <li>Module 5: Importing, Exporting and Transforming Data</li> <ul> <li>ADO.NET</li> <li>Invoke-SQLCMD</li> <li>Importing and Exporting using CSV Files</li> <li>Importing and Exporting using XML Files</li> </ul> <li>Module 6: Manipulating Database Objects</li> <ul> <li>Creating and Deleting Schemas</li> <li>Creating, Modifying and Deleting Tables</li> <li>Creating, Modifying and Deleting Triggers</li> <li>Creating, Modifying and Deleting Indexes</li> <li>Creating, Modifying and Deleting Views</li> </ul> <li>Module 7: Managing the Enterprise</li> <ul> <li>Registering Servers</li> <li>Creating a Central Management Server</li> <li>Connecting to a Central Management Server</li> <li>Running Scripts Against Multiple Servers</li> <li>Defining Policies for Policy-Based Management</li> <li>Evaluating Policies for Policy-Based Management</li> </ul> <li>Module 8: Profiling and Monitoring SQL Server</li> <ul> <li>Gathering WMI Information</li> <li>Gathering Performance Counters</li> <li>Setting up a Server Side Trace</li> <li>Monitor Log Growth</li> </ul> <li>Module 9: Configuring and Tuning SQL Server</li> <ul> <li>Setting Configuration Options</li> <li>Setting Windows Mode or Mixed Mode</li> </ul> </ul> <p>As you can see, we're going to spend the first part of the day learning the basics of PowerShell, but the focus is on how you can manage your own environment using this powerful language, so you can spend your time solving problems instead of the constant point-and-click drudgery of typical DBA tasks.</p> <p>The all-day session is reasonably priced, and you'll come away with scripts to help you put this tool into use right away. Check out the session details at <a href="http://sqlpass.eventpoint.com/topic/details/DBA232P" title="SQLPass.org" target="_blank">Use PowerShell to Get the Most out of SQL Server</a>.</p> <p>See you there!</p> <p>Allen</p>