SQLServerCentral - Guest Columnist: Perry Whittle

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 | 7,272 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 2012/09/27 | Source: SQLServerCentral.com | Category: differential

Rating:

|

Discuss |

Briefcase | 2,379 reads

Combining AlwaysOn Groups With Failover Cluster Instances

This article discusses failover cluster instances and AlwaysOn groups Read more...

By Perry Whittle 2012/09/04 | Source: SQLServerCentral.com | Category: fci

Rating:

|

Discuss |

Briefcase | 3,728 reads

TDE and SQL Server Databases

The article discusses and demonstrates TDE for SQL Server databases Read more...

By Perry Whittle 2012/08/16 | Source: SQLServerCentral.com | Category: transparent data encryption (tde)

Rating:

|

Discuss |

Briefcase | 5,292 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 | 4,725 reads

How to Create a Corrupt SQL Server Database

This article details how to create a corrupt SQL Server database for testing purposes Read more...

By Perry Whittle 2012/05/04 | Source: SQLServerCentral.com | Category: checkdb

Rating:

|

Discuss |

Briefcase | 11,011 reads

SQL Server Log Shipping Between Standalone\Workgroup Computers

This article describes the requirements to log ship databases between workgroup computers Read more...

By Perry Whittle 2012/01/30 | Source: SQLServerCentral.com | Category: log shipping

Rating:

|

Discuss |

Briefcase | 2,480 reads

Implementing Microsoft iSCSI Initiator Policies & Multi Pathing

Impementing iSCSI multi-pathing and redundancy policies Read more...

By Perry Whittle 2012/03/09 | Source: SQLServerCentral.com | Category: iscsi

Rating:

|

Discuss |

Briefcase | 1,267 reads

Using and Creating Mount Points in SQL Server

This article talks about the use of mount points on Windows server for SQL Server installations and shows how you can create them. Read more...

By Perry Whittle 2011/11/10 | Source: SQLServerCentral.com | Category: mount points

Rating:

|

Discuss |

Briefcase | 5,442 reads

Creating a 2 Node SQL Server 2008 Virtual Cluster Part 3

This article continues the series on how to create a 2 node Windows\SQL Server 2008 cluster with a look at slipstreaming the service pack and cumulative updates needed. Read more...

By Perry Whittle 2011/08/12 | Source: SQLServerCentral.com | Category: clustering

Rating:

|

Discuss |

Briefcase | 4,210 reads

Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

Learn how to create a Windows\SQL Server 2008 virtual cluster. In this article learn about the Windows clustering setup. Read more...

By Perry Whittle 2011/07/12 | Source: SQLServerCentral.com | Category: clustering

Rating:

|

Discuss |

Briefcase | 5,703 reads

Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1

Learn how to create a Windows 2008\SQL Server 2008 virtual cluster in this three part series. Read more...

By Perry Whittle 2011/07/11 | Source: SQLServerCentral.com | Category: virtual

Rating:

|

Discuss |

Briefcase | 10,209 reads

Using Disparate File Paths in SQL Server Database Mirroring

Learn how you can setup Database Mirroring using disparate file paths and drive letters. Read more...

By Perry Whittle 2011/03/01 | Source: SQLServerCentral.com | Category: database mirroring

Rating:

|

Discuss |

Briefcase | 5,973 reads

Creating A SQL Server 2008\2008 R2 Failover Cluster

Details how to install a SQL Server 2008\2008R2 Failover Cluster Instance Read more...

By Perry Whittle 2011/01/19 | Source: SQLServerCentral.com | Category: clustering

Rating:

|

Discuss |

Briefcase | 10,083 reads

Slipstreaming SP\CU During Setup

This article shows how to slipstream the SP and CU during the SQL Server setup process. Read more...

By Perry Whittle 2010/12/27 | Source: SQLServerCentral.com | Category: slipstream

Rating:

|

Discuss |

Briefcase | 3,323 reads

Clustered instance will not start after removing builtin admins

After removing the builtin administrators group the clustered services do not start. Perry Whittle walks through the issue and what you can do to correct things. Read more...

By Perry Whittle 2010/04/16 | Source: SQLServerCentral.com | Category: clustering

Rating:

|

Discuss |

Briefcase | 1,413 reads

Setting up a SQL cluster under MS VS2005 R2 Part2

Continuing with setting up a 2 node SQL cluster under MS Virtual server 2005 Ent R2 SP1, Perry Whittle looks at the SQL configuration in this article. Read more...

By Perry Whittle 2009/05/15 | Source: SQLServerCentral.com | Category: clustering

Rating:

|

Discuss |

Briefcase | 3,748 reads

Setting up a SQL cluster under MS VS2005 R2 Part1

This article from Perry Whittle looks at setting up a 2 node SQL Server cluster under MS Virtual server 2005 Ent R2 SP1. Something that is very handy for testing clustered servers. Read more...

By Perry Whittle 2009/05/13 | Source: SQLServerCentral.com | Category: clustering

Rating:

|

Discuss |

Briefcase | 4,712 reads

SQL Server, SANs and Virtualisation

SAN's and virtualisation in the world of SQL server Read more...

By Perry Whittle 2009/01/08 | Source: SQLServerCentral.com | Category: san

Rating:

|

Discuss |

Briefcase | 8,911 reads