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,343 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,902 reads

Blogs

Simple Talks Episode 9–Data masking and subsetting

By

The episode on data masking and subetting is out. You can see it here:...

T-SQL Tuesday #180: Avoid Perfect for Good Enough

By

I'm listening to Effortless by Greg McKeon (link to author's page) through Audible.com. He...

Book Review – Humanizing Data Strategy by Tiankai Feng

By

This book was making its rounds on social media, and the concept seems interesting...

Read the latest Blogs

Forums

DBATools in a agent job

By tuokek

Hi Dbatools is used to copy table data from domain a to domain b...

SQL server help (converting rows to columns)

By don075

I am using the following sql to convert rows into columns for each pid,...

Ingesting Data From REST API endpoints: Data Engineering with Fabric

By John Miner

Comments posted to this topic are about the item Ingesting Data From REST API...

Visit the forum

Question of the Day

The Hash Join I

What are the two inputs called to a hash join operation in SQL Server? (choose 2)

See possible answers