{"id":4685,"date":"2017-02-01T12:34:56","date_gmt":"2017-02-01T20:34:56","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/paul\/?p=4685"},"modified":"2017-02-01T12:34:56","modified_gmt":"2017-02-01T20:34:56","slug":"new-class-immersion-event-on-powershell-for-sql-server-dbas","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-class-immersion-event-on-powershell-for-sql-server-dbas\/","title":{"rendered":"New class: Immersion Event on PowerShell for SQL Server DBAs"},"content":{"rendered":"<p>We have a really cool new class debuting this May in Chicago: <em>Immersion Event on PowerShell for SQL Server DBAs<\/em>.<\/p>\n<p>It&#8217;s a 3-day class, taught by MVP, MCM, and industry expert Ben Miller, and no prior PowerShell experience is necessary. PowerShell is getting more and more popular, and by the end of the class\u00a0you&#8217;ll have learned\u00a0the following:<\/p>\n<ul>\n<li>Installation and configuration of PowerShell<\/li>\n<li>Use of the ISE that comes with PowerShell<\/li>\n<li>Shared Management Objects (SMO) for SQL Server<\/li>\n<li>Programming concepts in PowerShell<\/li>\n<li>Modules and scripts to manage SQL Server<\/li>\n<li>Gathering data for analysis using PowerShell both with SMO and T-SQL<\/li>\n<li>Repositories that contain scripts that you can leverage in your daily work<\/li>\n<\/ul>\n<p>The modules are as follows:<\/p>\n<ul>\n<li>PowerShell Environment<\/li>\n<li>Commands, Cmdlets \u00a0and Modules<\/li>\n<li>Environment Configuration<\/li>\n<li>Assemblies in PowerShell<\/li>\n<li>PowerShell Fundamentals<\/li>\n<li>SQL Server PowerShell<\/li>\n<li>PowerShell for the DBA Starter<\/li>\n<li>Gathering Information<\/li>\n<li>Power Tools<\/li>\n<li>Scheduling<\/li>\n<\/ul>\n<p>You can read a more detailed curriculum <a href=\"https:\/\/www.sqlskills.com\/sql-server-training\/ieps\/\" target=\"_blank\">here<\/a> and all the class registration and logistical details are <a href=\"http:\/\/www.sqlskills.com\/sql-server-training\/chicago-ieps-20170508\/\" target=\"_blank\">here<\/a>.<\/p>\n<p>We hope to see you there!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We have a really cool new class debuting this May in Chicago: Immersion Event on PowerShell for SQL Server DBAs. It&#8217;s a 3-day class, taught by MVP, MCM, and industry expert Ben Miller, and no prior PowerShell experience is necessary. PowerShell is getting more and more popular, and by the end of the class\u00a0you&#8217;ll have [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[24,97],"tags":[],"class_list":["post-4685","post","type-post","status-publish","format-standard","hentry","category-classes","category-training"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>New class: Immersion Event on PowerShell for SQL Server DBAs - Paul S. Randal<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-class-immersion-event-on-powershell-for-sql-server-dbas\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New class: Immersion Event on PowerShell for SQL Server DBAs - Paul S. Randal\" \/>\n<meta property=\"og:description\" content=\"We have a really cool new class debuting this May in Chicago: Immersion Event on PowerShell for SQL Server DBAs. It&#8217;s a 3-day class, taught by MVP, MCM, and industry expert Ben Miller, and no prior PowerShell experience is necessary. PowerShell is getting more and more popular, and by the end of the class\u00a0you&#8217;ll have [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-class-immersion-event-on-powershell-for-sql-server-dbas\/\" \/>\n<meta property=\"og:site_name\" content=\"Paul S. Randal\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-01T20:34:56+00:00\" \/>\n<meta name=\"author\" content=\"Paul Randal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Randal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-class-immersion-event-on-powershell-for-sql-server-dbas\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-class-immersion-event-on-powershell-for-sql-server-dbas\/\",\"name\":\"New class: Immersion Event on PowerShell for SQL Server DBAs - Paul S. Randal\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\"},\"datePublished\":\"2017-02-01T20:34:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-class-immersion-event-on-powershell-for-sql-server-dbas\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-class-immersion-event-on-powershell-for-sql-server-dbas\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/new-class-immersion-event-on-powershell-for-sql-server-dbas\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"New class: Immersion Event on PowerShell for SQL Server DBAs\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/\",\"name\":\"Paul S. Randal\",\"description\":\"In Recovery...\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce\",\"name\":\"Paul Randal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g\",\"caption\":\"Paul Randal\"},\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/paul\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New class: Immersion Event on PowerShell for SQL Server DBAs - Paul S. Randal","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-class-immersion-event-on-powershell-for-sql-server-dbas\/","og_locale":"en_US","og_type":"article","og_title":"New class: Immersion Event on PowerShell for SQL Server DBAs - Paul S. Randal","og_description":"We have a really cool new class debuting this May in Chicago: Immersion Event on PowerShell for SQL Server DBAs. It&#8217;s a 3-day class, taught by MVP, MCM, and industry expert Ben Miller, and no prior PowerShell experience is necessary. PowerShell is getting more and more popular, and by the end of the class\u00a0you&#8217;ll have [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-class-immersion-event-on-powershell-for-sql-server-dbas\/","og_site_name":"Paul S. Randal","article_published_time":"2017-02-01T20:34:56+00:00","author":"Paul Randal","twitter_misc":{"Written by":"Paul Randal","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-class-immersion-event-on-powershell-for-sql-server-dbas\/","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-class-immersion-event-on-powershell-for-sql-server-dbas\/","name":"New class: Immersion Event on PowerShell for SQL Server DBAs - Paul S. Randal","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website"},"datePublished":"2017-02-01T20:34:56+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-class-immersion-event-on-powershell-for-sql-server-dbas\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/paul\/new-class-immersion-event-on-powershell-for-sql-server-dbas\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/new-class-immersion-event-on-powershell-for-sql-server-dbas\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/paul\/"},{"@type":"ListItem","position":2,"name":"New class: Immersion Event on PowerShell for SQL Server DBAs"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/paul\/","name":"Paul S. Randal","description":"In Recovery...","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/paul\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/ffcec826c18782e1e0adf173826a7fce","name":"Paul Randal","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/paul\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0b6a266bba2f088f2551ef529293001bd73bf026bc1908b9866728c062beeeb6?s=96&d=mm&r=g","caption":"Paul Randal"},"sameAs":["http:\/\/3.209.169.194\/blogs\/paul"],"url":"https:\/\/www.sqlskills.com\/blogs\/paul\/author\/paul\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/comments?post=4685"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/posts\/4685\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/media?parent=4685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/categories?post=4685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/paul\/wp-json\/wp\/v2\/tags?post=4685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}