Paul Ibison

Currently work in Aldgate, London for Pygmalion - a Microsoft CTEC - as a Trainer/Developer/Consultant. Specialise in SQL 2000 OLAP and am now beginning to learn Sharepoint Server and .NET
  • Interests: Collecting slide-rules and watching my complete collection of 'Are you being served'.

SQLServerCentral Article

Log Shipping vs. Replication

SQL Server high availability. Log shipping or replication, clustering or some other solution. It's a challenge and as companies grow more dependent on their databases, it's one that more and more DBAs face everyday. Paul Ibison has taken a look at how log shipping and replication can be compared in the quest for high availability.

4.57 (37)

You rated this post out of 5. Change rating

2008-06-27 (first published: )

65,324 reads

SQLServerCentral Article

High Availability (DR) Using SQL Server 2005 Transactional Replication

One of the four high availability technologies in SQL Server is replication, though this can be very cumbersome to setup and get working. Longtime author Paul Ibison looks at how this has changed from SQL Server 2000 to 2005 and what you should consider before setting this up.

3.89 (9)

You rated this post out of 5. Change rating

2008-04-17

7,768 reads

SQLServerCentral Article

Retain NULL values vs Keep NULLs in SSIS Dataflows - Which To Use?

Integration Services allows you to import all kinds of data easily into SQL Server as well as transform is along the way. Longtime author Paul Ibison brings us a look at how you should set your transformations to deal with NULL values.

4.92 (38)

You rated this post out of 5. Change rating

2008-02-13

11,719 reads

SQLServerCentral Article

Altering a column on a Replicated Table

SQL Server 2000 replication is usually simple and easy to setup and work with. However there are many restrictions to ensure this, one of which is the alteration of a column which is engaged in replication. Author Paul Ibison brings us two options for altering columns.

4.33 (15)

You rated this post out of 5. Change rating

2008-01-14 (first published: )

43,119 reads

SQLServerCentral Article

Merge Replication - Manual Range Handling

SQL Server 2000 replication is a great feature, but it can cause some headaches at times. Since the use of identities is something many people take advantage of, learning to handle these in a replication scenario is critical. Author Paul Ibison has done extensive work with replication and brings us two techniques to help manage the ranges of values.

5 (2)

You rated this post out of 5. Change rating

2005-01-13

12,703 reads

Technical Article

How to Short-circuit Where Clauses

There are many times when you might be concatenating text in a stored procedure to make a where clause, because the input parameters are optional. An alternative is to create many versions of the stored procedure - one for each possible combination of parameters - which can soon become too big. There is a more […]

3.75 (4)

You rated this post out of 5. Change rating

2001-11-25

4,258 reads

Blogs

Announcing a New Book on SQL from 3Cloud Authors

By

I am proud to announce the launch of a new book, centered around the...

Identify the (Top 20) most expensive queries across your SQL Server using Query Store

By

Script to identify the most expensive queries on your database server using the Query...

Setting Up Always Encrypted

By

In this post we're going to go through the steps to set up Always...

Read the latest Blogs

Forums

TOP with Order By alternative, performance results look mixed

By MMartin1

Hi I have a situation where I am testing two versions of the same...

Upgrading an Always on Availability Group two node from SQLServer 2016 to 2019

By ericwenger1

I'm looking for best practice here and these are Azure VMs by the way....

Azure availability groups requirements question

By Brandie Tarvin

Does anyone know if Azure absolutely requires windows clustered services to support availability groups?...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers