Lists of Tools
I ran across this list of interesting tools by Scott Hanselman and there is some good stuff to look at...
2007-12-14
1,360 reads
Blog Posts
12000!
A short congratulations to myself. I was answering posts last night after tech editing another chapter of the book I'm...
2007-12-12
1,474 reads
Finding the relationship of a filegroup and a partition
The other day, I was trying to find out which partition is on which filegroup for a a partitioned table....
2007-12-12
1,589 reads
Driving Debate
I write a daily editorial, which is one of the reasons that I don't post here as often as I'd...
2007-12-11
1,395 reads
Managing Funds for User Groups
This question seems to come up a lot and it's worth discussing. Few user groups are incorporated, fewer still are...
2007-12-11
639 reads
Disappearance
Wow, it's been a long time since I posted here. I actually had to search for my name to find...
2007-12-10
661 reads
Podcasting
A new video setup is on the way!!!!
Actually I'll do a couple podcasts on podcasting over the holidays here since...
2007-12-10
3,046 reads
How do you make a Wiki work?
Following up on my post about Wikipedia, I read an article in Eweek, 25 Tips for a Better Wiki Deployment...
2007-12-09
634 reads
Contributing to Wikipedia
Recently I posted about an interview with Jimmy Wales and only a couple days after that I ran across What...
2007-12-06
588 reads
Tribute to Honor Jim Gray
Saw this on the Association for Computer Machinery SIGMOD announcements.
Tribute to Honor Jim Gray
It is scheduled for May 31, 2008...
2007-12-05
555 reads
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 MUARA KARANG Telp:0817866887
WhatsApp:0817866887 Jl. Muara Karang Timur, Blok B VIII No.116-117, Daerah Khusus Ibukota Jakarta 14450
Alamat kontak resmi BCA KCP Taman Melati Telp:0817866887
WhatsApp:0817866887 Gedung Taman Melati Margonda Jl. Margonda No.525 A, Pondok Cina, Kecamatan Beji, Kota...
Alamat kontak resmi BCA KCU DEPOK Telp:0817866887
WhatsApp:0817866887 Jl. Margonda Raya No.182, Kemiri Muka, Kecamatan Beji, Kota Depok, Jawa Barat 16423
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