Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Bruce Szabo

SQLServerCentral.com profile

   Items 1 to 11 of 11   
 

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.   Read more...
By Bruce Szabo 2004/10/13 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 8,681 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.   Read more...
By Bruce Szabo 2004/07/23 | Source: SQLServerCentral.com | Category: product reviews
Rating: |  Discuss |   Briefcase | 6,227 reads

Restore a DTS package from a DTS Store

Probably not a task you'll have to do very often, all the better that someone has laid out how to do it in good detail!   Read more...
By Bruce Szabo 2004/04/08 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,777 reads

A DTS Data Store

Looks at some basic concepts of DTS and a couple ideas for putting it to work.   Read more...
By Bruce Szabo 2004/03/08 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 10,867 reads

Review of Transact SQL Desk Reference

Looking for a good (or another) TSQL reference? This might be the one. Bruce took a good look at it and points out both the good and the bad.   Read more...
By Bruce Szabo 2004/02/17 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: (not yet rated) |  Discuss |   Briefcase | 5,389 reads

VBScript Class to Return Backup Information

The second article in a 3 part series that presents another VBScript class file that creates a class that can be used to display the backup information from a SQL server's maintanence plans.   Read more...
By Bruce Szabo 2003/08/28 | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 6,735 reads

VBScript Classes to Query SQL Server for Backup Information

A VBscript class is created that can be used to query the maintenance plans on an SQL server to determine when a backup has occurred. This class can be used with others to create a scripted method for monitoring backups.   Read more...
By Bruce Szabo 2002/08/22 | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 6,118 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.   Read more...
By Bruce Szabo 2002/07/22 | Source: SQLServerCentral.com | Category: basics
Rating: |  Discuss |   Briefcase | 8,952 reads

Using DTS to Detect and Process a File

This article shows how to use a DTS package to detect a file. After the detection of the file the processing of the file can be completed. This code in the .DONE processing section uses the Wscript.Shell command to unzip a file.   Read more...
By Bruce Szabo 2002/07/09 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 11,188 reads

Storing Checkbox Responses as Integers

This article demonstrates how to store checkbox results as integers in a database...perfect for surveys!   Read more...
By Bruce Szabo 2002/06/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,172 reads

Querying Responses

Binary data can be stored as integers in a table. This article explains how to query an integer field to return the bits represented by the integer.   Read more...
By Bruce Szabo 2002/06/28 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,422 reads
   Items 1 to 11 of 11