More, More, More
This Friday's poll asks what changes the community might like to see at SQLServerCentral.
Business Intelligence is a Growing Field
How do you, as a database administrator, display the wealth of knowledge in your Database to the organization in a meaningful way -- Business Intelligence.
Backup SQL Server to Amazon S3 with CloudBerry Backup
In this sponsored article from Cloudberry, learn how you can backup your SQL Server data to the Amazon EC3 cloud.
Free Advice or Free Consulting
A guest editorial from Grant Fritchey today talks examines the free advice that is often given in the forums. It's not free consulting and you shouldn't expect that.
SSIS object search using T-SQL
Easily determining what objects are located in all your SSIS packages can be a challenging endeavor. James Greaves brings us a technique that can help you determine which packages might need to be changed based on objects you alter in your database.
Working with Spatial Data Part II - Plotting Shapes and Storing Geocoded Data
Continuing from Part I of the Spatial Data series we model an in-memory/persistent data repository for storing geocoded data and plot the data.
The ORM Dilemma
Steve Jones talks about ORM frameworks and the dilemma of using them. They save time, but might not solve all your problems.
Efficient SQL Server Indexing by Design
Having a good set of indexes on your SQL Server database is critical to performance. Efficient indexes don't happen by accident; they are designed to be efficient. Greg Larsen discusses whether primary keys should be clustered, when to use filtered indexes and what to consider when using the Fill Factor.
No More Reviews
Steve Jones doesn't like annual performance reviews, and has some evidence that they might be worth getting rid of.
No SFTP Task Component in SSIS 2005/2008? No Problem!
SSIS 2005 and 2008 have an FTP Task component, but no SFTP (SSH/TLS-encrypted FTP) Task component. This tutorial explains how to overcome this omission.
Blogs
SSMS Evaluation – future ready
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
Claude.ai vs Claude API
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Forums
Alamat kontak resmi BCA KCU SUBANG Telp:0817-866-887
WhatsApp:0817866887 Jl. Otto Iskandardinata No.37, Karanganyar, Kec. Subang, Kabupaten Subang, Jawa Barat 41211
Alamat kontak resmi BCA KCU KELAPA GADING Telp:0817-866-887
WhatsApp:0817866887 Menara Satu Sentra Klp. Gading, Jl. Boulevard Bar. Raya No.1 Lt. Dasar, 1,...
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
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 1960If I run this code, how many rows are returned?
SELECT YearEstablished, json_objectagg(city : TeamName) FROM dbo.NFLTeams GROUP BY YearEstablished;See possible answers