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,312 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,740 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,543 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)

You rated this post out of 5. Change rating

2001-10-26

5,845 reads

Blogs

JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

By

I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...

Cultural Change: Fostering a Cost-Aware Culture in Your Organisation

By

After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...

Beyond VARBINARY: How to Store PDFs in SQL Server Using FILESTREAM and FileTable

By

Hello, dear blog reader. Today’s post is coming to you straight from the home...

Read the latest Blogs

Forums

Creating a JSON Document I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a JSON Document I

Who is Irresponsible?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Who is Irresponsible?

Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments

By Massimo Preitano

Comments posted to this topic are about the item Designing Database Changes Before Deployment:...

Visit the forum

Question of the Day

Creating a JSON Document I

I want to create a JSON document that contains data from this table: 

TeamID  TeamName  City          YearEstablished
1       Cowboys   Dallas        1960
2       Eagles  Philadelphia  1933
If I run this code, what is returned? 
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers