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

20,078 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,817 reads

Blogs

The Second Annual, Official WordPress.com Growth Summit is Coming and You Won’t Want to Miss It

By

Join us August 17 (Americas) or August 18 (Asia-Pacific). Register today!

The Post Pandemic Office Experience

By

I traveled to Pasadena, CA this week to work with a few other Redgaters...

Connecting to Azure Blobs in Power BI

By

The step-by-step process below walks through connecting to data housed in Azure Blob Storage...

Read the latest Blogs

Forums

Get the last day of the year based on a date range

By dqurve

I am trying to get the last day of the year from a date...

Put two queries together

By stephen.aa

Hello: Right now I have two queries as shown below: SELECT D.DocumentID AS [Document...

Excel Formula to create SQL Script for a Values Table

By allinadazework

Comments posted to this topic are about the item Excel Formula to create SQL...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers