You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
It's important to keep in mind, once you upgrade an existing model to 1400, you can't downgrade. Be sure to keep a backup of your 1200 model database, just in-case.
44
+
It's important to keep in mind, once you upgrade an existing model to 1400, you can't downgrade. Be sure to keep a backup of your 1200 model database.
45
45
46
46
## Modern Get Data experience
47
47
When it comes to ingesting data from data sources into your tabular models, SQL Server Data Tools (SSDT) introduces the modern **Get Data** experience for models at the 1400 compatibility level. This new feature is based on similar functionality in Power BI Desktop and Microsoft Excel 2016. The modern Get Data experience provides immense data transformation and data mashup capabilities by using the Get Data query builder and M expressions.
@@ -235,7 +235,7 @@ Filtered Sales:=CALCULATE (
235
235
```
236
236
237
237
## Additional improvements
238
-
In addition to all the new features, Analysis Services, SSDT, and SSMS also include to following improvements:
238
+
In addition to all the new features, Analysis Services, SSDT, and SSMS also include the following improvements:
239
239
240
240
* Hierarchy and column reuse surfaced in more helpful locations in the Power BI field list.
241
241
* Date relationships to easily create relationships to date dimensions based on date fields.
@@ -249,4 +249,4 @@ In addition to all the new features, Analysis Services, SSDT, and SSMS also incl
249
249
250
250
## See also
251
251
[SQL Server 2017 Release Notes](../sql-server/sql-server-2017-release-notes.md)
252
-
[What's new in SQL Server 2017](../sql-server/what-s-new-in-sql-server-2017.md)
252
+
[What's new in SQL Server 2017](../sql-server/what-s-new-in-sql-server-2017.md)
@@ -272,8 +272,6 @@ The following table lists extended events related to automatic seeding.
272
272
273
273
[Always On Availability Groups Troubleshooting and Monitoring Guide](http://technet.microsoft.com/library/dn135328.aspx)
274
274
275
-
> [Allan Hirt](http://mvp.microsoft.com/en-us/PublicProfile/4025254?fullName=Allan%20Hirt), Microsoft Most Valued Professional, contributed to this article.
Copy file name to clipboardExpand all lines: docs/database-engine/availability-groups/windows/basic-availability-groups-always-on-availability-groups.md
+1-1Lines changed: 1 addition & 1 deletion
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -18,7 +18,7 @@ manager: "jhubbard"
18
18
# Basic Availability Groups (Always On Availability Groups)
Always On Basic Availability Groups provide a high availability solution for SQL Server 2016 Standard Edition. A basic availability group supports a failover environment for a single database. It is created and managed much like traditional (advanced) [Always On Availability Groups (SQL Server)](../../../database-engine/availability-groups/windows/always-on-availability-groups-sql-server.md) with Enterprise Edition. The differences and limitations of basic availability groups are summarized in this document.
21
+
Always On Basic Availability Groups provide a high availability solution for SQL Server 2016 and SQL Server 2017 Standard Edition. A basic availability group supports a failover environment for a single database. It is created and managed much like traditional (advanced) [Always On Availability Groups (SQL Server)](../../../database-engine/availability-groups/windows/always-on-availability-groups-sql-server.md) with Enterprise Edition. The differences and limitations of basic availability groups are summarized in this document.
22
22
23
23
## Features
24
24
Always On Basic Availability Groups replaces the deprecated Database Mirroring feature and provides a similar level of feature support. Basic availability groups enable a primary database to maintain a single replica. This replica can use either synchronous-commit mode or asynchronous-commit mode. For more information about availability modes, see [Availability Modes (Always On Availability Groups)](../../../database-engine/availability-groups/windows/availability-modes-always-on-availability-groups.md). The secondary replica remains inactive unless there is a need to failover. This failover reverses the primary and secondary role assignments, causing the secondary replica to become the primary active database. For more information on failover, see [Failover and Failover Modes (Always On Availability Groups)](../../../database-engine/availability-groups/windows/failover-and-failover-modes-always-on-availability-groups.md). Basic availability groups can operate in a hybrid environment that spans on-premises and Microsoft Azure.
Copy file name to clipboardExpand all lines: docs/database-engine/availability-groups/windows/distributed-availability-groups.md
+1-3Lines changed: 1 addition & 3 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -13,7 +13,7 @@ helpviewer_keywords:
13
13
- "Availability Groups [SQL Server], distributed"
14
14
ms.assetid:
15
15
caps.latest.revision:
16
-
author: "MikeRayMSFT"
16
+
author: "allanhirt"
17
17
ms.author: "mikeray"
18
18
manager: "jhubbard"
19
19
---
@@ -262,8 +262,6 @@ and ag.is_distributed = 1
262
262
263
263
*[Create an availability group with Transact-SQL](create-an-availability-group-transact-sql.md)
264
264
265
-
This content was written by [Allan Hirt](http://mvp.microsoft.com/en-us/PublicProfile/4025254?fullName=Allan%20Hirt), Microsoft Most Valued Professional.
Copy file name to clipboardExpand all lines: docs/database-engine/availability-groups/windows/enhanced-database-failover.md
+2-3Lines changed: 2 additions & 3 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -1,7 +1,7 @@
1
1
---
2
2
title: "Add Enhanced Database Failover to an Availability Group (SQL Server) | Microsoft Docs"
3
3
ms.custom: ""
4
-
ms.date: "05/10/2017"
4
+
ms.date: "09/25/2017"
5
5
ms.prod: "sql-server-2016"
6
6
ms.reviewer: ""
7
7
ms.suite: ""
@@ -14,7 +14,7 @@ helpviewer_keywords:
14
14
- "Availability Groups [SQL Server], failover"
15
15
ms.assetid:
16
16
caps.latest.revision:
17
-
author: "MikeRayMSFT"
17
+
author: "allanhirt"
18
18
ms.author: "mikeray"
19
19
manager: "jhubbard"
20
20
---
@@ -82,4 +82,3 @@ To see whether an availability group has enhanced database failover enabled, que
82
82
83
83
-[Create an availability group with Transact-SQL](create-an-availability-group-transact-sql.md)
84
84
85
-
>This content written by [Allan Hirt](http://mvp.microsoft.com/en-us/PublicProfile/4025254?fullName=Allan%20%20Hirt), Microsoft Most Valued Professional.
0 commit comments