Setup SQL Server 2012 Always On Availability Groups using Certificate 使用憑證設定SQL Server Always On Availability Groups

Setup SQL Server 2012 Always On Availability Groups using Certificate

使用憑證設定SQL Server Always On Availability Groups

Setup SQL Server 2012 Always On Availability Groups using Join Only 使用僅聯結選項來設定SQL Server Always On Availability Groups

Setup SQL 2012 Always On Availability Groups using Join Only

使用僅聯結選項來設定SQL Server Always On Availability Groups

可以做到不中斷服務，初始化次要資料庫的備份檔之後的交易會自動接續同步到次要資料庫

Setup SQL Server 2012 Always On Availability Groups using Skip initial data synchronization 使用略過初始資料同步處理來設定SQL Server AlwaysOn Availability Groups

Setup SQL 2012 Always On Availability Groups using Skip initial data synchronization

使用略過初始資料同步處理來設定SQL Server Always On Availability Groups

可以做到不中斷服務，初始化次要資料庫的備份檔之後的交易會自動接續同步到次要資料庫

Quick Setup a SQL Server 2012 Always On Availability Groups 快速設定SQL Server AlwaysOn Availability Groups

Quick Setup a SQL 2012 Always On Availability Groups

快速設定SQL Server Always On Availability Groups

Remove a crash SQL Cluster Node and add new SQL Cluster Node back to exist SQL Cluster 如何移除一個硬體損毀的節點，並且重新加入原來的叢集

Remove a crash SQL Cluster Node and add new SQL Cluster Node back to exist SQL Cluster

Manage a SQL Server failover cluster from command line or powershell 使用Command line或PowerShell管理SQL Server failover Cluster

Manage a SQL Server failover cluster from command line or powershell

使用Command line或PowerShell管理SQL Server failover Cluster

AD account permission required for SQL Server Failover Cluster Installation

AD account permission required for SQL Server Failover Cluster Installation

SQL Server 2012 certifications

SQL Server 2012 certifications
from my MSDN blog January 16, 2013

Microsoft SQL Server certifications
http://www.microsoft.com/learning/en/us/sql-certification.aspx

MCSA->MCSE->MCSM

Microsoft Certified Solutions Associate (MCSA)

SQL Server 2012 MCSA (required exam: 461 + 462 + 463)

70-461 (Training 10774) Querying Microsoft SQL Server 2012
70-462 (Training 10775) Administering Microsoft SQL Server 2012 Databases
70-463 (Training 10777) Implementing a Data Warehouse with Microsoft SQL Server 2012

Microsoft Certified Solutions Expert (MCSE)

SQL Server 2012 MCSE: Data Platform (required exam: 461 + 462 + 463 + 464 + 465)

70-464 (Training 10776) Developing Microsoft SQL Server 2012 Databases
70-465 (Training 20465) Designing Database Solutions for SQL Server 2012

SQL Server 2012 MCSE: Business Intelligence (required exam: 461 + 462 + 463 + 466 + 467)

70-466 (Training 10778) Implementing Data Models and Reports with Microsoft SQL Server 2012
70-467 (Training 20467) Designing Business Intelligence Solutions with Microsoft SQL Server 2012

Microsoft Certified Solutions Master (MCSM)

SQL Server 2012 MCSM: Data Platform (required exam: 461 + 462 + 463 + 464 + 465 + 88-986 + 88-987)

88-986 (not yet available) MCSM: Data Platform Knowledge exam
88-987 (not yet available) MCSM: Data Platform Lab exam

Add a node to an existing two-node SQL Server 2008 R2 Cluster 在已存在的SQL Server Cluster加入一個節點

Add a node to an existing two-node SQL Server 2008 R2 Cluster

Build a two-node SQL Server 2008 R2 Cluster with iSCSI 使用iSCSI磁碟建置一組2節點的SQL Server Failover Cluster

Build a two-node SQL Server 2008 R2 Cluster with iSCSI

使用iSCSI磁碟建置一組2節點的SQL Server Failover Cluster

SQL Server 2012 Installing on Windows Server 2012, Error while enabling Windows feature : NetFx3, Error Code : –2146498298

SQL Server 2012 Installing on Windows Server 2012, Error while enabling Windows feature : NetFx3, Error Code : –2146498298
from my MSDN blog January 7, 2013

1.安裝過程發生Error while enabling Windows Feature NetFx3, Error Code : –2146498298 的警告。

  Error while enabling Windows feature : NetFx3, Error Code : –2146498298 , Please try enabling Windows Feature : NetFx3 from Windows management tools and then run setup again.

2.解決方法是在安裝SQL Server 2012之前，在Windows Server 2012的新增角色及功能，啟用[.Net Framework 3.5 功能]。

 注意:此步驟必須點選[指定替代來源路徑]，並事先放入Windows Server 2012 Installation 光碟。

 如果光碟機是D，則輸入D:\sources\SxS

 指定替代來源路徑.Net Framework 3.5才能安裝成功。

 3.安裝完成後再開始安裝SQL Server 2012。


[Reference]

Enable .NET Framework 3.5 by using the Add Roles and Features Wizard
https://technet.microsoft.com/en-us/library/dn482071.aspx

Steps

1. In Server Manager, click Manage and then select Add Roles and Features to start the Add Roles and Features Wizard.
2. On the Select installation type screen, select Role-based or feature-based installation.
3. Select the target server.
4. On the Select features screen, check the box next to .Net Framework 3.5 Features.
5. On the Confirm installation selections screen, a warning will be displayed asking Do you need to specify an alternate source path?.

If the target computer does not have access to Windows Update, click the Specify an alternate source path link to specify the path to the \sources\sxs folder on the installation media and then click OK. After you have specified the alternate source, or if the target computer has access to Windows Update, click the X next to the warning, and then click Install.

If you are using Server Manager in Windows Server 2012 to add a role or feature to a remote server, the remote server’s computer account (DOMAIN\ComputerName$) requires access to the alternate source file path because the deployment operation runs in the SYSTEM context on the target server.

Installing NetFx3 on Windows Server 2012
http://garvis.ca/2013/01/04/installing-netfx3-on-windows-server-2012/