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)

2008-06-27 (first published: )

64,972 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)

2008-04-17

7,768 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)

2005-01-13

12,698 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)

2001-11-25

4,254 reads

Blogs

Join Denny Cherry and Associates at SQL Bits 2023

By

I am very excited and lucky to be speaking once again at SQLBits along...

Daily Coping 27 Jan 2023

By

Today’s coping tip is to try something new to get out of your comfort...

Things to look out for while TDE is encrypting existing data

By

Monitoring for Problems The encryption of your existing data occurs as a background process...

Read the latest Blogs

Forums

ROUND or CONVERT the output of the POWER function

By Chrissy321

Hello smart people, I am trying to use the POWER function to return data...

Weird Log Backup Failure message

By Lee Linares

I found the same error message in the SQL Error log on 3 dozen...

Roles in cluster

By PJ_SQL

Hello! When we failover one node from another, does the roles from the node...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers