{"id":94,"date":"2014-01-25T12:34:26","date_gmt":"2014-01-25T12:34:26","guid":{"rendered":"http:\/\/www.dbafox.com\/?page_id=94"},"modified":"2016-02-25T11:18:07","modified_gmt":"2016-02-25T11:18:07","slug":"microsoft-sql-server","status":"publish","type":"page","link":"https:\/\/dbafox.com\/?page_id=94","title":{"rendered":"Microsoft SQL Server"},"content":{"rendered":"

\"SQL<\/a>

SQL Server<\/p><\/div>
\nA series of links to <\/p>\n

SQL Server articles and documents<\/h3>\n

.<\/p>\n

Books online for Microsoft SQL Server 2012<\/h2>\n

Books online for SQL Server 2012<\/a><\/p>\n

Task descriptions and reference documentation that describes how to perform data management and business intelligence work by using Microsoft SQL Server.<\/p>\n

Using Registered Servers to Manage Servers<\/h2>\n

Registered Servers (Microsoft doc)<\/a>
\nEnables the management of many servers. Used for organizing frequently accessed servers. Many servers can be queried simultaneously. Caution must be exercised when executing queries as they will be executed on all serves to which to are connected (check the status bar in SSMS).
\n

\"Registered

View Registered Servers<\/p><\/div><\/p>\n

DBCC – CHECKDB<\/h2>\n

Check Database Corruption<\/a><\/p>\n

SQL Server Waits<\/h2>\n

SQL Server Waits<\/a>
\n
\nPaul Randall – “wait-statistics-or-please-tell-me-where-it-hurts”<\/a>
\n<\/p>\n

Development – reading and writing files with T-SQL<\/h2>\n

reading and writing files with T-SQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

A series of links to SQL Server articles and documents . Books online for Microsoft SQL Server 2012 Books online for SQL Server 2012 Task descriptions and reference documentation that describes how to perform data management and business intelligence work … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"pgc_sgb_lightbox_settings":"","footnotes":""},"class_list":["post-94","page","type-page","status-publish","hentry"],"yoast_head":"\nMicrosoft Sql Server articles - technical information and documents.<\/title>\n<meta name=\"description\" content=\"A series of links concerning Microsoft SQL Server articles and documents. This page is a collection of links that are useful, current and interesting.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbafox.com\/?page_id=94\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Sql Server articles - technical information and documents.\" \/>\n<meta property=\"og:description\" content=\"A series of links concerning Microsoft SQL Server articles and documents. This page is a collection of links that are useful, current and interesting.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbafox.com\/?page_id=94\" \/>\n<meta property=\"og:site_name\" content=\"dbafox\" \/>\n<meta property=\"article:modified_time\" content=\"2016-02-25T11:18:07+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbafox.com\/wp-content\/uploads\/2014\/01\/ms-sql-server.jpg\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbafox.com\/?page_id=94\",\"url\":\"https:\/\/dbafox.com\/?page_id=94\",\"name\":\"Microsoft Sql Server articles - technical information and documents.\",\"isPartOf\":{\"@id\":\"https:\/\/dbafox.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbafox.com\/?page_id=94#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbafox.com\/?page_id=94#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.dbafox.com\/wp-content\/uploads\/2014\/01\/ms-sql-server.jpg\",\"datePublished\":\"2014-01-25T12:34:26+00:00\",\"dateModified\":\"2016-02-25T11:18:07+00:00\",\"description\":\"A series of links concerning Microsoft SQL Server articles and documents. This page is a collection of links that are useful, current and interesting.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbafox.com\/?page_id=94#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbafox.com\/?page_id=94\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/dbafox.com\/?page_id=94#primaryimage\",\"url\":\"http:\/\/www.dbafox.com\/wp-content\/uploads\/2014\/01\/ms-sql-server.jpg\",\"contentUrl\":\"http:\/\/www.dbafox.com\/wp-content\/uploads\/2014\/01\/ms-sql-server.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbafox.com\/?page_id=94#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbafox.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbafox.com\/#website\",\"url\":\"https:\/\/dbafox.com\/\",\"name\":\"dbafox\",\"description\":\"DBA Technical Information\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbafox.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Sql Server articles - technical information and documents.","description":"A series of links concerning Microsoft SQL Server articles and documents. This page is a collection of links that are useful, current and interesting.","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:\/\/dbafox.com\/?page_id=94","og_locale":"en_GB","og_type":"article","og_title":"Microsoft Sql Server articles - technical information and documents.","og_description":"A series of links concerning Microsoft SQL Server articles and documents. This page is a collection of links that are useful, current and interesting.","og_url":"https:\/\/dbafox.com\/?page_id=94","og_site_name":"dbafox","article_modified_time":"2016-02-25T11:18:07+00:00","og_image":[{"url":"http:\/\/www.dbafox.com\/wp-content\/uploads\/2014\/01\/ms-sql-server.jpg","type":"","width":"","height":""}],"twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/dbafox.com\/?page_id=94","url":"https:\/\/dbafox.com\/?page_id=94","name":"Microsoft Sql Server articles - technical information and documents.","isPartOf":{"@id":"https:\/\/dbafox.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbafox.com\/?page_id=94#primaryimage"},"image":{"@id":"https:\/\/dbafox.com\/?page_id=94#primaryimage"},"thumbnailUrl":"http:\/\/www.dbafox.com\/wp-content\/uploads\/2014\/01\/ms-sql-server.jpg","datePublished":"2014-01-25T12:34:26+00:00","dateModified":"2016-02-25T11:18:07+00:00","description":"A series of links concerning Microsoft SQL Server articles and documents. This page is a collection of links that are useful, current and interesting.","breadcrumb":{"@id":"https:\/\/dbafox.com\/?page_id=94#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbafox.com\/?page_id=94"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/dbafox.com\/?page_id=94#primaryimage","url":"http:\/\/www.dbafox.com\/wp-content\/uploads\/2014\/01\/ms-sql-server.jpg","contentUrl":"http:\/\/www.dbafox.com\/wp-content\/uploads\/2014\/01\/ms-sql-server.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/dbafox.com\/?page_id=94#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbafox.com\/"},{"@type":"ListItem","position":2,"name":"Microsoft SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/dbafox.com\/#website","url":"https:\/\/dbafox.com\/","name":"dbafox","description":"DBA Technical Information","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbafox.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"}]}},"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/P3ecMb-1w","_links":{"self":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/pages\/94","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=94"}],"version-history":[{"count":23,"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/pages\/94\/revisions"}],"predecessor-version":[{"id":620,"href":"https:\/\/dbafox.com\/index.php?rest_route=\/wp\/v2\/pages\/94\/revisions\/620"}],"wp:attachment":[{"href":"https:\/\/dbafox.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=94"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}