The PGP part is easy using GnuPGP as it can handle input from either a file or from another program. The problem is getting the data from the...
ActiveX was a bit unfamiliar, so I ended up writing two encryption functions on the source server and performing decryption and then immediate...
A DTS is reading fields from a source database using a stored procedure. Before storing certain fields in the (different) destination database, they...
An existing DTS selects rows from various tables and outputs them to a CSV file. I need to use PGP (the command line version) to encrypt that output...
What's a good way to download five SQL Server 2005 databases from production to my laptop for development work with Visual Studio? Our application...
Thanks much for your replies. This machine is a dual-core system and that's a snapshot of performance. The CPU ranges from 30% to 80% and probably...
When monitoring the performance of our production SQL Server 2005 system, it's now running much better thanks to help from people here. Now that...
That sounds like a good plan. Could you share how you perform those two jobs? If they are custom scripts, is there any chance you could share them?
Thanks to everyone for the help. When talking to the hosting company about the tape backups they perform, they commented that for our largest...
The backups in the maintenance plan are all to disk. Unfortunately, on that database server everything is on one partition including Windows Server...
Here's our maintenance plan for a production database server. Hosting company backups: Full backup to tape each Sunday, diff backups to tape...
Thanks much, MohammedU. That helps me significantly.
I'm reading about the fill factor setting in Sql Server 2005. Most sources recommend a setting of 80 to 90, depending on how the table is used....
Reviewing our databases, we find 31% of our indexes have index fragmentation above 30% and should be rebuilt. Yesterday, I found fragmentation of the...
Thanks, Roji! I'm using Microsoft SQL Server Management Studio 9.00.1399.00 so access a remotely hosted Sql Server 2005 database on Windows Server...
If I take the first SQL example from Reorganizing and Rebuilding Indexes and try to execute it, it fails with this error: "Msg 102, Level 15, State...
I've inherited a production SQL Server 2000 database that was migrated to SQL Server 2005 by restoring backup tapes on the new server. Stored...
Separate names with a comma.
