Microsoft Docs - Latest Articles

As the new home for Microsoft technical documentation, docs.microsoft.com has not only modernized the web experience for content, but also how we create and support the content you use to learn, manage and deploy solutions. It is the one-stop shop for everything related to Microsoft technologies. In order to make sure you can keep up to date on what’s new and exciting on docs.microsoft.com, we’ve created a dedicated feed for you.


Selected Feed: SQL

Azure SQL Data Warehouse - Connectors

https://docs.microsoft.com/en-us/connectors/sqldw/ Azure SQL Data Warehouse Microsoft Azure SQL Data Warehouse is a relational database management system developed by Microsoft. ... Connect to Azure SQL Data Warehouse to view your data.
Published Date : Tuesday, May 9, 2017

Azure Cosmos DB - Connectors

https://docs.microsoft.com/en-us/connectors/documentdb/ The Azure Cosmos DB connector using Azure Cosmos DB .NET SDK for SQL API, version 2.10.1. ... QueryText QueryText string SQL Syntax Query over documents Partition key value partitionKey string Partition key value. ... SQL Syntax Query queryText True string SQL query.
Published Date : Tuesday, May 9, 2017

SQL Server - Connectors

https://docs.microsoft.com/en-us/connectors/sql/ SQL Server Microsoft SQL Server is a relational database management system developed by Microsoft. ... SQL native query is not supported for on-premises SQL Server. ... Execute a SQL query (V2) Execute a SQL query (V2) Execute a SQL query [DEPRECATED] This action has been deprecated.
Published Date : Tuesday, May 9, 2017

List of all Production connectors

https://docs.microsoft.com/en-us/connectors/connector-reference/connector-reference-production-connectors Provides a summary of the connectors currently provided with Azure Logic Apps, Microsoft Power Automate, and Microsoft Power Apps. Filter on Production connectors.
Published Date : Sunday, March 29, 2020

List of all connectors published by Microsoft

https://docs.microsoft.com/en-us/connectors/connector-reference/connector-reference-microsoft-connectors Provides a summary of the connectors currently provided with Azure Logic Apps, Microsoft Power Automate, and Microsoft Power Apps. Filter on connectors published by Microsoft.
Published Date : Sunday, March 29, 2020

Connectors Overview

https://docs.microsoft.com/en-us/connectors/connectors An overview of Connectors
Published Date : Tuesday, December 12, 2017

Connector reference overview

https://docs.microsoft.com/en-us/connectors/connector-reference/ Provides a summary of the connectors currently provided with Azure Logic Apps, Microsoft Power Automate, and Microsoft Power Apps.
Published Date : Sunday, March 29, 2020

Power BI - Connectors

https://docs.microsoft.com/en-us/connectors/powerbi/ Blob Value value True string OAuth2 access token for SQL Azure Reports Reports string Report for which this identity applies, Only supported for paginated reports Returns The content of the file.
Published Date : Tuesday, May 9, 2017

PIPware KPIs - Connectors

https://docs.microsoft.com/en-us/connectors/pipwarekpis/ Commonly used data sources are Excel or SQL, but any source returning data in the expected format can be used. ... Commonly used data sources are Excel or SQL, but any source returning data in the expected format can be used.
Published Date : Tuesday, May 9, 2017

List of all Premium tier connectors

https://docs.microsoft.com/en-us/connectors/connector-reference/connector-reference-premium-connectors Provides a summary of the connectors currently provided with Azure Logic Apps, Microsoft Power Automate, and Microsoft Power Apps. Filter on Premium tier connectors.
Published Date : Sunday, March 29, 2020

List of all Logic Apps connectors

https://docs.microsoft.com/en-us/connectors/connector-reference/connector-reference-logicapps-connectors Provides a summary of the connectors currently provided with Azure Logic Apps, Microsoft Power Automate, and Microsoft Power Apps. Filter on Logic Apps connectors.
Published Date : Sunday, March 29, 2020

List of all Power Automate connectors

https://docs.microsoft.com/en-us/connectors/connector-reference/connector-reference-powerautomate-connectors Provides a summary of the connectors currently provided with Azure Logic Apps, Microsoft Power Automate, and Microsoft Power Apps. Filter on Power Automate connectors.
Published Date : Sunday, March 29, 2020

List of all Power Apps connectors

https://docs.microsoft.com/en-us/connectors/connector-reference/connector-reference-powerapps-connectors Provides a summary of the connectors currently provided with Azure Logic Apps, Microsoft Power Automate, and Microsoft Power Apps. Filter on Power Apps connectors.
Published Date : Sunday, March 29, 2020

Gmail - Connectors

https://docs.microsoft.com/en-us/connectors/gmail/ in actions and triggers: Control, AI Builder, Data operations, Date Time, Number Functions, Power Virtual Agents, Power Apps, Request, Schedule, Text Functions, Variables, Flow button, Location Limited set of Microsoft services: OneDrive, Sharepoint, Excel, Dynamics, Microsoft Teams, Office 365, SQL
Published Date : Tuesday, May 9, 2017

Getting Started with Azure Cognitive Search using .NET - Code Samples

https://docs.microsoft.com/en-us/samples/azure-samples/search-dotnet-getting-started/getting-started-with-azure-cognitive-search-using-net/ Contains several projects to help you get started with Azure Cognitive Search and the .NET SDK
Published Date : Thursday, November 12, 2020

Configure SQL Server On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/premier/health/sql_video Configure SQL Server On-Demand Assessment For general feedback on the Resource Center or content, please submit your response to UserVoice.
Published Date : Monday, April 15, 2019

Services Hub On-Demand Assessments

https://docs.microsoft.com/en-us/services-hub/premier/health/ for Office 365 Office 365 Collaboration Survey Office 365 Exchange Office 365 Operational Survey Office 365 SharePoint Office 365 Skype and Teams Offline Active Directory SharePoint SharePoint Operational Survey SharePoint Security Survey Skype for Business Skype for Business Operational Survey SQL
Published Date : Monday, November 16, 2020

Purchased Offline assessments are now available on the Services Hub

https://docs.microsoft.com/en-us/services-hub/health/getting-started-offline-assessments Offline Assessment for Active Directory Offline Assessment for Active Directory Security Offline Assessment for Group Policy Object Offline Assessment for Windows Server Security Offline Assessment for Windows Client Security Offline Assessment for Exchange Server Security Offline Assessment for SQL
Published Date : Tuesday, March 24, 2020

Getting Started with the SCCM On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/premier/health/getting-started-sccm Single user account if Site Systems are in Multi-Domain Environment 2) Unrestricted network access to every server (Site System) in the Configuration Manager hierarchy 3) Administrator permissions to all SQL servers used by the Configuration Manager Sites or Software Update Points 4) Full
Published Date : Monday, April 15, 2019

Getting Started with the SharePoint On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/premier/health/getting-started-sharepoint Local Admin rights on All SharePoint & SQL Servers associated with the SharePoint farm being assessed.
Published Date : Friday, April 3, 2020

Offline Assessment for SharePoint Server

https://docs.microsoft.com/en-us/services-hub/unified/health/getting-started-sharepoint/offline_checklist Member of the “SysAdmin” group on SQL instances hosting SharePoint databases Unrestricted network access from the Tools machine to all servers D. 
Published Date : Friday, November 13, 2020

Getting Started with the Skype for Business On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/unified/health/getting-started-skype-for-business Local administrator on all SQL servers that support Lync/Skype for Business Server (for clusters, on all nodes where the instance can be present) d.
Published Date : Tuesday, May 26, 2020

Missing a support plan or An error occurred / Add Contract fails

https://docs.microsoft.com/en-us/services-hub/support/support-for-business/missing-support-plan Non-developer products (such as SQL, Windows, SharePoint) downloaded from Visual Studio Subscriptions are eligible only for mainstream support.
Published Date : Saturday, October 3, 2020

Getting Started with the SQL Server On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/unified/health/getting-started-sql Contract Remote Engineer Onsite Engineer Premier SQL Remote Datasheet SQL Onsite Datasheet Unified SQL Remote Datasheet SQL Onsite Datasheet For general feedback on the Resource Center or content, please submit your response to UserVoice.
Published Date : Tuesday, May 26, 2020

Services Hub On-Demand Assessments Prerequisites

https://docs.microsoft.com/en-us/services-hub/health/assessment-prereq-docs On-Demand Assessment Prerequisite Documents Active Directory Active Directory Security System Center Configuration Manager Exchange Server Microsoft Azure Office 365 Exchange Online Office 365 Skype and Teams Office 365 SharePoint Online SharePoint Server Skype for Business SQL Server System Center Operations
Published Date : Tuesday, May 26, 2020

Running Assessments in Multiple Environments

https://docs.microsoft.com/en-us/services-hub/health/running_assessments_multiple_environments The recommended number of servers (where applicable - Windows Server assessment, Windows client assessment and SQL assessment) is 40 server per scheduled task.
Published Date : Thursday, August 29, 2019

Average Data Ingestion Statistics for Services Hub On-Demand Assessments

https://docs.microsoft.com/en-us/services-hub/premier/health/average_assessment_consumption Hub On-Demand Assessment Average Data Ingestion (In MB) Active Directory 7.69430978 Active Directory Security 4.738712044 Exchange Server 6.469056078 System Center Configuration Manager 2.922046484 System Center Operations Manager 16.49145414 Skype for Business 2.568184941 SharePoint 5.063209337 SQL
Published Date : Wednesday, August 28, 2019

How to Modify and Remove Assessment Tasks

https://docs.microsoft.com/en-us/services-hub/health/how_to_modify_and_remove_assessment_tasks How to change/update Target SQL Servers, Window Servers or Windows Clients provided while setting up SQL Server Assessment, Windows Server Assessment or Windows Client Assessment respectively?
Published Date : Monday, March 23, 2020

Purchased Offline assessments are now available on the Services Hub

https://docs.microsoft.com/en-us/services-hub/unified/health/getting-started-offline-assessments Offline Assessment for Active Directory Offline Assessment for Active Directory Security Offline Assessment for Group Policy Object Offline Assessment for Windows Server Security Offline Assessment for Windows Client Security Offline Assessment for Exchange Server Security Offline Assessment for SQL
Published Date : Tuesday, March 24, 2020

Getting Started with the System Center Operations Manager (SCOM) On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/premier/health/getting-started-scom SysAdmin role on all Microsoft SQL servers or instances used by Operations Manager.
Published Date : Tuesday, May 26, 2020

Assessment Quality

https://docs.microsoft.com/en-us/services-hub/unified/health/successfailure What if 3 data collection machines all have SQL Assessment running and pointing to the same Log Analytics workspace, but one of those machines was decommissioned 2 weeks ago?
Published Date : Thursday, October 17, 2019

Running Assessments with Managed Service Accounts

https://docs.microsoft.com/en-us/services-hub/health/kb-running-assessments-with-msas control which computers are authorized authenticate MSAs and run code in their context Supported On-Demand Assessments Managed Service Accounts are supported for running the following On-Demand Assessments Active Directory Active Directory Security System Center Configuration Manager SharePoint SQL
Published Date : Tuesday, June 4, 2019

Getting Started with the Skype for Business On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/premier/health/getting-started-skype-for-business Local administrator on all SQL servers that support Lync/Skype for Business Server (for clusters, on all nodes where the instance can be present) d.
Published Date : Tuesday, May 26, 2020

Services Hub On-Demand Assessments

https://docs.microsoft.com/en-us/services-hub/health/ for Office 365 Office 365 Collaboration Survey Office 365 Exchange Office 365 Operational Survey Office 365 SharePoint Office 365 Skype and Teams Offline Active Directory SharePoint SharePoint Operational Survey SharePoint Security Survey Skype for Business Skype for Business Operational Survey SQL
Published Date : Tuesday, July 14, 2020

Average Data Ingestion Statistics for Services Hub On-Demand Assessments

https://docs.microsoft.com/en-us/services-hub/unified/health/average_assessment_consumption Hub On-Demand Assessment Average Data Ingestion (In MB) Active Directory 7.69430978 Active Directory Security 4.738712044 Exchange Server 6.469056078 System Center Configuration Manager 2.922046484 System Center Operations Manager 16.49145414 Skype for Business 2.568184941 SharePoint 5.063209337 SQL
Published Date : Wednesday, August 28, 2019

Offline Assessment for SharePoint Server

https://docs.microsoft.com/en-us/services-hub/health/getting-started-sharepoint/prerequisites_offline_sp Earlier versions of SQL Server are not supported. 7. ... SQL Queries: Some of the information pertaining to the SQL databases that are hosted by the SharePoint SQL instance are gathered via SQL scripts.
Published Date : Friday, November 13, 2020

Creation of the Assessment Scheduled Task

