Kamil

My name is Kamil Nowinski and I'm the founder & owner of SQLPlayer blog.
I'm Microsoft Data Platform MVP, MCSE. Senior Data Engineer, data geek and friend of Redgate. I speak at user groups and conferences across Europe. Love #SQLfamily and Community around Microsoft Data Platform - that's why my podcast is called "Ask SQL Family" where I talk to well-known and valued specialists in the industry (including Microsoft employees).

All authors

Blog Post

Last Week Reading (2019-11-10)

Hello all! An extraordinary week has just passed. Two big conferences took place in the USA, PASS Summit and Ignite, where Microsoft announced plenty of new products or updates....

2019-11-10

13 reads

Blog Post

Last Week Reading (2019-10-20)

Hello folks! 2 weeks passed but eventually, I have some news for you. Press Support for Azure Databricks Instance pool for operationalizing Databricks workloads in Data Factory Public Preview...

2019-10-20

12 reads

Blog Post

ASF 025: Rob Farley interview

Introduction Rob Farley is a Microsoft Certified Master, Microsoft Certified Trainer and is a recipient of the Microsoft MVP Award for SQL Server since 2006. Rob provides consulting and...

2019-09-26

19 reads

All authors

Blogs

Fabric Mirroring doesn’t start copying Rows

By

A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...

JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

By

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

After working deep in cloud operations, I’ve learned that FinOps isn’t really about dashboards...

Read the latest Blogs

Forums

Creating a JSON Document I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Creating a JSON Document I

Who is Irresponsible?

By Steve Jones - SSC Editor

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

By Massimo Preitano

Comments posted to this topic are about the item Designing Database Changes Before Deployment:...

Visit the forum

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  1933
If I run this code, what is returned? 
SELECT json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers