Fundamentals of Storage Systems – RAID, An Introduction
In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up...
2009-12-07
8,929 reads
In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up...
2009-12-07
8,929 reads
In case you haven’t discovered this for yourself, SQL Server Profiler is one of the most powerful tools that come...
2009-12-07
1,402 reads
Cross-Posted from A Goal-Keeping DBA blog:
I'm reading Getting Things Done because of Brent Ozar's excellent blog post, How I Use...
2009-12-07
690 reads
Alternative title for programmers using C-derivatives and Java:
Good Programmer == Lazy & Dumb?
I read this blog post, Why Good Programmers Are...
2009-12-07
665 reads
Was just doing my more or less weekly update on LinkedIn and saw that – finally – just hit 500 connections. Growth...
2009-12-07
554 reads
Ran across the Time Top 50 web site list and thought I’d share. I’m fond of lists, especially about web...
2009-12-07
416 reads
This is part four in the series of blog posts that will help in building a library of calculations you...
2009-12-07
2,810 reads
Microsoft Learning has put up a new Microsoft Student Career Portal that gives advice and links to resources on how...
2009-12-07
1,457 reads
It surprises me how often I see people posting questions about what type of encryption to implement for credit card...
2009-12-07
778 reads
I am a pretty frequent traveler, as you would imagine. Running a consulting company, and being on it's principals assets...
2009-12-07
471 reads
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Good documentation gets you started. Good books get you deep. After years of working...
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
WhatsApp:0817866887 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101, Wil, Kec. Duren Sawit,...
WhatsApp:0817866887 Jl. Bukit Barisan No.3, Kesawan, Kec. Medan Bar., Kota Medan, Sumatera Utara 20111
WhatsApp:0817866887 Jl. Sudirman No.59, Bukit Cangang Kayu Ramang, Kec. Guguk Panjang, Kota Bukittinggi, Sumatera...
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