https://docs.microsoft.com/en-us/services-hub/premier/health/create-task On-Demand Assessment - Active Directory On-Demand Assessment - AD Security On-Demand Assessment - Exchange On-Demand Assessment - SCCM On-Demand Assessment - SCOM On-Demand Assessment - SharePoint On-Demand Assessment - Skype for Business On-Demand Assessment - SQL Server On-Demand Assessment - Windows
Published Date : Tuesday, May 26, 2020

How to Modify and Remove Assessment Tasks

https://docs.microsoft.com/en-us/services-hub/premier/health/how_to_modify_and_remove_assessment_tasks How to change/update Target SQL Servers, Window Servers or Windows Clients provided while setting up SQL Server Assessment, Windows Server Assessment or Windows Client Assessment respectively?
Published Date : Thursday, October 29, 2020

Services Hub Videos

https://docs.microsoft.com/en-us/services-hub/getting-started/videos Assessment – Microsoft Azure Configure Office 365 On-Demand Assessment Configure SCCM On-Demand Assessment Configure SCOM On-Demand Assessment Configure SharePoint Online On-Demand Assessment Configure Sharepoint Server On-Demand Assessment Configure Skype for Business On-Demand Assessment Configure SQL
Published Date : Thursday, October 1, 2020

Getting Started with the SCCM On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/health/getting-started-sccm Single user account if Site Systems are in Multi-Domain Environment 2) Unrestricted network access to every server (Site System) in the Configuration Manager hierarchy 3) Administrator permissions to all SQL servers used by the Configuration Manager Sites or Software Update Points 4) Full
Published Date : Monday, April 15, 2019

Getting Started with the System Center Operations Manager (SCOM) On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/health/getting-started-scom SysAdmin role on all Microsoft SQL servers or instances used by Operations Manager.
Published Date : Tuesday, May 26, 2020

Getting Started with the System Center Operations Manager (SCOM) On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/unified/health/getting-started-scom SysAdmin role on all Microsoft SQL servers or instances used by Operations Manager.
Published Date : Tuesday, May 26, 2020

Getting Started with the SharePoint On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/health/getting-started-sharepoint Local Admin rights on All SharePoint & SQL Servers associated with the SharePoint farm being assessed.
Published Date : Friday, April 3, 2020

Services Hub On-Demand Assessments Prerequisites

https://docs.microsoft.com/en-us/services-hub/unified/health/assessment-prereq-docs On-Demand Assessment Prerequisite Documents Active Directory Active Directory Security System Center Configuration Manager Exchange Server Microsoft Azure Office 365 Exchange Online Office 365 Skype and Teams Office 365 SharePoint Online SharePoint Server Skype for Business SQL Server System Center Operations
Published Date : Tuesday, May 26, 2020

Environment Filter

https://docs.microsoft.com/en-us/services-hub/premier/health/environment-filter Technology Criteria AD, ADSec forest name Azure and O365 assessments tenant domain Exchange organization name SCCM central site name SCOM mgmt, group name SFB organization name SharePoint farm id SQL scheduled task/folder name for the overall assessment + 1 environment per SQL instance (clustered or
Published Date : Thursday, September 10, 2020

Environment Filter

https://docs.microsoft.com/en-us/services-hub/unified/health/environment-filter Technology Criteria AD, ADSec forest name Azure and O365 assessments tenant domain Exchange organization name SCCM central site name SCOM mgmt, group name SFB organization name SharePoint farm id SQL scheduled task/folder name for the overall assessment + 1 environment per SQL instance (clustered or
Published Date : Thursday, September 10, 2020

Getting Started with the SharePoint On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/unified/health/getting-started-sharepoint Local Admin rights on All SharePoint & SQL Servers associated with the SharePoint farm being assessed.
Published Date : Friday, April 3, 2020

Azure Roles for Log Analytics and How they Relate to the Services Hub

https://docs.microsoft.com/en-us/services-hub/premier/health/getting-started-sharepoint/offline_checklist Member of the “SysAdmin” group on SQL instances hosting SharePoint databases Unrestricted network access from the Tools machine to all servers D. 
Published Date : Thursday, October 29, 2020

Missing a support plan or An error occurred / Add Contract fails

https://docs.microsoft.com/en-us/services-hub/sfbus/support-for-business/missing-support-plan Non-developer products (such as SQL, Windows, SharePoint) downloaded from Visual Studio Subscriptions are eligible only for mainstream support.
Published Date : Saturday, October 3, 2020

Troubleshooting the On-Demand Assessments

https://docs.microsoft.com/en-us/services-hub/unified/health/assessments-troubleshooting Try to reduce the number of targets per assessment schedule If you are running the Windows Server, Windows Client or SQL Assessment and have added more than 5 targets in a single scheduled task, sometimes its possible that the assessment agent would not be able to process so many targets in one go.
Published Date : Monday, June 1, 2020

Services Hub Releases - Archive

https://docs.microsoft.com/en-us/services-hub/release-notes/services-hub-releases-archive On-Demand Assessments available for Active Directory, QL Server, Exchange, Active Directory Security, and SharePoint in Portuguese, Russian, and Italian On-Demand Assessments are now available in Portuguese, Russian, and Italian for Active Directory, SQL Server, Exchange Server, Active Directory Security,
Published Date : Tuesday, November 3, 2020

Troubleshooting the On-Demand Assessments

https://docs.microsoft.com/en-us/services-hub/premier/health/assessments-troubleshooting Try to reduce the number of targets per assessment schedule If you are running the Windows Server, Windows Client or SQL Assessment and have added more than 5 targets in a single scheduled task, sometimes its possible that the assessment agent would not be able to process so many targets in one go.
Published Date : Thursday, October 29, 2020

Running Assessments in Multiple Environments

https://docs.microsoft.com/en-us/services-hub/premier/health/running_assessments_multiple_environments The recommended number of servers (where applicable - Windows Server assessment, Windows client assessment and SQL assessment) is 40 server per scheduled task.
Published Date : Thursday, August 29, 2019

How to Modify and Remove Assessment Tasks

https://docs.microsoft.com/en-us/services-hub/unified/health/how_to_modify_and_remove_assessment_tasks How to change/update Target SQL Servers, Window Servers or Windows Clients provided while setting up SQL Server Assessment, Windows Server Assessment or Windows Client Assessment respectively?
Published Date : Monday, March 23, 2020

Services Hub On-Demand Assessments

https://docs.microsoft.com/en-us/services-hub/unified/health/ for Office 365 Office 365 Collaboration Survey Office 365 Exchange Office 365 Operational Survey Office 365 SharePoint Office 365 Skype and Teams Offline Active Directory SharePoint SharePoint Operational Survey SharePoint Security Survey Skype for Business Skype for Business Operational Survey SQL
Published Date : Monday, November 16, 2020

Services Hub Videos

https://docs.microsoft.com/en-us/services-hub/unified/getting-started/videos Assessment – Microsoft Azure Configure Office 365 On-Demand Assessment Configure SCCM On-Demand Assessment Configure SCOM On-Demand Assessment Configure SharePoint Online On-Demand Assessment Configure Sharepoint Server On-Demand Assessment Configure Skype for Business On-Demand Assessment Configure SQL
Published Date : Thursday, October 1, 2020

Services Hub Videos

https://docs.microsoft.com/en-us/services-hub/premier/getting-started/videos Assessment – Microsoft Azure Configure Office 365 On-Demand Assessment Configure SCCM On-Demand Assessment Configure SCOM On-Demand Assessment Configure SharePoint Online On-Demand Assessment Configure Sharepoint Server On-Demand Assessment Configure Skype for Business On-Demand Assessment Configure SQL
Published Date : Wednesday, October 28, 2020

Services Hub On-Demand Assessments Prerequisites

https://docs.microsoft.com/en-us/services-hub/premier/health/assessment-prereq-docs On-Demand Assessment Prerequisite Documents Active Directory Active Directory Security System Center Configuration Manager Exchange Server Microsoft Azure Office 365 Exchange Online Office 365 Skype and Teams Office 365 SharePoint Online SharePoint Server Skype for Business SQL Server System Center Operations
Published Date : Thursday, October 29, 2020

Assessment Quality

https://docs.microsoft.com/en-us/services-hub/premier/health/successfailure What if 3 data collection machines all have SQL Assessment running and pointing to the same Log Analytics workspace, but one of those machines was decommissioned 2 weeks ago?
Published Date : Thursday, October 17, 2019

Getting Started with the Skype for Business On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/health/getting-started-skype-for-business Local administrator on all SQL servers that support Lync/Skype for Business Server (for clusters, on all nodes where the instance can be present) d.
Published Date : Tuesday, May 26, 2020

Running Assessments with Managed Service Accounts

https://docs.microsoft.com/en-us/services-hub/premier/health/kb-running-assessments-with-msas control which computers are authorized authenticate MSAs and run code in their context Supported On-Demand Assessments Managed Service Accounts are supported for running the following On-Demand Assessments Active Directory Active Directory Security System Center Configuration Manager SharePoint SQL
Published Date : Tuesday, June 4, 2019

Average Data Ingestion Statistics for Services Hub On-Demand Assessments

https://docs.microsoft.com/en-us/services-hub/health/average_assessment_consumption Hub On-Demand Assessment Average Data Ingestion (In MB) Active Directory 7.69430978 Active Directory Security 4.738712044 Exchange Server 6.469056078 System Center Configuration Manager 2.922046484 System Center Operations Manager 16.49145414 Skype for Business 2.568184941 SharePoint 5.063209337 SQL
Published Date : Wednesday, August 28, 2019

Offline Assessment for SharePoint Server

https://docs.microsoft.com/en-us/services-hub/unified/health/getting-started-sharepoint/prerequisites_offline_sp Earlier versions of SQL Server are not supported. 7. ... SQL Queries: Some of the information pertaining to the SQL databases that are hosted by the SharePoint SQL instance are gathered via SQL scripts.
Published Date : Friday, November 13, 2020

Running Assessments in Multiple Environments

https://docs.microsoft.com/en-us/services-hub/unified/health/running_assessments_multiple_environments The recommended number of servers (where applicable - Windows Server assessment, Windows client assessment and SQL assessment) is 40 server per scheduled task.
Published Date : Thursday, August 29, 2019

Troubleshooting the On-Demand Assessments

https://docs.microsoft.com/en-us/services-hub/health/assessments-troubleshooting Try to reduce the number of targets per assessment schedule If you are running the Windows Server, Windows Client or SQL Assessment and have added more than 5 targets in a single scheduled task, sometimes its possible that the assessment agent would not be able to process so many targets in one go.
Published Date : Monday, June 1, 2020

Services Catalog Releases

https://docs.microsoft.com/en-us/services-hub/release-notes/services-catalog-releases December 2019 Activate Azure with DevTest Labs Modern Service Management Cloud Success Plan for Dynamics 365 Activate Building and Deploying Machine Learning Models Activate SQL Server 2019 Showcase Data Platform Modernization Assessment for OpenSource WorkshopPLUS – Dynamics 365 Customer Engagement:
Published Date : Tuesday, November 3, 2020

Getting Started with the SQL Server On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/health/getting-started-sql Contract Remote Engineer Onsite Engineer Premier SQL Remote Datasheet SQL Onsite Datasheet Unified SQL Remote Datasheet SQL Onsite Datasheet For general feedback on the Resource Center or content, please submit your response to UserVoice.
Published Date : Tuesday, May 26, 2020

Getting Started with the SQL Server On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/premier/health/getting-started-sql Contract Remote Engineer Onsite Engineer Premier SQL Remote Datasheet SQL Onsite Datasheet Unified SQL Remote Datasheet SQL Onsite Datasheet For general feedback on the Resource Center or content, please submit your response to UserVoice.
Published Date : Tuesday, May 26, 2020

Creation of the Assessment Scheduled Task

https://docs.microsoft.com/en-us/services-hub/health/create-task On-Demand Assessment - Active Directory On-Demand Assessment - AD Security On-Demand Assessment - Exchange On-Demand Assessment - SCCM On-Demand Assessment - SCOM On-Demand Assessment - SharePoint On-Demand Assessment - Skype for Business On-Demand Assessment - SQL Server On-Demand Assessment - Windows
Published Date : Tuesday, May 26, 2020

Purchased Offline assessments are now available on the Services Hub

https://docs.microsoft.com/en-us/services-hub/premier/health/getting-started-offline-assessments Offline Assessment for Active Directory Offline Assessment for Active Directory Security Offline Assessment for Group Policy Object Offline Assessment for Windows Server Security Offline Assessment for Windows Client Security Offline Assessment for Exchange Server Security Offline Assessment for SQL
Published Date : Tuesday, March 24, 2020

Offline Assessment for SharePoint Server

https://docs.microsoft.com/en-us/services-hub/health/getting-started-sharepoint/offline_checklist Member of the “SysAdmin” group on SQL instances hosting SharePoint databases Unrestricted network access from the Tools machine to all servers D. 
Published Date : Friday, November 13, 2020

Offline Assessment for SharePoint Server

