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
Copy file name to clipboardExpand all lines: docs/2014/2014-toc/case-study-building-an-enterprise-ecosystem.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
@@ -28,6 +28,6 @@ How to understand the specifics involved while leveraging transactional replicat
28
28
**Applies to:**SQL Server 2008, SQL Server 2012, and SQL Server 2014
29
29
30
30
To review the document, please download the
31
-
[Case Study: Building an Enterprise Ecosystem with Microsoft Dynamics ERP and SQL Server 2014 Replication for Scalability and Performance](http://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/A%20Case%20Study%20Using%20Replication%20to%20Build%20an%20Enterprise%20Ecosystem%20in%20Microsoft%20Dynamics%20ERP%20for%20Scalability%20and%20Performance.docx) Word document.
31
+
[Case Study: Building an Enterprise Ecosystem with Microsoft Dynamics ERP and SQL Server 2014 Replication for Scalability and Performance](https://download.microsoft.com/download/D/2/0/D20E1C5F-72EA-4505-9F26-FEF9550EFD44/A%20Case%20Study%20Using%20Replication%20to%20Build%20an%20Enterprise%20Ecosystem%20in%20Microsoft%20Dynamics%20ERP%20for%20Scalability%20and%20Performance.docx) Word document.
Copy file name to clipboardExpand all lines: docs/2014/2014-toc/sql-server-transaction-locking-and-row-versioning-guide.md
+6-6Lines changed: 6 additions & 6 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -55,9 +55,9 @@ manager: craigg
55
55
- Transaction management features that enforce transaction atomicity and consistency. After a transaction has started, it must be successfully completed (committed), or the [!INCLUDE[ssDE](../includes/ssde-md.md)] undoes all of the data modifications made since the transaction started. This operation is referred to as rolling back a transaction because it returns the data to the state it was prior to those changes.
56
56
57
57
### Controlling Transactions
58
-
Applications control transactions mainly by specifying when a transaction starts and ends. This can be specified by using either [!INCLUDE[tsql](../includes/tsql-md.md)] statements or database application programming interface (API) functions. The system must also be able to correctly handle errors that terminate a transaction before it completes. For more information, see [Transaction Statements (Transact-SQL)](/sql/t-sql/language-elements/transactions-transact-sql), [Transactions in ODBC](http://technet.microsoft.com/library/ms131281.aspx) and [Transactions in SQL Server Native Client (OLEDB)](http://msdn.microsoft.com/library/ms130918.aspx).
58
+
Applications control transactions mainly by specifying when a transaction starts and ends. This can be specified by using either [!INCLUDE[tsql](../includes/tsql-md.md)] statements or database application programming interface (API) functions. The system must also be able to correctly handle errors that terminate a transaction before it completes. For more information, see [Transaction Statements (Transact-SQL)](/sql/t-sql/language-elements/transactions-transact-sql), [Transactions in ODBC](https://technet.microsoft.com/library/ms131281.aspx) and [Transactions in SQL Server Native Client (OLEDB)](https://msdn.microsoft.com/library/ms130918.aspx).
59
59
60
-
By default, transactions are managed at the connection level. When a transaction is started on a connection, all [!INCLUDE[tsql](../includes/tsql-md.md)] statements executed on that connection are part of the transaction until the transaction ends. However, under a multiple active result set (MARS) session, a [!INCLUDE[tsql](../includes/tsql-md.md)] explicit or implicit transaction becomes a batch-scoped transaction that is managed at the batch level. When the batch completes, if the batch-scoped transaction is not committed or rolled back, it is automatically rolled back by [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)]. For more information, see [Multiple Active Result Sets (MARS) in SQL Server](http://msdn.microsoft.com/library/ms345109(v=SQL.90).aspx).
60
+
By default, transactions are managed at the connection level. When a transaction is started on a connection, all [!INCLUDE[tsql](../includes/tsql-md.md)] statements executed on that connection are part of the transaction until the transaction ends. However, under a multiple active result set (MARS) session, a [!INCLUDE[tsql](../includes/tsql-md.md)] explicit or implicit transaction becomes a batch-scoped transaction that is managed at the batch level. When the batch completes, if the batch-scoped transaction is not committed or rolled back, it is automatically rolled back by [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)]. For more information, see [Multiple Active Result Sets (MARS) in SQL Server](https://msdn.microsoft.com/library/ms345109(v=SQL.90).aspx).
61
61
62
62
#### Starting Transactions
63
63
Using API functions and [!INCLUDE[tsql](../includes/tsql-md.md)] statements, you can start transactions in an instance of the [!INCLUDE[ssDEnoversion](../includes/ssdenoversion-md.md)] as explicit, autocommit, or implicit transactions.
- **Parallel query execution-related resources** Coordinator, producer, or consumer threads associated with an exchange port may block each other causing a deadlock usually when including at least one other process that is not a part of the parallel query. Also, when a parallel query starts execution, [!INCLUDE[ssNoVersion](../includes/ssnoversion-md.md)] determines the degree of parallelism, or the number of worker threads, based upon the current workload. If the system workload unexpectedly changes, for example, where new queries start running on the server or the system runs out of worker threads, then a deadlock could occur.
649
649
650
-
- **Multiple Active Result Sets (MARS) resources**. These resources are used to control interleaving of multiple active requests under MARS. For more information, see [Multiple Active Result Sets (MARS) in SQL Server](http://msdn.microsoft.com/library/ms345109(v=SQL.90).aspx).
650
+
- **Multiple Active Result Sets (MARS) resources**. These resources are used to control interleaving of multiple active requests under MARS. For more information, see [Multiple Active Result Sets (MARS) in SQL Server](https://msdn.microsoft.com/library/ms345109(v=SQL.90).aspx).
651
651
652
652
- **User resource**. When a thread is waiting for a resource that is potentially controlled by a user application, the resource is considered to be an external or user resource and is treated like a lock.
653
653
@@ -1854,8 +1854,8 @@ GO
1854
1854
 [In This Guide](#Top)
1855
1855
1856
1856
## See Also
1857
-
[SQL Server 2005 Row Versioning-Based Transaction Isolation](http://msdn.microsoft.com/library/ms345124(v=sql.90).aspx)
1858
-
[Overhead of Row Versioning](http://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/03/30/overhead-of-row-versioning.aspx)
1859
-
[How to create an autonomous transaction in SQL Server 2008](http://blogs.msdn.com/b/sqlprogrammability/archive/2008/08/22/how-to-create-an-autonomous-transaction-in-sql-server-2008.aspx)
1857
+
[SQL Server 2005 Row Versioning-Based Transaction Isolation](https://msdn.microsoft.com/library/ms345124(v=sql.90).aspx)
1858
+
[Overhead of Row Versioning](https://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/03/30/overhead-of-row-versioning.aspx)
1859
+
[How to create an autonomous transaction in SQL Server 2008](https://blogs.msdn.com/b/sqlprogrammability/archive/2008/08/22/how-to-create-an-autonomous-transaction-in-sql-server-2008.aspx)
Copy file name to clipboardExpand all lines: docs/2014/2014-toc/sql-server-transaction-log-architecture-and-management.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
@@ -119,7 +119,7 @@ manager: craigg
119
119
## Additional Reading
120
120
We recommend the following articles and books for additional information about the transaction log.
121
121
122
-
[Understanding Logging and Recovery in SQL Server by Paul Randall](http://technet.microsoft.com/magazine/2009.02.logging.aspx)
122
+
[Understanding Logging and Recovery in SQL Server by Paul Randall](https://technet.microsoft.com/magazine/2009.02.logging.aspx)
123
123
124
124
[SQL Server Transaction Log Management by Tony Davis and Gail Shaw](http://www.simple-talk.com/books/sql-books/sql-server-transaction-log-management-by-tony-davis-and-gail-shaw/)
Copy file name to clipboardExpand all lines: docs/2014/analysis-services/analysis-services-mdx-query-designer-powerpivot.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
@@ -50,7 +50,7 @@ manager: craigg
50
50
Importing an .mdx query from a file is not supported.
51
51
52
52
> [!NOTE]
53
-
> For more information about MDX and general information about the MDX query designer, see "MDX Query Editor (Analysis Services - Multidimensional Data)" in [SQL Server Books Online](http://go.microsoft.com/fwlink/?linkid=98335).
53
+
> For more information about MDX and general information about the MDX query designer, see "MDX Query Editor (Analysis Services - Multidimensional Data)" in [SQL Server Books Online](https://go.microsoft.com/fwlink/?linkid=98335).
54
54
55
55
### Graphical MDX Query Designer Toolbar in Design Mode
56
56
The query designer toolbar provides buttons to help you design MDX queries using the graphical interface. The following table lists the buttons and their functions.
Copy file name to clipboardExpand all lines: docs/2014/analysis-services/analysis-services-mdx-query-designer-ssas.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
@@ -54,7 +54,7 @@ manager: craigg
54
54
Importing an .mdx query from a file is not supported.
55
55
56
56
> [!NOTE]
57
-
> For more information about MDX and general information about the MDX query designer, see "MDX Query Editor (Analysis Services - Multidimensional Data)" in [SQL Server Books Online](http://go.microsoft.com/fwlink/?linkid=98335).
57
+
> For more information about MDX and general information about the MDX query designer, see "MDX Query Editor (Analysis Services - Multidimensional Data)" in [SQL Server Books Online](https://go.microsoft.com/fwlink/?linkid=98335).
58
58
59
59
### Graphical MDX Query Designer Toolbar in Design Mode
60
60
The query designer toolbar provides buttons to help you design MDX queries using the graphical interface. The following table lists the buttons and their functions.
Copy file name to clipboardExpand all lines: docs/2014/analysis-services/analysis-services-powershell.md
+4-4Lines changed: 4 additions & 4 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -37,7 +37,7 @@ For more information about syntax and examples, see [Analysis Services PowerShel
37
37
## <aname="bkmk_prereq"></a> Prerequisites
38
38
Windows PowerShell 2.0 must be installed. It is installed by default on newer versions of the Windows operating systems. For more information, see [Install Windows PowerShell 2.0](https://msdn.microsoft.com/library/ff637750.aspx)
39
39
40
-
<!-- ff637750.aspx above is linked to by: (http://go.microsoft.com/fwlink/?LinkId=227613). -->
40
+
<!-- ff637750.aspx above is linked to by: (https://go.microsoft.com/fwlink/?LinkId=227613). -->
41
41
42
42
You must install a SQL Server feature that includes the SQL Server PowerShell (SQLPS) module and client libraries. The easiest way to do this is by installing SQL Server Management Studio, which includes the PowerShell feature and client libraries automatically. The SQL Server PowerShell (SQLPS) module contains the PowerShell providers and cmdlets for all SQL Server features, including the SQLASCmdlets module and SQLAS provider used for navigating the Analysis Services object hierarchy.
43
43
@@ -53,7 +53,7 @@ For more information about syntax and examples, see [Analysis Services PowerShel
|Multidimensional instances and databases|Supported for local and remote administration.<br /><br /> Merge-partition requires a local connection.|
56
-
|Tabular instances and databases|Supported for local and remote administration.<br /><br /> For more information, see an August 2011 blog about [Manage Tabular Models Using PowerShell](http://go.microsoft.com/fwlink/?linkID=227685).|
56
+
|Tabular instances and databases|Supported for local and remote administration.<br /><br /> For more information, see an August 2011 blog about [Manage Tabular Models Using PowerShell](https://go.microsoft.com/fwlink/?linkID=227685).|
57
57
|PowerPivot for SharePoint instances and databases|Limited support. You can use HTTP connections and the SQLAS provider to view instance and database information.<br /><br /> However, using the cmdlets is not supported. You must not use Analysis Services PowerShell to backup and restore in-memory PowerPivot database, nor should you add or remove roles, process data, or run arbitrary XMLA script.<br /><br /> For configuration purposes, PowerPivot for SharePoint has built-in PowerShell support that is provided separately. For more information, see [PowerShell Reference for PowerPivot for SharePoint](/sql/analysis-services/powershell/powershell-reference-for-power-pivot-for-sharepoint).|
58
58
|Native connections to local cubes<br /><br /> "Data Source=c:\backup\test.cub"|Not supported.|
59
59
|HTTP connections to BI semantic model (.bism) connection files in SharePoint<br /><br /> "Data Source=http://server/shared_docs/name.bism"|Not supported.|
When using Basic authentication, you should always use HTTPS with SSL so that username and passwords are sent over an encrypted connection. For more information, see [Configure Secure Sockets Layer in IIS 7.0](http://go.microsoft.com/fwlink/?linkID=184299) and [Configure Basic Authentication (IIS 7)](http://go.microsoft.com/fwlink/?LinkId=230776).
87
+
When using Basic authentication, you should always use HTTPS with SSL so that username and passwords are sent over an encrypted connection. For more information, see [Configure Secure Sockets Layer in IIS 7.0](https://go.microsoft.com/fwlink/?linkID=184299) and [Configure Basic Authentication (IIS 7)](https://go.microsoft.com/fwlink/?LinkId=230776).
88
88
89
89
Remember that credentials, queries, and commands that you provide in PowerShell are passed unchanged to the transport layer. Including sensitive content in your scripts increases the risk of a malicious injection attack.
[Install SQL Server PowerShell](../database-engine/install-windows/install-sql-server-powershell.md)
275
-
[Manage Tabular Models Using PowerShell (blog)](http://go.microsoft.com/fwlink/?linkID=227685)
275
+
[Manage Tabular Models Using PowerShell (blog)](https://go.microsoft.com/fwlink/?linkID=227685)
276
276
[Configure HTTP Access to Analysis Services on Internet Information Services (IIS) 8.0](instances/configure-http-access-to-analysis-services-on-iis-8-0.md)
Copy file name to clipboardExpand all lines: docs/2014/analysis-services/analysis-services-tutorials-ssas.md
+5-5Lines changed: 5 additions & 5 deletions
Display the source diff
Display the rich diff
Original file line number
Diff line number
Diff line change
@@ -21,17 +21,17 @@ manager: craigg
21
21
[Multidimensional Modeling (Adventure Works Tutorial)](multidimensional-modeling-adventure-works-tutorial.md)
22
22
This tutorial teaches the fundamental skills and concepts behind multidimensional modeling in [!INCLUDE[ssBIDevStudioFull](../includes/ssbidevstudiofull-md.md)]. When you are finished, you will have a cube database based on Adventure Works data that you can access from Excel, Reporting Services, or any other client application that connects to Analysis Services.
23
23
24
-
[AdventureWorks Sample Databases on Codeplex](http://go.microsoft.com/fwlink/?linkID=335807)
24
+
[AdventureWorks Sample Databases on Codeplex](https://go.microsoft.com/fwlink/?linkID=335807)
25
25
This link takes you to the codeplex download page that has the AdventureWorks sample databases for [!INCLUDE[ssSQL14](../includes/sssql14-md.md)].
26
26
27
-
[AMO Code Sample for Creating Tabular Models Programmatically](http://go.microsoft.com/fwlink/?linkID=221036)
27
+
[AMO Code Sample for Creating Tabular Models Programmatically](https://go.microsoft.com/fwlink/?linkID=221036)
28
28
This link takes you to a Codeplex download page that has the AMO sample for [!INCLUDE[ssSQL14](../includes/sssql14-md.md)].
29
29
30
-
[SQL Server 2008 R2 Tutorials](http://go.microsoft.com/fwlink/?linkID=220944)
30
+
[SQL Server 2008 R2 Tutorials](https://go.microsoft.com/fwlink/?linkID=220944)
31
31
Most of the SQL Server 2008 R2 tutorials work on a [!INCLUDE[ssSQL14](../includes/sssql14-md.md)] server. If you are new to Data Mining, use this link to find the SQL Server 2008 R2 Data Mining Tutorials that also work with a [!INCLUDE[ssSQL14](../includes/sssql14-md.md)] instance of Analysis Services.
32
32
33
33
## See Also
34
-
[TechNet WIKI: SQL Server 2012 Samples](http://go.microsoft.com/fwlink/?linkID=220734)
0 commit comments