Skip to content

Commit 6035910

Browse files
author
MightyPen
committed
'titleSuffix:' defaults in docs/docfx.json, per seodec18
1 parent b7d621e commit 6035910

5 files changed

Lines changed: 91 additions & 76 deletions

File tree

‎docs/analysis-services/analysis-services.md‎

Lines changed: 20 additions & 20 deletions
Original file line numberDiff line numberDiff line change
@@ -12,32 +12,32 @@ manager: kfile
1212
---
1313
# About SQL Server Analysis Services
1414

15-
Analysis Services is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
15+
Analysis Services is an analytical data engine used in decision support and business analytics. It provides enterprise-grade semantic data models for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1616

17-
A typical workflow includes creating a tabular or multidimensional data model project in Visual Studio, deploying the model as a database to a server instance, setting up recurring data processing, and assigning permissions to allow data access by end-users. When it's ready to go, your semantic data model can be accessed by client applications supporting Analysis Services as a data source.
17+
A typical workflow includes creating a tabular or multidimensional data model project in Visual Studio, deploying the model as a database to a server instance, setting up recurring data processing, and assigning permissions to allow data access by end-users. When it's ready to go, your semantic data model can be accessed by client applications supporting Analysis Services as a data source.
1818

19-
Analysis Services is available in two different platforms:
19+
Analysis Services is available in two different platforms:
2020