https://docs.microsoft.com/en-us/services-hub/premier/health/getting-started-sharepoint/prerequisites_offline_sp Earlier versions of SQL Server are not supported. 7. ... SQL Queries: Some of the information pertaining to the SQL databases that are hosted by the SharePoint SQL instance are gathered via SQL scripts.
Published Date : Friday, November 13, 2020

Creation of the Assessment Scheduled Task

https://docs.microsoft.com/en-us/services-hub/unified/health/create-task On-Demand Assessment - Active Directory On-Demand Assessment - AD Security On-Demand Assessment - Exchange On-Demand Assessment - SCCM On-Demand Assessment - SCOM On-Demand Assessment - SharePoint On-Demand Assessment - Skype for Business On-Demand Assessment - SQL Server On-Demand Assessment - Windows
Published Date : Tuesday, May 26, 2020

Getting Started with the SCCM On-Demand Assessment

https://docs.microsoft.com/en-us/services-hub/unified/health/getting-started-sccm Single user account if Site Systems are in Multi-Domain Environment 2) Unrestricted network access to every server (Site System) in the Configuration Manager hierarchy 3) Administrator permissions to all SQL servers used by the Configuration Manager Sites or Software Update Points 4) Full
Published Date : Monday, April 15, 2019

Environment Filter

https://docs.microsoft.com/en-us/services-hub/health/environment-filter Technology Criteria AD, ADSec forest name Azure and O365 assessments tenant domain Exchange organization name SCCM central site name SCOM mgmt, group name SFB organization name SharePoint farm id SQL scheduled task/folder name for the overall assessment + 1 environment per SQL instance (clustered or
Published Date : Thursday, September 10, 2020

Assessment Quality

https://docs.microsoft.com/en-us/services-hub/health/successfailure What if 3 data collection machines all have SQL Assessment running and pointing to the same Log Analytics workspace, but one of those machines was decommissioned 2 weeks ago?
Published Date : Thursday, October 17, 2019

Assessments guide for CSAMs

https://docs.microsoft.com/en-us/services-hub/health/assessments-guide-for-tams / Onsite Remote / Onsite Download Watch Excel PowerPoint Azure Active Directory Remote / Onsite Remote / Onsite Download Watch Excel PowerPoint SCCM Remote / Onsite Remote / Onsite Download Watch Excel PowerPoint Exchange Remote / Onsite Remote / Onsite Download Watch Excel PowerPoint SQL
Published Date : Monday, March 16, 2020

Assessments guide for CSAMs

https://docs.microsoft.com/en-us/services-hub/premier/health/assessments-guide-for-tams / Onsite Remote / Onsite Download Watch Excel PowerPoint Azure Active Directory Remote / Onsite Remote / Onsite Download Watch Excel PowerPoint SCCM Remote / Onsite Remote / Onsite Download Watch Excel PowerPoint Exchange Remote / Onsite Remote / Onsite Download Watch Excel PowerPoint SQL
Published Date : Thursday, October 29, 2020

Assessments guide for CSAMs

https://docs.microsoft.com/en-us/services-hub/unified/health/assessments-guide-for-tams / Onsite Remote / Onsite Download Watch Excel PowerPoint Azure Active Directory Remote / Onsite Remote / Onsite Download Watch Excel PowerPoint SCCM Remote / Onsite Remote / Onsite Download Watch Excel PowerPoint Exchange Remote / Onsite Remote / Onsite Download Watch Excel PowerPoint SQL
Published Date : Monday, March 16, 2020

Running Assessments with Managed Service Accounts

https://docs.microsoft.com/en-us/services-hub/unified/health/kb-running-assessments-with-msas control which computers are authorized authenticate MSAs and run code in their context Supported On-Demand Assessments Managed Service Accounts are supported for running the following On-Demand Assessments Active Directory Active Directory Security System Center Configuration Manager SharePoint SQL
Published Date : Tuesday, June 4, 2019

Azure.Service Module

https://docs.microsoft.com/en-us/powershell/module/servicemanagement/azure.service/ This topic displays help topics for the Azure Service Management Cmdlets.
Published Date : Tuesday, September 11, 2018

What is SQL Server Machine Learning Services (Python and R)?

https://docs.microsoft.com/en-us/sql/machine-learning/sql-server-machine-learning-services Machine Learning Services is a feature in SQL Server that gives the ability to run Python and R scripts with relational data. You can use open-source packages and frameworks, and the Microsoft Python and R packages for predictive analytics and machine learning. The scripts are executed in-database without moving data outside SQL Server or over the network. This article explains the basics of SQL Server Machine Learning Services and how to get started.
Published Date : Tuesday, November 10, 2020

Connect to an availability group listener - SQL Server Always On

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/listeners-client-connectivity-application-failover Contains information about connecting to an Always On availability group listener, such as how to connect to the primary replica, a read-only secondary replica, use TLS/SSL, and Kerberos.
Published Date : Thursday, February 27, 2020

Configure replication with availability groups - SQL Server Always On

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/configure-replication-for-always-on-availability-groups-sql-server Learn the detailed process required to configure SQL Server replication with your Always On availability group.
Published Date : Friday, January 25, 2019

Failover modes for availability groups - SQL Server Always On

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/failover-and-failover-modes-always-on-availability-groups A description of the different failover modes available for databases participating in an Always On availability group.
Published Date : Tuesday, May 17, 2016

Automatic seeding for secondary replicas - SQL Server Always On

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/automatic-seeding-secondary-replicas Learn about how automatic seeding can initialize secondary replicas as part of an Always On availability group with SQL 2016 and greater.
Published Date : Tuesday, November 27, 2018

Add a database to an availability group - SQL Server Always On

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-group-add-a-database Add a database to an Always On availability group using Transact-SQL (T-SQL), PowerShell, or SQL Server Management Studio.
Published Date : Tuesday, May 17, 2016

Suspend an availability database - SQL Server Always On

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/suspend-an-availability-database-sql-server Learn about suspending the data movement for a database within an Always On availability group using SQL Server Management Studio, Transact-SQL or PowerShell.
Published Date : Tuesday, May 17, 2016

Availability replica is disconnected in an availability group - SQL Server Always On

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/availability-replica-is-disconnected Identify possible causes for why a replica is disconnected within an Always On availability group.
Published Date : Tuesday, May 17, 2016

Add a secondary replica to an availability group - SQL Server Always On

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/add-a-secondary-replica-to-an-availability-group-sql-server Learn how to add a secondary replica to an Always On availability group using either Transact-SQL (T-SQL), PowerShell, or the Availability Group Wizard in SQL Server Management Studio (SSMS).
Published Date : Wednesday, May 18, 2016

Join a secondary replica to an availability group - SQL Server Always On

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/join-a-secondary-replica-to-an-availability-group-sql-server Steps to join a secondary replica to an Always On availability group using either Transact-SQL (T-SQL), PowerShell, or SQL Server Management Studio.
Published Date : Tuesday, May 17, 2016

Availability group wizard: Specify availability group options - SQL Server Always On

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/specify-availability-group-name-page Describes the options found on the 'Specify Availability Group Name' page of the Availability Group Wizard within SQL Server Management Studio.
Published Date : Tuesday, May 17, 2016

Change availability mode of a replica for an availability group - SQL Server Always On

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/change-the-availability-mode-of-an-availability-replica-sql-server A description for how to change the availability mode of an availability replica within an Always On availability group using either Transact-SQL (T-SQL), PowerShell, or SQL Server Management Studio.
Published Date : Tuesday, May 17, 2016

Python tutorial: Predict NYC taxi fares with binary classification - SQL machine learning

https://docs.microsoft.com/en-us/sql/machine-learning/tutorials/python-taxi-classification-introduction Learn how to embed Python code in SQL Server stored procedures and T-SQL functions with SQL machine learning to predict NYC taxi fares using binary classification.
Published Date : Tuesday, July 28, 2020

Remove an availability group listener - SQL Server Always On

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/remove-an-availability-group-listener-sql-server Describes how to remove an Always On availability group listener with SQL Server Management Studio (SSMS), Transact-SQL (T-SQL), or SQL PowerShell.
Published Date : Tuesday, May 17, 2016

Python tutorial: Categorize customers - SQL machine learning

https://docs.microsoft.com/en-us/sql/machine-learning/tutorials/python-clustering-model In this four-part tutorial series, you'll cluster customers, using K-Means, in a database using Python with SQL machine learning.
Published Date : Tuesday, May 26, 2020

Quickstart: R data structures, data types, and objects - SQL machine learning

https://docs.microsoft.com/en-us/sql/machine-learning/tutorials/quickstart-r-data-types-and-objects In this quickstart, you'll learn how to use data structures, data types, and objects when using R with SQL machine learning.
Published Date : Thursday, May 21, 2020