Alex Kersha

DTS and Global Variables

SQL Server 2000's DTS subsystem is a tremendously flexible environment for handling any number of tasks on your SQL Server. Alex Kersha used DTS to implment a task that manages the number of backup files on his server, which is conifgurable with a global variable. Read on and get the code to implement this task on your servers.

5 (2)

2006-02-20

19,874 reads

DTS Hashing

DTS is a great tool in SQL Server 2000 for easily setting up jobs to import or export data. But it can also have security risks. New author Alex Kersha brings us a simple security technique to be sure that you are properly executing your DTS packages in a secure manner.

4 (1)

2005-12-20

5,800 reads

Blogs

Daily Coping 9 Apr 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...

Webinar: How to unlock the value of frequent deployments

By

I’m doing a webinar next week, on Wednesday, April 15, 2020, that looks at...

SSMS 18.5 Fixes from Redgate

By

I wrote yesterday about the issues with SSMS 18.5 and some of the add-ins...

Read the latest Blogs

Forums

ALWAYS On Setup problem

By interest

While configuring N1 and N2  Nodes connected to DC  Domain Controller working fine. Establishing...

Do You Have a Mentor?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Do You Have a Mentor?

Counting Rows in DAX

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Counting Rows in DAX

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers