File tree

• docs
  • advanced-analytics/r-services
    • step-2-import-data-to-sql-server-using-powershell.md
    • step-3-explore-and-visualize-the-data-in-database-advanced-analytics-tutorial.md
    • step-4-create-data-features-using-t-sql-in-database-advanced-analytics-tutorial.md
    • step-5-train-and-save-a-model-using-t-sql.md
  • analysis-services
    • TOC.md
    • multidimensional-models
      • error-configuration-for-cube-partition-and-dimension-processing.md
      • work-with-analysis-services-projects-and-databases-in-development.md
      • work-with-analysis-services-projects-and-databases-in-production.md
    • power-pivot-sharepoint
      • activate-power-pivot-integration-for-site-collections-in-ca.md
      • add-bi-semantic-model-connection-content-type-to-library.md
      • an-error-occurred-during-an-attempt-to-establish-a-connection.md
      • comments-shapes-other-objects-not-supported-by-excel-services.md
      • configure-and-view-sharepoint-and-diagnostic-logging.md
      • configure-or-repair-power-pivot-for-sharepoint-2013.md
      • connect-power-pivot-service-app-to-sharepoint-web-app-in-ca.md
      • could-not-load-microsoft-analysisservices-sharepoint-integration.md
      • create-and-configure-power-pivot-service-application-in-ca.md
      • schedule-data-refresh-and-data-sources-no-windows-authentication.md
      • the-data-connection-path-is-invalid.md
      • the-data-connection-user-could-not-be-delegated.md
      • trusted-location-does-not-allow-external-data-connections.md
      • unable-to-refresh-data-for-a-data-connection-in-the-workbook.md
    • tabular-model-programming-compatibility-level-1200
      • connect-to-existing-analysis-services-tabular-server-and-database.md
      • create-tables-partitions-and-columns-in-a-tabular-model.md
      • install-distribute-and-reference-the-tabular-object-model.md
    • tabular-model-programming-compatibility-levels-1050-1103/representation
      • understanding-tabular-object-model-at-levels-1050-through-1103.md
    • tabular-modeling-adventure-works-tutorial.md
    • tabular-models
      • bi-directional-cross-filters-tabular-models-analysis-services.md
  • database-engine/availability-groups/windows
    • active-secondaries-backup-on-secondary-replicas-always-on-availability-groups.md
    • active-secondaries-readable-secondary-replicas-always-on-availability-groups.md
    • always-on-policies-for-operational-issues-always-on-availability.md
    • availability-group-add-database-to-group-wizard.md
    • availability-group-properties-new-availability-group-backup-preferences-page.md
    • configuration-of-a-server-instance-for-always-on-availability-groups-sql-server.md
    • configure-flexible-automatic-failover-policy.md
    • connect-to-existing-secondary-replicas-page.md
    • database-mirroring-always-on-availability-groups-powershell.md
    • flexible-automatic-failover-policy-availability-group.md
    • listeners-client-connectivity-application-failover.md
    • logins-and-jobs-for-availability-group-databases.md
    • prereqs-migrating-log-shipping-to-always-on-availability-groups.md
    • prereqs-restrictions-recommendations-always-on-availability.md
    • replicate-track-change-data-capture-always-on-availability.md
    • select-initial-data-synchronization-page-always-on-availability-group-wizards.md
    • specify-availability-group-name-page.md
    • specify-endpoint-url-adding-or-modifying-availability-replica.md
    • transact-sql-statements-for-always-on-availability-groups.md
    • transactions-always-on-availability-and-database-mirroring.md
    • use-always-on-policies-to-view-the-health-of-an-availability-group-sql-server.md
    • use-object-explorer-details-to-monitor-availability-groups.md
    • use-the-add-replica-to-availability-group-wizard-sql-server-management-studio.md
  • integration-services
    • TOC.md
    • data-flow/transformations
      • convert-data-type-by-using-data-conversion-transformation.md
      • lookup-transformation-full-cache-mode-cache-connection-manager.md
      • lookup-transformation-full-cache-mode-ole-db-connection-manager.md
    • extending-packages-custom-objects
      • TOC.md
      • data-flow
        • TOC.md
    • extending-packages-scripting
      • TOC.md
      • data-flow-script-component
        • TOC.md
      • task
        • TOC.md
    • service
      • view-integration-services-packages-in-sql-server-management-studio-ssis-service.md
  • master-data-services
    • TOC.md
    • create-database-mail-profile-and-account-dialog-box.md
    • master-data-services-and-data-quality-services-features-support.md
  • relational-databases
    • TOC.md
    • json
      • include-null-values-in-json-include-null-values-option.md
      • remove-square-brackets-from-json-without-array-wrapper-option.md
    • lesson-1-create-stored-access-policy-and-shared-access-signature.md
    • manage
      • change-proxy-account-for-utility-collection-on-managed-sql-server.md
      • run-utility-and-non-utility-collection-sets-on-same-sql-instance.md
    • native-client-ole-db-how-to/results
      • execute-stored-procedure-with-odbc-call-and-process-output.md
      • execute-stored-procedure-with-rpc-and-process-output.md
    • performance
      • performance-improvements-using-dta-recommendations.md
    • replication
      • bulk-load-data-into-tables-in-a-merge-publication.md
      • control-behavior-of-triggers-and-constraints-in-synchronization.md
      • distributor-info-subscription-watch-list-merge-pub-sql-2005.md
      • distributor-info-subscription-watch-list-snapshot-pub-sql-2005.md
      • distributor-info-subscription-watch-list-transaction-pub-sql-2005.md
      • enable-initialization-with-backup-for-transactional-publications.md
      • execute-scripts-before-and-after-a-snapshot-is-applied.md
      • initialize-a-transactional-subscription-from-a-backup.md
      • monitor
        • view-information-and-perform-tasks-for-publication-agents.md
        • view-information-and-perform-tasks-for-subscription-agents.md
        • view-replicated-commands-and-information-in-distribution-database.md
      • publication-information-tracer-tokens-sql-server-2005-and-later.md
      • publication-information-warnings-merge-publication-sql-server-2005-and-later.md
      • publication-information-warnings-snapshot-publication-sql-server-2005-and-later.md
      • publication-information-warnings-transactional-publication.md
      • publisher-information-subscription-watch-list-merge-publication.md
      • publisher-information-subscription-watch-list-snapshot.md
      • publisher-information-subscription-watch-list-transactional.md
      • publish
        • add-articles-to-and-drop-articles-from-a-publication.md
        • automatically-generate-join-filters-between-merge-articles.md
        • create-an-updatable-subscription-to-a-transactional-publication.md
        • create-updatable-subscription-to-transactional-publication.md
        • publish-execution-of-stored-procedure-in-transactional-publication.md
        • specify-that-deletes-should-not-be-tracked-for-merge-articles.md
        • specify-the-processing-order-of-merge-table-articles.md
      • set-distribution-retention-period-for-transactional-publications.md
      • specify-a-merge-subscription-type-and-conflict-resolution-priority.md
      • subscription-synchronization-history.md
      • subscription-undistributed-commands-transactional-subscription.md
      • synchronize-a-subscription-using-windows-synchronization-manager.md
      • view-and-resolve-data-conflicts-for-merge-publications.md
      • view-conflict-information-for-merge-publications.md
      • view-data-conflicts-for-transactional-publications-sql-server-management-studio.md
    • sqlxml-annotated-xsd-schemas-using
      • creating-valid-id-idref-and-idrefs-type-attributes-using-sql-prefix-sqlxml-4-0.md
      • default-mapping-of-xsd-elements-and-attributes-to-tables-and-columns-sqlxml-4-0.md
      • excluding-schema-elements-from-the-xml-document-using-sql-mapped.md
      • explicit-mapping-xsd-elements-and-attributes-to-tables-and-columns.md
    • system-dynamic-management-views
      • always-on-availability-groups-dynamic-management-views-functions.md
      • full-text-and-semantic-search-dynamic-management-views-functions.md
      • sql-and-parallel-data-warehouse-dynamic-management-views.md
      • sys-dm-linux-proc-all-stat-transact-sql.md
      • sys-dm-linux-proc-cpuinfo-transact-sql.md
      • sys-dm-linux-proc-meminfo-transact-sql.md
      • sys-dm-linux-proc-sql-maps-transact-sql.md
      • sys-dm-linux-proc-sql-threads-transact-sql.md
    • tables
      • memory-optimized-system-versioned-temporal-tables-performance.md
    • tutorial-use-azure-blob-storage-service-with-sql-server-2016.md
    • wmi-provider-configuration
      • using-wql-and-scripting-languages-with-the-wmi-provider.md
    • wmi-provider-server-events
      • sample-creating-a-sql-server-agent-alert-with-the-wmi-provider.md
  • reporting-services
    • TOC.md
    • create-drillthrough-rdlc-report-with-parameters-reportviewer.md
    • report-builder
      • interactive-functionality-different-report-rendering-extensions.md
    • report-data
      • TOC.md
      • data-connections-data-sources-and-connection-strings-report-builder-and-ssrs.md
      • define-parameters-in-the-mdx-query-designer-for-analysis-services.md
      • sharepoint-list-connection-type-ssrs.md
      • show-hidden-datasets-for-parameter-values-multidimensional-data.md
      • use-an-office-data-connection-odc-with-reports.md
    • report-design
      • add-change-or-delete-available-values-for-a-report-parameter.md
      • add-change-or-delete-default-values-for-a-report-parameter.md
      • add-dataset-filters-data-region-filters-and-group-filters.md
      • change-map-legends-color-scale-and-associated-rules-report-builder-and-ssrs.md
      • controlling-the-tablix-data-region-display-on-a-report-page.md
      • displaying-a-series-with-multiple-data-ranges-on-a-chart.md
      • drillthrough-drilldown-subreports-and-nested-data-regions.md
      • expression-scope-for-totals-aggregates-and-built-in-collections.md
      • hide-a-page-header-or-footer-on-the-first-or-last-page-report-builder-and-ssrs.md
      • set-parameters-on-a-published-report-sharepoint-integrated-mode.md
      • specify-consistent-colors-across-multiple-shape-charts-report-builder-and-ssrs.md
      • vary-polygon-line-and-point-display-by-rules-and-analytical-data.md
    • report-server-sharepoint
      • activate-the-report-server-file-sync-feature-in-sharepoint-ca.md
      • add-the-report-viewer-web-part-to-a-web-page.md
      • configuration-and-administration-of-a-report-server.md
      • connect-filter-or-documents-web-part-sharepoint-integrated-mode.md
      • local-mode-vs-connected-mode-reports-in-the-report-viewer.md
      • upload-documents-to-a-sharepoint-library-reporting-services-in-sharepoint-mode.md
    • report-server
      • performance-counters-msrs-2011-sharepoint-mode-performance-objects.md
      • performance-counters-msrs-2011-web-service-performance-objects.md
    • reports
      • find-text-numbers-or-dates-in-a-report.md
    • security
      • reporting-services-roles-tasks-vs-sharepoint-groups-permissions.md
      • set-permissions-for-report-server-items-on-a-sharepoint-site.md
    • subscriptions
      • manage-subscription-owners-and-run-subscription-powershell.md
    • tools
      • url-examples-for-items-on-a-report-server-sharepoint-mode.md
    • wmi-provider-library-reference
      • configurationsetting-method-generatedatabasecreationscript.md
      • configurationsetting-method-removeunattendedexecutionaccount.md
      • configurationsetting-property-virtualdirectoryreportmanager.md
      • configurationsetting-property-virtualdirectoryreportserver.md
      • configurationsetting-property-windowsserviceidentityactual.md
      • rswindowsextendedprotectionlevel-property.md
      • rswindowsextendedprotectionscenario-property.md
      • windowsserviceidentityconfigured-property.md
  • sql-server/stretch-database
    • stretch-database-databases-and-tables-stretch-database-advisor.md
  • t-sql/statements
    • permissions-grant-deny-revoke-azure-sql-data-warehouse-parallel-data-warehouse.md
    • restore-statements-for-restoring-recovering-and-managing-backups-transact-sql.md
    • set-fips-flagger-transact-sql.md
  • tools/sql-server-management-studio
    • change-the-name-of-registered-server-or-registered-server-group.md
    • create-a-central-management-server-and-server-group.md
    • execute-statements-against-multiple-servers-simultaneously.md
    • move-a-registered-server-or-registered-server-group.md
  • whitepapers
    • introducing-microsoft-technologies-for-data-storage-movement-and-transformation.md