Azure Privatelink provides private connectivity from an Azure Virtual Network to Azure PaaS such as Snowflake. This secures the connection between client endpoint and Snowflake(more...)
The post Snowflake + Azure...
2022-05-13
206 reads
Azure AD application provisioning refers to automatically creating user identities, groups and roles in the applications that users need access to for accounts created in(more...)
The post Azure AD Automatic...
2022-03-29
116 reads
Azure Active Directory is Microsoft Azure’s identity and access management providing authentication and authorization mechanism for internal and external applications in Azure ecosystem. With AD(more...)
The post Snowflake Integration to...
2022-03-10
67 reads
Snowflake is a columnar cloud native data platform for data warehouse and big data analytics. Snowflake provides massive scale and high-performance compute resource for data(more...)
The post Introduction to Snowflake...
2022-03-04
129 reads
Virtual Network data gateway service provides a secure data source connectivity in a given Azure VNet such as Power BI connection to Azure PaaS data(more...)
2022-02-23 (first published: 2022-02-10)
972 reads
Azure Resource Manager (ARM) Template is a cloud automation API for deploying Azure resources such as VM, database, network and storage services repeatedly with little(more...)
2021-07-08
50 reads
Business Continuity in Azure SQL database is about the mechanism, policies and procedures that enable business to operate in the face of disruption such as(more...)
2021-06-26
46 reads
Auditing, monitoring and alerting are security & performance tools that track activities inside a database and generates log events and alerts when a predefined event(more...)
2021-06-05
12 reads
Database backup and restore strategy is vital in preserving data for disaster recovery, compliance or fixing human error. In a business critical application, data need(more...)
2021-06-04
10 reads
In Azure database, security is managed through multiple-layers such as network layer, server layer and database layer. A secure blue print in deploying Azure SQL(more...)
2021-05-08
14 reads
By Vinay Thakur
In previous posts, we looked at the SQL Server engine. for us DBAs, the...
By Arun Sirpal
You have used Claude. But which Claude? The Claude app (claude.ai, the desktop and...
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Comments posted to this topic are about the item Creating a JSON Document IV
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
When the schema of an object is changed, SQL Server wipes out the previous...
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