2121
**Azure Analysis Services** - Supports tabular models at the 1200 and higher compatibility levels. DirectQuery, partitions, row-level security, bi-directional relationships, and translations are all supported. To learn more, see [Azure Analysis Services](https://docs.microsoft.com/azure/analysis-services/).
2222

2323
**SQL Server Analysis Services** - Supports tabular models at all compatibility levels, multidimensional models, data mining, and Power Pivot for SharePoint.
24-
25-
## Documentation by area
24+
25+
## Documentation by area
26+
2627
In general, [Azure Analysis Services documentation](https://docs.microsoft.com/azure/analysis-services/) is included with Azure documentation. If you're interested in having your tabular models in the cloud, it's best to start there. This article and documentation in this section is mostly for SQL Server Analysis Services. However, at least for tabular models, how you create and deploy your tabular model projects is much the same, regardless of the platform you're using. Check out these sections to learn more:
2728

28-
29-
* [Comparing Tabular and Multidimensional Solutions](../analysis-services/comparing-tabular-and-multidimensional-solutions-ssas.md)
30-
* [Install SQL Server Analysis Services](../analysis-services/instances/install-windows/install-analysis-services.md)
31-
* [Tabular models](../analysis-services/tabular-models/tabular-models-ssas.md)
32-
* [Multidimensional models](../analysis-services/multidimensional-models/multidimensional-models-ssas.md)
33-
* [Data Mining](../analysis-services/data-mining/data-mining-ssas.md)
34-
* [Power Pivot for SharePoint](../analysis-services/power-pivot-sharepoint/power-pivot-for-sharepoint-ssas.md)
35-
* [Tutorials](../analysis-services/analysis-services-tutorials-ssas.md)
36-
* [Server management](../analysis-services/instances/analysis-services-instance-management.md)
37-
* [Developer documentation](analysis-services-developer-documentation.md)
38-
* [Technical reference](https://docs.microsoft.com/bi-reference/)
39-
40-
See also
41-
42-
[Azure Analysis Services documentation](https://docs.microsoft.com/azure/analysis-services/)
29+
- [Comparing Tabular and Multidimensional Solutions](../analysis-services/comparing-tabular-and-multidimensional-solutions-ssas.md)
30+
- [Install SQL Server Analysis Services](../analysis-services/instances/install-windows/install-analysis-services.md)
31+
- [Tabular models](../analysis-services/tabular-models/tabular-models-ssas.md)
32+
- [Multidimensional models](../analysis-services/multidimensional-models/multidimensional-models-ssas.md)
33+
- [Data Mining](../analysis-services/data-mining/data-mining-ssas.md)
34+
- [Power Pivot for SharePoint](../analysis-services/power-pivot-sharepoint/power-pivot-for-sharepoint-ssas.md)
35+
- [Tutorials](../analysis-services/analysis-services-tutorials-ssas.md)
36+
- [Server management](../analysis-services/instances/analysis-services-instance-management.md)
37+
- [Developer documentation](analysis-services-developer-documentation.md)
38+
- [Technical reference](https://docs.microsoft.com/bi-reference/)
39+
40+
#### See also
41+
42+
[Azure Analysis Services documentation](https://docs.microsoft.com/azure/analysis-services/)
4343
[SQL Server Documentation](../sql-server/sql-server-technical-documentation.md)

‎docs/database-engine/availability-groups/windows/always-on-availability-groups-interoperability-sql-server.md‎

Lines changed: 54 additions & 52 deletions
Original file line numberDiff line numberDiff line change
@@ -18,55 +18,57 @@ manager: craigg
1818
# Always On availability groups: interoperability (SQL Server)
1919
[!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md](../../../includes/appliesto-ss-xxxx-xxxx-xxx-md.md)]
2020

21-
This topic documents interoperability of [!INCLUDE[ssHADR](../../../includes/sshadr-md.md)] with other [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] features in [!INCLUDE[ssCurrent](../../../includes/sscurrent-md.md)].
22-
23-
## <a name="Interop"></a> Features That Interoperate with Always On Availability Groups
24-
The following table lists [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] features that interoperate with [!INCLUDE[ssHADR](../../../includes/sshadr-md.md)] in [!INCLUDE[ssCurrent](../../../includes/sscurrent-md.md)]. A link in the **More Information** column indicates that interoperability considerations exist for a given feature.
25-
26-
|Feature|More Information|
27-
|-------------|----------------------|
28-
|Change data capture|[Replication, Change Tracking, Change Data Capture, and Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/replicate-track-change-data-capture-always-on-availability.md)|
29-
|Change tracking|[Replication, Change Tracking, Change Data Capture, and Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/replicate-track-change-data-capture-always-on-availability.md)|
30-
|Contained databases|[Contained Databases with Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/contained-databases-with-always-on-availability-groups-sql-server.md)|
31-
|Database encryption|[Encrypted Databases with Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/encrypted-databases-with-always-on-availability-groups-sql-server.md)|
32-
|Database snapshots|[Database Snapshots with Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/database-snapshots-with-always-on-availability-groups-sql-server.md)|
33-
|FILESTREAM and FileTable|[FILESTREAM and FileTable with Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/filestream-and-filetable-with-always-on-availability-groups-sql-server.md)|
34-
|Full-text search|Note: Full-Text indexes are synchronized with Always On secondary databases.|
35-
|Log shipping|[Prerequisites for Migrating from Log Shipping to Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/prereqs-migrating-log-shipping-to-always-on-availability-groups.md)|
36-
|Remote Blob Store (RBS)|[Remote Blob Store &#40;RBS&#41; and Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/remote-blob-store-rbs-and-always-on-availability-groups-sql-server.md)|
37-
|Replication|[Configure Replication for Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/configure-replication-for-always-on-availability-groups-sql-server.md)<br /><br /> [Maintaining an Always On Publication Database &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/maintaining-an-always-on-publication-database-sql-server.md)<br /><br /> [Replication, Change Tracking, Change Data Capture, and Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/replicate-track-change-data-capture-always-on-availability.md)<br /><br /> [Replication Subscribers and Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/replication-subscribers-and-always-on-availability-groups-sql-server.md)|
38-
|Analysis Services|[Analysis Services with Always On Availability Groups](../../../database-engine/availability-groups/windows/analysis-services-with-always-on-availability-groups.md)|
39-
|Reporting Services|Utilize read only secondary replicas as a reporting data source and reduce the load on your primary read-write replica.<br /><br /> [Reporting Services with Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/reporting-services-with-always-on-availability-groups-sql-server.md)|
40-
|Service Broker|[Service Broker with Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/service-broker-with-always-on-availability-groups-sql-server.md)|
41-
|SQL Server Agent||
42-
43-
## <a name="restrictions"></a> Features that Interoperate with Always On Availability Groups with Restrictions
44-
The following features interoperate with [!INCLUDE[ssHADR](../../../includes/sshadr-md.md)] with specific restrictions. See the linked topics for details.
45-
46-
- Cross-database transactions/distributed transactions ([!INCLUDE[ssSQL15](../../../includes/sssql15-md.md)] and Windows Server 2016). For more information, see [Cross-Database Transactions and Distributed Transactions for Always On Availability Groups and Database Mirroring &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/transactions-always-on-availability-and-database-mirroring.md)
47-
48-
## <a name="NoInterop"></a> Features that Do Not Interoperate with Always On Availability Groups
49-
[!INCLUDE[ssHADR](../../../includes/sshadr-md.md)] does not interoperate with the following features:
50-
51-
- Database mirroring. For more information, see [Cross-Database Transactions and Distributed Transactions for Always On Availability Groups and Database Mirroring &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/transactions-always-on-availability-and-database-mirroring.md).
52-
53-
## <a name="RelatedContent"></a> Related Content
54-
55-
- **Blogs:**
56-
57-
[Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments](https://blogs.msdn.microsoft.com/sqlalwayson/2012/04/09/now-available-migration-guide-migrating-to-sql-server-2012-failover-clustering-and-availability-groups-from-prior-clustering-and-mirroring-deployments/)
58-
[SQL Server Always On Team Blogs: The official SQL Server Always On Team Blog](https://blogs.msdn.microsoft.com/sqlalwayson/)
59-
[CSS SQL Server Engineers Blogs](https://blogs.msdn.com/b/psssql/)
60-
61-
- **Whitepapers:**
62-
63-
[Migration Guide: Migrating to Always On Availability Groups from Prior Deployments Combining Database Mirroring and Log Shipping](https://msdn.microsoft.com/library/jj635217)
64-
[Microsoft SQL Server Always On Solutions Guide for High Availability and Disaster Recovery](https://go.microsoft.com/fwlink/?LinkId=227600)
65-
[Microsoft White Papers for SQL Server 2012](https://msdn.microsoft.com/library/hh403491.aspx)
66-
[SQL Server Customer Advisory Team Whitepapers](https://sqlcat.com/)
67-
68-
## See Also
69-
[Overview of Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server.md)
70-
[Prerequisites, Restrictions, and Recommendations for Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/prereqs-restrictions-recommendations-always-on-availability.md)
71-
72-
21+
This topic documents interoperability of [!INCLUDE[ssHADR](../../../includes/sshadr-md.md)] with other [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] features in [!INCLUDE[ssCurrent](../../../includes/sscurrent-md.md)].
22+
23+
## <a name="Interop"></a> Features that Interoperate with Always On Availability Groups
24+
25+
The following table lists [!INCLUDE[ssNoVersion](../../../includes/ssnoversion-md.md)] features that interoperate with [!INCLUDE[ssHADR](../../../includes/sshadr-md.md)] in [!INCLUDE[ssCurrent](../../../includes/sscurrent-md.md)]. A link in the **More Information** column indicates that interoperability considerations exist for a given feature.
26+
27+
|Feature|More Information|
28+
|:------|:---------------|
29+
|Change data capture|[Replication, Change Tracking, Change Data Capture, and Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/replicate-track-change-data-capture-always-on-availability.md)|
30+
|Change tracking|[Replication, Change Tracking, Change Data Capture, and Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/replicate-track-change-data-capture-always-on-availability.md)|
31+
|Contained databases|[Contained Databases with Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/contained-databases-with-always-on-availability-groups-sql-server.md)|
32+
|Database encryption|[Encrypted Databases with Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/encrypted-databases-with-always-on-availability-groups-sql-server.md)|
33+
|Database snapshots|[Database Snapshots with Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/database-snapshots-with-always-on-availability-groups-sql-server.md)|
34+
|FILESTREAM and FileTable|[FILESTREAM and FileTable with Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/filestream-and-filetable-with-always-on-availability-groups-sql-server.md)|
35+
|Full-text search|Note: Full-Text indexes are synchronized with Always On secondary databases.|
36+
|Log shipping|[Prerequisites for Migrating from Log Shipping to Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/prereqs-migrating-log-shipping-to-always-on-availability-groups.md)|
37+
|Remote Blob Store (RBS)|[Remote Blob Store &#40;RBS&#41; and Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/remote-blob-store-rbs-and-always-on-availability-groups-sql-server.md)|
38+
|Replication|[Configure Replication for Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/configure-replication-for-always-on-availability-groups-sql-server.md)<br /><br /> [Maintaining an Always On Publication Database &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/maintaining-an-always-on-publication-database-sql-server.md)<br /><br /> [Replication, Change Tracking, Change Data Capture, and Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/replicate-track-change-data-capture-always-on-availability.md)<br /><br /> [Replication Subscribers and Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/replication-subscribers-and-always-on-availability-groups-sql-server.md)|
39+
|Analysis Services|[Analysis Services with Always On Availability Groups](../../../database-engine/availability-groups/windows/analysis-services-with-always-on-availability-groups.md)|
40+
|Reporting Services|Utilize read only secondary replicas as a reporting data source and reduce the load on your primary read-write replica.<br /><br /> [Reporting Services with Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/reporting-services-with-always-on-availability-groups-sql-server.md)|
41+
|Service Broker|[Service Broker with Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/service-broker-with-always-on-availability-groups-sql-server.md)|
42+
|SQL Server Agent|&nbsp;|
43+
44+
## <a name="restrictions"></a> Features that Interoperate with Always On Availability Groups with Restrictions
45+
46+
The following features interoperate with [!INCLUDE[ssHADR](../../../includes/sshadr-md.md)] with specific restrictions. See the linked topics for details.
47+
48+
- Cross-database transactions/distributed transactions ([!INCLUDE[ssSQL15](../../../includes/sssql15-md.md)] and Windows Server 2016). For more information, see [Cross-Database Transactions and Distributed Transactions for Always On Availability Groups and Database Mirroring &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/transactions-always-on-availability-and-database-mirroring.md)
49+
50+
## <a name="NoInterop"></a> Features that Do Not Interoperate with Always On Availability Groups
51+
52+
[!INCLUDE[ssHADR](../../../includes/sshadr-md.md)] does not interoperate with the following features:
53+
54+
- Database mirroring. For more information, see [Cross-Database Transactions and Distributed Transactions for Always On Availability Groups and Database Mirroring &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/transactions-always-on-availability-and-database-mirroring.md).
55+
56+
## <a name="RelatedContent"></a> Related Content
57+
58+
- **Blogs:**
59+
60+
[Migration Guide: Migrating to SQL Server 2012 Failover Clustering and Availability Groups from Prior Clustering and Mirroring Deployments](https://blogs.msdn.microsoft.com/sqlalwayson/2012/04/09/now-available-migration-guide-migrating-to-sql-server-2012-failover-clustering-and-availability-groups-from-prior-clustering-and-mirroring-deployments/)
61+
[SQL Server Always On Team Blogs: The official SQL Server Always On Team Blog](https://blogs.msdn.microsoft.com/sqlalwayson/)
62+
[CSS SQL Server Engineers Blogs](https://blogs.msdn.com/b/psssql/)
63+
64+
- **Whitepapers:**
65+
66+
[Migration Guide: Migrating to Always On Availability Groups from Prior Deployments Combining Database Mirroring and Log Shipping](https://msdn.microsoft.com/library/jj635217)
67+
[Microsoft SQL Server Always On Solutions Guide for High Availability and Disaster Recovery](https://go.microsoft.com/fwlink/?LinkId=227600)
68+
[Microsoft White Papers for SQL Server 2012](https://msdn.microsoft.com/library/hh403491.aspx)
69+
[SQL Server Customer Advisory Team Whitepapers](https://sqlcat.com/)
70+
71+
## See Also
72+
73+
[Overview of Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server.md)
74+
[Prerequisites, Restrictions, and Recommendations for Always On Availability Groups &#40;SQL Server&#41;](../../../database-engine/availability-groups/windows/prereqs-restrictions-recommendations-always-on-availability.md)

0 commit comments

Comments
 (0)