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'.

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: )

63,398 reads

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,756 reads

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,651 reads

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,252 reads

Blogs

SQL Server on Linux Storage Secrets on Microsoft Channel 9

By

I’m thrilled to have recently released a video with Microsoft’s Data Exposed on Channel...

Daily Coping 29 Jul 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Server vs Instance. A rant.

By

It’s a SQL Server Instance not a SQL Server. The product is SQL Server....

Read the latest Blogs

Forums

SQL Server Agent producing unreproducible error

By Thom A

I've built a Powershell script, which I want to run through SQL Server Agent....

Replace hexidecimal value wih '§' or blank in a TEXT field

By Edvard Korsbæk

I have a DB with a field defined as: dag_text text allow nulls I...

Monitor data and update it conditionally

By kittil

Hi, Is there a way for monitoring data in a table and update it...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers