2005-12-16
2,376 reads
2005-12-16
2,376 reads
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.
2005-11-21
8,605 reads
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.
2005-08-15
6,925 reads
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.
2005-07-25
11,419 reads
2005-02-07
2,152 reads
By Steve Jones
The other day I got a note from Ben Weissman the other day that...
Knowledge of how your system behaves is vital to better control, maintain, and grow...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
We are most reliable and efficient suppliers/distributor of all kinds of commonly used pain...
I read the upgrade path for standard edition to SQL server 2019, the oldest...