Jonathan Stokes


SQLServerCentral Article

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.

(1)

You rated this post out of 5. Change rating

2005-11-21

8,627 reads

SQLServerCentral Article

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.

You rated this post out of 5. Change rating

2005-07-25

11,539 reads

Blogs

Rambling about Data on Wheels – origins, branding, expansion

By

I have been asked many times about how the name “Data on Wheels” came...

Think Twice Before Enabling Fabric’s Inbound Network Protection

By

Fabric inbound network protection involves two tenant-level controls: Private Link and Block Public Internet...

Match the Model to the Task, Not the App: An Orchestrator-Worker Pattern in Python

By

Most apps that call an LLM send every request to the same model. That...

Read the latest Blogs

Forums

AI Observability Challenges in FinOps as a DBA

By dbakevlar

Comments posted to this topic are about the item AI Observability Challenges in FinOps...

Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL

By abdalah.mehdoini

Hello everyone , I am planning to migrate a database from SQL Server 2014...

SQL Agent Job Automated Change Capture Process

By James Greaves

Comments posted to this topic are about the item SQL Agent Job Automated Change...

Visit the forum

Question of the Day

Finding a Database Master Key

Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?

See possible answers