{"id":1136,"date":"2013-12-17T08:37:31","date_gmt":"2013-12-17T16:37:31","guid":{"rendered":"http:\/\/3.209.169.194\/blogs\/joe\/?p=1136"},"modified":"2013-12-17T08:38:40","modified_gmt":"2013-12-17T16:38:40","slug":"new-course-sql-server-database-creation-configuration-and-alteration","status":"publish","type":"post","link":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-database-creation-configuration-and-alteration\/","title":{"rendered":"New Course: \u201cSQL Server: Database Creation, Configuration, and Alteration\u201d"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>Today Pluralsight published my new course, \u201c<a href=\"http:\/\/pluralsight.com\/training\/Courses\/TableOfContents\/sql-server-creation-config-alteration\" target=\"_blank\">SQL Server: Database Creation, Configuration, and Alteration<\/a>\u201d.<\/p>\n<p>This is a demo-centric, short course on how to how to use T-SQL to create and configure databases, files, and filegroups. \u00a0Areas I cover include:<\/p>\n<ul>\n<li>How to create a database<\/li>\n<li>How to configure files and filegroups<\/li>\n<li>Configuration of file settings<\/li>\n<li>Configuration of recovery model, security, collation<\/li>\n<li>How to create a database snapshot<\/li>\n<li>How to support FILESTREAM data<\/li>\n<li>Enabling containment<\/li>\n<li>Adding, removing and modifying files and filegroups<\/li>\n<li>Changing growth options<\/li>\n<li>Relocating files<\/li>\n<li>Changing logical file names<\/li>\n<li>Making a filegroup read-only<\/li>\n<li>Modifying compatibility levels, \u201cAUTO\u201d options, access and database state<\/li>\n<li>Changing a database to read-only<\/li>\n<li>Restricting database access<\/li>\n<li>Changing recovery and recovery time options<\/li>\n<li>Changing various options like page verification, snapshot isolation, ANSI settings<\/li>\n<li>Enabling change tracking<\/li>\n<li>Enabling Transparent Data Encryption<\/li>\n<li>Changing security and Service Broker options<\/li>\n<li>Changing containment settings<\/li>\n<\/ul>\n<p>There are now 29 courses from the SQLskills team as of today and much more to come.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Today Pluralsight published my new course, \u201cSQL Server: Database Creation, Configuration, and Alteration\u201d. This is a demo-centric, short course on how to how to use T-SQL to create and configure databases, files, and filegroups. \u00a0Areas I cover include: How to create a database How to configure files and filegroups Configuration of file settings Configuration [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,38],"tags":[],"class_list":["post-1136","post","type-post","status-publish","format-standard","hentry","category-community","category-sql-server-training"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>New Course: \u201cSQL Server: Database Creation, Configuration, and Alteration\u201d - Joe Sack<\/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\/joe\/new-course-sql-server-database-creation-configuration-and-alteration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"New Course: \u201cSQL Server: Database Creation, Configuration, and Alteration\u201d - Joe Sack\" \/>\n<meta property=\"og:description\" content=\"&nbsp; Today Pluralsight published my new course, \u201cSQL Server: Database Creation, Configuration, and Alteration\u201d. This is a demo-centric, short course on how to how to use T-SQL to create and configure databases, files, and filegroups. \u00a0Areas I cover include: How to create a database How to configure files and filegroups Configuration of file settings Configuration [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-database-creation-configuration-and-alteration\/\" \/>\n<meta property=\"og:site_name\" content=\"Joe Sack\" \/>\n<meta property=\"article:published_time\" content=\"2013-12-17T16:37:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-12-17T16:38:40+00:00\" \/>\n<meta name=\"author\" content=\"Joseph Sack\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Joseph Sack\" \/>\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\/joe\/new-course-sql-server-database-creation-configuration-and-alteration\/\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-database-creation-configuration-and-alteration\/\",\"name\":\"New Course: \u201cSQL Server: Database Creation, Configuration, and Alteration\u201d - Joe Sack\",\"isPartOf\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#website\"},\"datePublished\":\"2013-12-17T16:37:31+00:00\",\"dateModified\":\"2013-12-17T16:38:40+00:00\",\"author\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-database-creation-configuration-and-alteration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-database-creation-configuration-and-alteration\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-database-creation-configuration-and-alteration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Community\",\"item\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/community\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"New Course: \u201cSQL Server: Database Creation, Configuration, and Alteration\u201d\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#website\",\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/\",\"name\":\"Joe Sack\",\"description\":\"SQL Server Performance Tuning, High Availability and Disaster Recovery Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648\",\"name\":\"Joseph Sack\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g\",\"caption\":\"Joseph Sack\"},\"description\":\"Joe Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail and the real estate industry. Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development and high-availability. In 2006 Joe earned the \u201cMicrosoft Certified Master: SQL Server 2005\u201d certification and in 2008 he earned the \u201cMicrosoft Certified Master: SQL Server 2008\u201d certification. In 2009 he took over responsibility for the entire SQL Server Microsoft Certified Master program and held that post until 2011. He was given the SQL Server MVP award in 2013.\",\"sameAs\":[\"http:\/\/3.209.169.194\/blogs\/joe\",\"https:\/\/twitter.com\/https:\/\/twitter.com\/josephsack\"],\"url\":\"https:\/\/www.sqlskills.com\/blogs\/joe\/author\/joe\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"New Course: \u201cSQL Server: Database Creation, Configuration, and Alteration\u201d - Joe Sack","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\/joe\/new-course-sql-server-database-creation-configuration-and-alteration\/","og_locale":"en_US","og_type":"article","og_title":"New Course: \u201cSQL Server: Database Creation, Configuration, and Alteration\u201d - Joe Sack","og_description":"&nbsp; Today Pluralsight published my new course, \u201cSQL Server: Database Creation, Configuration, and Alteration\u201d. This is a demo-centric, short course on how to how to use T-SQL to create and configure databases, files, and filegroups. \u00a0Areas I cover include: How to create a database How to configure files and filegroups Configuration of file settings Configuration [&hellip;]","og_url":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-database-creation-configuration-and-alteration\/","og_site_name":"Joe Sack","article_published_time":"2013-12-17T16:37:31+00:00","article_modified_time":"2013-12-17T16:38:40+00:00","author":"Joseph Sack","twitter_misc":{"Written by":"Joseph Sack","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-database-creation-configuration-and-alteration\/","url":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-database-creation-configuration-and-alteration\/","name":"New Course: \u201cSQL Server: Database Creation, Configuration, and Alteration\u201d - Joe Sack","isPartOf":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#website"},"datePublished":"2013-12-17T16:37:31+00:00","dateModified":"2013-12-17T16:38:40+00:00","author":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648"},"breadcrumb":{"@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-database-creation-configuration-and-alteration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-database-creation-configuration-and-alteration\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/new-course-sql-server-database-creation-configuration-and-alteration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/"},{"@type":"ListItem","position":2,"name":"Community","item":"https:\/\/www.sqlskills.com\/blogs\/joe\/category\/community\/"},{"@type":"ListItem","position":3,"name":"New Course: \u201cSQL Server: Database Creation, Configuration, and Alteration\u201d"}]},{"@type":"WebSite","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#website","url":"https:\/\/www.sqlskills.com\/blogs\/joe\/","name":"Joe Sack","description":"SQL Server Performance Tuning, High Availability and Disaster Recovery Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.sqlskills.com\/blogs\/joe\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/533eb0113a15fb5a6e8067a49e4ae648","name":"Joseph Sack","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sqlskills.com\/blogs\/joe\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a4b39a7719a6bfff1add3ec00527810734579ee114d6d983e8e68f937b77be96?s=96&d=mm&r=g","caption":"Joseph Sack"},"description":"Joe Sack is a Principal Consultant with SQLskills. He has worked as a SQL Server professional since 1997 and has supported and developed for SQL Server environments in financial services, IT consulting, manufacturing, retail and the real estate industry. Prior to joining SQLskills he worked at Microsoft as a Premier Field Engineer supporting very large enterprise customer environments. He was responsible for providing deep SQL Server advisory services, training, troubleshooting and ongoing solutions guidance. His areas of expertise include performance tuning, scalability, T-SQL development and high-availability. In 2006 Joe earned the \u201cMicrosoft Certified Master: SQL Server 2005\u201d certification and in 2008 he earned the \u201cMicrosoft Certified Master: SQL Server 2008\u201d certification. In 2009 he took over responsibility for the entire SQL Server Microsoft Certified Master program and held that post until 2011. He was given the SQL Server MVP award in 2013.","sameAs":["http:\/\/3.209.169.194\/blogs\/joe","https:\/\/twitter.com\/https:\/\/twitter.com\/josephsack"],"url":"https:\/\/www.sqlskills.com\/blogs\/joe\/author\/joe\/"}]}},"_links":{"self":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts\/1136","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/comments?post=1136"}],"version-history":[{"count":0,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/posts\/1136\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/media?parent=1136"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/categories?post=1136"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sqlskills.com\/blogs\/joe\/wp-json\/wp\/v2\/tags?post=1136"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}