SQL Server provides the ability to reassign the ports that are used by the default instance and any named instances. In SQL Server 2008 R2, and SQL Server 2012, you reassign the TCP port by using SQL Server Configuration Manager…. Read More ›
SQL
Migrate SQL Server to another SQL Server (same or new version) sharepoint
This is a step by step guide on how you migrate your SharePoint’s (I used 2010 version in this instance) SQL Server to an new SQL Server host. In this exercise I tried migrating it in a new version of… Read More ›
Configuring SQL Server 2014 AlwaysOn Availability Group using PowerShell
Introduction Earlier on I was trying to search for some scenarios to implement AlwaysOn Availability Groups using PowerShell, although I was able to find some interesting post however non of them represented a complete scenario starting from a fresh windows… Read More ›
Add SQL Server Availability Group to Exiting Failover Cluster Instance–Part1 of 2
Introduction Microsoft SQL Server 2012/2014 AlwaysOn provides flexible design choices for selecting an appropriate high availability (HA) and disaster recovery (DR) solution for your application. Building on that fact I will be providing a posts that provides a step-by-step configuration… Read More ›