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

Guest Columnist: Jonathan Stokes

SQLServerCentral.com profile

   Items 1 to 3 of 3   

DTS Standards

SQL Server 2000 brought us DTS, a new way of working with data movement for SQL Server DBAs. However, unlike Integration Services and Project REAL, there weren't any great standards for working with this tool and building portable solutions was hard. Jonathan Stokes brings us a great article on how you can create a standard structure for your packages and make them more portable.   Read more...
By Jonathan Stokes 2005/11/21 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 8,599 reads

Single Point of Administration

Whether you write TSQL code or front end VB code against your SQL Server, it pays to have some good development practices that make your life easier. Jonathan Stokes has written a good article showing some of the good practices you should use.   Read more...
By Jonathan Stokes 2005/08/15 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 6,915 reads

Portable DTS Packages

Moving DTS Packages from one SQL Server 2000 server to another can be a real hassle. There are any number of issues that occur whenever you seek to use a package on different servers. New author Jonathan Stokes brings us a technique he's used many times to build portable DTS packages.   Read more...
Rating: |  Discuss |   Briefcase | 11,383 reads
   Items 1 to 3 of 3