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,435 reads

All authors

Blogs

Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework

By

I’m excited to announce the release of a new open-source project that fully automates...

T-SQL Snapshot Backups on Availability Group Secondary Replicas

By

One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....

The Book of Redgate: Hours

By

I have said and written this many times: Redgate Software is the type of...

Read the latest Blogs

Forums

ORDER BY alias

By aniap

Comments posted to this topic are about the item ORDER BY alias

Optional Parameter Plan Optimization in SQL Server 2025: Fixing the Kitchen-Sink Search Procedure

By vgupta

Comments posted to this topic are about the item Optional Parameter Plan Optimization in...

AI Experience Gap that we keep talking about

By Pat Wright

Comments posted to this topic are about the item AI Experience Gap that we...

Visit the forum

Question of the Day

ORDER BY alias

There is a table tmp_tab: 

CREATE TABLE tmp_tab (
id int,
val int
);
INSERT INTO tmp_tab VALUES
(1, 1),
(2, NULL),
(3, 3),
(4, 4),
(5, 5);
You want to order the rows ids by the following expression: 
    ISNULL(val, id) + 1
Which of the following queries produces the expected ordering and why? (Select all correct)

See possible answers