Bruce Szabo


DTS: Copy Objects Task

SQL Server DTS may be one of the best tools ever included with a database server. It makes data movement, copying, any sort of ETL task a breeze. At least for the most part. Bruce Szabo found a place where the Copy Objects task sometimes doesn't work as expected. This article looks a problem he had as well as the solution that you can use to ensure that this task works reliably for you.

2004-10-13

8,831 reads

Review: SQLCentric

Monitoring your SQL Servers is something every DBA must do. Checking job status, disk space, etc. is a frequent question seen in our forums. Pearl Knowledge Solutions has developed a product to help you easily setup monitoring on your servers from a web interface. SQLCentric gets 4 stars from author Bruce Szabo; read his detailed review on this fine product.

5 (1)

2004-07-23

6,244 reads

Designing a Database with Microsoft Visio 2000

An extremely useful tool to reverse engineer a database is Visio 2000. It also has the ability to generate a database. This generation takes place after Visio has been used to draw the tables and relationships. This process can be a huge time saver. If a database needs to be tweaked and reworked it can be done in Visio and then regenerated. This article is intended to provide a nice introduction to using Visio 2000 to generate a database.

2002-07-22

9,011 reads

Blogs

Career: Talk To References

By

As we try to get through these strange times in the world, I am...

This Saturday: #DataWeekender, DataSaturday Southwest

By

Geeked to be speaking 2x on Saturday May 14, my second time speaking at...

Daily Coping 14 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

How can I tell where my Database encryption keys are kept

By cxmelga

Hello, can someone please help me with the following question, thanks in advance I...

UDF could not be bound

By Scott745618

Hi everyone, I have created a sum UDF and I cannot call  it. The...

Why doesn't the Secondary failover?

By FrankFarquar

Hi, I hope someone can help. I will try to summarise as best as...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Container Logs

See possible answers