{"id":532,"date":"2017-08-29T09:12:06","date_gmt":"2017-08-29T13:12:06","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=532"},"modified":"2021-09-16T14:58:05","modified_gmt":"2021-09-16T18:58:05","slug":"database-administration-fundamentals-sf17sql1001-day-1","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=532","title":{"rendered":"Database Administration Fundamentals (SF17SQL1001) \u2013 Day 1"},"content":{"rendered":"<p>Yesterday we had some <em>&#8220;technical difficulties&#8221;<\/em> with the <a title=\"SQL Server Express\" href=\"https:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server-editions\/sql-server-express.aspx\" target=\"_blank\" rel=\"noopener\">SQL Server Express<\/a> installation. At times, we can learn the hard way.<\/p>\n<p>When installing <a title=\"SQL Server Express\" href=\"https:\/\/www.microsoft.com\/en-us\/server-cloud\/products\/sql-server-editions\/sql-server-express.aspx\" target=\"_blank\" rel=\"noopener\">SQL Server Express<\/a> on your computer at home and work, make sure you are the <em>user<\/em> (<em>administrator<\/em>) of the server instance.<\/p>\n<p><iframe loading=\"lazy\" width=\"768\" height=\"432\" src=\"https:\/\/www.youtube.com\/embed\/dspNtyemezo?feature=oembed\" frameborder=\"0\" allowfullscreen><\/iframe><\/p>\n<p><iframe loading=\"lazy\" width=\"768\" height=\"432\" src=\"https:\/\/www.youtube.com\/embed\/nt5CVSLpplw?feature=oembed\" frameborder=\"0\" allowfullscreen><\/iframe><\/p>\n<p><a title=\"SQL Server Management Studio\" href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms\" target=\"_blank\" rel=\"noopener\">SQL Server Management Studio<\/a> is simpler to install &#8212; no special configuration.<\/p>\n<p>Download the\u00a0<a title=\"Class Notes for SF17SQL1001 - Day 1 (2017\/08\/28)\" href=\"https:\/\/folvera.commons.gc.cuny.edu\/files\/2017\/08\/SF17SQL1001.20170828.pdf\">class notes<\/a>\u00a0for day 1.<\/p>\n<ul>\n<li><small>special thanks to <a title=\"Wise Owl\" href=\"http:\/\/www.wiseowl.co.uk\/\" target=\"_blank\" rel=\"noopener\">Wise Owl<\/a> for the videos<\/small><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Yesterday we had some &#8220;technical difficulties&#8221; with the SQL Server Express installation. At times, we can learn the hard way. When installing SQL Server Express on your computer at home and work, make sure you are the user (administrator) of the server instance. SQL Server Management Studio is simpler to install &#8212; no special configuration. [&hellip;]<\/p>\n","protected":false},"author":7213,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"send_to_group_blog":0,"footnotes":""},"categories":[20,3,1,17,2],"tags":[],"class_list":["post-532","post","type-post","status-publish","format-standard","hentry","category-sf17sql1001","category-computer-programming","category-cuny","category-open-source","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/532","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/users\/7213"}],"replies":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=532"}],"version-history":[{"count":3,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/532\/revisions"}],"predecessor-version":[{"id":536,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/532\/revisions\/536"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=532"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=532"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}