Future DBA – Hadoop Big Data
As we discussed on earlier blog that in future its more than SQL-(R)DBMS, as data is growing we have to...
2016-09-21
428 reads
Vinay Thakur
Operational Analytics -SQL Server 2016
What is Operational Analytics:- Operational Analytics is a combination of two words “Operational” and “Analytics”. so your OLTP system is...
2016-09-20
402 reads
Distributed AG
going though Allan Hirt’s 24 SQLPASS recording, he has explained the new feature of SQL Server Availability group you can get...
2016-09-19
380 reads
Future DBA part 2
I do not say you should be expert in other technologies but you should be aware of what it is...
2016-09-15
385 reads
Future DBA Part 1
As I stated in my earlier blog on future DBA, we should learn many things as we can to be...
2016-09-14
465 reads
World is changing so DBA should
I was going through SQLPASS recording and on first time I could see a session as “MongoDB for the SQL...
2016-09-13
376 reads
24 Hours of SQLPASS
Like every years before PASS summit, this years also SQLpass has 24 hrs sessions… it has great sessions every time,...
2016-09-12
373 reads
SQL 2016-Always Encrypted
As you know this has been introduced in sql server 2016, I am not going in details on it but...
2016-05-07
456 reads
SQL Server 2016 …whats new…WOW!!!
Hey there…. I wrote on SQL Server 2016 in my earlier blog Lets See and Whats new, during that time I knew that SQL...
2016-04-01
681 reads
2016-01-11
556 reads
Blogs
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Cultural Change: Fostering a Cost-Aware Culture in Your Organisation
By HeyMo0sh
After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...
Forums
Creating a JSON Document I
Comments posted to this topic are about the item Creating a JSON Document I
Who is Irresponsible?
Comments posted to this topic are about the item Who is Irresponsible?
Designing Database Changes Before Deployment: Level 1 of the Stairway to Reliable Database Deployments
Comments posted to this topic are about the item Designing Database Changes Before Deployment:...
Question of the Day
Creating a JSON Document I
I want to create a JSON document that contains data from this table:
TeamID TeamName City YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933If I run this code, what is returned?
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers