Alex Kersha


SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2006-02-20

20,292 reads

SQLServerCentral Article

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)

You rated this post out of 5. Change rating

2005-12-20

5,898 reads

Blogs

Know Thy Platform

By

IT and data professionals, I implore you – know thy platform. All of it....

Adding Git LFS Support – #SQLNewBlogger

By

I got this message recently while committing some changes: This post shows my work...

EightKB 2024

By

EightKB is back! The biggest online SQL Server internals conference is back in 2024…it’s...

Read the latest Blogs

Forums

How to suppress the info of queries execution in Stored Procedure.

By rkordonsky 63916

I inherited the Stored procedure the whole purpose of it is to populate our...

ssis catalog not showing all executions

By stan

Hi we just migrated to 2019.  Unlike our previous server on which every ssis...

Is there a such thing as connections being made too fast in a package?

By stricknyn

Hi all, SSIS doing some quirky things and I wanted to run a scenario...

Visit the forum

Question of the Day

A New Audit

I have a brand new D: drive on my system that is formatted, but contains no files or folders. What happens when I execute this code?

CREATE SERVER AUDIT audit2 TO FILE ( FILEPATH ='D:\audit' );
GO

See possible answers