{"id":8341,"date":"2007-03-06T14:51:04","date_gmt":"2007-03-06T14:51:04","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/powershell\/2007\/03\/06\/managing-sql-with-powershell-powersmo\/"},"modified":"2019-02-18T13:16:50","modified_gmt":"2019-02-18T20:16:50","slug":"managing-sql-with-powershell-powersmo","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/powershell\/managing-sql-with-powershell-powersmo\/","title":{"rendered":"Managing SQL with PowerShell &#8211; PowerSMO"},"content":{"rendered":"<p>Dan Sullivan has been doing some great things using PowerShell to manage SQL.  Dan wrote that Addison-Wesley book &#8220;A Developer&#8217;s Guide to SQL Server 2005&#8221; along with Bob Beauchemin.  He has now started a series of articles on this topic at simple-talk.com.  Here are the first two but Dan told me that he&#8217;ll be writing more so you might want to bookmark the <a href=\"http:\/\/www.simple-talk.com\/author\/dan-sullivan\/\">search for all Dan&#8217;s articles<\/a>:\n<\/p>\n<ul>\n<li><a href=\"http:\/\/www.simple-talk.com\/sql\/database-administration\/managing-sql-server-using-powersmo\/\">Managing SQL Server using PowerSMO<\/a>\n\t\t<\/li>\n<li><a href=\"http:\/\/www.simple-talk.com\/sql\/database-administration\/powersmo-at-work-part-i-dba-scripts-and-functions\/\">PowerSMO at work Part 1:  DBA Scripts and Functions<\/a>\n\t\t<\/li>\n<\/ul>\n<p>BTW \u2013 if you are new to PowerShell, these are worth reading as they also provide a very good and pithy introduction to PowerShell.\n<\/p>\n<p>Enjoy!\n<\/p>\n<p>Jeffrey Snover [MSFT]<br \/>Windows PowerShell\/Aspen Architect<br \/>Visit the Windows PowerShell Team blog at:    <a href=\"http:\/\/blogs.msdn.com\/PowerShell\">http:\/\/blogs.msdn.com\/PowerShell<\/a><br \/>Visit the Windows PowerShell ScriptCenter at:  <a href=\"http:\/\/www.microsoft.com\/technet\/scriptcenter\/hubs\/msh.mspx\">http:\/\/www.microsoft.com\/technet\/scriptcenter\/hubs\/msh.mspx<\/a>\n\t<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dan Sullivan has been doing some great things using PowerShell to manage SQL. Dan wrote that Addison-Wesley book &#8220;A Developer&#8217;s Guide to SQL Server 2005&#8221; along with Bob Beauchemin. He has now started a series of articles on this topic at simple-talk.com. Here are the first two but Dan told me that he&#8217;ll be writing [&hellip;]<\/p>\n","protected":false},"author":600,"featured_media":13641,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-8341","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powershell"],"acf":[],"blog_post_summary":"<p>Dan Sullivan has been doing some great things using PowerShell to manage SQL. Dan wrote that Addison-Wesley book &#8220;A Developer&#8217;s Guide to SQL Server 2005&#8221; along with Bob Beauchemin. He has now started a series of articles on this topic at simple-talk.com. Here are the first two but Dan told me that he&#8217;ll be writing [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/posts\/8341","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/users\/600"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/comments?post=8341"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/posts\/8341\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/media\/13641"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/media?parent=8341"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/categories?post=8341"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/powershell\/wp-json\/wp\/v2\/tags?post=8341"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}