Relationships with Microsoft Fabric GraphQL API
Learn how to join tables together when using the GraphQL API with Microsoft Fabric in this step-by-step article.
2024-11-13
Articles
A Tidy Database is a Fast Database: Why Index Management Matters
Learn about the ways in which you might better manage indexes for a better performing and efficient database.
2024-11-11
3,974 reads
How Many Indexes Is Too Many?
Let’s start with the Stack Overflow database (any size will work), drop all the indexes on the Users table, and run a delete:
2024-11-11
Step by step guide to setup PostgreSQL on Docker
Learn how to get started with PostgreSQL using a container to practice database skills.
2024-11-08
1,928 reads
How To Embed Your Azure Logic Apps in a Metadata-driven Data Platform
In this article, I am going to explain how you can dial your productivity up to 11 when you’re dealing with a lot of Azure Logic Apps in your data platform.
2024-11-08
What’s In Your Development Database? The Answer: Production Data
Are your developers working with live production data, completely made-up synthetic data, or something in between? I posted a poll here on the blog and on a few of my social media feeds, and here were the results:
2024-11-06
Your Personal ChatGPT Tutorial
This tutorial will show how to use an AI model with Python to respond to queries.
2024-11-04
11,087 reads
Creating Views in MongoDB
Like many relational database systems, MongoDB supports the use of views. A view is a read-only object in a MongoDB
2024-11-04
Live webinar - Prioritizing security: Essential strategies for IT leaders
In today's rapidly evolving landscape, managing the security of large and complex database estates is a critical challenge for organizations. Join us for a webinar on Nov 21 covering “Prioritizing security: Essential strategies for IT leaders,” where Redgate’s security experts will share their tips on how you can safeguard your database estate and minimize reputational risk. There will also be a Q&A session where you can get expert advice from our panelists.
2024-11-04
A Guide to SQL Security in Django
If you encounter Django in your environment, are you thinking about SQL Injection and security? If not, read this article and learn how to protect your data.
2024-11-01
1,122 reads
Blogs
T-SQL Tuesday #198–Change Detection
By Steve Jones
This month we have a new host, Meagan Longoria, who graciously agreed to help...
Redgate and Rome
By Steve Jones
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
Optimizing Azure SQL Database performance often begins with identifying the most resource-intensive queries. Understanding...
Forums
BCA KCU DARMO No.telp:08385883375
Whatsapp:08385883375 PPCR+MQ6, Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
Creating a JSON Document IV
Comments posted to this topic are about the item Creating a JSON Document IV
Restoring Azure Key Vault Keys and Validating SQL Server TDE Recovery: Level 7 of the Stairway to TDE
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Restoring Azure Key Vault Keys...
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 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