Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Perry Whittle

SQLServerCentral.com profile

   Items 1 to 20 of 34    Older >>
 

Stairway to AlwaysOn Level 8: Segregate Mirror Traffic in AlwaysOn

this article details how to segregate the mirror traffic in an AlwaysOn group configuration  Read more...
By Perry Whittle 2016/03/09 | Source: SQLServerCentral.com | Category: alwayson
Rating: (not yet rated) |  Discuss |   Briefcase | 1,225 reads

How to execute a Powershell script via SSIS

Learn how you can execute a PowerShell script via the SSIS execute process task.  Read more...
By Perry Whittle 2015/12/03 | Source: SQLServerCentral.com | Category: execute process task
Rating: |  Discuss |   Briefcase | 3,724 reads

SMKs, DMKs, Certificates for TDE and Encrypted Backups

This article details SMKs, DMKs and certificates in SQL Server as they relate to Transparent Data Encryption and Encrypted Backups.  Read more...
By Perry Whittle 2015/12/09 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 1,925 reads

Stairway to AlwaysOn Level 7: Combining FCIs with Availability Groups

In Level 7 of this stairway, we look at combining Availability Groups with FCIs for both HA and DR protection.  Read more...
By Perry Whittle 2015/07/01 | Source: SQLServerCentral.com | Category: high availability
Rating: |  Discuss |   Briefcase | 2,902 reads

Using Encrypted Backups in SQL Server 2014

This article details encrypted backups and how they are implemented in SQL Server 2014.  Read more...
By Perry Whittle 2014/05/15 | Source: SQLServerCentral.com | Category: encryption
Rating: |  Discuss |   Briefcase | 2,650 reads

Stairway to AlwaysOn Level 6: Analyse & Deploy an AlwaysOn Availability Group

In level 6 of this stairway, we will look deeper into Availability Groups and how to set them up along with a Listener.  Read more...
By Perry Whittle 2015/03/25 | Source: SQLServerCentral.com | Category: stairway
Rating: |  Discuss |   Briefcase | 4,610 reads

Stairway to AlwaysOn Level 5: Analyse & Deploy a Failover Cluster Instance

In Level 5 of this stairway, we help you understand and deploy a Failover Cluster Instance (FCI).  Read more...
By Perry Whittle 2015/02/11 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 3,615 reads

Stairway to AlwaysOn Level 4: Analyse & Deploy a Windows Server Failover Cluster

In level 4 of the stairway to AlwaysOn we look at creating a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2014/12/10 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 3,948 reads

Stairway to AlwaysOn Level 3: Infrastructure 101

In this next level of the Stairway to AlwaysOn, we will look at the components required to implement a Windows Server Failover Cluster.  Read more...
By Perry Whittle 2014/10/29 | Source: SQLServerCentral.com | Category: cluster
Rating: |  Discuss |   Briefcase | 5,511 reads

Stairway to AlwaysOn Level 2: Storage 101

level 2 of the stairway  Read more...
By Perry Whittle 2014/10/01 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 6,075 reads

Stairway to AlwaysOn Level 1: What is "SQL Server AlwaysOn"?

Level 1 of the stairway looks at exactly what the technologies "AlwaysOn", "Failover Cluster Instance" (FCI) and "Windows Server Failover Cluster" are. We'll look at each in detail and summarize where in the High Availability stack they sit.  Read more...
By Perry Whittle 2016/02/24 (first published: 2014/09/24) | Source: SQLServerCentral.com | Category: failover clustered instance (fci)
Rating: |  Discuss |   Briefcase | 16,675 reads

SQL Server 2012 AlwaysOn Groups and FCIs Part 4

This is Part 4 of a series on AlwaysOn and FCI integration in SQL Server. In this article we will learn how to add the iSCSI disk storage to our SQL Server nodes and build the cluster.  Read more...
By Perry Whittle 2014/05/20 | Source: SQLServerCentral.com | Category: mirroring
Rating: |  Discuss |   Briefcase | 3,622 reads

SQL Server 2012 AlwaysOn Groups and FCIs Part 3

Part 3 of the AO and FCI integration series. This article gets SQL Server configured on the nodes and ready for work.  Read more...
By Perry Whittle 2014/04/03 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 3,439 reads

SQL Server 2012 AlwaysOn Groups and FCIs Part 2

This is Part 2 of a series on AlwaysOn and FCI integration in SQL Server. In this article we will learn how to add the iSCSI disk storage to our SQL Server nodes and build the cluster.  Read more...
By Perry Whittle 2014/03/06 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 4,404 reads

SQL Server 2012 AlwaysOn Groups and FCIs Part 1

Learn how to get a Failover Cluster Instance set up and configured with Windows and SQL Server. This is part of a series showing how to combine a Failover Cluster Instance of SQL Server with an AlwaysOn availability group.  Read more...
By Perry Whittle 2014/02/10 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 7,651 reads

Moving Database Files in SQL Server

A short article that talks about the isues with moving SQL Server database files around on your storage subsystem.  Read more...
By Perry Whittle 2013/02/11 | Source: SQLServerCentral.com | Category: files and filegroups
Rating: |  Discuss |   Briefcase | 8,015 reads

Repairing a Broken Log Shipping Plan From a Differential Backup

This article details how to reinitialise a Log Shipping scenario from a primary differential backup  Read more...
By Perry Whittle 2013/12/20 (first published: 2012/09/27) | Source: SQLServerCentral.com | Category: differential
Rating: |  Discuss |   Briefcase | 3,519 reads

Combining AlwaysOn Groups With Failover Cluster Instances

This article discusses failover cluster instances and AlwaysOn groups  Read more...
Rating: |  Discuss |   Briefcase | 8,809 reads

TDE and SQL Server Databases

The article discusses and demonstrates TDE for SQL Server databases  Read more...
Rating: |  Discuss |   Briefcase | 5,960 reads

AlwaysOn Availability Groups in SQL Server 2012

This article discusses and demonstrates AlwaysOn Availability groups in SQL Server 2012, a new feature for high availability.  Read more...
By Perry Whittle 2012/08/28 | Source: SQLServerCentral.com | Category: alwayson
Rating: |  Discuss |   Briefcase | 7,608 reads
   Items 1 to 20 of 34    Older >>