Editorial

SQLServerCentral Editorial

An Integrated Process for Software Delivery.

  • Editorial

Developers, enamored of the integrated approach to Software Delivery, would like to be able to respond to business need in business time, adding functionality when the need is recognized, instead of 6-9 months later after it's gone through the sclerotic IT purchasing and configuration process.

You rated this post out of 5. Change rating

2014-03-10

88 reads

SQLServerCentral Editorial

Caching

  • Editorial

A SQL Server database can easily be seen as a bottleneck as all data must be retrieved from a single machine. However a caching strategy in your application and alleviate load and improve performance.

You rated this post out of 5. Change rating

2014-02-26

249 reads

Blogs

VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”

By

Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...

Future IT Roles – Agentic Architect and AI Boom!!

By

These days everything is changing to AI World, IT roles are getting changed and...

Free Webinar about Columnstore Indexes

By

I’m doing a small series on indexing basics for SQL Server, and on May...

Read the latest Blogs

Forums

BCA KCP Duta Mas Fatmawati TLP:WA 08216366654

By ASAPRoofing

Komplek Pertokoan Duta Mas, Jl. RS. Fatmawati Raya No.8 Blok D1 No.6, 7, Cipete...

BCA KCP Permata Hijau TLP/WA 08216977701

By ASAPRoofing

Pertokoan, Jl. Permata Hijau Blok D No. C27-28 dan B22, RT.4/RW.12, Grogol Utara, Kec....

SPAM Issues May 2026

By Steve Jones - SSC Editor

We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...

Visit the forum

Question of the Day

Creating a JSON Document III

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 TOP 2 
  json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers