Additional Articles

All authors

Technical Article

Red Earth Technologies releases Superior SQL Builder

Red Earth Technologies announces the release of Superior SQL Builder, a new SQL tool that visually builds complete SQL scripts, not just single queries. It employs a completely different method of developing SQL scripts. By taking advantage of new scripting technology, Superior SQL Builder can visually build complete SQL scripts within a single, integrated environment. This means that SQL scripts can be developed faster, while reducing syntax and logic errors. (Not Reviewed)

2003-08-12

68 reads

Technical Article

Log Navigator Final Beta Released

The final beta of Log Navigator has been released. This sql server auditing tool reads the MS SQL Server transaction log to track all data changes with no performance overhead or use of triggers. You can read database auditing trails from activity that took place even before the tool was installed. Powerful filters allow you to sort audit data by date, user, table and more. New features include LIVE LOG support and XML export. (Not Reviewed)

2003-08-11

48 reads

Technical Article

SQLCentric

This is an update to v1.2 of the product which does monitoring of your SQL servers. Looks like it checks service status, jobs, disk space, some other things. (Not Reviewed)

2003-08-01

1,425 reads

Technical Article

MZTools - Addin for VB6

Freeware! This add-in gives you some great extra features when working in VB6. It has a tab index setter, options to add a chunk of error handling code, a simple code analyzer that gives you some metrics, and my favorite - an option to identify unused code and variables. If you're still using VB6 it's worth trying.

2003-07-30

1,541 reads

Technical Article

New Product - Equivalent Script

At Last! No need to convert SQL Scripts from one dialect to another. Although SQL is a simple language, it can be tedious, inaccurate and frustrating when developing equivalent SQL scripts for multiple database servers. This product handles the conversion for you. (Not Reviewed)

2003-07-15

804 reads

All authors

Blogs

A Fabric solution can be very cost effective

By

Are you currently using Microsoft Fabric or considering migrating to it? If so, there...

Track SQL Server Configuration Changes Using the Error Log

By

Track SQL Server Configuration Changes Using the Error Log If you...

Data Engineering Books Worth Having on Your Shelf (or your tablet)

By

Good documentation gets you started. Good books get you deep. After years of working...

Read the latest Blogs

Forums

SQL Server Showing Out of Space But Plenty of Drive Space

By AMCity

We have a SQL Server installed. We have a 500GB drive for the database....

Creating a JSON Document IV

By Steve Jones - SSC Editor

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

Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE

By VishnuGupthanSQLPowershellDBA

Comments posted to this topic are about the item Restoring Azure Key Vault Keys...

Visit the forum

Question of the Day

Creating a JSON Document IV

I have this data in a table called dbo.NFLTeams 

TeamID  TeamName       City             YearEstablished
------  --------       ----             ---------------
1       Cowboys        Dallas           1960
2       Eagles         Philadelphia     1933
3       Packers        Green Bay        1919
4       Chiefs         Kansas City      1960
5       49ers          San Francisco    1946
6       Broncos        Denver           1960
7       Seahawks       Seattle          1976
8       Patriots       New England      1960
If I run this code, how many rows are returned? 
SELECT 
  YearEstablished,
  json_objectagg(city : TeamName)
FROM dbo.NFLTeams
GROUP BY  YearEstablished;

See possible answers