Product and Book Reviews

Technical Article

myLittleAdmin for MS SQL and MSDE released !

  • Article

myLittleTools.net is pleased to announce the release of myLittleAdmin, the most advanced and robuste web-based MS SQL and MSDE database administration tool. This new version offers a new skinnable interface and a lot of great new features, such as user levels, multi-databases support or SQL script generation. A lite version is available for free so that you can test it in your own environment. Use myLittleAdmin and do through a browser almost everything you did before with Enterprise Manager.

2003-06-17

1,164 reads

SQLServerCentral Article

A Sneak Peek at Entegra

  • Article

Recently, the SQLServerCentral.com labs had the chance to get a sneak peak at Lumigents latest creation, Entegra, which is scheduled to ship in the second week in December. Entegra monitors database activity and provides a complete record of access to the data and changes to database structure and permissions.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2002-11-13

3,307 reads

SQLServerCentral Article

Review of SQLZip

  • Article

Running short of disk space? One way to solve that is to keep fewer backups on disk, or write a routine that will compress them to conserve space. Or you could try SQLZip, an add in that creates compressed backups. Read the review, see if it's something you should consider!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2002-04-16

5,735 reads

SQLServerCentral Article

Total SQL Analyzer Review

  • Article

Often times, a DBA is asked by clients to document their entire server. This usually includes jobs, database objects and DTS packages. What an utterly boring task it is for a DBA to document the properties of each column, table, and database. FMS's new Total SQL Analyzer to the rescue, freeing up time for people who are tired of creating mountains of documentation.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2001-12-12

3,535 reads

SQLServerCentral Article

Easily Create Insert Scripts with AutoInserts

  • Article

One of the most pain-staking tasks a developer and DBA must often accomplish is to create an install procedure for the database. This involves creating the necessary DDL to create the tables, relationships and indexes. Inevitably in this process you forget about the data. AutoInserts to the rescue!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

1 (1)

You rated this post out of 5. Change rating

2001-10-26

5,839 reads

Blogs

Understanding Zonal Redundancy in Azure SQL MI

By

Do you know what happens when you enable zonal redundancy for your SQL managed...

SQL Server Database Compatibility Levels

By

Why You Shouldn’t Overlook This Quiet but Critical SQL Server Setting   If you’ve...

The PASS Summit on Tour in the Netherlands

By

The PASS Summit goes on tour this year, with the final date the first...

Read the latest Blogs

Forums

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

By Chandan Shukla

Comments posted to this topic are about the item How a Legacy Logic Choked...

Cycle Logs (non-error log)

By Mr. Brian Gale

Hello all, I am hoping that this is an easy question and I'm just...

Execution plan shows enormous number of records

By yerbabuena19

The problem was reported to us by a customer. They shared a graphic execution...

Visit the forum

Question of the Day

The Updated Columns List

I have this table in SQL Server 2022: 

CREATE TABLE CustomerLarge
  (CustomerID               INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED
 , CustomerName             VARCHAR(20)
 , CustomerContactFirstName VARCHAR(40)
 , CustomerContactLastName  VARCHAR(40)
 , Address                  VARCHAR(20)
 , Address2                 VARCHAR(20)
 , City                     VARCHAR(20)
 , CountryCode              CHAR(3)
 , Postal                   VARCHAR(20)
)
GO
If I check the columns_updated() function return in a trigger, what is the data returned?

See possible answers