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
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.
2004-07-23
6,244 reads
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!
2004-04-08
9,810 reads
2004-03-08
10,924 reads
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.
2004-02-17
5,410 reads
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.
2003-08-28
6,795 reads
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.
2002-08-22
6,239 reads
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
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.
2002-07-09
11,208 reads
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.
2002-06-28
4,529 reads
By Steve Jones
As we try to get through these strange times in the world, I am...
By Will Assaf
Geeked to be speaking 2x on Saturday May 14, my second time speaking at...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hello, can someone please help me with the following question, thanks in advance I...
Hi everyone, I have created a sum UDF and I cannot call it. The...
Hi, I hope someone can help. I will try to summarise as best as...
Ask SSC