2005-12-16
2,377 reads
2005-12-16
2,377 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,606 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,927 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,430 reads
2005-02-07
2,154 reads
By kleegeek
I am thrilled to have been a part of this year’s Storage Field Day...
The other day I was asked to supply a list of all of the...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi team, We have already enabled a SQL filestream for storing API request and...
Hi team, We have already enabled a SQL filestream for storing API request and...
Hello Is there any good query available to find when the AG mode is...