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,845 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,799 reads

Blogs

AWS RDS SQL Server Announcements - 2019

By

1.    Amazon RDS SQL Server Supports differential and log and restores: https://aws.amazon.com/about-aws/whats-new/2019/11/amazon-rds-for-sql-server-now-supports-differential-restores-and-log-restores/  2.    Amazon RDS SQL...

AWS RDS SQL Server Version List

By

AWS RDS SQL Server 2017 Builds RDS...

What is a strong password anyway?

By

Background Fellow Microsoft MVP Troy Hunt (blog | Twitter) has been operating the website Have...

Read the latest Blogs

Forums

Recommendation on catching up with SQL from Older version

By YSLGuru

If you're used to working with SQL Server 2008R2 and to lesser extent, 2012...

Upgrade SQL Server

By Admingod

Planning to upgrade the DB from SQL 2012 to SQL 2016. However, the application...

Looking for SQL Code

By patla4u

Hi I am having situation where I would like to update the existing data...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers