SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Paul Ibison

SQLServerCentral.com profile

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

   Items 1 to 9 of 9   

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.  Read more...
By Paul Ibison 2008/04/17 | Source: SQLServerCentral.com | Category: high availability (ha)
Rating: |  Discuss |   Briefcase | 7,739 reads

Transactions in Transactional Replication

SQL Server MVP Paul Ibison takes a look at how transactions are handled in replicated environments and the implications of rollbacks.  Read more...
By Paul Ibison 2008/04/03 | Source: SQLServerCentral.com | Category: transactional replication
Rating: |  Discuss |   Briefcase | 5,739 reads

Simple Method for Importing Ragged files

This article explains how to import text files using SSIS in those cases where the text files have different formatted data on different rows. The solution recommended involves minimal coding and is highly maintainable.   Read more...
Rating: |  Discuss |   Briefcase | 7,639 reads

Coping with No Column Names in the SSIS OLEDB Data Source Editor

Longtime author Paul Ibison brings us a short look at a common problem in Integration Services: your source has no column names.  Read more...
Rating: |  Discuss |   Briefcase | 6,218 reads

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.  Read more...
Rating: |  Discuss |   Briefcase | 4,490 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.   Read more...
By Paul Ibison 2005/01/13 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 12,535 reads

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.   Read more...
By Paul Ibison 2007/11/30 (first published: 2005/01/19) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 35,550 reads

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.   Read more...
By Paul Ibison 2008/06/27 (first published: 2004/06/17) | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 60,056 reads

Allowing BULK INSERT for non-SysAdmin Users in SQL 7.0

One of the largest security "issues" in SQL Server 7.0 is that a user must be in the SysAdmin role to run the BULK INSERT command. This article by Paul Ibison shows you a workaround.   Read more...
By Paul Ibison 2001/10/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,854 reads
   Items 1 to 9 of 9