Product and Book Reviews

SQLServerCentral Article

Visual Defrag for SQL Server Discount

  • Article

How often do you check your SQL Server tables for fragmentation? How often do you defragment them? This is one of those technologies that has been available for disks for a long time, but now is here for SQL Server. Norb Technologies is offering a discount to the SQLServerCentral.com community on this product.

You rated this post out of 5. Change rating

2005-11-01

4,107 reads

SQLServerCentral Article

SQL Rescue Review

  • Article

Having a good tool to read your SQL Server transaction log can be a lifesaver, or a job saver. RegGate Software, maker of a number of useful SQL Server utilities has a log reader and Grany Fritchey takes a look at this product and how it might work in your environment.

You rated this post out of 5. Change rating

2005-11-01

10,392 reads

SQLServerCentral Article

Review Armtech for SQL Server

  • Article

How many times have you wished you could throttle the CPU use of SQL Server? Or for a database? Prevent your developers from using too many resources while sharing the server with production or QA. ArmTech for Windows can do this and Dinsesh Asanka brings us a review of how this product worked in his environment.

You rated this post out of 5. Change rating

2005-07-26

5,476 reads

SQLServerCentral Article

Turbo for SQL Server

  • Article

Searching data is an essential part of SQL Server applications, especially text searching. While Full Text Search in SQL Server 2000 works, it lacks some important features that Turbo for SQL Server can handle. Read this review of the product and see if this is a way you can enhance the search functions in your application.

You rated this post out of 5. Change rating

2005-06-01

7,454 reads

SQLServerCentral Article

Litespeed for SQL Server

  • Article

Your backups are critical for the success and stability of your business. However as backup sizes grow and servers proliferate, managing the backups and storing all this data becomes a challenge. Dale Elizabeth Corey brings us a look at Imceda's Litespeed for SQL Server, a fantastic utility for helping manage your backups.

5 (1)

You rated this post out of 5. Change rating

2005-05-11

21,984 reads

SQLServerCentral Article

SQL Backup 3.0

  • Article

SQL Server 2000 has a rock solid backup process and one that many people have relied upon for years. However with the growth in database sizes and the constant load on many database servers, a third party backup utility is almost required in many environments. Kathi Kellenberger takes a look at Red-Gate Software's SQL Backup 3.0 and how it performs in her environment.

5 (2)

You rated this post out of 5. Change rating

2005-04-27

12,397 reads

SQLServerCentral Article

SQLH2: The Free Health, History and Performance Monitoring Tool

  • Article

One of the strengths and powers of the SQL Server platform over others is the shear number of things that are available free from Microsoft besides the relational platform. DTS, Reporting Services, SQLAgent, and more are included with the product. One of the newer utilities is SQLH2, a performance monitoring tool that is reviewed here by Kathi Kellenberger.

4.8 (5)

You rated this post out of 5. Change rating

2005-03-28

18,573 reads

SQLServerCentral Article

Netlib Encryptionizer Review

  • Article

SQL Server 2000 has a weak point in how it handles security. SA can see everything, a notion that disturbs many people, especially those that have data security requirements. Netlib has a great product that allows you to encrypt columns, tables, or databases in a way that is seemless to your application. Dale Corey takes a look at this product and how you might use it in your application.

You rated this post out of 5. Change rating

2005-03-07

8,009 reads

Technical Article

Review of Adventnet SwisSQL SQLOne Console, SQL Query Converter

  • Article

Recently, SwisSQL approached me for a review of their product that can convert SQL statements from one dialect to another. They told me that "SwisSQL SQLOne Console" is a GUI application that can convert SQL statements from one RDBMS implementation to another and the dialects supported include:

Microsoft SQL Server
Sybase
Oracle
IBM DB2
Informix
MySQL
PostgreSQL
MySQL
and last but not the least, ANSI SQL

2005-02-24

1,438 reads

Blogs

Local LLM Models at SQL Saturday Boston 2025

By

I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...

3 things you must do to start data quality management right

By

As a data & AI strategist who’s seen countless projects succeed and fail, I...

Set Theory vs. Batch Mode in SQL Server

By

Set Theory vs. Batch Mode in SQL Server Not long ago,...

Read the latest Blogs

Forums

Changing the Recovery Time

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Changing the Recovery Time

SSC Website Deployment 24 Sept 2025

By Steve Jones - SSC Editor

We are planning on a fairly big code deployment to set the stage for...

Timeout when expanding the table

By LearningDBA

Experts, I am hoping to get some help and feedback. I have a server...

Visit the forum

Question of the Day

Changing the Recovery Time

I want to change the recovery time for a database running on SQL Server 2022. What are my options for setting the value in my ALTER DATABASE statement. If I run this code, what can I use in place of the xxx to define what 12 means?

ALTER DATABASE Finance 
 SET TARGET_RECOVERY_TIME = 12 xxx;

See possible answers