Technical Article

Life Logging

Would you like the idea of capturing everything you do? Audio, video, text, code, a log of your life. A new book from Microsoft Research talks about this and Steve Jones things it could be an interesting capability for your career.

Technical Article

Life Logging

Would you like the idea of capturing everything you do? Audio, video, text, code, a log of your life. A new book from Microsoft Research talks about this and Steve Jones things it could be an interesting capability for your career.

SQLServerCentral Editorial

The Flaws of Choice

It's nice to be able to choose what you want, or what might fit you better. Too much choice, however, can be a bad thing, even in software where it seems we could have unlimited choices. Steve Jones tasks about the need to limit choice.

SQLServerCentral Editorial

All-in-one

The client tools for SQL Server have grown from small single purpose applications to larger tools that combine a number of functions. Do you like that? Is it a good idea? Steve Jones asks the question in today's Friday poll.

Blogs

How to Connect to SQL Server When Nothing Else Works – DAC

By

It's 2 AM. Your phone is going off. Users can't connect to the application,...

Get a Range of Sequence Values: #SQLNewBlogger

By

I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...

The Agent Era: When “How do I…?” Replaces “Where do I click?”

By

After a year away getting to grips with AI and its application across the...

Read the latest Blogs

Forums

Query compile/runtime issue

By as_1234

I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...

Hiring: Financial SQL Systems Administrator

By Tracy Rivers

Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...

Job Opening for ERP Systems Administrator - Hybrid

By rdr1

Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...

Visit the forum

Question of the Day

Creating a JSON Document II

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

TeamID TeamNameCity         YearEstablished
1      Cowboys  Dallas       1960
2      Eagles   Philadelphia 1933
3      Packers  Green Bay    1919
4      Chiefs   Kansas City  1960
If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName)
FROM dbo.NFLTeams n;

See possible answers