Sukanya Konatam

Sukanya Konatam is a Senior Manager - Enterprise Data Governance and Data Science with over 17 years of experience enabling companies with digital transformation and helping them become data driven organizations. A highly regarded thought leader with an exceptional background in data science, data governance, data Architecture, data modeling, data analytics, data visualization, automation, BI modernization. She has a proven track record of solving complex business problems, building & leading diverse teams and has established and governed an enterprise data governance implementation roadmap rolling out an enterprise-wide data governance framework and building the data catalogue/inventory and lineage for enterprise visibility. She has demonstrated 17+ years of expertise in leading large cross functional development teams and has implemented data centric solutions for several industries including banking & financials, telecom, health care, automobile, criminal justice and many more.

All authors

SQLServerCentral Article

MuleSoft Integration with Azure Key Vault

Introduction MuleSoft Anypoint is a platform that helps to aggregate and integrate data from different source systems. As part of the data integration, the MuleSoft Anypoint Environment needs source system and target system login credentials stored in the platform, making it a vulnerability. The storage is vulnerable to attacks from cyber-criminals. This vulnerability can arise […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2023-06-02

2,346 reads

All authors

Blogs

T-SQL Tuesday #198–Change Detection

By

This month we have a new host, Meagan Longoria, who graciously agreed to help...

Redgate and Rome

By

I’m at the UK Redgate office today, meeting with senior leaders in all areas...

Quick Tip: Check Most DTU Expensive Queries in Azure SQL Database

By

Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...

Read the latest Blogs

Forums

How Important Is a Google Knowledge Panel for Online Reputation?

By ghostwritingassistance

I’ve been learning more about the google knowledge panel and it seems like one...

Which Wireless Credit Card Terminal Works Best for Small Businesses?

By honey cloe

I’m currently researching the best wireless credit card terminal for a growing business and...

Creating a JSON Document IV

By Steve Jones - SSC Editor

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

Visit the forum

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      1960
If I run this code, how many rows are returned? 
SELECT 
  YearEstablished,
  json_objectagg(city : TeamName)
FROM dbo.NFLTeams
GROUP BY  YearEstablished;

See possible answers