Bruce Szabo


SQLServerCentral Article

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,915 reads

SQLServerCentral Article

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,246 reads

SQLServerCentral Article

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,032 reads

Technical Article

Kill Processes in a Database

This script kills all the processes using a given database.  It is useful for removing users from a database so it can be restored.To use this script change the server variable and the database variable at the top of the script.  Notifications are written to the windows application eventlog.Use this script at your own risk. […]

2002-07-12

1,080 reads

Blogs

Daily Coping 31 Jan 2023

By

Today’s coping tip is to take a small step towards and important goal. One...

Tales From The Field Weekly Wrap Up for the Week of 01-23-2022

By

 Hello Dear Reader!  It's been a while since I had time to sit down...

CONCAT_WS Function Truncates Text

By

I was writing some dynamic SQL that generates some SQL statements to load my...

Read the latest Blogs

Forums

SSIS Sort Alphanumeric?

By John524

Hello, I'm pretty new to SSIS, but I have an Excel source that I...

How to get number of unique months from table

By pelusch

Hi guys, I want some help with a code to count the number of...

Track Insert/Update/Delete Operations in Sql Server DB Table

By RCRock

Hi Team, I have a requirement to track any insert/update/Delete operations happened against Database...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers