SQL Server 2012: New Business Intelligence features
SQL Server 2012 has many new Business Intelligence (BI) features and enhancements. Here are my top 12, in order of...
2012-10-30
8,661 reads
Blog Posts
The Fundamentals of Storage Systems – Shared Consolidated Storage Systems
Shared Consolidated Storage Systems – A Brief History
Hey, “Shared Consolidated Storage Systems” did you just make that up? Why yes, yes...
2012-10-30 (first published: 2012-10-26)
2,497 reads
Transaction Log Internals - My session ingredients
Still 18 days to go for my session on Transaction Log Internals for Chennai SQL Server User Group (17-Nov).
While seeing...
2012-10-30
2,609 reads
Amazon Kindle Fire Released
Amazon has released the latest version of it Kindle – the Kindle Fire HD.
It seems amazon are moving away from a...
2012-10-29
626 reads
Countdown to PASS Summit 2012 – 8 to Go – What Is PASS Anyway?
Eight days to go. So after going to my first conference, I was surprised that I did not know more...
2012-10-29
1,207 reads
Geographic Failover/Redundancy (and DR)
Today we await the arrival of a 100 year storm that threatens to surge New York harbor and the Long...
2012-10-29
1,103 reads
Last Weeks Top 10 “Reading” Links #4
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out...
2012-10-29
653 reads
Microsoft Surface RT Review
Last Friday, pretty much on impulse, I decided to go to the Microsoft Store in the Park Meadows Mall in...
2012-10-29
2,388 reads
Monitor Blocking with Extented Events in SQL 2012
1. Set the "blocked process threshold (s)"
sp_configure 'show advanced options', 1 ;
GO
RECONFIGURE ;
GO
sp_configure 'blocked process threshold', 10 ;
GO
RECONFIGURE ;
GO
here we...
2012-10-29
2,626 reads
Virtualizing Your Business Critical SQL Servers Anthology
This week I completed a six-part blog series (more like five plus one) on the path to virtualizing your business-critical...
2012-10-29 (first published: 2012-10-24)
2,362 reads
Blogs
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Data Engineering Books Worth Having on Your Shelf (or your tablet)
Good documentation gets you started. Good books get you deep. After years of working...
Forums
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...
SQL Server Showing Out of Space But Plenty of Drive Space
We have a SQL Server installed. We have a 500GB drive for the database....
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